def exec_cmd(msg=''): fd = open(gen.action_file,'w') fd.close() gen.get_signal(gen.if_file) while 1: cmd = 'select * from cmd where valid = "cmd"' res = sql.run_sql_cmd(cmd) if len(res) == 0: break time.sleep(1) res = sql.read('cmd','succ') ret = True if res != [(None,None)]: print "<p>%s update successful"%(msg) res = sql.read('cmd','err') if res != [(None,None)]: for rec in res: errcmd = rec[1].split(":")[0] err = rec[1].split(":")[1] cmdtype = gen.get_cmd_type(errcmd) print "<p>Update FAILED: %s"%(err) ret = False cmd = 'delete from cmd' sql.run_sql_cmd(cmd) return ret
def exec_cmd(msg=''): fd = open(gen.action_file, 'w') fd.close() gen.get_signal(gen.if_file) while 1: cmd = 'select * from cmd where valid = "cmd"' res = sql.run_sql_cmd(cmd) if len(res) == 0: break time.sleep(1) res = sql.read('cmd', 'succ') ret = True if res != [(None, None)]: print "<p>%s update successful" % (msg) res = sql.read('cmd', 'err') if res != [(None, None)]: for rec in res: errcmd = rec[1].split(":")[0] err = rec[1].split(":")[1] cmdtype = gen.get_cmd_type(errcmd) print "<p>Update FAILED: %s" % (err) ret = False cmd = 'delete from cmd' sql.run_sql_cmd(cmd) return ret
def handle(): print 'handling' res = sql.read('cmd','cmd') cmd = '' for rec in res: print rec[1] out = sub.Popen([rec[1]],shell=True,stdout=nfp,stderr=sub.PIPE).communicate() if len(out[1]) > 1: cmd = "insert into cmd (valid,valchar) values('err','%s:%s')"%(rec[1],out[1]) else: cmd = "insert into cmd (valid,valchar) values('succ','%s')"%(rec[1]) sql.run_sql_cmd(cmd) cmd = 'delete from cmd where valid = "cmd"' sql.run_sql_cmd(cmd)
def handle(): print 'handling' res = sql.read('cmd', 'cmd') cmd = '' for rec in res: print rec[1] out = sub.Popen([rec[1]], shell=True, stdout=nfp, stderr=sub.PIPE).communicate() if len(out[1]) > 1: cmd = "insert into cmd (valid,valchar) values('err','%s:%s')" % ( rec[1], out[1]) else: cmd = "insert into cmd (valid,valchar) values('succ','%s')" % ( rec[1]) sql.run_sql_cmd(cmd) cmd = 'delete from cmd where valid = "cmd"' sql.run_sql_cmd(cmd)