Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # -*- coding: utf-8 -*-
- import MySQLdb
- from datetime import datetime
- import time
- ip = ''
- username = ''
- userpass = ''
- db = ''
- while True:
- start_connect = datetime.now().strftime('%d-%m-%y %H:%M:%S')
- print('{} Подключение в БД.'.format(start_connect))
- conn = MySQLdb.connect(ip, username, userpass, db)
- file_IMEI = open('delete.txt', 'r') #Читаем файл с списком IMEI приборов. Обязательным условием является наличие пустой последней строки.
- create_time = str(datetime.now())
- LOG_FILENAME = 'log_%s.txt' % datetime.now().strftime('%d-%m-%y_%H-%M-%S')
- file_log = open(LOG_FILENAME, 'w+')
- cursor = conn.cursor()
- start_delete = datetime.now().strftime('%d-%m-%y %H:%M:%S')
- print('{} Старт удаления выброосов.'.format(start_delete))
- for IMEI in file_IMEI:
- format_IMEI = IMEI[:-1]
- try:
- cursor.execute("delete from fm_t{} where lon between '0' AND '20' or lon < '0' or lon > '40'".format(format_IMEI))
- cursor.execute("delete from fm_t{} where lat between '0' AND '40' or lat < '0' or lat > '58'".format(format_IMEI))
- conn.commit()
- file_log.write('{} - обработан.'.format(format_IMEI) + '\n')
- except:
- file_log.write('{} - приборa не существует или удалён ранее.'.format(format_IMEI) + '\n')
- pass
- end_delete = datetime.now().strftime('%d-%m-%y %H:%M:%S')
- print('{} Удаление выбросов завершено.\n-----------------------------------------------------'.format(end_delete))
- cursor.close()
- conn.close()
- file_IMEI.close()
- file_log.close()
- time.sleep(3600)
Add Comment
Please, Sign In to add comment