- projectB.query("INSERT INTO suite (suite_name, version, origin, description) VALUES ('%s', '%s', '%s', '%s')"
- % (string.lower(suite), SubSec["Version"], SubSec["Origin"], SubSec["Description"]))
+ projectB.query("INSERT INTO suite (suite_name) VALUES ('%s')" % string.lower(suite));
+ for i in ("Version", "Origin", "Description"):
+ if SubSec.has_key(i):
+ projectB.query("UPDATE suite SET %s = '%s' WHERE suite_name = '%s'" % (string.lower(i), SubSec[i], string.lower(suite)))