insert query builder

insert.py

def sql_insert(cursor, table, dictionary):
    columns = ','.join(dictionary.keys())
    placeholders = ', '.join('?' * len(dictionary))
    sql_cmd = "INSERT INTO {0} ({1}) VALUES ({2})".format(table, columns, placeholders)
    return cursor.execute(sql_cmd, list(dictionary.values()))


#example usage
#gene_rows = {}
#gene_rows['gene_name'] = parsedCSVColumns['GeneSymbol']
#...
#sql_insert(cursor, 'ACC', gene_rows)
#conn.commit()

truncateAllTables.sql

EXEC sp_MSForEachTable 'TRUNCATE TABLE ?'