def get_a_sql_cur_forever(mylog, db_name=None):
while True:
if None == db_name:
(_cur, err) = wtclib.get_a_sql_cur("../conf/conf.conf")
else:
(_cur, err) = wtclib.get_a_sql_cur("../conf/conf.conf",
dbn=db_name)
if None != _cur:
break
else:
mylog.info(err)
time.sleep(20)
return _cur
def get_a_sql_cur_forever(db_name=None):
global mylogger
while True:
if None == db_name:
(_cur, conn_err) = wtclib.get_a_sql_cur("../conf/conf.conf")
else:
(_cur, conn_err) = wtclib.get_a_sql_cur("../conf/conf.conf",
db_name)
if None != _cur:
break
else:
mylogger.info(conn_err)
time.sleep(20)
return _cur, conn_err
def get_a_sql_cur_forever(mylog):
while True:
(_cur, err) = wtclib.get_a_sql_cur("../conf/conf.conf", "hvpd3db2")
if None != _cur:
break
else:
mylog.info(err)
time.sleep(20)
return _cur
def get_a_sql_cur_forever(logger):
while True:
(_cur, err) = wtclib.get_a_sql_cur("../conf/conf.conf")
if None != _cur:
break
else:
logger.info(err)
time.sleep(20)
return _cur
def get_mysql_cur():
global mylogger
while True:
(cur, err) = wtclib.get_a_sql_cur("../conf/conf.conf", "hvpd3db2")
if None != cur:
break
else:
mylogger.info("can not connect to db and sleep 20")
time.sleep(20)
return cur
def get_a_sql_cur_forever():
global mylogger
while True:
(_cur, conn_err) = wtclib.get_a_sql_cur("../conf/conf.conf",
"hvpd3db2")
if None != _cur:
break
else:
mylogger.info(conn_err)
time.sleep(20)
return _cur, conn_err
def get_a_sql_cur_forever(mylog_i):
while True:
try:
(_cur, err) = wtclib.get_a_sql_cur("../conf/conf.conf")
if None != _cur:
break
else:
mylog_i.info(err)
except Exception, e:
mylog_i.info(str(e))
time.sleep(20)
def msg_consumer(body):
global cur, mylogger, msg_props, interval_sec, AIOUT_CH, msgsnd_ipc, msgrcv_ipc, AI_daybook_en, NEW_daybook_create
_dic_info = json.loads(body)
_cmos = _dic_info["cmos"]
_sql_str = "select * from aisettingtablemem where cameraID='%s' and cmosID=%d" % (
_dic_info["cam_id"], _cmos)
try:
if 0 == cur.execute(_sql_str):
mylogger.debug("None= " + _sql_str)
return
_ai_setting = cur.fetchone()
_sql_str = "select * from aiouttable where cameraID='%s' and cmosID=%d" % (
_dic_info["cam_id"], _cmos)
if 0 == cur.execute(_sql_str):
_sql_str = "insert into aiouttable(cameraID,cmosID)values('%s',%d)" % (
_dic_info["cam_id"], _cmos)
cur.execute(_sql_str)
except Exception, e:
(cur, err) = wtclib.get_a_sql_cur("../conf/conf.conf")
if None == cur:
mylogger.error("can not connect to db and sleep 20")
return
import time
import pika
import wtclib
if not os.path.isdir("../log/reret"):
try:
os.mkdir("../log/reret")
except Exception, e:
print str(e) + " in line: " + str(sys._getframe().f_lineno)
os._exit()
mylogger = wtclib.create_logging("../log/reret/re2filter.log")
mylogger.info("start running")
while True:
(cur, err) = wtclib.get_a_sql_cur("../conf/conf.conf")
if None != cur:
break
else:
mylogger.info("can not connect to db and sleep 20")
time.sleep(20)
"""
cur.execute("insert into ReFilterTable(Spaceid, cameraID, cmosID)values('123456', '1315', 0)")
cur.execute("update ReFilterTable set PlateNumber1='wfbi' where Spaceid='123456'")
cur.execute("update ReFilterTable set PlateNumber1=NULL where Spaceid='123456'")
"""
"""
_pid = os.getpid()
try:
cur.execute("insert into WatchdogTable(pid, runCMD,watchSeconds,renewTimet)values(%d, "
"'python %s &', 300, %d)"%(_pid, __file__, (time.time())))
import time
import pika
import wtclib
if not os.path.isdir("../log/reret"):
try:
os.mkdir("../log/reret")
except Exception, e:
print str(e) + " in line: " + str(sys._getframe().f_lineno)
os._exit()
mylogger = wtclib.create_logging("../log/reret/re2filter.log")
mylogger.info("start running")
while True:
(cur, err) = wtclib.get_a_sql_cur("../conf/conf.conf", "hvpd3db2")
if None != cur:
break
else:
mylogger.info("can not connect to db and sleep 20")
time.sleep(20)
"""
cur.execute("insert into ReFilterTable(Spaceid, cameraID, cmosID)values('123456', '1315', 0)")
cur.execute("update ReFilterTable set PlateNumber1='wfbi' where Spaceid='123456'")
cur.execute("update ReFilterTable set PlateNumber1=NULL where Spaceid='123456'")
"""
"""
_pid = os.getpid()
try:
cur.execute("insert into WatchdogTable(pid, runCMD,watchSeconds,renewTimet)values(%d, "
"'python %s &', 300, %d)"%(_pid, __file__, (time.time())))
import os, time,wtclib,socket
if __name__ == '__main__':
while True:
_cur, _conn = wtclib.get_a_sql_cur("../conf/conf.conf")
if None == _cur:
time.sleep(5)
else:
break
print "DB connect OK"
while True:
print "********"
try:
a1 = _cur.execute("select * from OnlineHvpdStatusTableMem")
_hvpds = _cur.fetchmany(a1)
socket.setdefaulttimeout(1)
try:
for _hvps in _hvpds:
if None == _hvps[4]:
continue
wtclib.http_get_cgi_msg2device({"Lamp": "R:0,G:20,B:0"}, ip=_hvps[4],cgi_name="setting")
print "%s is Green"%_hvps[4]
except Exception, e:
print str(e)
time.sleep(5)
try:
for _hvps in _hvpds:
if None == _hvps[4]:
continue
wtclib.http_get_cgi_msg2device({"Lamp": "R:0,G:0,B:20"}, ip=_hvps[4],cgi_name="setting")
print "%s is Blue" % _hvps[4]
