There is a list of dictionaries of the form:
[{"1":"1","2":"1"},...] in which the keys of the dictionaries are columns in the database table. That is, all dictionaries with the same keys, but with different values. I need to add these values to the table.
How to implement it?
You can use the Pandas module:
import pandas as pd from sqlalchemy import create_engine data = [{'a':1, 'b':'string1'}, {'a':2, 'b':'string2'}, {'a':3, 'b':'string3'}] # create SQL Alchemy DB connection # conn = create_engine('postgresql://user:password@host:port/dbname') conn = create_engine('postgresql+psycopg2://user:password@host:port/dbname') # create Pandas DataFrame from the list of records df = pd.DataFrame(data) # write DF into SQL table df.to_sql('table_name', conn, if_exists='replace', index=False) DataFrame example:
In [74]: df Out[74]: ab 0 1 string1 1 2 string2 2 3 string3 
Found another solution using psycopg2. It took due to the fact that pandas does not support python 3.4.
import psycopg2 out = [{'a':1,'b':2,'c':3}, {'a':4,'b':5,'c':6}] with psycopg2.connect("dbname='dbname' user='user' host='host' password='password'") as conn1: with conn1.cursor() as cur: cur.execute("CREATE TABLE table (a varchar, b varchar, c varchar);") cur.executemany("INSERT INTO table VALUES (%(a)s, %(b)s, %(c)s);", out) conn1.commit() ? use? - gil9redSource: https://ru.stackoverflow.com/questions/856346/
All Articles
create table ...) tables. Are all table fields present in dictionaries? Is it planned to update, rewrite or create a table? - MaxU