def query_target(self):
sql = "select * from {0} where mime_type={1}".format(self.TABLE_TARGET, 'image/png')
result = self.query_row(sql)
target = TestTarget(result[1], result[2], result[3], result[4], result[5], result[6], result[7], result[8],
result[9], result[10])
target.id = result[0]
return target
def query_targets_by_type(self, mime_type, number=0):
sql = "select * from {0} where mime_type='{1}'".format(self.TABLE_TARGET, mime_type)
result = self.query_more(sql, number)
targets = []
for row in result:
target = TestTarget(row[1], row[2], row[3], row[4], row[5], row[6], row[7], row[8],
row[9], row[10])
target.id = row[0]
targets.append(target)
return targets
