Sqlite insert query not working with python?

by

You do have to commit after inserting:

cursor.execute("Insert into links (link,id) values (?,?)",(a,b))
conn.commit()

or use the connection as a context manager:

with conn:
    cursor.execute("Insert into links (link,id) values (?,?)", (a, b))

or set autocommit correctly by setting the isolation_level keyword parameter to the connect() method to None:

conn = db.connect('insertlinks.db', isolation_level=None)

See Controlling Transactions.

More Related Contents:

  1. Select Query To Get Last 9 Months Data in SQLite3
  2. sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 74 supplied
  3. No module named _sqlite3
  4. Sqlite / SQLAlchemy: how to enforce Foreign Keys?
  5. Force Python to forego native sqlite3 and use the (installed) latest sqlite3 version
  6. Parameter substitution for a SQLite “IN” clause
  7. OperationalError: database is locked
  8. How can I get dict from sqlite query?
  9. Sqlite3, OperationalError: unable to open database file
  10. parameter unsupported when inserting int in sqlite
  11. How to read datetime back from sqlite as a datetime instead of string in Python?
  12. Python CSV to SQLite
  13. Python sqlite3 string variable in execute
  14. Why is SQLAlchemy insert with sqlite 25 times slower than using sqlite3 directly?
  15. SQLite parameter substitution and quotes
  16. Passing a column name in a SELECT statement in Python
  17. Bulk insert huge data into SQLite using Python
  18. String similarity with Python + Sqlite (Levenshtein distance / edit distance)
  19. Is there a way to get a list of column names in sqlite?
  20. “no such table” exception
  21. sqlite3.OperationalError: unable to open database file
  22. What is an efficient way of inserting thousands of records into an SQLite table using Django?
  23. How to upgrade sqlite 3.8.2 to >= 3.8.3
  24. Python 3 sqlite parameterized SQL-query
  25. sqlite3.ProgrammingError: You must not use 8-bit bytestrings unless you use a text_factory that can interpret 8-bit bytestrings
  26. SQLite, python, unicode, and non-utf data
  27. Python and SQLite: insert into table
  28. Pycharm environment different than command line
  29. Can’t change system default SQLite binary
  30. Django: sudden DB reset after Heroku sleep

Leave a Comment