0
The purpose of the code is to do Sqlite3 searches between two dates and insert these Tkinter Treeview searches.
I have the second table in sqlite3:
CREATE TABLE "MOTO_PALIO" (
"cod" INTEGER,
"data" TEXT NOT NULL,
"hora" INTEGER,
"valor" VARCHAR(11) NOT NULL,
PRIMARY KEY("cod")
);
It contains values like:
Tabela: MOTO_PALIO
1 23/10/2020 14:30 11
2 23/10/2020 14:54 24
3 23/10/2020 14:59 11
.
.
. # Assim por diante...
I have Treeviw from Tkinter as follows https://ideone.com/h5L0Os
In this case, I have a list like this, which represents the dates to be consulted in Sqlite3:
lista_datas = ['25/10/20', '26/10/20', '27/10/20', '28/10/20', '29/10/20', '30/10/20',
'31/10/20', '01/11/20', '02/11/20', '03/11/20', '04/11/20', '05/11/20', '06/11/20',
'07/11/20', '08/11/20', '09/11/20', '10/11/20', '11/11/20', '12/11/20', '13/11/20',
'14/11/20', '15/11/20', '16/11/20', '17/11/20', '18/11/20', '19/11/20', '20/11/20',
'21/11/20', '22/11/20']
My doubts:
- How to search a set of multiple dates using python in Sqlite3?
- How to Enter Search Data in Tkinter’s Treeview?