Lines Matching full:key
85 sql += "%sid INTEGER PRIMARY KEY" % (tableName)
105 sql += "%sFOREIGN KEY(typeid) REFERENCES TYPE(typeid)," % start
106 sql += "FOREIGN KEY(categoryid) REFERENCES CATEGORY(categoryid),"
107 sql += "FOREIGN KEY(testnameid) REFERENCES TESTNAME(testnameid),"
108 sql += "FOREIGN KEY(testdateid) REFERENCES TESTDATE(testdateid),"
109 sql += "FOREIGN KEY(platformid) REFERENCES PLATFORM(platformid),"
110 sql += "FOREIGN KEY(coreid) REFERENCES CORE(coreid),"
111 sql += "FOREIGN KEY(compilerid) REFERENCES COMPILER(compilerid)"
112 sql += "FOREIGN KEY(runid) REFERENCES RUN(runid)"
116 # Find the key or add it in a table
117 def findInTable(conn,table,keystr,strv,key): argument
119 r = conn.execute("select %s from %s where %s=?" % (key,table,keystr),(strv,))
126 r = conn.execute("select %s from %s where %s=?" % (key,table,keystr),(strv,))