Ishan Bhatt Ishan Bhatt - 11 days ago 5
Python Question

Insert a list of dictionary using sqlalchemy efficiently

I have a list containing dictionaries as elements. All the dictionaries confronts to my schema, is there a simple or efficient way to insert these details in db with sqlalchemy?

my list is below

[{id:'12',name:'a':lang:'eng},{id:'13',name:'b':lang:'eng},{id:'14',name:'c':lang:'eng}]


and I am having a schema given below

id String(10)
name String(10)
lang String(10)

Answer

As stated in SQLAchemy documentation, you can insert many records in your table by calling your connection.execute() method, using table.insert() and your list of records as it's parameters, like this:

connection.execute(table.insert(), [ 
        {'id':'12','name':'a':'lang':'eng'},
        {'id':'13','name':'b':'lang':'eng'},
        {'id':'14','name':'c':'lang':'eng'},
    ]
)

Assuming, of course, that your table really has those column names as stated in your dictionary's keys and your values doesn't violate any constraint that you might have defined.

Comments