def query(self):
print 'generate query'
print self.query_offset
print self.query_file[self.query_offset]
print self.query_str[self.query_offset]
query = query_builder(self.query_file[self.query_offset], self.query_str[self.query_offset]) \
.build_where(columns=self.columns, params=self.data)
return query.finish()
def query(self, one_record=False):
print '------query start'
print self.query_file
print self.query_str
print self.columns
print self.data
if one_record:
self.limit_rows = False
query = query_builder(self.query_file, self.query_str) \
.build_where(columns=self.columns, params=self.data) \
.build_group(self.grouping) \
.build_limit(page=self.page, limit=PAGINATION_ROWS, enabled=self.limit_rows)
print '------query end'
return query.finish()
def query(self):
query = query_builder(self.query_file, self.query_str) \
.build_where(columns=self.columns, params=self.data) \
.build_group(self.grouping) \
.build_limit(page=self.page, limit=PAGINATION_ROWS, enabled=self.limit_rows)
return query.finish()
def query(self):
query = query_builder(self.query_file, self.query_str) \
.build_where(columns=self.columns, params=self.data)
return query.finish()