/g dZddlZddlZddlmZeej j dZejjeddl m Z m Z dZ dZded efd Zy) z& module for db manipulation functions N)datetimeROOT_DIR_PHONETRACK_API)mydbmysqlcd} tj}|j|tj |jy#tj j $r}t||d}~wtj j$r}t||d}~wt$r}t||d}~wwxYw#jwxYw)z2 function to create table if not existent a; CREATE TABLE IF NOT EXISTS wp_last_clients_calls_update ( id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, client_name VARCHAR(150) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci N) rcursorexecutecommitr connectorInterfaceError RuntimeError DatabaseError Exceptionclose)sqlmycursorerrs F/var/www/html/phonetrack_api_data_manager/app/utils/db/db_functions.py$should_create_last_client_call_tablers  C;;=   ?? ) ))3S( ?? ( ()3S( )3S() s;9AC, A88 C B$$ C0 B<<CCCctd} tj}|j|||gtjt d |jy#t jj$r}t||d}~wt jj$r}t||d}~wt$r}t||d}~wwxYw#jwxYw)z8 function to insert into last_client_call table z INSERT INTO wp_last_clients_calls_update ( client_name, created_at ) VALUES ( %s, %s ) z+last_client_call table updated successfullyN) rrrr r printrr r r rrr) client_namedaterrrs rinsert_last_client_call_tabler2s)* C;;={D12  ;<  ?? ) ))3S( ?? ( ()3S( )3S() s<AA''C B C0 B<< C CCCC.rrcd}|r|d}|d}|d|d|dz }|dz } tj}|j||f|j}|r|dn t d d d f |j S#t jj$r}t||d }~wt jj$r}t||d }~wt$r}t||d }~wwxYw#j wxYw) z function to get the last call date for specific client Args: client_name: str = client name Returns: timestamp stringfied zh SELECT created_at FROM wp_last_clients_calls_update WHERE client_name = %s z T00:00:00z T23:59:59zAND created_at BETWEEN 'z' AND 'z' zORDER BY created_at DESCriN) rrr fetchallrrrr r r rr)rrr date_startdate_endrdatars rget_last_client_call_dater!Ts  C  vY' V9% )*WXJbII %%C;;={n-  "tAwXdAq%9$;;  ?? ) ))3S( ?? ( ()3S( )3S() s<A A>>C0 B'' C0 C C0 C++C00C33D)__doc__ossysrstrenvironget ROOT_PATHpathappendapp.utils.db.db_connectionrrrrr!rr.s`   89 :   >D&3&c&r-