Python Materialization.define_from_view 예제들

예제 #1

def test_define_type_from_view(conn, dataset):
    with closing(conn.cursor()) as cursor:
        materialization = Materialization.define_from_view(dataset.view)(
            cursor)

        assert not materialization is None

        type_id = materialization.id

        assert type_id > 0

예제 #2

def test_materialize(conn, dataset):
    with closing(conn.cursor()) as cursor:
        materialization = Materialization.define_from_view(dataset.view)(
            cursor)

        materialization_chunk = materialization.chunk(dataset.timestamp)

        result = materialization_chunk.execute(cursor)

        assert not result is None

예제 #3

def test_materialize_altered_column(conn, dataset):
    conn.commit()

    with closing(conn.cursor()) as cursor:
        materialization = Materialization.define_from_view(dataset.view)(
            cursor)

        materialization_chunk = materialization.chunk(dataset.timestamp)

        max_modified, row_count = materialization_chunk.execute(cursor)

        eq_(row_count, 2)

        dataset.update_type(cursor)

        max_modified, row_count = materialization_chunk.execute(cursor)

        eq_(row_count, 2)

        conn.commit()