SQLAlchemy INSERT IGNORE

python insert sqlalchemy ignore
spacemonkey picture spacemonkey · Feb 7, 2010 · Viewed 13.8k times · Source

How can I insert multiple data records into table ignoring duplicates. I am using SQLAlchemy.

Thank you!

Answer

joeforker picture joeforker · Feb 8, 2010

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'}])

Related questions

Insert a row to pandas dataframe

I have a dataframe: s1 = pd.Series([5, 6, 7]) s2 = pd.Series([7, 8, 9]) df = pd.DataFrame([list(s1), list(s2)], columns = ["A", "B", "C"]) A B C 0 5 6 7 1 7 8 9 [2 rows x 3 columns] and I need to add a first row [2, 3, 4] to get: A B C 0 2 3 4 1 5 6 7 2 7 8 9 …

Read More
Insert at first position of a list in Python

How can I insert an element at the first index of a list ? If I use list.insert(0,elem), do elem modify the content of the first index? Or do I have to create a new list with the first …

Read More
Insert an element at a specific index in a list and return the updated list

I have this: >>> a = [1, 2, 4] >>> print a [1, 2, 4] >>> print a.insert(2, 3) None >>> print a [1, 2, 3, 4] >>> b = a.insert(3, 6) >>> print b None >>> print …

Read More