execute python code from db
Laszlo Zsolt Nagy
gandalf at geochemsource.com
Wed Jan 26 08:06:25 EST 2005
robert wrote:
>Hello,
>
>Anybody knows if it's possible to execute python code from an db.
>
>db=MySQLdb.connect(host="localhost",user="r",passwd="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
More information about the Python-list
mailing list