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)