Method test_sql_dml_insert_12

tests/test_sql_dml.py:288–300

(self)

        )

    async def test_sql_dml_insert_12(self):
        # returning
        await self.scon.execute('INSERT INTO "User" DEFAULT VALUES;')
        res = await self.scon.fetch(
            '''
            INSERT INTO "Document" (title, owner_id)
            SELECT 'Meeting Report', id FROM "User" LIMIT 1
            RETURNING id, owner_id, LOWER(title) as my_title
            '''
        )
        self.assert_shape(res, rows=1, columns=["id", "owner_id", "my_title"])
        first = res[0]
        self.assertEqual(first[2], 'meeting report (new)')

    async def test_sql_dml_insert_13(self):
        # returning sublink