Method test_sql_dml_insert_09

tests/test_sql_dml.py:245–256

(self)

            )

    async def test_sql_dml_insert_09(self):
        # insert with a CTE
        await self.scon.execute(
            '''
            WITH a AS (
                SELECT 'Report' as t UNION ALL SELECT 'Briefing'
            )
            INSERT INTO "Document" (title) SELECT * FROM a
            '''
        )
        res = await self.squery_values('SELECT title FROM "Document"')
        self.assertEqual(res, tb.bag([['Report (new)'], ['Briefing (new)']]))

    async def test_sql_dml_insert_10(self):
        # two inserts