/
Russid
/
python_advanced
Обзор
Документация
Войти
/
Russid
/
python_advanced
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
module_13_db2/materials/select_order_by.py
24 строки
611 B
itookyourboo
Задания разбиты по папкам
07 окт 2022, 11:08
07 окт 2022, 11:08
0a33b03
Код
Авторство
О чём код?
import sqlite3 get_all_people_by_class_sql: str = """ SELECT * FROM `table_school` WHERE class = ? ORDER BY amount_of_money """ def get_worst_student_name_by_class_number( c: sqlite3.Cursor, class_number: int, ) -> str: c.execute(get_all_people_by_class_sql, (class_number,)) student_data: tuple = c.fetchone() return student_data[1] if __name__ == "__main__": with sqlite3.connect("db_school.db") as conn: cursor: sqlite3.Cursor = conn.cursor() worst_student: str = get_worst_student_name_by_class_number(cursor, 9) print(worst_student)