def putkeys(): cursor.execute("SELECT id, dn FROM thunderpeople") people = cursor.fetchall() for person in people: person_id = person[0] person_dn = person[1] # Handle email addresses with pesky quotes. person_dn = person_dn.replace('"', r'\"') query = 'UPDATE thundergroup SET thunderpeople_id' \ ' = "%s" WHERE member = "%s"' % (person_id, person_dn) print query cursor.execute(query) query = 'SELECT * FROM thundergroup WHERE thunderpeople_id' \ ' IS NULL;' cursor.execute(query) result = cursor.fetchall() if result: try: raise Exception('F*ck thunder bird') except Exception: print "thundergroup records with no foreign key:" for record in result: print record raise
cursor.execute(create_info) get_columns = """ SELECT column_name FROM COLUMNS WHERE table_schema = '%s' AND table_name = 'master' """ % settings.DATABASE info_c.execute(get_columns) columns = info_c.fetchall() columns = tuple(map(lambda col: col[0], columns )) cursor.execute("SELECT distinct(source) FROM master") sources = tuple(map(lambda res: res[0], cursor.fetchall())) do_tally_base = r""" SELECT * FROM (SELECT %s as sb1, COUNT(*) as sb2, source as sb3 FROM master WHERE source = '%s' AND %s IS NOT NULL GROUP BY %s ORDER BY COUNT(*) DESC) as t2 WHERE sb2 > 1 """ for source in sources: for column in columns: do_tally = do_tally_base % (column, source, column, column) cursor.execute(do_tally) stuff = cursor.fetchall()