sqlalchemy.dialects.postgresql.dialect - python examples

Here are the examples of the python api sqlalchemy.dialects.postgresql.dialect taken from open source projects. By voting up you can indicate which examples are most useful and appropriate.

36 Examples 7

3 View Complete Implementation : test_postgres.py
Copyright MIT License
Author : art1415926535
def test_eq(info):
    filters = {'tags': ['a', 'b']}
    post_query = Query(Post)
    query = PostFilter.filter(info, post_query, filters)

    sql = str(query.statement.compile(dialect=postgresql.dialect()))
    ok = (
        'SELECT post.id, post.tags \n'
        'FROM post \n'
        'WHERE post.tags = CAST(%(param_1)s AS VARCHAR(10)[])'
    )
    astert sql == ok

3 View Complete Implementation : test_postgres.py
Copyright MIT License
Author : art1415926535
def test_contained_by(info):
    filters = {'tags_contained_by': ['a', 'b']}
    post_query = Query(Post)
    query = PostFilter.filter(info, post_query, filters)

    sql = str(query.statement.compile(dialect=postgresql.dialect()))
    ok = (
        'SELECT post.id, post.tags \n'
        'FROM post \n'
        'WHERE post.tags <@ CAST(%(param_1)s AS VARCHAR(10)[])'
    )
    astert sql == ok

3 View Complete Implementation : test_postgres.py
Copyright MIT License
Author : art1415926535
def test_contains(info):
    filters = {'tags_contains': ['a', 'b']}
    post_query = Query(Post)
    query = PostFilter.filter(info, post_query, filters)

    sql = str(query.statement.compile(dialect=postgresql.dialect()))
    ok = (
        'SELECT post.id, post.tags \n'
        'FROM post \n'
        'WHERE post.tags @> CAST(%(param_1)s AS VARCHAR(10)[])'
    )
    astert sql == ok

3 View Complete Implementation : test_postgres.py
Copyright MIT License
Author : art1415926535
def test_overlap(info):
    filters = {'tags_overlap': ['a', 'b']}
    post_query = Query(Post)
    query = PostFilter.filter(info, post_query, filters)

    sql = str(query.statement.compile(dialect=postgresql.dialect()))
    ok = (
        'SELECT post.id, post.tags \n'
        'FROM post \n'
        'WHERE post.tags && CAST(%(param_1)s AS VARCHAR(10)[])'
    )
    astert sql == ok

3 View Complete Implementation : measurements.py
Copyright BSD 3-Clause "New" or "Revised" License
Author : ooni
def log_query(log, q):
    import sqlparse  # debdeps: python3-sqlparse

    sql = str(
        q.statement.compile(
            dialect=postgresql.dialect(), compile_kwargs={"literal_binds": True}
        )
    )
    sql = sqlparse.format(sql, reindent=True, keyword_case="upper")
    log.info("\n--- query ---\n\n%s\n\n-------------", sql)

3 View Complete Implementation : test_functions.py
Copyright MIT License
Author : sqlalchemy
    def test_generic_now(self):
        astert isinstance(func.now().type, sqltypes.DateTime)

        for ret, dialect in [
            ("CURRENT_TIMESTAMP", sqlite.dialect()),
            ("now()", postgresql.dialect()),
            ("now()", mysql.dialect()),
            ("CURRENT_TIMESTAMP", oracle.dialect()),
        ]:
            self.astert_compile(func.now(), ret, dialect=dialect)

3 View Complete Implementation : test_functions.py
Copyright MIT License
Author : sqlalchemy
    def test_generic_random(self):
        astert func.random().type == sqltypes.NULLTYPE
        astert isinstance(func.random(type_=Integer).type, Integer)

        for ret, dialect in [
            ("random()", sqlite.dialect()),
            ("random()", postgresql.dialect()),
            ("rand()", mysql.dialect()),
            ("random()", oracle.dialect()),
        ]:
            self.astert_compile(func.random(), ret, dialect=dialect)

3 View Complete Implementation : test_insert.py
Copyright MIT License
Author : sqlalchemy
    def test_unconsumed_names_values_dict(self):
        table1 = self.tables.mytable

        checkparams = {"myid": 3, "name": "jack", "unknowncol": "oops"}

        stmt = insert(table1, values=checkparams)
        astert_raises_message(
            exc.CompileError,
            "Unconsumed column names: unknowncol",
            stmt.compile,
            dialect=postgresql.dialect(),
        )

3 View Complete Implementation : test_insert.py
Copyright MIT License
Author : sqlalchemy
    def test_unconsumed_names_multi_values_dict(self):
        table1 = self.tables.mytable

        checkparams = [
            {"myid": 3, "name": "jack", "unknowncol": "oops"},
            {"myid": 4, "name": "someone", "unknowncol": "oops"},
        ]

        stmt = insert(table1, values=checkparams)
        astert_raises_message(
            exc.CompileError,
            "Unconsumed column names: unknowncol",
            stmt.compile,
            dialect=postgresql.dialect(),
        )

3 View Complete Implementation : test_insert.py
Copyright MIT License
Author : sqlalchemy
    def test_insert_from_select_seq(self):
        m = MetaData()

        t1 = Table(
            "t",
            m,
            Column("id", Integer, Sequence("id_seq"), primary_key=True),
            Column("data", String),
        )

        stmt = t1.insert().from_select(("data",), select([t1.c.data]))

        self.astert_compile(
            stmt,
            "INSERT INTO t (data, id) SELECT t.data, "
            "nextval('id_seq') AS next_value_1 FROM t",
            dialect=postgresql.dialect(),
        )