403Webshell
Server IP : 192.158.238.246  /  Your IP : 18.189.143.114
Web Server : LiteSpeed
System : Linux uniform.iwebfusion.net 4.18.0-553.27.1.lve.1.el8.x86_64 #1 SMP Wed Nov 20 15:58:00 UTC 2024 x86_64
User : jenniferflocom ( 1321)
PHP Version : 8.1.32
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON  |  Sudo : OFF  |  Pkexec : OFF
Directory :  /opt/cloudlinux/venv/lib/python3.11/site-packages/lvestats/lib/__pycache__/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /opt/cloudlinux/venv/lib/python3.11/site-packages/lvestats/lib/__pycache__/dbengine.cpython-311.pyc
�

ЍigJ*��x�ddlZddlZddlZddlmZmZddlmZddlm	Z	ddl
mZddlm
Z
mZddlmZddlmZdd	lmZmZdd
lmZddlmZdZd
\ZZZeeegZedediZdZd�Z d�Z!Gd�de��Z"Gd�de��Z#d'd�Z$d(d�Z%defd�Z&d�Z'd�Z(d)d�Z)d�Z*d*d �Z+d!�Z,d+d"�Z-d,d#�Z.d,d$�Z/d%�Z0d&�Z1dS)-�N)�delete�func)�	Inspector)�make_url)�
_ModuleMarker)�RelationshipProperty�sessionmaker)�	mysql_lib)�FormattedException)�Base�history��LVE_STATS_2_TABLENAME_PREFIX)�alembic_migratez/var/lve/lvestats2.db)�mysql�
postgresql�sqlite�pymysql�psycopg2�shamanc���tj|��}t|�����}d�|D��|z
}t	d�t	|��D����S)z^
    Checks if views exist.
    :param sqlalchemy.engine.base.Engine engine:
    :return:
    c�"�h|]}t|z��
S�r)�.0�ns  ��/builddir/build/BUILDROOT/lve-stats-4.2.11-1.el8.x86_64/opt/cloudlinux/venv/lib/python3.11/site-packages/lvestats/lib/dbengine.py�	<setcomp>z4find_not_existing_tables_or_views.<locals>.<setcomp>+s��D�D�D��0�1�4�D�D�D�c3�LK�|]}|�td��V�� dS)�N)�replacer)r�xs  r�	<genexpr>z4find_not_existing_tables_or_views.<locals>.<genexpr>,s1����Z�Z�����7��<�<�Z�Z�Z�Z�Z�Zr)r�from_engine�set�get_view_names�tuple)�engine�names�	inspector�existing�not_existings     r�!find_not_existing_tables_or_viewsr-#sj���%�f�-�-�I��9�+�+�-�-�.�.�H�D�D�e�D�D�D�x�O�L��Z�Z�e�L�FY�FY�Z�Z�Z�Z�Z�Zrc���ttjj�����}g�d}tj|�����s��tdz���fd�|D��S)zc
    Used to call engine.create_all() without views that are described as Table()
    :return:
    z;/opt/cloudlinux/flags/enabled-flags.d/burstable-limits.flag�bursting_eventsc�&��g|]
}|j�v�|��Sr��name)r�t�tables_for_disabled_featuress  �r�
<listcomp>z4get_list_of_tables_without_views.<locals>.<listcomp>;s&���L�L�L�!���/K�!K�!K�A�!K�!K�!Kr)
�dictr�metadata�tables�values�pathlib�Path�exists�appendr)r8�burstable_limits_feature_flagr4s  @r� get_list_of_tables_without_viewsr?/s����
�$�-�&�
'�
'�
.�
.�
0�
0�F�#%� �$a�!��<�5�6�6�=�=�?�?�^�$�+�+�,H�K\�,\�]�]�]�L�L�L�L�v�L�L�L�Lrc��eZdZdS)�MakeDbExceptionN��__name__�
__module__�__qualname__rrrrArA>��������DrrAc��eZdZdS)�DatabaseConfigErrorNrBrrrrHrHBrFrrHTc���|�d��}|�tdddid����|r6|tvr-td|d�t��d�d����|�d	��}|tkr|�tddd	id����|tkr!|�d
|�dt
����}n)t
|��}|�d|�d
|��}t||��}|S)z�
    Extract and validate database connection uri from config
    :param dict cfg:
    :param bool check_support:
    :return str:
    �db_typeNz#"%(config_variable)s" not in config�config_variable��message�contextz}Incorrect database type %(database_type)s. You should only use %(database_types)s. The correct db_type for mariadb is "mysql"z", ")�
database_type�database_types�connect_stringz:///�sqlite_db_path�+z://)�getrH�SUPPORTED_DATABASES�join�SQLITE�DEFAULT_DB_PATH�get_db_client_library_name�
get_fixed_uri)�cfg�
check_supportrJrQ�uri�client_librarys      r�cfg_get_urir_FsA���g�g�i� � �G���!�=�K\�^g�Jh�i�i�
�
�	
�
�
��(;�;�;�!�=�-4����Tg�Hh�Hh�i�i�
�
�
�
�	
��W�W�-�.�.�N��&���^�3�!�=�K\�^n�Jo�p�p�
�
�	
�
�&����J�J�c�g�g�&6��H�H�J�J���3�G�<�<���>�>�>�>�>�n�>�>���G�S�)�)���JrFc���tjd��}	t||���}nN#t$rA}d}dt	|��i}	|�||	��t
||	d���|�d}~wwxYw|�d|d��|d	urd
|vr|d
}|r&d�}
tj	�
|d|
�
��}n"tj	�
|||���}|S)z�
    Create sqlalchemy database engine
    :param dict cfg:
    :param bool just_print:
    :param bool debug:
    :param pool_class:
    :param bool check_support:
    :return:
    �init_db_engine)r\z2Unable to configure database connection. %(error)s�errorrLNzConnecting to database: %srJF�debugc�$�t|��dS�N)�print)�sql�multiparams�paramss   r�dumpzmake_db_engine.<locals>.dump�s���#�J�J�J�J�Jr�mock)�strategy�executor)�echo�	poolclass)�logging�	getLoggerr_rH�strrbrA�info�
sqlalchemyr(�
create_engine)r[�
just_printrc�
pool_classr\�logrQ�e�msgrNrjr(s            r�make_db_enginer{os%���
�,�
-�
-�C�K�$�S�
�F�F�F�����K�K�K�B���C��F�F�#���	�	�#�w�����#�'�B�B�C�C��J�����	K�����H�H�
)�3�y�>�:�:�:���~�~�'�S�.�.��G����c�	�	�	��"�0�0��&�[_�0�`�`����"�0�0��e�Wa�0�b�b���Ms�(�
A3�<A.�.A3c	��tjd��}|r-d|_|�tj����ddggd�}tj|��}|���}t|j	�
����D�]\}}t|t��r�|j
}	|d�|	��|	|vr�d�|�|	��D��}
t!j|��}|jD]M}t|t&��r�|jD]-}
|
j|
vr"|�d||
j|��d|d<�.�N��|�d	||	|��d|d
<|d�|	����|d
r|�d��|dr|�d
��|S)N�validate_databaseF)�table_error�column_error�missing_tables�
orm_tablesr�c��g|]
}|d��Sr1r)r�cs  rr5z%validate_database.<locals>.<listcomp>�s��V�V�V�!�A�f�I�V�V�Vrz?Model %s declares column %s which does not exist in database %sTrz>Model %s declares table %s which does not exist in database %sr~r�zWYou can run 'lve-create-db --create-missing-tables' command to recreate missing tables.zLYou can try to recreate malformed table, or ask CloudLinux support for help.)rprq�	propagate�
addHandler�NullHandlerrr$�get_table_names�list�_decl_class_registry�items�
isinstancer�
__tablename__r=�get_columnsrt�inspect�attrsr�columns�key�critical)r(�hide_logging�baserx�result�database_inspection�real_tables�_�_class�table�real_columns�mapper�column_prop�columns              rr}r}�s��
�
�/�
0�
0�C��.���
����w�*�,�,�-�-�-�"�E�R�_a�
b�
b�F�#�/��7�7��%�5�5�7�7�K��$�3�9�9�;�;�<�<�3�3�	��6��f�m�,�,�	���$���|��#�#�E�*�*�*��K���V�V�/B�/N�/N�u�/U�/U�V�V�V�L��'��/�/�F�%�|�

:�

:���k�+?�@�@�:��"-�"5�:�:��!�:�\�9�9��L�L� a� &� &�
� &�	���6:�F�>�2��:�

:�
�L�L�Y�[a�ch�jp�q�q�q�$(�F�=�!��#�$�+�+�E�2�2�2�2�
�m��p����n�o�o�o�
�n��e����c�d�d�d��Mrc�H�t|d���}|d|dkS)NT)r�r�r�)r})r(�inspect_results  r�check_need_create_dbr��s*��&�v�D�A�A�A�N��*�+�~�l�/K�K�Krc��tj�|t�����t	|d���dS)N)r8T)�stamp)rr7�
create_allr?r�r(s r�	create_dbr��s=���M���V�,L�,N�,N��O�O�O��F�$�'�'�'�'�'�'rc�l�|st|��rt|��dSt||���dS)N)�
lve_stats_cfg)r�r�r)r(�create_missing_tablesr[s   r�setup_dbr��sG���3� 4�V� <� <�3��&��������c�2�2�2�2�2�2rc�D�tj�|��dSre)rr7�drop_allr�s r�drop_tablesr��s���M���6�"�"�"�"�"rc�.�|���}|���}	ttjj�����D]�\}}|�t|��}nWt|ttf��rt||j
j|v��}nt||j
j|k��}|�|����|�
��dS#t$r|����wxYwre)�connect�beginr�rr7r8r�rr�r'r��	server_id�execute�commit�	Exception�rollback)r(r��conn_�transr��table_object�delete_querys       r�
clear_rowsr��s���N�N���E��K�K�M�M�E��#�D�M�$8�$>�$>�$@�$@�A�A�	(�	(�O�A�|�� �%�l�3�3����I��e�}�5�5�
[�%�l�L�N�4L�PY�4Y�Z�Z���%�l�L�N�4L�PY�4Y�Z�Z���M�M�,�'�'�'�'�
�������������
������
����s�CC4�4 Dc�B�t|��t|��dSre)r�r�r�s r�recreate_dbr��s$�������
�f�����rc�4�|�tj���tj|k���tj���tjtj	��dk���tj
tj	��dk��}|�#|�tj|k��}|�#|�tj|k��}d�|D��S)Nrc��g|]
}|d��S�rr)r�record_s  rr5z(find_lost_keep_alive.<locals>.<listcomp>�s��5�5�5�7�G�A�J�5�5�5r)�queryr
�created�filterr��group_by�havingr�max�id�min)�sessionr��
from_timestmp�to_timestamp�lost_keepalives     r�find_lost_keep_aliver��s���
	�
�
�g�o�&�&�	���!�Y�.�	/�	/�	��'�/�	"�	"�	������$�$�q�(�	)�	)�	������$�$�q�(�	)�	)����'�.�.�w��,�/N�O�O��� �'�.�.�w��-�/O�P�P��5�5�n�5�5�5�5rc��t||||��}|sdSd�ttjj�����D��}||tjj<|D]*}tdi|��}||_|�	|���+|�
��|r&|�dt|��|��dSdS)Nc��i|]}|d��Sr�r)r�cols  r�
<dictcomp>z'fix_lost_keep_alive.<locals>.<dictcomp>s��Q�Q�Q�3��Q�Q�Q�Qrz*Was fixed %s losted keep alive records: %sr)
r�r�r
�	__table__r��keysr�r�r��addr�rs�len)	r�r�r�r��log_�lost_keep_alive�v2_keepalive_row�	timestamp�history_keepalives	         r�fix_lost_keep_aliver��s���*�7�I�}�l�[�[�O�����Q�Q�$�w�/@�/H�/M�/M�/O�/O�*P�*P�Q�Q�Q��.7��W�&�*�+�$�'�'�	�#�7�7�&6�7�7��$-��!����%�&�&�&�&��N�N�����g��	�	�>��O�@T�@T�Ve�f�f�f�f�f�g�grc��t|�����}t||d|||���|���dS)N)�bindr�)r�r�r�)r	r��close)r(r[r�r�r�r�s      r�fix_dbr�sK��'�l��'�'�'�)�)�G����[�!1��]i�pt�u�u�u�u��M�M�O�O�O�O�Orc�f�t�|��}|�tdd|id����|S)zZ
    Get database Python client library name
    :param str db_type:
    :return str:
    NzTThe client library to connect to the "%(database_type)s" database cannot be detectedrOrL)�DB_CLIENT_LIBRARY_MAPrTrH)rJr^s  rrYrYsN��+�.�.�w�7�7�N���!�t�#�W��
�
�
�
�	
��rc�|�|tkr|St|��}ttj|����S)zo
    Get fixed URI for the specified database
    :param str db_type:
    :param str uri:
    :return str:
    )�MYSQLrrrr
�get_rfc1738_db_uri)rJr]�us   rrZrZ&s8���%����
���
�
�A��y�+�A�.�.�/�/�/r)T)FFNT)FNre)NN)NNN)2rpr:�sqlalchemy.enginertrr�sqlalchemy.engine.reflectionr�sqlalchemy.engine.urlr�&sqlalchemy.ext.declarative.clsregistryr�sqlalchemy.ormrr	�clcommonr
�clcommon.clexceptionr�lvestats.ormrr
r�lvestats.utils.dbmigratorrrXr��
POSTGRESQLrWrUr��
__author__r-r?rArHr_r{r}r�r�r�r�r�r�r�r�r�rYrZrrr�<module>r�s���������������#�#�#�#�#�#�#�#�2�2�2�2�2�2�*�*�*�*�*�*�@�@�@�@�@�@�=�=�=�=�=�=�=�=�������3�3�3�3�3�3�&�&�&�&�&�&�&�&�5�5�5�5�5�5�5�5�5�5�5�5�)��;���z�6��j�&�1��	�9��
���
�
�	[�	[�	[�M�M�M�	�	�	�	�	�(�	�	�	�	�	�	�	�	�,�	�	�	�&�&�&�&�R!�!�!�!�H,1�t�&�&�&�&�RL�L�L�
(�(�(�3�3�3�3�#�#�#�����$���
6�6�6�6�$g�g�g�g�"�������&0�0�0�0�0r

Youez - 2016 - github.com/yon3zu
LinuXploit