hh dZddlZddlZddlZddlZeejjdZ ejje ddl m Z mZmZdZdZdefdZded efd Zded eefd Zded edefdZy)z& module for db manipulation functions NROOT_DIR_GESTAO_MIDIA)engine alchemy_exectextcd} tj5}|jt|d|ij cdddS#1swYyxYw#t j $r}td||d}~wt j$r}td||d}~wt j$r}td||d}~wt$r}td||d}~wwxYw)= iterate through all blogs related to media database zJ SELECT blog_id, path FROM wp_blogs WHERE blog_id = :blog_id; blog_idNErro de conexão: Erro no banco de dados: Erro SQLAlchemy: Erro inesperado: rbeginexecuterfetchallrInterfaceError RuntimeError DatabaseErrorSQLAlchemyError Exception)r sqlconnerrs D/var/www/html/p-interativo-gestao-midia/app/utils/db/db_functions.py get_wp_blogrs  C? \\^t<<S Iw+?@IIK^^  & &@/u56C?  % %F5cU;<#E  ' '?.se453> ?.se453>?sXA+A  A AAAC%,A;;C%B  C%6C C%C  C%cd} tj5}|jt|j cdddS#1swYyxYw#t j $r}td||d}~wt j$r}td||d}~wt j$r}td||d}~wt$r}td||d}~wwxYw)rzT SELECT blog_id, path FROM wp_blogs WHERE blog_id > 1 ORDER BY blog_id; Nr r r r r)rrrs rget_all_wp_blogsr-s  C? \\^t<<S *335^^  & &@/u56C?  % %F5cU;<#E  ' '?.se453> ?.se453>?sXA(A  A AAAC")A88C"BC"3C C"CC"r c\tjjjtjdz }d|d|d} d|i}t j 5}t jt|||}|cdddS#1swYyxYw#tj$r}td ||d}~wtj$r}td ||d}~wtj$r}td ||d}~wt$r}td ||d}~wwxYw) z get all messages with attachment error from last 2 days Args: blog_id: int = current blog id Returns: messages_list: list(string) = a list of messages received from one hour ago until now g?daysK SELECT pm.post_id, pm.midia, pm.galeria_de_midias FROM wp_1_posts p LEFT JOIN ( SELECT meta.post_id, MAX(CASE WHEN meta.meta_key = 'midia' THEN meta.meta_value END) AS midia, MAX(CASE WHEN meta.meta_key = 'galeria_de_midias' THEN meta.meta_value END) AS galeria_de_midias from wp_a_postmeta meta WHERE meta.meta_key IN ('midia', 'galeria_de_midias') GROUP BY meta.post_id ORDER BY meta.post_id ) pm ON p.ID = pm.post_id WHERE p.post_date >= :date AND p.post_type = "mensagem" AND pm.midia <> "" AND (galeria_de_midias LIKE '%midia%' OR galeria_de_midias IS NULL OR galeria_de_midias = '') daterconparamsNr r r r )datetimenowr# timedeltarrpdread_sqlrrrrrrr)r r#rr&r df_mensagensrs rget_no_galery_messagesr-Gs#    " ' ' )H,>,>C,H HD  ! " C*?$ \\^t;;49$vNL^^  & &@/u56C?  % %F5cU;<#E  ' '?.se453> ?.se453>?sZB&#B BBBBD+2CD+C&&D+<D  D+D&&D+msg_idcd|d|d} d|i}tj5}tjt |||}|cdddS#1swYyxYw#t j $r}td||d}~wt j$r}td||d}~wt j$r}td ||d}~wt$r}td ||d}~wwxYw) z get specific message with attachment error Args: blog_id: int = current blog id Returns: messages_list: list(string) = a list of messages received from one hour ago until now r!r"a_postmeta meta WHERE meta.meta_key IN ('midia', 'galeria_de_midias') GROUP BY meta.post_id ORDER BY meta.post_id ) pm ON p.ID = pm.post_id WHERE p.ID = :msg_id AND p.post_type = "mensagem" AND pm.midia <> "" AND (galeria_de_midias LIKE '%midia%' OR galeria_de_midias IS NULL OR galeria_de_midias = '') r.r$Nr r r r ) rrr*r+rrrrrrr)r r.rr&rr,rs rget_no_galery_specific_messager0ws  ! " C*?F# \\^t;;49$vNL^^  & &@/u56C?  % %F5cU;<#E  ' '?.se453> ?.se453>?sXA#A AAAAC(/A>>C(B##C(9C C(C##C(file_names_arrc|sgStjjjtjdz }dj |}d|d|d|d} t j 5}|jt|j}|Dcgc]}t|dc}cd d d Scc}w#1swYy xYw#tj$r}td ||d }~wtj$r}td ||d }~wtj$r}td ||d }~wt $r}td ||d }~wwxYw)z gets ids from attachments based on file names Args: file_names_arr: list(string) = a list of file names Results: attachment_ids: list(int) = a list of ids g@rz', 'z: SELECT id, post_title, post_name FROM wp_z%_posts WHERE post_title IN ('z}') AND post_name REGEXP '^[a-f0-9]{32}-[a-z0-9]{3,4}$' AND post_type = 'attachment' AND post_date >= ; rNr r r r )r'r(r#r)joinrconnectrrrstrrrrrrr) r r1 yesterday placeholdersrrresultrowrs rget_ids_from_filenamesr;sa  !!%%',,.1C1C1MMI;;~.L +n-$%  C? ^^ \\$s),557F+126CCAK62 2   & &@/u56C?  % %F5cU;<#E  ' '?.se453> ?.se453>?sl&C:-C 'C<C > CC  CCCE%,C;;E%D  E%6E E%E  E% message_idserialized_ids_arraycd|d|d|d} tj5}|jt||j dddy#1swYyxYw#t j $r}td||d}~wt j$r}td||d}~wt j$r}td||d}~wt$r}td ||d}~wwxYw) z Inserts ids into message attachment galery Args: blog_id: int message_id: int ids_serialized_array: str Results: attachment_ids: list(int) = a list of ids z UPDATE wp_z_postmeta SET meta_value = 'z5' WHERE meta_key = 'galeria_de_midias' AND post_id = r3Nr r r r ) rr5rrcommitrrrrrr)r r<r=rrrs rgalery_insert_attachment_idsr@s)78L7MNCDNCOO C? ^^  LLc # KKM    & &@/u56C?  % %F5cU;<#E  ' '?.se453> ?.se453>?sXA"+A A"AA"A""C.5BC.B))C.?C C.C))C.)__doc__ossysr'pandasr*r6environget ROOT_PATHpathappendapp.utils.db.db_connectionrrrrrintr-r0listr;r@rrOs   67 8  ?2?4.?C.?`-?C-?-?`%?C%?c%?P? ?!?9<?rN