def updateItem(table, index, dict, globals): ''' Use the items in a dictionary to update an SQL table entry. ''' fullDict = {} for k, v in dict.iteritems(): fullDict[k.replace('-', '_')] = v row_id = sqlbackend.assignment_list(['row_id'], globals['backend']) l = sqlbackend.assignment_list(fullDict.keys(), globals['backend']) query = ', '.join(l) command = 'UPDATE %s SET %s WHERE %s' % (table, query, row_id[0]) fullDict['row_id'] = index cursor = globals['cursor'] cursor.execute(command, fullDict)
def getTableItem(table, idDict, globals): l = sqlbackend.assignment_list(idDict.keys(), globals['backend']) query = ' AND '.join(l) command = "SELECT * FROM %s WHERE %s" % (table, query) cursor = globals['cursor'] cursor.execute(command, idDict) result = cursor.fetchone() if not result: return None desc = dtuple.TupleDescriptor(map(lambda x: (string.lower(x[0]),) + x[1:], cursor.description)) dt = dtuple.DatabaseTuple(desc, result) return dt