[scribus] Python MySQLdb

[ale rimoldi]

hi jean,

> I've been experimenting with Python and MySQLdb.
> 
> Previously I worked with Indesign and a custom CMS to import magazine 
> articles via XML.
> Scribus and Python I see allows me to link directly to the DB - which
> is fantastic.
> 
> However for the life of me I can't seem to get a grip on the MySQLdb
> API.
> 
> I am trying to fetch a record from the db, but I am uncertain of the
> syntax.
> 
> I've tried this:
> 
> cur.execute("""SELECT text FROM table WHERE id=8""")
> 
> But this does not seem to work.
> I'm not exactly sure how fetchone() and fetchall() works in this case.

if you send a testcase (table structure + sample data + short scribus
scripter that uses it) i can have a look at it.

ciao
a.l.e