Lines Matching full:key
89 sql += "%sid INTEGER PRIMARY KEY" % (tableName)
111 sql += "%sFOREIGN KEY(typeid) REFERENCES TYPE(typeid)," % start
112 sql += "FOREIGN KEY(categoryid) REFERENCES CATEGORY(categoryid),"
113 sql += "FOREIGN KEY(testnameid) REFERENCES TESTNAME(testnameid),"
114 sql += "FOREIGN KEY(testdateid) REFERENCES TESTDATE(testdateid),"
115 sql += "FOREIGN KEY(platformid) REFERENCES PLATFORM(platformid),"
116 sql += "FOREIGN KEY(coreid) REFERENCES CORE(coreid),"
117 sql += "FOREIGN KEY(compilerid) REFERENCES COMPILER(compilerid)"
118 sql += "FOREIGN KEY(runid) REFERENCES RUN(runid)"
122 # Find the key or add it in a table
123 def findInTable(conn,table,keystr,strv,key): argument
125 r = conn.execute("select %s from %s where %s=?" % (key,table,keystr),(strv,))
132 r = conn.execute("select %s from %s where %s=?" % (key,table,keystr),(strv,))