def wrapper(**kwargs):
tries = kwargs['tries']
delay = kwargs['delay']
db_name = kwargs['db_name']
for i in range(int(tries)):
logger.info(f'It is y {i} try to connect')
conn = None
if os.path.isfile(db_name):
try:
conn = sqlite3.connect(db_name)
except Exception as e:
logger.error(f' The {i} attempt failed', exc_info=True)
time.sleep(delay)
else:
logger.error
return conn
else:
logger.error(f'No database {db_name}')
def wrapper(**kwargs):
tries = kwargs['tries']
delay = kwargs['delay']
db_name = kwargs['db_name']
for i in range(int(tries)):
logger.info(f"It is my {i+1} try to connect")
conn = None
if os.path.isfile(
db_name
): #tutaj sprawdzenie czy jest taki plik bo wcześniej nam tworzył a tego nie chcemy
try:
conn = sqlite3.connect(db_name, timeout=20)
except Exception as e:
logger.error(f"The {i+1} attempt failed", exc_info=True)
time.sleep(delay)
else:
logger.info(f"Connection established")
return conn
else:
logger.error(f"No database {db_name}")
db_name = r'E:\Moje\Python szkolenie\Python zaawansowany\Project\clinic.db'
db = Db_executer(db_name)
after = dict([(f, None) for f in os.listdir(path_to_watch)])
added = []
for name in after: #sprawdzamy czy pojawił sie nowy plik
if not name in before: #porównanie
added.append(name) #jeśli nie ma tej nazwy w before to dodaj
removed = []
for name in before:
if not name in after:
removed.append(name)
if added: #jeśli lista nie jest pusta to wchodze do tego bloku
logger.info(f"Added : {added}")
for added_file in added: #dla każdego pliku z listy dodanych wykonaj:
if 'patients' in added_file: #jeśli w nazwie jest słowo patients to :
with open(added_file, 'r') as file: #otwórz ten plik
rows = file.readlines() #odczytaj wiersz po wierszu
for row in rows: #dla kazdego wiersza wykonaj:
row = row.split(',') #podziel string na liste
print(row)
db.insert_new_patient(row[0], row[1], row[2], row[3])
if 'antarctica' in added_file:
for name in added_file:
db.antarctica_analysis(name)
else:
logger.info("Nothing was added")
if removed:
#from db_executer import Db_executer
from CustomLogger import logger
import datetime
'''db_name = r"C:\Users\Kasia\PycharmProjects\W1_cwiczenia\Project\clinic.db"
db = Db_executer(db_name)'''
logger.info(f'Start{datetime.datetime.now()}')
#db.create_analysis_table()
#db.close_conn()
def send_sms(msg,phone_num):
log.info(f"We sent message: {msg} to: {phone_num}")
'''with open(r"C:\Users\Kasia\PycharmProjects\W1_cwiczenia\Project\Antarctica.csv", encoding='UTF-8-sig') as csv_file3:
all_row = csv.reader(csv_file3, delimiter=';')
dane = db.select_all_tasks(table_name='patients')
for row in all_row:
if row[4] != 'collection_time':
row[4] = str(datetime.strptime(row[4], "%d.%m.%Y %H:%M"))
if row[5] == 'T':
row[5] = 'True'
else:
row[5] = 'False'
if row[2] != 'pesel':
#print(row[2])
import os
import time
from db_executer import Db_executer
from CustomLogger import logger
import datetime
logger.info(f"Start {datetime.datetime.now()}")
path_to_watch = '.'
before = dict([(f, None) for f in os.listdir(path_to_watch)])
while 1:
db_name = r'C:\Users\Kasia\PycharmProjects\W1_cwiczenia\Project\clinic.db'
db = Db_executer(db_name)
after = dict([(f, None) for f in os.listdir(path_to_watch)])
added = []
for name in after: #sprawdzamy czy pojawil sie nowy plik
if not name in before: # porownanie
added.append(
name) #jesli nie a tej nazwy to znaczy ze zostal dodany
removed = []
for name in before:
if not name in after:
removed.append(name)
if added: # jesli lista nie jest pusta to wchodze do tego bloku
logger.info(f'Added:{added}')
for added_file in added: # dla kazdego pliku