"""
Модуль подключения к SQLite.
"""
import sqlite3

DB_PATH = "/home/puh/scud_orion_ai_v2/data/scud_orion_ai.db"

def get_db_connection() -> sqlite3.Connection:
    conn = sqlite3.connect(DB_PATH, timeout=30.0)
    conn.row_factory = sqlite3.Row
    conn.execute("PRAGMA journal_mode = WAL;")
    conn.execute("PRAGMA synchronous = NORMAL;")
    return conn