/
mialdr
/
python_advanced
Обзор
Документация
Войти
/
mialdr
/
python_advanced
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
module_13_db2/homework/hw2/main.py
27 строк
633 B
Druchek MA
module13 is solved
08 дек 2023, 19:57
08 дек 2023, 19:57
1467561
Код
Авторство
О чём код?
import sqlite3 import csv sql_removes_penalty = """ DELETE FROM `table_fees` WHERE `truck_number` = ?; """ def delete_wrong_fees( cursor: sqlite3.Cursor, wrong_fees_file: str ) -> None: with open(wrong_fees_file) as file: for row in csv.reader(file): print(row) if row[0] != 'car_number': cursor.execute(sql_removes_penalty, (row[0],)) if __name__ == "__main__": with sqlite3.connect("../homework.db") as conn: cursor: sqlite3.Cursor = conn.cursor() delete_wrong_fees(cursor, "../wrong_fees.csv") conn.commit()