import os
import sqlite3
import tempfile
from datetime import datetime

from db.database import conn


def create_database_backup():
    timestamp = datetime.now().strftime("%Y%m%d-%H%M%S")
    backup_path = os.path.join(tempfile.gettempdir(), f"bot-backup-{timestamp}.db")
    target = sqlite3.connect(backup_path)
    try:
        conn.backup(target)
    finally:
        target.close()
    return backup_path