Module `materialize.checks.all_checks.text_bytea_types`

Expand source code Browse git

# Copyright Materialize, Inc. and contributors. All rights reserved.
#
# Use of this software is governed by the Business Source License
# included in the LICENSE file at the root of this repository.
#
# As of the Change Date specified in that file, in accordance with
# the Business Source License, use of this software will be governed
# by the Apache License, Version 2.0.
from textwrap import dedent

from materialize.checks.actions import Testdrive
from materialize.checks.checks import Check


class TextByteaTypes(Check):
    def initialize(self) -> Testdrive:
        return Testdrive(
            dedent(
                """
            > CREATE TABLE text_bytea_types_table (text_col TEXT, bytea_col BYTEA);
            > INSERT INTO text_bytea_types_table VALUES ('aaaa', '\\xAAAA'), ('това е', 'текст');
        """
            )
        )

    def manipulate(self) -> list[Testdrive]:
        return [
            Testdrive(dedent(s))
            for s in [
                """
                > CREATE MATERIALIZED VIEW string_bytea_types_view1 AS
                  SELECT text_col, bytea_col, 'това'::TEXT, '\\xAAAA'::BYTEA
                  FROM text_bytea_types_table
                  WHERE text_col >= ''::TEXT AND bytea_col >= ''::BYTEA;

                > INSERT INTO text_bytea_types_table SELECT DISTINCT text_col, bytea_col FROM text_bytea_types_table;
                """,
                """
                > CREATE VIEW string_bytea_types_view2 AS
                  SELECT text_col, bytea_col, 'това'::TEXT, '\\xAAAA'::BYTEA
                  FROM text_bytea_types_table
                  WHERE text_col >= ''::TEXT AND bytea_col >= ''::BYTEA;

                > INSERT INTO text_bytea_types_table SELECT DISTINCT text_col, bytea_col FROM text_bytea_types_table;
                """,
            ]
        ]

    def validate(self) -> Testdrive:
        return Testdrive(
            dedent(
                f"""
                > SHOW CREATE MATERIALIZED VIEW string_bytea_types_view1;
                materialize.public.string_bytea_types_view1 "CREATE MATERIALIZED VIEW \\"materialize\\".\\"public\\".\\"string_bytea_types_view1\\" IN CLUSTER \\"{self._default_cluster()}\\" WITH (REFRESH = ON COMMIT) AS SELECT \\"text_col\\", \\"bytea_col\\", 'това'::\\"pg_catalog\\".\\"text\\", '\\\\xAAAA'::\\"pg_catalog\\".\\"bytea\\" FROM \\"materialize\\".\\"public\\".\\"text_bytea_types_table\\" WHERE \\"text_col\\" >= ''::\\"pg_catalog\\".\\"text\\" AND \\"bytea_col\\" >= ''::\\"pg_catalog\\".\\"bytea\\""

                > SELECT text_col, text, LENGTH(bytea_col), LENGTH(bytea) FROM string_bytea_types_view1;
                aaaa това 2 2
                aaaa това 2 2
                aaaa това 2 2
                "това е" това 10 2
                "това е" това 10 2
                "това е" това 10 2

                > SHOW CREATE VIEW string_bytea_types_view2;
                materialize.public.string_bytea_types_view2 "CREATE VIEW \\"materialize\\".\\"public\\".\\"string_bytea_types_view2\\" AS SELECT \\"text_col\\", \\"bytea_col\\", 'това'::\\"pg_catalog\\".\\"text\\", '\\\\xAAAA'::\\"pg_catalog\\".\\"bytea\\" FROM \\"materialize\\".\\"public\\".\\"text_bytea_types_table\\" WHERE \\"text_col\\" >= ''::\\"pg_catalog\\".\\"text\\" AND \\"bytea_col\\" >= ''::\\"pg_catalog\\".\\"bytea\\""

                > SELECT text_col, text, LENGTH(bytea_col), LENGTH(bytea) FROM string_bytea_types_view2;
                aaaa това 2 2
                aaaa това 2 2
                aaaa това 2 2
                "това е" това 10 2
                "това е" това 10 2
                "това е" това 10 2
            """
            )
        )

Classes

class TextByteaTypes (base_version: MzVersion, rng: random.Random | None)

Expand source code Browse git

class TextByteaTypes(Check):
    def initialize(self) -> Testdrive:
        return Testdrive(
            dedent(
                """
            > CREATE TABLE text_bytea_types_table (text_col TEXT, bytea_col BYTEA);
            > INSERT INTO text_bytea_types_table VALUES ('aaaa', '\\xAAAA'), ('това е', 'текст');
        """
            )
        )

    def manipulate(self) -> list[Testdrive]:
        return [
            Testdrive(dedent(s))
            for s in [
                """
                > CREATE MATERIALIZED VIEW string_bytea_types_view1 AS
                  SELECT text_col, bytea_col, 'това'::TEXT, '\\xAAAA'::BYTEA
                  FROM text_bytea_types_table
                  WHERE text_col >= ''::TEXT AND bytea_col >= ''::BYTEA;

                > INSERT INTO text_bytea_types_table SELECT DISTINCT text_col, bytea_col FROM text_bytea_types_table;
                """,
                """
                > CREATE VIEW string_bytea_types_view2 AS
                  SELECT text_col, bytea_col, 'това'::TEXT, '\\xAAAA'::BYTEA
                  FROM text_bytea_types_table
                  WHERE text_col >= ''::TEXT AND bytea_col >= ''::BYTEA;

                > INSERT INTO text_bytea_types_table SELECT DISTINCT text_col, bytea_col FROM text_bytea_types_table;
                """,
            ]
        ]

    def validate(self) -> Testdrive:
        return Testdrive(
            dedent(
                f"""
                > SHOW CREATE MATERIALIZED VIEW string_bytea_types_view1;
                materialize.public.string_bytea_types_view1 "CREATE MATERIALIZED VIEW \\"materialize\\".\\"public\\".\\"string_bytea_types_view1\\" IN CLUSTER \\"{self._default_cluster()}\\" WITH (REFRESH = ON COMMIT) AS SELECT \\"text_col\\", \\"bytea_col\\", 'това'::\\"pg_catalog\\".\\"text\\", '\\\\xAAAA'::\\"pg_catalog\\".\\"bytea\\" FROM \\"materialize\\".\\"public\\".\\"text_bytea_types_table\\" WHERE \\"text_col\\" >= ''::\\"pg_catalog\\".\\"text\\" AND \\"bytea_col\\" >= ''::\\"pg_catalog\\".\\"bytea\\""

                > SELECT text_col, text, LENGTH(bytea_col), LENGTH(bytea) FROM string_bytea_types_view1;
                aaaa това 2 2
                aaaa това 2 2
                aaaa това 2 2
                "това е" това 10 2
                "това е" това 10 2
                "това е" това 10 2

                > SHOW CREATE VIEW string_bytea_types_view2;
                materialize.public.string_bytea_types_view2 "CREATE VIEW \\"materialize\\".\\"public\\".\\"string_bytea_types_view2\\" AS SELECT \\"text_col\\", \\"bytea_col\\", 'това'::\\"pg_catalog\\".\\"text\\", '\\\\xAAAA'::\\"pg_catalog\\".\\"bytea\\" FROM \\"materialize\\".\\"public\\".\\"text_bytea_types_table\\" WHERE \\"text_col\\" >= ''::\\"pg_catalog\\".\\"text\\" AND \\"bytea_col\\" >= ''::\\"pg_catalog\\".\\"bytea\\""

                > SELECT text_col, text, LENGTH(bytea_col), LENGTH(bytea) FROM string_bytea_types_view2;
                aaaa това 2 2
                aaaa това 2 2
                aaaa това 2 2
                "това е" това 10 2
                "това е" това 10 2
                "това е" това 10 2
            """
            )
        )

Ancestors

Check

Methods

def initialize(self) ‑> Testdrive

Expand source code Browse git

def initialize(self) -> Testdrive:
    return Testdrive(
        dedent(
            """
        > CREATE TABLE text_bytea_types_table (text_col TEXT, bytea_col BYTEA);
        > INSERT INTO text_bytea_types_table VALUES ('aaaa', '\\xAAAA'), ('това е', 'текст');
    """
        )
    )

def manipulate(self) ‑> list[Testdrive]

Expand source code Browse git

def manipulate(self) -> list[Testdrive]:
    return [
        Testdrive(dedent(s))
        for s in [
            """
            > CREATE MATERIALIZED VIEW string_bytea_types_view1 AS
              SELECT text_col, bytea_col, 'това'::TEXT, '\\xAAAA'::BYTEA
              FROM text_bytea_types_table
              WHERE text_col >= ''::TEXT AND bytea_col >= ''::BYTEA;

            > INSERT INTO text_bytea_types_table SELECT DISTINCT text_col, bytea_col FROM text_bytea_types_table;
            """,
            """
            > CREATE VIEW string_bytea_types_view2 AS
              SELECT text_col, bytea_col, 'това'::TEXT, '\\xAAAA'::BYTEA
              FROM text_bytea_types_table
              WHERE text_col >= ''::TEXT AND bytea_col >= ''::BYTEA;

            > INSERT INTO text_bytea_types_table SELECT DISTINCT text_col, bytea_col FROM text_bytea_types_table;
            """,
        ]
    ]

def validate(self) ‑> Testdrive

Expand source code Browse git

def validate(self) -> Testdrive:
    return Testdrive(
        dedent(
            f"""
            > SHOW CREATE MATERIALIZED VIEW string_bytea_types_view1;
            materialize.public.string_bytea_types_view1 "CREATE MATERIALIZED VIEW \\"materialize\\".\\"public\\".\\"string_bytea_types_view1\\" IN CLUSTER \\"{self._default_cluster()}\\" WITH (REFRESH = ON COMMIT) AS SELECT \\"text_col\\", \\"bytea_col\\", 'това'::\\"pg_catalog\\".\\"text\\", '\\\\xAAAA'::\\"pg_catalog\\".\\"bytea\\" FROM \\"materialize\\".\\"public\\".\\"text_bytea_types_table\\" WHERE \\"text_col\\" >= ''::\\"pg_catalog\\".\\"text\\" AND \\"bytea_col\\" >= ''::\\"pg_catalog\\".\\"bytea\\""

            > SELECT text_col, text, LENGTH(bytea_col), LENGTH(bytea) FROM string_bytea_types_view1;
            aaaa това 2 2
            aaaa това 2 2
            aaaa това 2 2
            "това е" това 10 2
            "това е" това 10 2
            "това е" това 10 2

            > SHOW CREATE VIEW string_bytea_types_view2;
            materialize.public.string_bytea_types_view2 "CREATE VIEW \\"materialize\\".\\"public\\".\\"string_bytea_types_view2\\" AS SELECT \\"text_col\\", \\"bytea_col\\", 'това'::\\"pg_catalog\\".\\"text\\", '\\\\xAAAA'::\\"pg_catalog\\".\\"bytea\\" FROM \\"materialize\\".\\"public\\".\\"text_bytea_types_table\\" WHERE \\"text_col\\" >= ''::\\"pg_catalog\\".\\"text\\" AND \\"bytea_col\\" >= ''::\\"pg_catalog\\".\\"bytea\\""

            > SELECT text_col, text, LENGTH(bytea_col), LENGTH(bytea) FROM string_bytea_types_view2;
            aaaa това 2 2
            aaaa това 2 2
            aaaa това 2 2
            "това е" това 10 2
            "това е" това 10 2
            "това е" това 10 2
        """
        )
    )