Passing SQLite variables in Python

by

Use parameters to .execute():

query = """
     INSERT INTO credit
         (bank, number, card, int1, value, type, int2)
     VALUES
          (?, ?, ?, ?, ?, ?, ?)
        """
data =  ['Citi', '5567', 'visa', 6000, 9.99, '23', 9000]

cursor.execute(query, data)

According to PEP249:

.execute(operation[,parameters]):

Prepare and execute a database operation (query or command). Parameters may be provided as sequence or mapping and will be bound to variables in the operation. Variables are specified in a database-specific notation (see the module’s paramstyle attribute for details)

Checking paramstyle:

>>> import sqlite3
>>> print sqlite3.paramstyle
qmark

qmark means you use ? for parameters.

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. Force Python to forego native sqlite3 and use the (installed) latest sqlite3 version
  5. Parameter substitution for a SQLite “IN” clause
  6. List of tables, db schema, dump etc using the Python sqlite3 API
  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. How to delete a table in SQLAlchemy?
  27. Python and SQLite: insert into table
  28. How to check the existence of a row in SQLite with Python?
  29. sqlite3.OperationalError: no such column – but I’m not asking for a column?
  30. Django: sudden DB reset after Heroku sleep

Leave a Comment