def updateFreq(self, table, *columnsAndValues):
if self.testing():
return -1
else:
sql = ("update " + table + " set `freq`=`freq`+1 where " +
" and ".join(["(`%s`=%s)" % (column,self.kwote(value))
for column,value
in iterChunks(columnsAndValues, 2)]))
with EngineVerbosity(self.verbose):
self.cxn.query(sql)
def fetchId(self, table, *columnsAndValues):
if self.testing():
return -1
else:
sql = ("select id from `%s` where " % table +
" and ".join(["(`%s`=%s)" % (column,self.kwote(value))
for column,value
in iterChunks(columnsAndValues, 2)]))
with EngineVerbosity(self.verbose):
rows = self.cxn.query(sql)
return rows and int(rows[0].id)
def fetchQuery(self, table, *columnsAndValues):
"untested"
j = " AND ".join(["(`%s`=%s)" % (column,self.kwote(value))
for column,value
in iterChunks(columnsAndValues, 2)])
query = ("SELECT id FROM `%s`" % table
+
(" WHERE " if columnsAndValues else "")
+
j)
return query
