Kutuma Maombi kwa Hifadhidata katika Python

Baada ya kuunganisha na hifadhidata, unaweza kutuma maombi kwake. Hii inafanywa kwa kutumia kutofautisha query, ambayo huandikwa ombi la SQL ili kuchapisha data yote kutoka kwenye jedwali users. Huu utofautishi unapaswa kuandikwa kwenye kizuizi chenye utofautishi connection:

try:
	with connect(
			host='localhost',
			user='root',
			password='',
			database='test',
	) as connection:
		query = "SELECT * FROM users"
		
	except Error as e:
	print(e)

Ifuatayo tunaandika muundo mwingine with kwa kufanya kazi na Kitu cha MySQLConnection, kilichohifadhiwa kwenye utofautishi connection. Kitu hiki kinahitaji kutumiwa kwa mtiririko na mbinu maalum. Ya kwanza kati yao ni mbinu cursor, ambayo kutoka kwa Kitu cha MySQLConnection huunda Kitu cha CMySQLCursor. Kwa upande wake humtumia mbinu execute, ambayo inahakikisha utekelezaji wa ombi la SQL, lililopitishwa kwake kama kigeuzi:

try:
	with connect(
		...
	) as connection:
		query = "SELECT * FROM users"
		with connection.cursor() as cursor:
			cursor.execute(query)

Ifuatayo inahitajika kutoa data yote kwa kutumia mbinu fetchall na kuiandika kwenye utofautishi result. Na ili kuchapisha data iliyopatikana, inahitajika kuzipitisha kwenye mzunguko for:

try:
	with connect(
		...
	) as connection:
		query = "SELECT * FROM users"
		with connection.cursor() as cursor:
			cursor.execute(query)
			result = cursor.fetchall()
			
			for row in result:
				print(row)

Nambari kamili itaonekana kama hii:

try:
with connect(
		host='localhost',
		user='root',
		password='',
		database='test',
) as connection:
	query = "SELECT * FROM users"
	with connection.cursor() as cursor:
		print(cursor)
		cursor.execute(query)
		result = cursor.fetchall()
		
		for row in result:
			print(row)
			
except Error as e:
print(e)

Baada ya kutekeleza nambari kwenye konsoli zitachapishwa rekodi zote kwa mfumo wa tuple:

(1, 'user1', 23, 400)
(2, 'user2', 25, 500)
(3, 'user3', 23, 500)
(4, 'user4', 30, 900)
(5, 'user5', 27, 500)
(6, 'user6', 28, 900)

Chapisha data yote kutoka kwenye jedwali users.