Method test_sql_native_query_02

tests/test_sql_query.py:3071–3098

(self)

        )

    async def test_sql_native_query_02(self):
        await self.assert_sql_query_result(
            """
                SELECT
                    "Movie".title,
                    "Genre".name AS genre
                FROM
                    "Movie",
                    "Genre"
                WHERE
                    "Movie".genre_id = "Genre".id
                    AND "Genre".name = $1::text
                    AND length("Movie".title) > $2::int
                ORDER BY
                    title
            """,
            [
                {
                    "title": "Saving Private Ryan",
                    "genre": "Drama",
                }
            ],
            variables={
                "1": "Drama",
                "2": 14,
            },
            apply_access_policies=False,
        )

    async def test_sql_native_query_03(self):
        # No output at all