ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: opt / alt / python37 / lib / python3.7 / site-packages / lvestats / utils / dbmigrator-back / versions / pycache

����@��c#������������������@���s���d�Z�ddlmZ�ddlZddlZddlZddlmZ�ddlmZ�ddl	m
Z
mZmZm
Z
mZmZmZ�ddlmZ�dZd	ZdZdZd
Ze��Ze�dej�e���Ze
ded
d
dd�e
ded�d
dd�e
de
�e
de
�e
de
�e
de�e
de�e
de�e
de�e
ded�d
dd�f
Ze
ded
dd�ed�e�d�e
ded
dd�e
de
�e
de
�e
de
�e
de�e
de�e
de�e
de�e
ded�d
dd�fZ dd��Z!d d!��Z"dS�)"zzReplace columns username to uid

Revision ID: 15fed017ca0b
Revises: 48efb1674139
Create Date: 2016-07-22 17:19:55.478609

�����)�absolute_importN)�op)�context)�Column�Integer�String�Float�Index�MetaData�Table)�uidconverterZ15fed017ca0bZ48efb1674139Zlve_stats2_history_govzalembic.script.%sZtsTF)�index�primary_key�
autoincrement�username�@���)r���r���Zsum_cpuZ	sum_writeZsum_readZlimit_cpu_on_period_endZlimit_read_on_period_endZlimit_write_on_period_endZcause_of_restrict�	server_id����z
ix_{}_ts_2�uidc��������
������C���s(��t����}�tjj�d�d�}t�t�}t	d�t
�}t��t	|��t�jt	ft
���}t|tft���}|����}|��|����}x�|���D�]�}t|�}	|	d�}
|	�d�}|||
�kr�||
�|�}n:t�|||
|��p�d}|dk�r�t�d||
f���|||
�|<�|dkr|||	d<�|��|�|	���q|W�|����t��|��d�S�)	Nz	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���Zusername_to_uid�logger�warning�insert�commit�
drop_table)
�
connection�local_server_idZusername_to_uid_cache�tablename_renamed�history_gov�history_gov_old�transZdata_history_gov_oldZhistory_gov_old_row�history_gov_new_rowr���r���r�����r6����o/opt/alt/python37/lib/python3.7/site-packages/lvestats/utils/dbmigrator/versions/15fed017ca0b_add_uid_column.py�upgrade?���s6����

r8���c��������
������C���s ��t����}�tjj�d�d�}t�t�}t	d�t
�}t��t	|��t�jt	ft
���}t|tft���}|����}|��|����}x�|���D�]�}t|�}	|	d�}
|	�d�}|||
�kr�||
�|�}n6t�|||
|��}|d�kr�t�d||
f���|||
�|<�|r|||	d<�|��|�|	���q|W�|����t��|��d�S�)Nz	lve-statsr���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 ���r!���r$���r���r#���r"���r%���r&���r'���r(���r)���r���Zuid_to_usernamer*���r+���r,���r-���r.���)
r/���r0���Zuid_to_username_cacher1���r3���r2���r4���Zdata_history_gov_newr5���Zhistory_gov_old_dictr���r���r���r6���r6���r7����	downgradec���s8����

r:���)#�__doc__Z
__future__r���Zlogging�osr���Zalembicr���r���Z
sqlalchemyr���r���r���r���r	���r
���r���Zlvestats.libr���r9���r���Z
branch_labelsZ
depends_onr���r#���Z	getLogger�path�basename�__name__r*���r$����formatr"���r8���r:���r6���r6���r6���r7����<module>
���sL���$$

[-] 54d3ae3043dd_snapshot_changes.cpython-37.pyc [edit]
[-] 48efb1674139_init.cpython-37.pyc [edit]
[-] 15fed017ca0b_add_uid_column.cpython-37.pyc [edit]
[-] 15fed017ca0b_add_uid_column.cpython-37.opt-1.pyc [edit]
[-] 48efb1674139_init.cpython-37.opt-1.pyc [edit]
[-] 54d3ae3043dd_snapshot_changes.cpython-37.opt-1.pyc [edit]
[+] ..

PATH: opt / alt / python37 / lib / python3.7 / site-packages / lvestats / utils / dbmigrator-back / versions / __pycache__

PATH: opt / alt / python37 / lib / python3.7 / site-packages / lvestats / utils / dbmigrator-back / versions / pycache