PipelineFX Forum

Qube! => Developer Customization => Topic started by: Toph on December 18, 2012, 09:52:32 PM

Title: add to custom column in qube db
Post by: Toph on December 18, 2012, 09:52:32 PM
i added a custom column to the db in qube/job and I'm looking for a way to update the column. The information being added won't be added until the job is completed. Is there anything built in to add information to this custom column other than qb.modify()?
Title: Re: add to custom column in qube db
Post by: jburk on December 21, 2012, 12:22:27 AM
qb.modify won't let you access a custom column, you'll need to resort to raw SQL.

There is a qb.query module that will help you with making connections to the MySQL server, you can find it in $QBDIR/api/python/qb.  Since it's pure python, you'll need to have the MySQLdb python module available to use it.