/
darkus
/
love_bot
Обзор
Документация
Войти
/
darkus
/
love_bot
Код
Запросы
0
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
main
data/sqlite_connect.py
49 строк
1 KB
Pavel Repin
add README.md, auxiliary_module.py, logs_hendler_telegram.py, code optimization
13 мар 2024, 10:35
13 мар 2024, 10:35
2759d65
Код
Авторство
О чём код?
import logging import sqlite3 from dotenv import load_dotenv import os load_dotenv() logger = logging.getLogger(__name__) class DatabaseConnect: def __init__(self, path_to_db=os.getenv('PATH_TO_DB')): self.path_to_db = path_to_db @property def connect(self): return sqlite3.connect(self.path_to_db) def execute(self, sql: str, parameters: tuple = None, fetchall=False, fetchone=False, commit=False): if not parameters: parameters = tuple() connection = self.connect cursor = connection.cursor() data = None with connection: cursor.execute(sql, parameters) if commit: connection.commit() if fetchone: data = cursor.fetchone() if fetchall: data = cursor.fetchall() return data def logger_bd(stattement): logging.basicConfig( level=logging.INFO, format='%(asctime)s - %(name)s - %(levelname)s - %(message)s') logging.info(f""" ________________________________________ Executing: {stattement} ________________________________________ """)