✘✘ GRAYBYTE WORDPRESS FILE MANAGER ✘✘

​🇳​​🇦​​🇲​​🇪♯➤ server366.web-hosting.com ​🇻​♯➤ 4.18.0-553.50.1.lve.el8.x86_64 #1 SMP 🇾​♯➤ 2025

𝗛𝗢𝗠𝗘 𝗜𝗗 ♯➤ 67.223.118.204 ♯➤ 𝗔𝗗𝗠𝗜𝗡 𝗜𝗗 216.73.217.42
𝗢𝗣𝗧𝗜𝗢𝗡𝗦 ♯ CRL ♯➤ 𝗢𝗞 ┃ WGT ♯➤ 𝗢𝗞 ┃ SDO ♯➤ 𝗢𝗙𝗙 ┃ PKEX ♯➤ 𝗢𝗙𝗙
𝗗𝗘𝗔𝗖𝗧𝗜𝗩𝗔𝗧𝗘𝗗 ♯➤ 𝗔𝗟𝗟 𝗪𝗢𝗥𝗞𝗜𝗡𝗚....

𝗛𝗢𝗠𝗘
𝗖𝗨𝗥𝗥𝗘𝗡𝗧 𝗙𝗜𝗟𝗘 : /opt/cloudlinux/venv/lib/python3.11/site-packages/ssa/modules/__pycache__//storage.cpython-311.pyc
�

|�&j� ����dZddlZddlmZddlmZmZmZmZddl	Z	ddl	m
Z
mZmZddl
mZmZeGd�d����Zd	eefd
�Zd�Zd	eeeeffd�Zd
�ZdS)zF
Represents storage where ssa data is collected, stored and extracted
�N)�	dataclass)�List�Iterator�Tuple�Dict)�func�cast�distinct)�
session_scope�
RequestResultc�D�eZdZUeed<eeed<eed<eed<dS)�
DomainData�domain_name�domain_total_reqs�is_a_wordpress_domain�urls_numberN)�__name__�
__module__�__qualname__�str�__annotations__r�int�bool���J/opt/cloudlinux/venv/lib64/python3.11/site-packages/ssa/modules/storage.pyrrsF������������C�y� � � ����������rr�returnc#�zK�t|��5}|�tjt	jdtj��t	jtj��t	j	tj
��t	jttj
�������tjt	jdtj�����tjt	jdtj����}t!j|d����}|D]^\}}t%|��}d}dgdz}|D]*\}	}
}}}
||t'|
��<t||
��}�+t)||||���V��_	ddd��dS#1swxYwYdS)z7
    Iterates data from database domain-by-domain.
    �%Hc��|dS�Nrr��items r�<lambda>z#iter_domains_data.<locals>.<lambda>/s
��VZ�[\�V]�r��keyr�)rrrrN)r�queryr�domainr�strftime�
created_at�Count�id�max�	wordpress�countr
�path�group_by�order_by�	itertools�groupby�tuplerr)�engine�db�results_by_hour�results_by_hour_groupedr�group�domain_results_by_hourr�requests_number_by_hour�_�hour�requests_num�is_wordpress�urlss              r�iter_domains_datarCs�����
�v�	�	�!�"��(�(�� ��M�$�
� 8�9�9��J�}�'�(�(��H�]�,�-�-��J�x�
� 2�3�3�4�4�
�
��(�� ��M�$�
� 8�9�9�
�
��(�� ��M�$�
� 8�9�9�
�
�	�#,�"3�O�I]�I]�"^�"^�"^��"9�	�	��K��%*�5�\�\�"��K�()�c�B�h�#�=S�
5�
5�9��4��|�T�5A�'��D�	�	�2�!�+�t�4�4����'�"9�&2�'�	���
�
�
�
�	�#!�!�!�!�!�!�!�!�!�!�!�!����!�!�!�!�!�!s�FF0�0F4�7F4c
#� K�t|��5}|�tjt	jdtj��t	jttj	tj�����d��t	j
tj���d��t	jttjtj�����d�����tj|k���tj�|�����tjt	jdtj�����tjt	jdtj����}d}dgdzdgdzdgdz}}}|D]q\}	}
}}}
|r/||	kr)|t+||||���fV�dgdzdgdzdgdz}}}||t-|
��<||t-|
��<|
|t-|
��<|	}�r|	t+|	|||���fV�ddd��dS#1swxYwYdS)	z6
    Iterates urls data from database url-by-url.
    r�url_throttled_reqs�url_total_reqs�
url_slow_reqsNrr'�r1rErFrG)rr(rr1rr*r+�Sumr	�hitting_limits�
sqlalchemy�Integer�labelr,r-�is_slow_request�filterr)�in_r2r3�dictr)r7r�	all_pathsr8�	urls_data�
previous_pathrErFrGr1r?�url_throttled_req�
url_total_req�url_slow_reqs              r�iter_urls_datarXCs�����
�v�	�	�1
�"��H�H����M�$�
� 8�9�9��H�T��,�j�.@���
�
��u�)�*�*��J�� �
�
��e�$�%�%��H�T��-�z�/A�C�C�
�
��e�O�$�$�
�
��&�� �K�/�
�
�
�&���"�"�9�-�-�
�
�
�(����
�d�M�4L� M� M�
�
�
�(����
�d�M�4L� M� M�
�
�%	�,�
�
�C�"�H�q�c�B�h���b��-:�N��KT�	!�	!�F�D�$�)�=�,��
1��$�!6�!6�#�T�&�'9�#1�"/�	&�&�&������C�"�H�q�c�B�h���b��5B�N�"�->��s�4�y�y�)�(5�N�3�t�9�9�%�'3�M�#�d�)�)�$� �M�M��D��1�)�'�	
�
�
�
�	
�	
�	
�Y1
�1
�1
�1
�1
�1
�1
�1
�1
�1
�1
�1
����1
�1
�1
�1
�1
�1
s�I$J�J�
Jc#�K�t|��5}|�tjtj���tj|k���tj��}tj	|d���}|D]\}}|d�|D��fV��	ddd��dS#1swxYwYdS)zA
    Get information about durations of requests url-by-url.
    c��|dSr!rr"s rr$z#get_url_durations.<locals>.<lambda>�s
��D��G�rc��g|]\}}|��Srr)�.0r>�durations   r�
<listcomp>z%get_url_durations.<locals>.<listcomp>�s��:�:�:�[�Q���:�:�:rN)
rr(rr1r]rOr)r3r4r5)r7rr8rS�durations_by_pathr&r;s       r�get_url_durationsr`{s#����
�v�	�	�;�"��H�H����"�
�
��&�� �K�/�
�
�
�(���
�
�	�&�-��+�+�-�-��+�	;�	;�J�C���:�:�E�:�:�:�:�:�:�:�:�	;�;�;�;�;�;�;�;�;�;�;�;�;����;�;�;�;�;�;s�BB7�7B;�>B;c
#�K�t|��5}|�tjt	jdtj��t	jttj	tj�����d��t	j
tj���d��t	jttjtj�����d�����tj|k���tjt	jdtj�����tjt	jdtj����}|�tjtj���tj|k���tj��}t+j|d����}t+j|d����}t/|d��}t/|d��}|��|��|\}	}
|\}}|	|kr�d	gd
z}
d	gd
z}d	gd
z}|
D]>\}}}}}||
t1|��<||t1|��<||t1|��<�?d�|D��}|	|t3|	|
||���fV�t/|d��}t/|d��}n'|	|krt/|d��}nt/|d��}|�|��ddd��dS#1swxYwYdS)
u
    Stream per-URL data for a single domain.

    Yields ``(path, durations, url_data)`` per path, where:
    - ``path`` is the URL path (str);
    - ``durations`` is a list of raw request durations for that path;
    - ``url_data`` is a dict with per-hour aggregates
      (``url_throttled_reqs``, ``url_total_reqs``, ``url_slow_reqs``
      as 24-element lists) plus ``path``.

    Merges two ``ORDER BY path`` streams in lock-step instead of
    materialising the per-domain ``{path: [durations...]}`` dict up
    front, which caused OOM on large databases (CLPRO-3077). A second
    benefit: this drops the redundant ``WHERE path IN (...)`` clause —
    both queries already filter by ``domain``, so the path list adds
    no selectivity, only memory pressure on the SQL parser.
    rrErFrGc��|dSr!r��rs rr$z&iter_domain_url_data.<locals>.<lambda>��
���1��rr%c��|dSr!rrcs rr$z&iter_domain_url_data.<locals>.<lambda>�rerNrr'c��g|]\}}|��Srr)r\r>�ds   rr^z(iter_domain_url_data.<locals>.<listcomp>�s��5�5�5�4�1�a�Q�5�5�5rrH)rr(rr1rr*r+rIr	rJrKrLrMr,r-rNrOr)r2r3r]r4r5�nextrrQ)r7rr8�	agg_query�	dur_query�agg_by_path�dur_by_path�agg_item�dur_item�agg_path�	agg_group�dur_path�	dur_grouprErFrGr>r?�	throttled�total�slow�	durationss                      r�iter_domain_url_datarx�s�����$
�v�	�	�E3�"��H�H����M�$�
� 8�9�9��H�T��,�j�.@���
�
��u�)�*�*��J�� �
�
��e�$�%�%��H�T��-�z�/A�C�C�
�
��e�O�$�$�
�
��&�� �K�/�
�
�
�(����M�$�
� 8�9�9�
�
��(����M�$�
� 8�9�9�
�
�#	�,�H�H����"�
�
��&�� �K�/�
�
�
�(���
�
�	� �'�	�~�~�F�F�F���'�	�~�~�F�F�F����T�*�*����T�*�*���"�x�';�"*��H�i�"*��H�i��8�#�#�&'�S�2�X�"�"#��r���!"��b��
�7@�4�4�3�A�t�Y��t�4=�&�s�4�y�y�1�05�N�3�t�9�9�-�/3�M�#�d�)�)�,�,�5�5�9�5�5�5�	��	�4�!�'9�#1�"/�	,�,�,����� ��T�2�2����T�2�2����H�$�$�
 ��T�2�2�����T�2�2��?�"�x�';�ME3�E3�E3�E3�E3�E3�E3�E3�E3�E3�E3�E3����E3�E3�E3�E3�E3�E3s�L"M�M�M)�__doc__r4�dataclassesr�typingrrrrrKrr	r
�ssa.dbrrrrCrXrrr`rxrrr�<module>r}s@��������!�!�!�!�!�!�.�.�.�.�.�.�.�.�.�.�.�.�����+�+�+�+�+�+�+�+�+�+�/�/�/�/�/�/�/�/������������%��*�!5�%�%�%�%�N5
�5
�5
�p;�d�3��c�
�?�.C�;�;�;�;�*W3�W3�W3�W3�W3r


Current_dir [ 𝗡𝗢𝗧 𝗪𝗥𝗜𝗧𝗘𝗔𝗕𝗟𝗘 ] Document_root [ 𝗪𝗥𝗜𝗧𝗘𝗔𝗕𝗟𝗘 ]


[ Back ]
𝗡𝗔𝗠𝗘
𝗦𝗜𝗭𝗘
𝗟𝗔𝗦𝗧 𝗧𝗢𝗨𝗖𝗛
𝗨𝗦𝗘𝗥
𝗦𝗧𝗔𝗧𝗨𝗦
𝗙𝗨𝗡𝗖𝗧𝗜𝗢𝗡𝗦
..
--
25 Jun 2026 5.03 AM
root / root
0755
__init__.cpython-311.pyc
0.18 KB
25 Jun 2026 5.03 AM
root / root
0644
autotracer.cpython-311.pyc
26.442 KB
25 Jun 2026 5.03 AM
root / root
0644
common.cpython-311.pyc
3.229 KB
25 Jun 2026 5.03 AM
root / root
0644
decision_maker.cpython-311.pyc
14.904 KB
25 Jun 2026 5.03 AM
root / root
0644
processor.cpython-311.pyc
15.519 KB
19 May 2026 5.00 AM
root / root
0644
stat_sender.cpython-311.pyc
12.472 KB
19 May 2026 5.00 AM
root / root
0644
storage.cpython-311.pyc
11.361 KB
25 Jun 2026 5.03 AM
root / root
0644

✘✘ GRAYBYTE WORDPRESS FILE MANAGER @ 2026 CONTACT ME ✘✘
Static GIF Static GIF