How to get keep information in a loop

[ginod]

Hey there,

I am new to python. At the moment I am trying to program a GUI, that show me some user information from a table of a SQL Database with a loop. He also should add a entry field, where i can type in the amount of pieces for the user. After that i want some form entries where i can add a description, a date and a upload button. The upload button should open a function where i can send the amount of the entry fields and the belonging user_id to a new function with a loop that add the information in another sql table.

the problem is, that i dont know how i can catch all the entries from the loop, so that i can send the information to another function. I experimented with the append method - but i doesn't get it. Can anybody help? thank you

PROBLEM SOLVED - FOUND A CODE THAT WORKED - BUT NOT WHY (AT THE MOMENT) :-D
CODE WHICH WORKS:

import tkinter as tk
import sqlite3

def insert_data(zahler_id, grund, betrag, preis, insert_date):
    
    endresult=float(betrag)*float(preis)
    conn = sqlite3.connect('data.db')
    cursor = conn.cursor()
    cursor.execute("CREATE TABLE IF NOT EXISTS SOLL (zahler_id TEXT, grund TEXT, betrag TEXT, datum INT)")
    cursor.execute("INSERT INTO SOLL (zahler_id, grund, betrag, datum) VALUES (?, ?, ?, ?)", (zahler_id, grund, endresult, insert_date))
    conn.commit()
    conn.close()

def fetch_data():
    conn = sqlite3.connect('database.db')
    cursor = conn.cursor()
    cursor.execute("SELECT zahler_id,  firstname, lastname FROM customer_data")
    return cursor.fetchall()

def submit_values():
    preis=preis_entry.get()
    grund=grund_entry.get()
    insert_date=datum_entry.get()
    for entry in entry_fields:
        zahler_id = entry[0]
        
        betrag = entry[1].get()
        insert_data(zahler_id, grund, betrag, preis, insert_date)

app = tk.Toplevel()
app.title("Einkauf")

data = fetch_data()
entry_fields = []

for zahler_id, vorname, nachname in data:
    frame = tk.Frame(app)
    frame.pack()
    tk.Label(frame, text=f"Zahler-ID: {zahler_id}").pack(side=tk.LEFT) 
    tk.Label(frame, text=f"Name: {vorname}, Nachname: {nachname}", bg="white", font="Helvetica 13 bold").pack(side=tk.LEFT)
    entry = tk.Entry(frame, width=5)
    entry.pack(side=tk.LEFT)
    entry_fields.append((zahler_id, entry))

preislabel=tk.Label(app, text="Kosten pro Ware")
preislabel.pack()
preis_entry=tk.Entry(app)
preis_entry.pack()

grundlabel=tk.Label(app, text="Beschreibung")
grundlabel.pack()
grund_entry=tk.Entry(app)
grund_entry.pack()

date_label = tk.Label(app, text="Buchungsdatum")
date_label.pack()
#Eine StringVar erstellen- Für Zahlen IntVar, für Kommazahlen DoubleVar, für Wahr oder falsch Booleanvar
datum_text = tk.StringVar()
#ein Text wird gesetzt
datum_text.set("DD.MM.YYYY")
datum_entry=tk.Entry(app, textvariable=datum_text)
datum_entry.pack()

upload_button = tk.Button(app, text="Ware eintragen", command=submit_values)
upload_button.pack()

app.mainloop()

[menator01]

Can you give the table layout from database and some sample data in the table?
What should the starting page contain?

[ginod]

ok i tried a few other prompts and he gave me a code that works. It worked with the append method and "for variable in data:" loop. I do not really know why it works at the moment. But I will try to reanalyze the code

[menator01]

Here is a quick example of what I think your trying to do. Not fully functional and not tested for errors

import tkinter as tk
from tkinter import ttk, messagebox
import sqlite3 as sq

class Database:
    ''' Class for handling database queries '''
    def __init__(self):
        self.connection = sq.connect('test.db')
        self.cursor = self.connection.cursor()

    def insert(self, data):
        pass

    def edit(self, id):
        pass

    def delete(self, id):
        pass

    def getone(self, id):
        query = f'select * from user_data where rowid="{int(id)}"'
        return self.cursor.execute(query).fetchone()

    def getall(self):
        query = 'select * from user_data'
        return self.cursor.execute(query).fetchall()


class Window:
    ''' Class for window display '''
    def __init__(self, parent):
        parent.columnconfigure(0, weight=1)
        parent.rowconfigure(0, weight=1)
        self.parent = parent

        self.var = tk.StringVar()
        self.combo = ttk.Combobox(self.parent, textvariable=self.var)
        self.combo.pack()

        self.labelframe = tk.LabelFrame(parent)
        self.labelframe.pack(pady=10)


class Controller:
    ''' Class for communications between class '''
    def __init__(self, database, window):
        self.database = database
        self.window = window

        # Populate the dropdown box
        self.populatebox()

        # Bind the dropdown box for changes
        self.window.combo.bind('<<ComboboxSelected>>', lambda event: self.populateform())


    def insert(self, data):
        self.database.insert(['data'])

    def edit(self, id):
        self.database.edit(id)

    def delete(self, id):
        self.database.delete(id)

    def getone(self, id):
        self.database.getone(id)

    def getall(self):
        ''' Method queries database for all entries '''
        names = []
        for item in self.database.getall():
            names.append(f'{item[0]} {item[1]} {item[2]}')
        return names

    def populatebox(self):
        ''' Method populate dropdown box '''
        alist = self.getall()
        alist.insert(0, 'Choose a name')
        self.window.combo.configure(values=alist)
        self.window.combo.current(0)

    def populateform(self):
        ''' Method populates form '''
        name = self.window.var.get().split()
        for widget in self.window.labelframe.winfo_children():
            widget.destroy()
        if name[0].isdigit():
            res = self.database.getone(name[int(0)])
            self.entry = []
            for index, info in enumerate(res):
                self.entry.append(tk.Entry(self.window.labelframe,))
                self.entry[index].pack(pady=5)
                self.entry[index].delete(0, 'end')
                self.entry[index].insert('end', info)

        # Create update button
        self.btn = tk.Button(self.window.labelframe, text='Update')
        self.btn.pack()
        self.btn.configure(command=lambda:messagebox.showinfo('Database Updated', 'This is just a message. Nothing really happened.'))
        
if __name__ == '__main__':
    root = tk.Tk()
    root.configure(padx=5, pady=3)
    root.geometry('400x400')
    controller = Controller(Database(), Window(root))
    root.mainloop()

[deanhystad]

Posting code that works and asking why is odd. Doesn't it make more sense to post code that doesn't work and ask why?