Python sqlite3 parameterized drop table

by

You cannot use parameters for table names nor column names.

Alternatively you could make it a two-step process, e.g.:

a_table_name = "table_a"
sql_stmt = f"""DROP TABLE {a_table_name}"""
self.conn.execute(sql_stmt)

And if you’re doing that you may want to explicitly specify which tables can be deleted…

TABLES_THAT_CAN_BE_DROPPED = ('table_a','table_b',)
if a_table_name in TABLES_THAT_CAN_BE_DROPPED:
    # use code snippet from above 
else:
    pass # handle creatively

More Related Contents:

  1. SQLite parameter substitution problem
  2. How to retrieve inserted id after inserting row in SQLite using Python?
  3. Parameter substitution for a SQLite “IN” clause
  4. python 3.2 UnicodeEncodeError: ‘charmap’ codec can’t encode character ‘\u2013’ in position 9629: character maps to
  5. List of tables, db schema, dump etc using the Python sqlite3 API
  6. OperationalError: database is locked
  7. Sqlite3, OperationalError: unable to open database file
  8. How to read datetime back from sqlite as a datetime instead of string in Python?
  9. Python CSV to SQLite
  10. Python sqlite3 and concurrency
  11. What if I don’t close the database connection in Python SQLite
  12. Passing a column name in a SELECT statement in Python
  13. HDF5 – concurrency, compression & I/O performance [closed]
  14. Bulk insert huge data into SQLite using Python
  15. Is there a way to get a list of column names in sqlite?
  16. “no such table” exception
  17. Is this Python code vulnerable to SQL injection? (SQLite3)
  18. pysqlite: Placeholder substitution for column or table names?
  19. sqlite3.OperationalError: unable to open database file
  20. SQLite not saving data between uses
  21. What is an efficient way of inserting thousands of records into an SQLite table using Django?
  22. Problem with regexp python and sqlite
  23. Python 3 sqlite parameterized SQL-query
  24. sqlite3.ProgrammingError: You must not use 8-bit bytestrings unless you use a text_factory that can interpret 8-bit bytestrings
  25. How to delete a table in SQLAlchemy?
  26. Python and SQLite: insert into table
  27. How to check the existence of a row in SQLite with Python?
  28. Pycharm environment different than command line
  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