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)
