Python Forum
display the contents of a sqlite3 database according to the dates
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
display the contents of a sqlite3 database according to the dates
#3
the complete error traceback is :

Exception in Tkinter callback
Traceback (most recent call last):
File "C:\Users\AHMED\AppData\Local\Programs\Python\Python36\lib\tkinter\__init__.py", line 1702, in __call__
return self.func(*args)
File "C:\Users\AHMED\Desktop\mon_cev_exe\ddm_test.py", line 55, in monitoring
update_releves()
File "C:\Users\AHMED\Desktop\mon_cev_exe\ddm_test.py", line 47, in update_releves
for resultats in curseur.execute('SELECT * FROM releves where time_releves_axe_loc35R between first_day AND last_day ORDER BY time_releves_axe_loc35R DESC'):
sqlite3.OperationalError: no such column: first_day


at the end for information; there is the sample of the code to create table releves in the database 'test.db':

def CreateTable_releves():
	
	conn1_releves = sqlite3.connect('bdd/test.db')
	curseur1_releves = conn1_releves.cursor()
	curseur1_releves.execute('''CREATE TABLE IF NOT EXISTS releves (id INTEGER PRIMARY KEY,time_releves TEXT NOT NULL, monitor1_releves TEXT NOT NULL,monitor2_releves TEXT NOT NULL)''')
	curseur1_releves.close()


def Add_To_Table_releves():

	time_releves_get = str(date_choisie_ils35R)

	monitor1_releves_get = str(ent_releves_mesure1.get())
	monitor2_releves_get = str(ent_releves_mesure2.get())

	conn2_releves = sqlite3.connect('bdd/test.db')
	curseur2_releves = conn2_releves.cursor()
	curseur2_releves.execute('''INSERT INTO releves (time_releves,monitor1_releves,monitor2_releves) VALUES (?,?,?)''',(time_releves_get,monitor1_releves_get,monitor2_releves_get))
	conn2_releves.commit()
	curseur2_releves.close()
Reply


Messages In This Thread
RE: display the contents of a sqlite3 database according to the dates - by atlass218 - Mar-02-2019, 10:05 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Create SQLite3 database with peewee Jim53_1980 2 743 Dec-20-2023, 02:38 PM
Last Post: buran
  Regex replace in SQLite3 database WJSwan 1 849 Dec-04-2023, 05:55 PM
Last Post: Larz60+
  Rows not adding to sqlite3 database using SQLAlchemy Calab 11 1,880 Jun-02-2023, 05:53 PM
Last Post: bowlofred
  How to display <IPython.core.display.HTML object>? pythopen 3 46,240 May-06-2023, 08:14 AM
Last Post: pramod08728
  Basic SQL query using Py: Inserting or querying sqlite3 database not returning data marlonbown 3 1,458 Nov-08-2022, 07:16 PM
Last Post: marlonbown
  Python Variables and Sqlite3 Database Staples200 1 3,242 May-25-2021, 02:40 AM
Last Post: Staples200
  how to suppress not to display the package contents from pydoc! maiya 3 2,557 Mar-19-2021, 03:41 AM
Last Post: bowlofred
Information Unable to display joystick's value from Python onto display box MelfoyGray 2 2,295 Nov-11-2020, 02:23 AM
Last Post: MelfoyGray
  sqlite3 database problem Maryan 2 2,554 Oct-05-2020, 05:21 AM
Last Post: buran
  sqlite3 database does not save data across restarting the program SheeppOSU 1 3,508 Jul-24-2020, 05:53 AM
Last Post: SheeppOSU

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020