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