관리-도구
편집 파일: 15fed017ca0b_add_uid_column.cpython-311.pyc
� �Cg � �. � d Z ddlZddlZddlZddlmZ ddlmZ ddlmZm Z m Z m Z m Z m Z mZ ddlmZ dZdZdZdZd Z e � � Z ej d ej � e� � � �� � Z ed e d d d �� � ed e d� � d d �� � ede � � ede � � ede � � ede � � ede � � ede � � ede � � ed e d� � d d �� � f Z ed e d d �� � e de� d �d � � ed e d d �� � ede � � ede � � ede � � ede � � ede � � ede � � ede � � ed e d� � d d �� � f Z d � Z d � Z dS ) zzReplace columns username to uid Revision ID: 15fed017ca0b Revises: 48efb1674139 Create Date: 2016-07-22 17:19:55.478609 � N)�op)�context)�Column�Integer�String�Float�Index�MetaData�Table)� uidconverter� 15fed017ca0b� 48efb1674139�lve_stats2_history_govzalembic.script.�tsTF)�index� primary_key� autoincrement�username�@ )r r �sum_cpu� sum_write�sum_read�limit_cpu_on_period_end�limit_read_on_period_end�limit_write_on_period_end�cause_of_restrict� server_id� �ix_�_ts_2�uidc �� � t j � � } t j j � d� � d }t j t � � }t dz t z }t j t |� � t j t gt �R � }t |t gt �R � }| � � � }| � |� � � � � }|� � � D ]�}t |� � } | d } | � d� � } | || v r|| | } nFt- j | || | � � pd} | dk r t0 � d| | � � | || | < | dk r-| | d< | � |� | � � � � ��|� � � t j |� � d S ) N� lve-statsr �_r ���r z.Can't obtain uid for user "%s"; server_id "%s"r! ) r �get_bindr �config� attributes�get� collections� defaultdict�dict�HISTORY_GOV_TABLE_NAME� down_revision� rename_table� create_table�history_gov_new_itemsr �metadata�history_gov_old_items�begin�execute�select�fetchall�popr �username_to_uid�logger�warning�insert�commit� drop_table) � connection�local_server_id�username_to_uid_cache�tablename_renamed� history_gov�history_gov_old�trans�data_history_gov_old�history_gov_old_row�history_gov_new_rowr r r! s ��/builddir/build/BUILDROOT/lve-stats-4.2.10-1.el8.x86_64/opt/cloudlinux/venv/lib/python3.11/site-packages/lvestats/utils/dbmigrator/versions/15fed017ca0b_add_uid_column.py�upgraderJ ? s� � ��� � �J� �n�/�3�3�K�@�@��M�O� '� 3�D� 9� 9��.��4�}�D�� �O�*�,=�>�>�>��/� �8�!6�8� 8� 8�K� � -�x�P�:O�P�P�P�O� � � � � �E�%�-�-�o�.D�.D�.F�.F�G�G�� 3� <� <� >� >� H� H�� "�#6� 7� 7��'� �4� �&�*�*�:�6�6�� �,�Y�7� 7� 7�'� �2�8�<�C�C� �.��/�9�j�B� B� H�EG� ��Q�w�w����E� �i�� � � :=� !�)� ,�X� 6� ��7�7�),� �� &� � � �{� 1� 1�2E� F� F� G� G� G�� �L�L�N�N�N��M�#�$�$�$�$�$� c �� � t j � � } t j j � d� � d }t j t � � }t dz t z }t j t |� � t j t gt �R � }t |t gt �R � }| � � � }| � |� � � � � }|� � � D ]�}t |� � } | d } | � d� � } | || v r|| | } n@t- j | || | � � } | � t0 � d| | � � | || | < | r-| | d< | � |� | � � � � ��|� � � t j |� � d S )Nr# r r$ r! z3Can't obtain user name for uid "%s"; server_id "%s"r ) r r& r r' r( r) r* r+ r, r- �revisionr/ r0 r3 r r2 r1 r4 r5 r6 r7 r8 r �uid_to_usernamer: r; r< r= r> ) r? r@ �uid_to_username_cacherB rD rC rE �data_history_gov_newrH �history_gov_old_dictr r! r s rI � downgraderR e s� � ��� � �J� �n�/�3�3�K�@�@��M�O� '� 3�D� 9� 9��.��4�x�?�� �O�*�,=�>�>�>��o� �8�!6�8� 8� 8�O� �)�8�L�6K�L�L�L�K� � � � � �E�%�-�-�k�.@�.@�.B�.B�C�C�� 3� <� <� >� >� M� M�� #�$7� 8� 8� �(��5� �"�&�&�u�-�-�� �'� �2� 2� 2�,�Y�7��<�H�H�#�3��_�i��=� =�H�� ����J���� � � 5=� !�)� ,�S� 1� � M�/7� �� ,� � � �� 5� 5�6J� K� K� L� L� L�� �L�L�N�N�N� �M�#�$�$�$�$�$rK ) �__doc__�logging�osr* �alembicr r � sqlalchemyr r r r r r r � lvestats.libr rM r. � branch_labels� depends_onr- r2 � getLogger�path�basename�__name__r: r3 r1 rJ rR � rK rI �<module>r` s� ��� � ���� � � � � � � � � � � � � � � � � � � � � M� M� M� M� M� M� M� M� M� M� M� M� M� M� M� M� M� M� %� %� %� %� %� %� �� � �� � � �1� � �8�:�:�� �� �I�R�W�-=�-=�h�-G�-G�I�I� J� J�� �F�4���$�e�L�L�L� �F�:�v�v�b�z�z�t�5�I�I�I� �F�9�e� � � �F�;�� � � �F�:�u� � � �F� $�g�.�.� �F� %�w�/�/� �F� &��0�0� �F� ��(�(� �F�;���s� � ��U�K�K�K� � � �F�4��d�%�@�@�@� �E� -�&� -� -� -�t�4�4� �F�5�'�t�5�A�A�A� �F�9�e� � � �F�;�� � � �F�:�u� � � �F� $�g�.�.� �F� %�w�/�/� �F� &��0�0� �F� ��(�(� �F�;���s� � ��U�K�K�K� � � #%� #%� #%�L$%� $%� $%� $%� $%rK