Insert a list of dictionary using sqlalchemy efficiently

Question

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 1

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.