def initData(self):
# init dbconnect
self.dbconn = sqlite3.connect("my.db", check_same_thread=False)
self.cursor = self.dbconn.cursor()
tabletuple = self.cursor.execute("select name from sqlite_master where type = 'table'").fetchall()
self.tablenames = [tb[0] for tb in tabletuple]
self.logcatMonitor = LogcatMonitor()
self.logcatMonitor.setLogListener(self)
self.logcatMonitor.start()
class Task(LogListener):
def __init__(self,cmd,repeat):
self.instrumentCmd = cmd
self.repeat = repeat
self.current = 0;
self.initData()
def initData(self):
# init dbconnect
self.dbconn = sqlite3.connect("my.db", check_same_thread=False)
self.cursor = self.dbconn.cursor()
tabletuple = self.cursor.execute("select name from sqlite_master where type = 'table'").fetchall()
self.tablenames = [tb[0] for tb in tabletuple]
self.logcatMonitor = LogcatMonitor()
self.logcatMonitor.setLogListener(self)
self.logcatMonitor.start()
def doTest(self):
if Utils.exeInstrument(self.instrumentCmd):
print "test {} ok".format(self.current)
else:
print "test {} failure".format(self.current)
self.logcatMonitor.stop(True)
def onRead(self,line):
if line.has_key('action') is False:
return
print(line)
action = line.pop('action')
keys = line.keys()
values = line.values()
count = len(keys)
if action not in self.tablenames:
self.tablenames.append(action)
create_sql = 'create table if not exists '+action+' ('+','.join(['{} text'.format(column) for column in keys])+')'
self.cursor.execute(create_sql)
insert_sql = 'insert into '+action+' ('+(','.join(keys))+') values ('+(','.join(values))+")"
self.cursor.execute(insert_sql)
self.dbconn.commit()
def onStop(self):
self.cursor.close()
self.dbconn.close()
print("disconnect database")