/
Newest
/
Create_bill
Обзор
Документация
Войти
/
Newest
/
Create_bill
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
test.py
62 строки
2 KB
Provocarot
update test.py
19 окт 2024, 16:44
19 окт 2024, 16:44
fadb677
Код
Авторство
О чём код?
import sqlite3 class Account: def __init__(self, db_name): self.conn = sqlite3.connect(db_name) self.cursor = self.conn.cursor() print("success") def insert_bank_acc(self): name = input("Input bank name: ") bik = input("Input bik: ") cor_num = input("Input cor_num: ") trad_acc = input("Input trade_acc: ") self.cursor.execute("INSERT INTO bank (name, bik, kor, account, company) VALUES (?, ?, ?, ?, ?)", (name, bik, cor_num, trad_acc)) self.conn.commit() print(" insert bank DONE") def insert_company(self): comp_name = input("Input company name: ") inn = input("Input inn: ") kpp = input("Input kpp: ") if not (self.check_inn(inn)): self.cursor.execute("INSERT INTO company (name, inn, kpp, adress) VALUES (?, ?, ?, ?)", (comp_name, inn, kpp)) self.conn.commit() print(" insert company DONE") else: print('Компания уже есть') def show_tables(self): self.cursor.execute("SELECT * from company") print(self.cursor.fetchall()) self.cursor.execute("SELECT * from bank_acc") print(self.cursor.fetchall()) def fetch_one_comp(self, inn): self.cursor.execute(f"SELECT * from company where inn = '{inn}'") comp = self.cursor.fetchall() return comp def fetch_one_bank(self, bank_name): self.cursor.execute(f"SELECT * from bank where name = '{bank_name}'") bank = self.cursor.fetchall() return bank def __del__(self): self.conn.close() print("close DONE") def check_inn(self, inn): self.cursor.execute(f"SELECT * from company where inn = '{inn}'") comp = self.cursor.fetchall() if comp: return True return False #database schema: #costumer (custID, name, adress, email) #orders (orderID, custID, amount, date) #item(itmeID, title, price) #order_items(orderID, itemID, qutty) #company()