rpathsync / rmake / changeset / d3fcda67c56b

@@ -71,7 +71,7 @@ class JobStore(object):
         cu = self.db.cursor()
         cu.execute("""
         CREATE TEMPORARY TABLE tjobIdList(
-            jobId INT
+            jobId integer
         )""", start_transaction=False)
         try:
@@ -241,11 +241,11 @@ class JobStore(object):
     def getTroves(self, troveList):
         cu = self.db.cursor()
         cu.execute('''CREATE TEMPORARY TABLE tTroveInfo(
                           jobId INT,
                           troveName STR,
                           version STR,
                           flavor STR,
-                          context STR
+                          jobId integer,
                           troveName text,
                           version text,
                           flavor text,
                           context text
                       )''', start_transaction=False)
         try:

@@ -55,7 +55,7 @@ class NodeStore(object):
             cu.execute("""UPDATE BuildTroves set chrootId=0 WHERE troveId=?
                           AND chrootId=?""", troveId, chrootId)
         for path in newPaths:
-            self._createChrootId(cu, nodeName, path, 0)
+            self._createChrootId(cu, nodeName, path, None)
     def getNodes(self, names):
         cu = self.db.cursor()

@@ -268,8 +268,8 @@ def createChroots(db):
             chrootId      %(PRIMARYKEY)s,
             nodeName      TEXT,
             path          TEXT,
             troveId       INTEGER NOT NULL
                 REFERENCES BuildTroves ON DELETE CASCADE,
             troveId       INTEGER
                 REFERENCES BuildTroves ON DELETE SET NULL,
             active        INTEGER NOT NULL
         )""" % db.keywords)
         db.tables["Chroots"] = []