From ce17eacde37c124abe07288ae1453b5b658f8ff2 Mon Sep 17 00:00:00 2001 From: Andrew Date: Wed, 17 Apr 2019 15:01:38 +0400 Subject: =?UTF-8?q?=D0=A7=D0=B5=D1=82=D0=B2=D0=B5=D1=80=D1=82=D1=8B=D0=B9?= =?UTF-8?q?=20=D0=B4=D0=B5=D0=BD=D1=8C,=20=D0=B7=D0=B0=D0=B4=D0=B0=D1=87?= =?UTF-8?q?=D0=B0=20=D0=BD=D0=BE=D0=BC=D0=B5=D1=80=203?= MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- day4/task3/db.py | 57 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 57 insertions(+) create mode 100644 day4/task3/db.py (limited to 'day4/task3/db.py') diff --git a/day4/task3/db.py b/day4/task3/db.py new file mode 100644 index 0000000..15eba02 --- /dev/null +++ b/day4/task3/db.py @@ -0,0 +1,57 @@ +import re +from datetime import datetime + +f = open('otrs_error.log') + +matcher = re.compile(r'\[(?P.*?)\]\[(?P.*?)\]\[(?P.*?)\]\[(?P.*?)\] (?P.*)') + +db = [] + +lines = f.readlines() +f.close() +for line in lines: + line = line.strip() + match = re.match(matcher, line) + + if match: + date = datetime.strptime(match.group('date'), '%c') + module = match.group('module') + + db.append({ + 'date': date, + 'type': match.group('type'), + 'module': module, + 'id': match.group('id'), + 'text': match.group('text') + }) + + else: + print(f'Ошибка при разборе строки:\n{line}') + + +def search_by_date(hour, minute=None, second=None, data=None): + arr = [] + print(f'filtering by h={hour}, m={minute}, s={second}, data="{data}"') + for err in db: + if err['date'].hour == int(hour): + if minute is not None: + if second is not None: + if err['date'].minute == int(minute) and err['date'].second == int(second): + if data in err['module']: + _ = err.copy() + _['date'] = _['date'].ctime() + arr.append(_) + else: + if err['date'].minute == int(minute): + if data in err['module']: + _ = err.copy() + _['date'] = _['date'].ctime() + arr.append(_) + + else: + if data in err['module']: + _ = err.copy() + _['date'] = _['date'].ctime() + arr.append(_) + + return arr -- cgit v1.2.3 From 588cdffdc1f527fac5a7bdd934008882e3efc70d Mon Sep 17 00:00:00 2001 From: Andrew Date: Wed, 17 Apr 2019 20:12:14 +0400 Subject: =?UTF-8?q?=D0=A3=D1=81=D0=BA=D0=BE=D1=80=D0=B5=D0=BD=20=D0=BF?= =?UTF-8?q?=D0=BE=D0=B8=D1=81=D0=BA=20=D0=BF=D0=BE=20=D0=BB=D0=BE=D0=B3?= =?UTF-8?q?=D1=83?= MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- day4/task3/db.py | 54 ++++++++++++++++++++++-------------------------------- 1 file changed, 22 insertions(+), 32 deletions(-) (limited to 'day4/task3/db.py') diff --git a/day4/task3/db.py b/day4/task3/db.py index 15eba02..f4cbd0b 100644 --- a/day4/task3/db.py +++ b/day4/task3/db.py @@ -1,4 +1,5 @@ import re +import bisect from datetime import datetime f = open('otrs_error.log') @@ -17,41 +18,30 @@ for line in lines: date = datetime.strptime(match.group('date'), '%c') module = match.group('module') - db.append({ - 'date': date, - 'type': match.group('type'), - 'module': module, - 'id': match.group('id'), - 'text': match.group('text') - }) + db.append((date.hour, date.minute, date.second, module, line)) else: print(f'Ошибка при разборе строки:\n{line}') +db.sort() + + def search_by_date(hour, minute=None, second=None, data=None): - arr = [] - print(f'filtering by h={hour}, m={minute}, s={second}, data="{data}"') - for err in db: - if err['date'].hour == int(hour): - if minute is not None: - if second is not None: - if err['date'].minute == int(minute) and err['date'].second == int(second): - if data in err['module']: - _ = err.copy() - _['date'] = _['date'].ctime() - arr.append(_) - else: - if err['date'].minute == int(minute): - if data in err['module']: - _ = err.copy() - _['date'] = _['date'].ctime() - arr.append(_) - - else: - if data in err['module']: - _ = err.copy() - _['date'] = _['date'].ctime() - arr.append(_) - - return arr + low = [hour] + high = [hour] + if minute is not None: + low.append(minute) + high.append(minute) + + if second is not None: + low.append(second) + high.append(second + 1) + else: + high.append(60) + else: + high.append(60) + + left = bisect.bisect_left(db, tuple(low)) + right = bisect.bisect_left(db, tuple(high)) + return [t[4] for t in db[left:right] if data in t[3]] -- cgit v1.2.3 From 4a3db50d7df0f636ef824637d33330543e9044b2 Mon Sep 17 00:00:00 2001 From: Andrew Date: Wed, 24 Apr 2019 20:42:29 +0400 Subject: =?UTF-8?q?=D0=98=D1=81=D0=BF=D1=80=D0=B0=D0=B2=D0=BB=D0=B5=D0=BD?= =?UTF-8?q?=D0=B8=D1=8F=20=D1=82=D1=80=D0=B5=D1=82=D1=8C=D0=B5=D0=B9=20?= =?UTF-8?q?=D0=B7=D0=B0=D0=B4=D0=B0=D1=87=D0=B8?= MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- day4/task3/db.py | 68 +++++++++++++++++++++++++++++++++++++++----------------- 1 file changed, 47 insertions(+), 21 deletions(-) (limited to 'day4/task3/db.py') diff --git a/day4/task3/db.py b/day4/task3/db.py index f4cbd0b..c23e9fb 100644 --- a/day4/task3/db.py +++ b/day4/task3/db.py @@ -2,30 +2,9 @@ import re import bisect from datetime import datetime -f = open('otrs_error.log') - -matcher = re.compile(r'\[(?P.*?)\]\[(?P.*?)\]\[(?P.*?)\]\[(?P.*?)\] (?P.*)') db = [] -lines = f.readlines() -f.close() -for line in lines: - line = line.strip() - match = re.match(matcher, line) - - if match: - date = datetime.strptime(match.group('date'), '%c') - module = match.group('module') - - db.append((date.hour, date.minute, date.second, module, line)) - - else: - print(f'Ошибка при разборе строки:\n{line}') - - -db.sort() - def search_by_date(hour, minute=None, second=None, data=None): low = [hour] @@ -45,3 +24,50 @@ def search_by_date(hour, minute=None, second=None, data=None): left = bisect.bisect_left(db, tuple(low)) right = bisect.bisect_left(db, tuple(high)) return [t[4] for t in db[left:right] if data in t[3]] + + +def open_log(path): + try: + f = open(path) + + except FileNotFoundError: + print('Файл с логом не обнаружен') + return + + except PermissionError: + print('Файл с логом не доступен для чтения') + return + + return f + + +# Возвращает значение успешности инициализации базы данных +def init(path) -> bool: + f = open_log(path) + if f is None: + return False + + matcher = re.compile(r'\[(?P.*?)\]\[(?P.*?)\]\[(?P.*?)\]\[(?P.*?)\] (?P.*)') + + lines = f.readlines() + f.close() + for line in lines: + line = line.strip() + match = re.match(matcher, line) + + if match: + try: + date = datetime.strptime(match.group('date'), '%c') + except ValueError: + print(f'Ошибка при разборе строки (Неверный формат даты):\n{line}') + continue + + module = match.group('module') + + db.append((date.hour, date.minute, date.second, module, line)) + + else: + print(f'Ошибка при разборе строки:\n{line}') + + db.sort() + return True -- cgit v1.2.3