def update_metadata_data(table, metadata): metadata_schema = user_metadata() column_titles = [d['column_name'] for d in metadata_schema] value_list = [] for idx, title in enumerate(column_titles): if idx == 0: value_list.append((metadata[title])) else: value_list.append('\'' + str(metadata[title])+ '\'') insert_stmt = 'INSERT INTO {0} ({1}) VALUES ({2});'.format(table, ','.join(column_titles), ','.join(value_list)) # print insert_stmt # print value_list db = cloudsql_connector() cursor = db.cursor(MySQLdb.cursors.DictCursor) cursor.execute(insert_stmt) db.commit() cursor.close() db.close()
def update_metadata_data(table, metadata): metadata_schema = user_metadata() column_titles = [d['column_name'] for d in metadata_schema] value_list = [] for idx, title in enumerate(column_titles): if idx == 0: value_list.append((metadata[title])) else: value_list.append('\'' + str(metadata[title]) + '\'') insert_stmt = 'INSERT INTO {0} ({1}) VALUES ({2});'.format( table, ','.join(column_titles), ','.join(value_list)) # print insert_stmt # print value_list db = cloudsql_connector() cursor = db.cursor(MySQLdb.cursors.DictCursor) cursor.execute(insert_stmt) db.commit() cursor.close() db.close()
def update_metadata_data_list(table, metadata): metadata_schema = user_metadata() column_titles = [d['column_name'] for d in metadata_schema] insert_stmt = 'INSERT INTO {0} ({1}) VALUES ({2});'.format(table, ','.join(column_titles), ','.join(['%s' for i in range(0,len(column_titles))])) value_list = [] # Generate a tuple for each row in the metadata. Only collect data from columns in the table for row in metadata: value_tuple = () for idx, title in enumerate(column_titles): if idx == 0: value_tuple += ((row[title]),) else: value_tuple += ((row[title]),) value_list.append(value_tuple) db = cloudsql_connector() cursor = db.cursor(MySQLdb.cursors.DictCursor) cursor.executemany(insert_stmt, value_list) db.commit() cursor.close() db.close()
def update_metadata_data_list(table, metadata): metadata_schema = user_metadata() column_titles = [d['column_name'] for d in metadata_schema] insert_stmt = 'INSERT INTO {0} ({1}) VALUES ({2});'.format( table, ','.join(column_titles), ','.join(['%s' for i in range(0, len(column_titles))])) value_list = [] # Generate a tuple for each row in the metadata. Only collect data from columns in the table for row in metadata: value_tuple = () for idx, title in enumerate(column_titles): if idx == 0: value_tuple += ((row[title]), ) else: value_tuple += ((row[title]), ) value_list.append(value_tuple) db = cloudsql_connector() cursor = db.cursor(MySQLdb.cursors.DictCursor) cursor.executemany(insert_stmt, value_list) db.commit() cursor.close() db.close()