Python getCursorの例

コード例 #1

ファイル: lists.py プロジェクト: rpalexis/schoolManagement

def listProfs(con):
	cursor = utilitaires.getCursor(con)
	cursor.execute("SELECT * FROM profs")
	datas = cursor.fetchall()
	print("|    ID    |    NOM    |     PRENOM     |")
	for prf in datas:
		print("|    ",prf['id'],"    |","    ",prf['nomProf'],"    |","    ",prf['prenomProf'],"    |")

コード例 #2

ファイル: lists.py プロジェクト: rpalexis/schoolManagement

def listClasse(con):
	cursor = utilitaires.getCursor(con)
	cursor.execute("SELECT * FROM classes")
	datas = cursor.fetchall()
	print("|    ID    |    NOM    |")
	for prf in datas:
		print("|    ",prf['id'],"    |","    ",prf['nomClasse'],"    |")

コード例 #3

ファイル: lists.py プロジェクト: rpalexis/schoolManagement

def listCour(con):
	cursor = utilitaires.getCursor(con)
	cursor.execute("SELECT * FROM cours")
	datas = cursor.fetchall()
	print("|    ID    |    NOM    |     COEFFICIENT     |")
	for prf in datas:
		print("|    ",prf['id'],"    |","    ",prf['nom'],"    |","    ",prf['coeff'],"    |")