def test_query_qc_dev_org_data_by_city_month():
dao = mysql_impl.DataOperationsByMysql()
df = dao.query_qc_dev_org_data_by_city_month([1], "2018-11-02 10:00:00")
for i in df.columns.values.tolist():
print(len(df[i]))
print(df)
print(df.columns.values)
print(df[df['VARGROUP_ID'] == 'YSRDTSPISJ'])
def test_query_qualitycontrol_version():
print('enter query qualitycontrol version')
dao = mysql_impl.DataOperationsByMysql()
df = dao.query_qualitycontrol_version()
df.to_csv('qualitycontrol_version.csv')
print(df)
print('finished')
print('----------')
def test_query_qc_dev_org_data_by_city():
dao = mysql_impl.DataOperationsByMysql()
df = dao.query_qc_dev_org_data_by_city([1], "2018-11-01 13:00:00")
# for i in df.columns.values.tolist():
# print(df[i])
print(df)
df.to_csv('qc_dev_org_data_by_city.csv')
print(df.columns.values)
def test_query_capture_data_by_hour(starttime):
print(starttime)
dao = mysql_impl.DataOperationsByMysql()
device_info_df = dao.query_active_devices()
dic_data = dao.query_capture_data_by_hour(
hour=starttime, device_info_df=device_info_df)
dic_data[7].to_csv('capture_7.csv')
print(dic_data)
def test_active_devices_by_city_list():
print('enter query active devices by city list')
dao = mysql_impl.DataOperationsByMysql()
df = dao.query_active_devices_by_city(city_list=[1])
print(df.columns.values)
print(df)
print('finished')
print('----------')
def test_query_site_data_by_city():
dao = mysql_impl.DataOperationsByMysql()
df = dao.query_site_data_by_city([1], "2018-11-08 00:00:00")
for i in df.columns.values.tolist():
print(df[i])
df.to_csv('tsp.csv')
print(df.columns.values)
print(df[df['SITE_ID'].isin([17941497, 17941504, 17941505, 17941488, 17941499, 17941501, 11, 17941490, 10, 17941495, 17941491])])
def test_active_devices():
print('enter query active devices')
dao = mysql_impl.DataOperationsByMysql()
df = dao.query_active_devices()
# df.to_csv('a.csv')
print(df.columns.values)
print(df)
print('finished')
print('----------')
def test_active_devices_by_device_list():
print('enter query active devices by city list')
device_list = ['YSRDTSPISJ00001388', 'YSRDPM250000006822']
dao = mysql_impl.DataOperationsByMysql()
df = dao.query_active_devices_by_device_list(device_list=device_list)
print(df)
print(df.columns.values)
print('finished')
print('----------')
def test_query_consistency_model():
dao = mysql_impl.DataOperationsByMysql()
df = dao.query_consistency_model()
df.to_csv('tsp.csv')
print(df)
def test_query_channels():
dao = mysql_impl.DataOperationsByMysql()
df = dao.query_channels()
df.to_csv('channels.csv')
print(df)
def test_query_field_name():
dao = mysql_impl.DataOperationsByMysql()
df_dev = dao.query_field_name()
df_dev.to_csv('channels.csv')
print(df_dev)
def test_query_site_data_by_hour():
dao = mysql_impl.DataOperationsByMysql()
df = dao.query_site_data_by_hour([1], "2018-09-05 23:00:00")
for i in df.columns.values.tolist():
print(df[i])
print(df.columns.values)
def test_query_site_latitude_longitude():
dao = mysql_impl.DataOperationsByMysql()
df = dao.query_site_latitude_longitude(city_id=[1], site_id=[1, 206])
for i in df.columns.values.tolist():
print(df[i])
print(df.columns.values)
def test_query_devices_latitude_longitude():
dao = mysql_impl.DataOperationsByMysql()
df = dao.query_devices_latitude_longitude(relate_site_id=1)
for i in df.columns.values.tolist():
print(df[i])
print(df.columns.values)