Example #1
0
 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()
Example #2
0
 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()
Example #3
0
 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()
Example #4
0
 def query(self):
     query = query_builder(self.query_file, self.query_str) \
         .build_where(columns=self.columns, params=self.data)
     return query.finish()