Python create_data_frame_by_sql Examples

Example #1

 def select(self, max_date):
     return pandas.create_data_frame_by_sql(
         sql=self.select_sql + self.where_clause,
         params=[max_date.strftime("%Y%m%d")],
         subset='code',
         keep='last'
     )

Example #2

 def select(self, date, min_kdjk, min_kdjd, min_kdjj, min_rsi_6, min_cci):
     return pandas.create_data_frame_by_sql(
         sql=self.select_sql + self.where_clause,
         params=[date.strftime("%Y%m%d"), min_kdjk, min_kdjd, min_kdjj, min_rsi_6, min_cci],
         subset='code',
         keep='last'
     )

Example #3

File: stock_statistics.py Project: focus-sh/stock

 def select(self, date, min_change_percent, min_pb):
     return pandas.create_data_frame_by_sql(
         sql=self.select_sql + self.where_clause,
         params=[date.strftime("%Y%m%d"), min_change_percent, min_pb],
         subset='code',
         keep='last')

Example #4

 def paged_select(self, date, begin, size):
     return pandas.create_data_frame_by_sql(
         sql=self.select_sql + self.where_clause + self.pagination_filter,
         params=[date.strftime("%Y%m%d"), begin, size],
         subset='code',
         keep='last')