execute python code from db

[robert]

Hello,

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

db=MySQLdb.conn ect(host="local host",user="r", passwd="j",db=" v")

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

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

Maybe feed python with stdin??.


robert.

[Laszlo Zsolt Nagy]

Re: execute python code from db

robert wrote:
[color=blue]
>Hello,
>
>Anybody knows if it's possible to execute python code from an db.
>
>db=MySQLdb.con nect(host="loca lhost",user="r" ,passwd="j",db= "v")
>
>c=db.cursor( )
>c.execute("""S ELECT * FROM table
> WHERE id = %s""", (id,))
>
>for python_code in c.fetchall():
> execute (python_code)
>
>Maybe feed python with stdin??.
>
>[/color]

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","globa ls"
before you try to use them.

Best,

Laci 2.0

[Nick Coghlan]

Re: execute python code from db

robert wrote:[color=blue]
> Hello,
>
> Anybody knows if it's possible to execute python code from an db.
>
> db=MySQLdb.conn ect(host="local host",user="r", passwd="j",db=" v")
>
> c=db.cursor()
> c.execute("""SE LECT * FROM table
> WHERE id = %s""", (id,))
>
> for python_code in c.fetchall():
> execute (python_code)
>
> Maybe feed python with stdin??.[/color]

What's wrong with the exec statement?

Cheers,
Nick.

--
Nick Coghlan | ncoghlan@email. com | Brisbane, Australia
---------------------------------------------------------------

http://boredomandlaziness.skystorm.net

[Damjan]

Re: execute python code from db

> for python_code in c.fetchall():[color=blue]
> execute (python_code)
>
> Maybe feed python with stdin??.[/color]

eval

--
damjan