Canot Get data from sqlite database Exception: Control must be added to the page first.

[bobwatcherx]

I'm making a CRUD with sqlite I want to put all the data from the database into the listview widget and do a loop and append to the listview but doing for on init doesn't seem to work how to get the data ( SELECT * FROM tbl) and doing and looping into the widget and if i click listview widget automatically get its id

code

from flet import *
from action import insert_data,result_data

class Mycrud(UserControl):
	def __init__(self,data):
		super().__init__()
		self.sourcedb = data
		print(self.sourcedb)
		self.datadb = ListView()
		for x in self.sourcedb:
			self.datadb.controls.append(
				Column([
					Text(x["id"]),
					Text(x["name"]),
					Text(x["age"]),

					])

				)
			self.update()

	def build(self):
		self.dataAll = ListView()
		self.name = TextField(label="Input name")
		self.age = TextField(label="Input age")
		return Column(
			controls=[
			self.name,
			self.age,
			IconButton(icon="Add",on_click=self.addnew),
			 self.datadb
			],
			)
	def addnew(self,e):
		name = self.name.value
		age = self.age.value
		insert_data(name,age)
		self.update()


		

def main(page:Page):
	res = []
	alldata = result_data.fetchall()
	for x in alldata:
		res.append({"id":x[0],"name":x[1],"age":x[2]})

	app = Mycrud(res)
	page.add(app)

flet.app(target=main)

action.py file

import sqlite3
conn = sqlite3.connect("db/main.sqlite", check_same_thread=False)
cur = conn.cursor()


# # res  = cur.execute("CREATE TABLE movie(title, year, score)")
# r = cur.execute("""
#     INSERT INTO movie VALUES
#         ('Monty Python and the Holy Grail', 1975, 8.2),
#         ('And Now for Something Completely Different', 1971, 7.5)
# """)
# conn.commit()

result_data = cur.execute("SELECT * FROM schoollname")

def insert_data(name,age):
	insert_data = cur.execute("insert into schoollname (name,age) values(?,?)",(name,age))
	conn.commit()

ERROR MESSAGE

Unhandled error processing page session 96ddcfb2-ca98-4092-ad3a-7411be449628: Traceback (most recent call last):
  File "/usr/local/lib/python3.10/dist-packages/flet/flet.py", line 212, in on_session_created
    session_handler(page)
  File "/home/minto/belajar/ytpro/fletpro/crudflet/main.py", line 49, in main
    app = Mycrud(res)
  File "/home/minto/belajar/ytpro/fletpro/crudflet/main.py", line 20, in __init__
    self.update()
  File "/usr/local/lib/python3.10/dist-packages/flet/control.py", line 258, in update
    raise Exception("Control must be added to the page first.")
Exception: Control must be added to the page first.

Why isn't there a listview.builder widget like in flutter so that it makes it easier to loop and render widgets automatically. so you don't have to
FOR x in data :
widget.append()

and do an append again

[ndonkoHenri]

I haven't run your code, but I think I have an idea :)
Because you have at the top from flet import *, there is a conflict between your variable app=Mycrud(res) and flet's app
To solve this issue, rename your variable from app=Mycrud(res) to something like my_app = Mycrud(res)

Let me know if it works.. :)