Method test_sql_dml_insert_18

tests/test_sql_dml.py:445–467

(self)

        )

    async def test_sql_dml_insert_18(self):
        res = await self.scon.fetch(
            '''
            WITH
                a as (INSERT INTO "Child" (prop) VALUES ('a')),
                b as (INSERT INTO "Child" (prop) VALUES ('b_0'), ('b_1'))
            SELECT line FROM "Log" ORDER BY line;
            '''
        )
        # changes to the database are not visible in the same query
        self.assert_shape(res, 0, 0)

        # so we need to re-select
        res = await self.squery_values('SELECT line FROM "Log" ORDER BY line;')
        self.assertEqual(
            res,
            [
                ["inserted all"],
                ["inserted each a"],
                ["inserted each b_0"],
                ["inserted each b_1"],
            ],
        )

    async def test_sql_dml_insert_19(self):
        # exclusive on base, then insert into base and child