Ejemplos de build_aggregate_query en Python

Ejemplo n.º 1

Archivo: sql_builder_test.py Proyecto: hediehy/vitess

 def test_build_aggregate_query(self):
     sql, bind_vars = sql_builder.build_aggregate_query(table_name="my_table", id_column_name="row_id", is_asc=False)
     self.assertEqual(sql, "SELECT row_id FROM my_table ORDER BY row_id DESC " "LIMIT %(limit_row_count)s")
     self.assertEqual(bind_vars, dict(limit_row_count=1))
     sql, bind_vars = sql_builder.build_aggregate_query(table_name="my_table", id_column_name="row_id", is_asc=True)
     self.assertEqual(sql, "SELECT row_id FROM my_table ORDER BY row_id ASC " "LIMIT %(limit_row_count)s")
     self.assertEqual(bind_vars, dict(limit_row_count=1))

Ejemplo n.º 2

Archivo: sql_builder_test.py Proyecto: fengshao0907/vitess

 def test_build_aggregate_query(self):
     sql, bind_vars = sql_builder.build_aggregate_query(
         table_name='my_table', id_column_name='row_id', is_asc=False)
     self.assertEqual(
         sql, 'SELECT row_id FROM my_table ORDER BY row_id DESC '
         'LIMIT %(limit_row_count)s')
     self.assertEqual(bind_vars, dict(limit_row_count=1))
     sql, bind_vars = sql_builder.build_aggregate_query(
         table_name='my_table', id_column_name='row_id', is_asc=True)
     self.assertEqual(
         sql, 'SELECT row_id FROM my_table ORDER BY row_id ASC '
         'LIMIT %(limit_row_count)s')
     self.assertEqual(bind_vars, dict(limit_row_count=1))

Ejemplo n.º 3

Archivo: db_object.py Proyecto: haoqoo/vitess

  def get_max(class_, cursor):
    if class_.id_column_name is None:
      raise dbexceptions.ProgrammingError("id_column_name not set.")

    query, bind_vars = sql_builder.build_aggregate_query(
        class_.table_name, class_.id_column_name, is_asc=False)
    cursor.execute(query, bind_vars)
    return cursor.fetch_aggregate_function(max)

Ejemplo n.º 4

    def get_max(class_, cursor):
        if class_.id_column_name is None:
            raise dbexceptions.ProgrammingError('id_column_name not set.')

        query, bind_vars = sql_builder.build_aggregate_query(
            class_.table_name, class_.id_column_name, is_asc=False)
        cursor.execute(query, bind_vars)
        return cursor.fetch_aggregate_function(max)

Ejemplo n.º 5

    def get_max(class_, cursor):
        if class_.id_column_name is None:
            raise dbexceptions.ProgrammingError("id_column_name not set.")

        query = sql_builder.build_aggregate_query(class_.table_name,
                                                  class_.id_column_name,
                                                  sort_func='max')
        cursor.execute(query, EmptyBindVariables)
        return cursor.fetch_aggregate_function(max)

Ejemplo n.º 6

Archivo: db_object.py Proyecto: egbonrelu/vitess-1

  def get_max(class_, cursor):
    if class_.id_column_name is None:
      raise dbexceptions.ProgrammingError("id_column_name not set.")

    query = sql_builder.build_aggregate_query(class_.table_name,
                                              class_.id_column_name,
                                              sort_func='max')
    cursor.execute(query, EmptyBindVariables)
    return cursor.fetch_aggregate_function(max)