Python cte Examples

Programming Language: Python

Namespace/Package Name: sqlalchemy.sql

Method/Function: cte

Examples at hotexamples.com: 2

Python cte - 2 examples found. These are the top rated real world Python examples of sqlalchemy.sql.cte extracted from open source projects. You can rate examples to help us improve the quality of examples.

Example #1

Show file

    def test_standalone_function(self):
        a = table("a", column("x"))
        a_stmt = select(a)

        stmt = select(cte(a_stmt))

        self.assert_compile(
            stmt,
            "WITH anon_1 AS (SELECT a.x AS x FROM a) "
            "SELECT anon_1.x FROM anon_1",
        )

Example #2

Show file

File: test_cte.py Project: monetate/sqlalchemy

    def test_standalone_function(self):
        a = table("a", column("x"))
        a_stmt = select([a])

        stmt = select([cte(a_stmt)])

        self.assert_compile(
            stmt,
            "WITH anon_1 AS (SELECT a.x AS x FROM a) "
            "SELECT anon_1.x FROM anon_1",
        )