Python sqlite3.OperationalError: no such table:

by

You are assuming that the current working directory is the same as the directory your script lives in. It is not an assumption you can make. Your script is opening a new database in a different directory, one that is empty.

Use an absolute path for your database file. You can base it on the absolute path of your script:

import os.path

BASE_DIR = os.path.dirname(os.path.abspath(__file__))
db_path = os.path.join(BASE_DIR, "PupilPremiumTable.db")
with sqlite3.connect(db_path) as db:

You can verify what the current working directory is with os.getcwd() if you want to figure out where instead you are opening the new database file; you probably want to clean up the extra file you created there.

More Related Contents:

  1. Variable table name in sqlite
  2. Importing a CSV file into a sqlite3 database table using Python
  3. OperationalError: database is locked
  4. Is there a way to get a list of column names in sqlite?
  5. SQLite Performance Benchmark — why is :memory: so slow…only 1.5X as fast as disk?
  6. sqlite3.OperationalError: unable to open database file
  7. How to open and convert sqlite database to pandas dataframe
  8. SQLite parameter substitution problem
  9. How do I get the “id” after INSERT into MySQL database with Python?
  10. How to retrieve inserted id after inserting row in SQLite using Python?
  11. python 3.2 UnicodeEncodeError: ‘charmap’ codec can’t encode character ‘\u2013’ in position 9629: character maps to
  12. Python CSV to SQLite
  13. Python sqlite3 and concurrency
  14. What if I don’t close the database connection in Python SQLite
  15. Bulk insert with SQLAlchemy ORM
  16. Django persistent database connection
  17. How can I verify Column data types in the SQLAlchemy ORM?
  18. HDF5 – concurrency, compression & I/O performance [closed]
  19. A QuerySet by aggregate field value
  20. Is this Python code vulnerable to SQL injection? (SQLite3)
  21. pysqlite: Placeholder substitution for column or table names?
  22. SQLite not saving data between uses
  23. SQLAlchemy: how to filter date field?
  24. Race conditions in django
  25. What is your favorite solution for managing database migrations in django? [closed]
  26. Problem with regexp python and sqlite
  27. Python SQLite3 SQL Injection Vulnerable Code
  28. Convert JSON to SQLite in Python – How to map json keys to database columns properly?
  29. django makemigrations and migrate on heroku server don’t create tables
  30. Python sqlite3 parameterized drop table

Leave a Comment