Menu
How can I insert multiple data records into table ignoring duplicates. I am using SQLAlchemy.
Thank you!
820
The INSERT IGNORE command keeps the first set of the duplicated records and discards the remaining. The REPLACE command keeps the last set of duplicates and erases out any earlier ones. Another way to enforce uniqueness is to add a UNIQUE index rather than a PRIMARY KEY to a table.
Update table elements in SQLAlchemy. Get the books to table from the Metadata object initialized while connecting to the database. Pass the update query to the execute() function and get all the results using fetchall() function. Use a for loop to iterate through the results.
Just call drop() against the table object. From the docs: Issue a DROP statement for this Table, using the given Connectable for connectivity.
prefix_with("TEXT") adds arbitrary text between INSERT and the rest of the SQL. execute() accepts a list of dictionaries with the records you would like to insert or a single dictionary if you only want to insert a single record.
The SQLite syntax for the behavior you're looking for:
inserter = table_object.insert().prefix_with("OR REPLACE") inserter.execute([{'column1':'value1'}, {'column1':'value2'}]) If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
