Author Topic: add to custom column in qube db  (Read 8689 times)

Toph

  • Jr. Member
  • **
  • Posts: 4
add to custom column in qube db
« 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()?

jburk

  • Administrator
  • *****
  • Posts: 493
Re: add to custom column in qube db
« Reply #1 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.