def main(): # try: sqlite = Sqlite(sqlite_settings) log_file, log_pos = sqlite.getPositionorCreate() print("from sqlite info: {},{}".format(log_file, log_file)) stream = create_stream(log_file, log_pos) stream = create_stream() for binlogevent in stream: print(binlogevent.event_type) log_file, log_pos = sqlite.getPositionorCreate() print("from sqlite info: {},{}".format(log_file, log_pos)) handler = GeneralHandler(binlogevent) results = handler.toKafka() if results: sqlite.updatePosition(stream.log_file, stream.log_pos) print('stream info {},{}'.format(stream.log_file, stream.log_pos)) print('success one') stream.close()
def todb(self): db = Sqlite(sqlite_settings) # print(db.getPositionorCreate(self.log_file,self.position)) db.updatePosition(self.log_file, self.position)