def runner(self):
db = Table(self.db_file)
conn = db.create_connection()
current_table = db.choose_table(self.sps_file)
parser = Sps21Parser()
with open(self.sps_file) as f:
for line in f:
parsed = parser.parse_point(line)
if parsed is not None:
key_list = [parsed[1], parsed[2], parsed[3]]
get_record = db.get_record_for_point(
conn, current_table, key_list)
print(get_record)
def run(self):
self.signals.start.emit(False)
line_numbers = check.iter_count(self.from_file_name)
self.signals.process_max.emit(line_numbers)
db = Table(self.db_file)
counter = 0
try:
with open(self.from_file_name) as fr:
with open(self.to_file_name, 'w') as tf:
for line in fr:
parsed = self.parser.parse_point(line)
if parsed:
list = [parsed[1], parsed[2], parsed[3]]
data = db.get_record_for_point(
self.conn, self.table_name, list)
tf.write(str(data) + '\n')
counter += 1
if counter % 10000 == 0:
self.signals.process.emit(counter)
except Exception as e:
print(str(e))
self.signals.process.emit(counter)
self.signals.finished.emit(True)