«

Hello,

Anybody knows if it's possible to execute python code from an db.

db=MySQLdb.connect(host="localhost",user="r",passw d="j",db="v")

c=db.cursor()
c.execute("""SELECT * FROM table
WHERE id = %s""", (id,))

for python_code in c.fetchall():
execute (python_code)

Maybe feed python with stdin??.


robert.

robert wrote:

>Hello,
>
>Anybody knows if it's possible to execute python code from an db.
>
>db=MySQLdb.connect(host="localhost",user="r",pass wd="j",db="v")
>
>c=db.cursor()
>c.execute("""SELECT * FROM table
> WHERE id = %s""", (id,))
>
>for python_code in c.fetchall():
> execute (python_code)
>
>Maybe feed python with stdin??.
>
>

http://docs.python.org/lib/built-in-funcs.html

Look for these:

compile
exec
eval
execfile

Also the statement exec:

http://docs.python.org/ref/exec.html#l2h-562

I also recommend to look at the documentation of "global","globals"
before you try to use them.

Best,

Laci 2.0

robert wrote:
> Hello,
>
> Anybody knows if it's possible to execute python code from an db.
>
> db=MySQLdb.connect(host="localhost",user="r",passw d="j",db="v")
>
> c=db.cursor()
> c.execute("""SELECT * FROM table
> WHERE id = %s""", (id,))
>
> for python_code in c.fetchall():
> execute (python_code)
>
> Maybe feed python with stdin??.

What's wrong with the exec statement?

Cheers,
Nick.

--
Nick Coghlan | | Brisbane, Australia
---------------------------------------------------------------
http://boredomandlaziness.skystorm.net

> for python_code in c.fetchall():
> execute (python_code)
>
> Maybe feed python with stdin??.

eval

--
damjan