button click edit and delete to get data from loop is not working

[bobwatcherx]

i want to get data from sqlite table . and I put it inside a for . but when i click on edit button . for the first data. but instead the last data appears. how to solve it

code

from nicegui import ui
import sqlite3

# membuat koneksi database dan cursor
conn = sqlite3.connect('db/mainan.db',check_same_thread=False)
cursor = conn.cursor()


name = ui.input(label="username").classes("w-full")
age = ui.input(label="age").classes("w-full")


def addnewdata():
	try:
		cursor.execute('''INSERT INTO users (name, age) VALUES (?, ?)''', (name.value, age.value))
		conn.commit()
		ui.notify(f"succes add data {name.value}")
		name.value = ""
		age.value = ""
	except Exception as e:
		print(e)

ui.button("add data",
	on_click=addnewdata
	).classes("bg-blue-200")	
list_alldata = ui.column()



def editdata(x):
	print(x)

def deletedata(x):
	print(x)


def get_all_data():
	cursor.execute('''SELECT * FROM users''')
	res =  cursor.fetchall()
	result = []
	for row in res:
	    # Buat dictionary kosong untuk menampung data satu baris
	    data = {}
	    # Loop pada setiap kolom dalam baris saat ini
	    for i, col in enumerate(cursor.description):
	        # Gunakan nama kolom sebagai kunci dan nilai dari hasil kursor sebagai nilai
	        data[col[0]] = row[i]
	    # Tambahkan dictionary baris ke dalam list result
	    result.append(data)
	    

	print(result)
	for x in result:
		with list_alldata:
			with ui.card():
				with ui.row().classes("justify-between w-full"):
					ui.label(x['id'])
					ui.label(x['name'])
					ui.label(f"age {x['age']}")
				with ui.row():
					ui.button("edit",
						on_click=lambda e: editdata(x)
						).props("flat color=green icon=create")
					
					ui.button("delete",
						on_click=lambda : deletedata(x)
						).classes("bg-red")

get_all_data()

ui.run()

and in my terminal it always prints the last data. even though I select the first data

NiceGUI ready to go on http://0.0.0.0:8080
{'id': 3, 'name': 'dwqdwq', 'age': 2}
{'id': 3, 'name': 'dwqdwq', 'age': 2}
{'id': 3, 'name': 'dwqdwq', 'age': 2}
{'id': 3, 'name': 'dwqdwq', 'age': 2}
{'id': 3, 'name': 'dwqdwq', 'age': 2}
{'id': 3, 'name': 'dwqdwq', 'age': 2}
{'id': 3, 'name': 'dwqdwq', 'age': 2}
{'id': 3, 'name': 'dwqdwq', 'age': 2}

[falkoschindler]

Please, have a look at #471 for a very similar problem.

[bobwatcherx]

yes it is working fine . thanks

code

from nicegui import ui
import sqlite3

# membuat koneksi database dan cursor
conn = sqlite3.connect('db/mainan.db',check_same_thread=False)
cursor = conn.cursor()


name = ui.input(label="username").classes("w-full")
age = ui.input(label="age").classes("w-full")


def addnewdata():
	try:
		cursor.execute('''INSERT INTO users (name, age) VALUES (?, ?)''', (name.value, age.value))
		conn.commit()
		ui.notify(f"succes add data {name.value}")
		name.value = ""
		age.value = ""
		list_alldata.clear()
		get_all_data()
	except Exception as e:
		print(e)

ui.button("add data",
	on_click=addnewdata
	).classes("bg-blue-200")
	
list_alldata = ui.column()



def editdata(x):
	print(x.default_slot.children[0].text)
	# print(x)
def deletedata(x):
	print(x)


def get_all_data():
	cursor.execute('''SELECT * FROM users''')
	res =  cursor.fetchall()
	result = []
	for row in res:
	    # Buat dictionary kosong untuk menampung data satu baris
	    data = {}
	    # Loop pada setiap kolom dalam baris saat ini
	    for i, col in enumerate(cursor.description):
	        # Gunakan nama kolom sebagai kunci dan nilai dari hasil kursor sebagai nilai
	        data[col[0]] = row[i]
	    # Tambahkan dictionary baris ke dalam list result
	    result.append(data)
	    

	print(result)
	for x in result:
		with list_alldata:
			with ui.card():
				with ui.column():
					with ui.row().classes("justify-between w-full") as carddata:
						ui.label(x['id'])
						ui.label(x['name'])
						ui.label(f"age {x['age']}")
					with ui.row():
						ui.button("edit",
								).on("click",lambda e , carddata=carddata:editdata(carddata)).props("flat color=green icon=create")
						ui.button("delete",
								on_click=lambda e: deletedata(x)
								).classes("bg-red")
					# with ui.row():

get_all_data()
print(dir(ui.button()))







ui.run()