Query Sqlite3 tables using python3 and insert the results in a Treeview in Tkinter

Asked

Viewed 22 times

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?
No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.