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