Method test_sql_dml_insert_10

tests/test_sql_dml.py:258–272

(self)

        self.assertEqual(res, tb.bag([['Report (new)'], ['Briefing (new)']]))

    async def test_sql_dml_insert_10(self):
        # two inserts
        await self.scon.execute(
            '''
            WITH a AS (
                INSERT INTO "Document" (title) VALUES ('Report')
                RETURNING title as t
            )
            INSERT INTO "Document" (title) SELECT t || ' - copy' FROM a
            '''
        )
        res = await self.squery_values('SELECT title FROM "Document"')
        self.assert_data_shape(
            res, tb.bag([['Report (new)'], ['Report (new) - copy (new)']])
        )

    async def test_sql_dml_insert_11(self):
        await self.scon.execute(