g7ۂ d dl Z d dlZd dlZd dlmZmZ d dlmZmZmZm Z m
Z
m Z m Z d dl
mZ d dlmZ d dlmZ d dlmZmZ e Z G d d e Z G d
d e Zd Zd
Zd Zd Z ddZ ej defd Z dS ) N)datetime timedelta)ColumnBooleanDateTimeIntegerString
create_engineevent)declarative_base) Inspector)Session)WMT_DBRETENTION_TIME_DAYSc e Zd ZdZdZ eed Z ee Z ee
d d Z ee Z
eed Z eed ZdS ) ScrapeResultz2
created_date is saved in local TZ format
scrape_resultT primary_keyc ( t j S Nr now /builddir/build/BUILDROOT/cl-web-monitoring-tool-3.2.3-1.el9.cloudlinux.x86_64/opt/cloudlinux/venv/lib/python3.11/site-packages/wmt/db.pyzScrapeResult.) s 8<>> r defaultindex)nullableN)__name__
__module__ __qualname____doc__
__tablename__r r idr websiter create_dater is_finished
response_coderesponse_time_msr r r r r ! s $M T * * *BfVnnG&+A+ANNNK&//KF7T222M vg555r r c e Zd ZdZdZ eed Z eed Z ee
d d Z ee d Z
d
S ) DomainAlertsz0
alert_time is saved in local TZ format
domain_alertsTr )r c ( t j S r r r r r r zDomainAlerts.9 s (,.. r r F)r N)r" r# r$ r% r& r r r' r r( r
alert_timer is_resolvedr r r r. r. 1 su $M T * * *BfV4(((G*@*@MMMJ&%000KKKr r. c t j t t z
}t | 5 }| t t j |k | t t j |k d d d d S # 1 swxY w Y d S )N)days) r todayr r
session_scopequeryr filterr) deleter. r1 )engine
n_days_agosessions r cleanup_old_datar= > s !!I3F$G$G$GGJ v '
l##
VL,z9
:
:
VXXX
l##
VL+j8
9
9
VXXX
s BC!!C%(C%c f t | s!t j | d S d S r )
is_db_presentBasemetadata
create_all)r: s r create_db_if_not_existrC I s8 )
((((() )r c t j t sdS t j | }d | D }t | dk S )NFc g | ]}|S r r ).0tables r
z!is_db_present..R s
G
G
Ge
G
G
Gr r )ospathisfiler r
from_engineget_table_nameslen)r: database_inspectiontabless r r? r? N s^
7>>& ! ! u#/77
G
G!4!D!D!F!F
G
G
GF v;;?r c 0 | d d S )NzPRAGMA journal_mode = WAL)execute) dbapi_con
con_records r setup_wal_moderU V s
122222r Fc dt | r dfd}t d|d }t j |dt t j d } t | t j | n# t j | w xY w| sWt j t d t d
t d fD ](} t j |d # t $ r Y %w xY w|S ) Nzfile:z?mode=roc 0 t j d S )NT)uri)sqlite3connect)connection_strings r r z setup_database..^ s go&7TBBB r z sqlite:////F)creatorechorZ _ i z-walz-shm)
r r
r listenrU rI umaskrC chmodFileNotFoundError)readonlyr\ r: old_umasksiblingr[ s @r setup_databaserf Z s+ ((( ; 0 : : :BBBBG
wU F
LN333I v&&&
!F 9 G
%(((($
Ms A> >B
C
C-,C-returnc # K t | } |V | n# | xY w | dS # | w xY w)zrt s
( ( ( ( ( ( ( ( 8 7 7 7 7 7 2 2 2 2 2 2 " " " " " " 8 8 8 8 8 8 8 8
6
6
6
6
64
6
6
6
1
1
1
1
14
1
1
1 ) ) )
3 3 3 F
W
r