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
import gen
import sql
import subprocess as sub
nfp = open('/dev/null','w')
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)
if __name__ == '__main__':
while 1:
print 'in'
gen.get_signal(gen.action_file)
print 'got signal'
fd = open(gen.if_file,'w')
handle()
print 'handled'
fd.close()
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)
if __name__ == '__main__':
while 1:
print 'in'
gen.get_signal(gen.action_file)
print 'got signal'
fd = open(gen.if_file, 'w')
handle()
print 'handled'
fd.close()
