def main(): # Create directory if it doesn't exist futil = FileUtil(".opendoord") # Get access to the database handler logger = Logger.get(verbose=True) db = Sqlite(futil.path + "/opendoor.db", logger) port = Port(logger) pipes = Pipes(logger, port, db) i = 0 logger.debug("Send commands via pipe with 10 sec delay") while i < 100: i += 1 pipes.send_to_app("OPEN DOOR\n", i) logger.debug("OPEN DOOR") time.sleep(10) i += 1 pipes.send_to_app("DOORBELL PRESSED\n", i) logger.debug("DOORBELL PRESSED") time.sleep(10) i += 1 pipes.send_to_app("DOW RING WITH AUTO OPEN\n", i) logger.debug("DOW RING WITH AUTO OPEN") time.sleep(10)
def isRun(data): sql_con = Sqlite() ID = data.get('Id') is_run = data.get('isRun') sql_con.cur.execute(UPDATE_SQL.format(table_name, f'is_valid = {is_run}, update_time = {int(time.time())}', ID)) sql_con.con.commit() logger.info(f'{ID} 设置为 {is_run}') del sql_con
def gerar_sqlite(self, caminho_sqlite, nome, legal_terms): base_sqlite = Sqlite(caminho_sqlite, nome, legal_terms) while True: self.__capitulo_atual = self.__get_capitulo() self.__processar_capitulo(base_sqlite) if self.__tem_proximo(): self.__referencia_atual = self.__get_proxima_referencia() else: break
def main(): global log, port, pipes, db, test_mode # Be sure we have root privileges if os.geteuid() != 0: exit("You need to have root privileges. Exiting.") # Ctrl-C and SIGTERM handler signal.signal(signal.SIGINT, signal_handler) signal.signal(signal.SIGTERM, signal_handler) # Parse arguments, use file docstring as a parameter definition args = docopt.docopt(__doc__, version='0.1a') # Create directory if it doesn't exist futil = FileUtil(".opendoord") print("Path: %s, args: %s" % (futil.path, args)) # Create a logger if args["--console"]: log = Logger.get(verbose=True) else: log = Logger.get(futil.path + "/opendoor.log", verbose=args["--verbose"]) log.info("*** Start OpenDoor ***") # Get access to the database handler db = Sqlite(futil.path + "/opendoor.db", log) if not db.exist(): log.info("No database found. Will create one.") db.create_tables() # if not already created db.reset_tables() # and initialize if args["--test"]: test_mode = True # Let's initialize the gpio's port = Port(log, test_mode) # Open the pipes pipes = Pipes(log, port, db) if args["--resetdb"]: db.reset_tables() log.info("Database has been reset.") else: log.info("Watch door events in an endless loop.") opendoor_endless_loop()
def gerarSqlite(self, caminhoSqlite, nome, copyright): baseSqlite = Sqlite(caminhoSqlite, nome, copyright) # cont = 0 while True: # cont += 1 # if cont == 5: # break self.__capituloAtual = self.__getCapitulo() self.__processarCapitulo(baseSqlite) if self.__temProximo(): self.__referenciaAtual = self.__getProximaReferencia() else: break
def save(data): sql_con = Sqlite() name = data.get('name') domain_name = data.get('domain_name') url_path = data.get('url_path') method = data.get('method') is_re = data.get('is_re') status_code = data.get('status_code') if method == '0' else 'null' response = data.get('response') if method == '0' else data.get('fields') is_file = data.get('is_file') if method == '0' else 'null' is_valid = 1 insert_date = (int(time.time()*1000), name, domain_name, url_path, status_code, response, is_file, is_re, method, is_valid, int(time.time())) sql_con.cur.execute(INSERT_SQL.format(table_name, FIELD, insert_date)) sql_con.con.commit() logger.info(f'{name}保存成功') del sql_con
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 update(data): sql_con = Sqlite() ID = data.get('ID') name = data.get('name') domain_name = data.get('domain_name') url_path = data.get('url_path') is_re = data.get('is_re') method = data.get('method') status_code = data.get('status_code') if method == '0' else 'null' response = data.get('response') if method == '0' else data.get('fields') is_file = data.get('is_file') if method == '0' else 'null' update_date = f"name = '{name}', domain_name = '{domain_name}', url_path = '{url_path}', status_code = {status_code}, " \ f"response = '{response}', is_file = {is_file}, is_regular = {is_re}, method = {method}, update_time = {int(time.time())}" sql_con.cur.execute(UPDATE_SQL.format(table_name, update_date, ID)) sql_con.con.commit() logger.info(f'{ID}更新成功') del sql_con
def __init__(self): self.__fig = plt.figure() self.__ax = self.__fig.add_subplot(1, 1, 1) self.__sqlite = Sqlite()
def reload(request): sql_con = Sqlite() sql_con.cur.execute("SELECT * FROM {} WHERE is_valid = 1 ORDER BY UPDATE_TIME DESC;".format(table_name)) data = sql_con.cur.fetchall() del sql_con return data
def edit(ID): sql_con = Sqlite() sql_con.cur.execute(EDIT_SQL.format(table_name, ID)) data = sql_con.cur.fetchall() return data[0]
def delete(ID): sql_con = Sqlite() sql_con.cur.execute(DELETE_SQL.format(table_name, ID)) sql_con.con.commit() logger.info(f'{ID} 删除成功') del sql_con
def home(request): sql_con = Sqlite() sql_con.cur.execute(SELECT_SQL.format(table_name)) data = sql_con.cur.fetchall() del sql_con return data
#!/usr/bin/python3 from sqlite import Sqlite obj_s = Sqlite() obj_s.output_names()
def todb(self): db = Sqlite(sqlite_settings) # print(db.getPositionorCreate(self.log_file,self.position)) db.updatePosition(self.log_file, self.position)