# db app part

import os
import sys
import sqlite3
import logging

appDir = os.path.dirname(os.path.realpath(__file__))

#concect to database
if os.path.isfile(os.path.join(appDir,'odm.sqlite')):
	db = sqlite3.connect('odm.sqlite')
else:
	print('couln\'t open database file')
	sys.exit()

#start logging
logger = logging.getLogger(__name__)
formatter = logging.Formatter('%(asctime)s - %(levelname)s - %(message)s')
handler = logging.TimedRotatingFileHandler('my_app.log', when='midnight', interval=1, backupCount=365)
handler.setFormatter(formatter)
logger.setLevel(logging.DEBUG)  # Adjust level as needed (e.g., DEBUG, WARNING)
logger.addHandler(handler)

logger.warning('Načtení')