from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
import logging
from time import sleep
from xlogger import XLogger
from utils import SqlHandler
import sys

engine = create_engine("sqlite:///test.db")
Session = sessionmaker(bind=engine)

logger = logging.getLogger()
logger.setLevel(logging.DEBUG)
session = Session()
sql_handler = SqlHandler(session)
file_handler = logging.FileHandler("test.log")
logger.addHandler(file_handler)
logger.addHandler(sql_handler)


xlogger = XLogger(logger)
xlogger.start()

while True:
    try:
        sleep(1)
    except KeyboardInterrupt:
        break

logger.disabled = True
xlogger.stop()
xlogger.join()
sql_handler.close()
file_handler.close()
session.close()
sys.exit(0)