golden hour

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

File/Folder	Size	Actions
15fed017ca0b_add_uid_column.cpython-37.opt-1.pyc	3.17 KB
15fed017ca0b_add_uid_column.cpython-37.pyc	3.17 KB
48efb1674139_init.cpython-37.opt-1.pyc	1.71 KB
48efb1674139_init.cpython-37.pyc	1.71 KB
54d3ae3043dd_snapshot_changes.cpython-37.opt-1.pyc	1.86 KB
54d3ae3043dd_snapshot_changes.cpython-37.pyc	1.86 KB

Edit: 15fed017ca0b_add_uid_column.cpython-37.pyc

����@��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.%s�tsTF)�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�����r7����o/opt/alt/python37/lib/python3.7/site-packages/lvestats/utils/dbmigrator/versions/15fed017ca0b_add_uid_column.py�upgrade?���s6����

r9���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/���)
r0���r1���Zuid_to_username_cacher2���r4���r3���r5���Zdata_history_gov_newr6���Zhistory_gov_old_dictr���r���r���r7���r7���r8����	downgradec���s8����

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