def emitSQLs(self, sqls):
"""
"""
#self.info('==EMIT_SQL==> %s'%sql)
try:
import db_agent
for sql in sqls:
db_agent.emit_sql(sql)
except Exception, e:
self.error(str(e))
#exit(1)
max_str_len = 6000
cmd = ''
for idx, sql in enumerate(sqls):
if 0 == len(cmd):
#cmd = 'dbus-launch --exit-with-session at_db_agent.py -c '
cmd = 'at_db_agent.py -c '
cmd += ('-v "%s" ' % (sql) )
if len(cmd) > max_str_len:
#self.checkDbus()
os.system(cmd)
cmd = ''
else:
pass
# send remains
if len(cmd):
os.system(cmd)
def emitSQL(self, sql):
"""
"""
self.info('==EMIT_SQL==> %s' % sql)
try:
import db_agent
db_agent.emit_sql(sql)
#cmd = 'dbus-launch --exit-with-session at_db_agent.py -c -v "%s" ' % (sql)
#self.checkDbus()
#os.system(cmd)
#self.emit_sql(sql)
except Exception, e:
self.error(str(e))
cmd = 'at_db_agent.py -c -v "%s" ' % (sql)
os.system(cmd)
