Q: "no such table: Sport" on exporting a table from sqlite db (django view) In my django view, after updating a table, I put this code for exporting that table into csv file:
import sqlite3 as sql
import os
import csv

# export Data
print ("Export data into csv file..............")
conn = sql.connect('sqlite3.db') #  I tried: db.sqlite3 -> same
cursor=conn.cursor()
cursor.execute("select * from Sport")
with open("heartrateai_data.csv", "w") as csv_file:
     csv_writer = csv.writer(csv_file, delimiter="\t")
     csv_writer.writerow([i[0] for i in cursor.description])
     csv_writer.writerows(cursor)
dirpath = os.getcwdb()+"/heartrateai_data.csv"
print("Data exported Successfully into {}".format(dirpath))
conn.close()

But it gives me the error: Exception Value:   no such table: Sport.
I am sure that the table name is correct because is the same in my model.py.
I am not sure if it correct the line with connection and connection close. I am new in this.
My browser: 
Edit 2:
I saw that the correct way to write the path is with 'E:\...' or with r'E:...'. I wrote like this in my code conn = sql.connect(r'E:\Work\django\analysisData\db.sqlite3') but I have the same error. "No such table: Sport"

A: Try this

python manage.py makemigrations


python manage.py migrate

it can be just Django's error

A: After I wrote this lines in my code:
con = sql.connect(r'E:\Work\django\analysisData\db.sqlite3')
cursor = con.cursor()
cursor.execute("SELECT name FROM sqlite_master WHERE type='table';")
print(cursor.fetchall())

I saw that the name of the table isn't the same like in the model.py. The name of tables is: projectName_NameOfTable.
I modified the table name, and I don't have that error again.
