import datetime
import time
from init_server import stt_server
server_object = stt_server(0)
for source_id in server_object.sources: # ['call', 'master']
#if source_id == 'master': # debug
server_object.source_id = server_object.get_source_id(source_id)
complete_files = server_object.get_sql_complete_files()
incomplete_count = 0
for filepath, filename, rec_date, src, dst, linkedid in server_object.get_fs_files_list(
complete_files):
server_object.set_shortest_queue_cpu()
server_object.add_queue(filepath, filename, rec_date, src, dst,
linkedid)
incomplete_count += 1
print('id', source_id)
print(incomplete_count, 'files sent to queue',
server_object.sources[source_id])
sleep_time = 600
print(datetime.datetime.now().strftime('%Y-%m-%dT%H:%M:%S'),
'sleeping ' + str(sleep_time) + 's..')
time.sleep(sleep_time)
import sys
import time
import datetime
from init_server import stt_server
import re
import os
import pendulum
print('cpu', sys.argv[1])
server_object = stt_server(sys.argv[1])
cursor = server_object.conn.cursor()
past_in_minutes = pendulum.now().add(minutes=-6).strftime('%Y-%m-%d %H:%M:%S')
sql_query = "select filepath, filename, duration, source_id, "
sql_query += "record_date, src, dst, linkedid from queue "
sql_query += "where cpu_id='" + str(server_object.cpu_id) + "' "
sql_query += "and ( (source_id = '2' and record_date < '" + past_in_minutes + "') or not source_id = '2' ) "
#sql_query += "order by ISNULL(record_date, 0) desc, record_date, linkedid, filename;"
sql_query += "order by record_date, filename;"
processed = 0
cursor.execute(sql_query)
linkedid = ''
for row in cursor.fetchall():
#queue_start = datetime.datetime.now()
queue_start = time.time()
original_file_path = row[0]
original_file_name = row[1]
original_file_duration = row[2]
server_object.source_id = row[3]
rec_date = row[4]