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()