Method test_sql_dml_insert_05

tests/test_sql_dml.py:168–197

(self)

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

    async def test_sql_dml_insert_05(self):
        # insert link
        await self.scon.execute('INSERT INTO "User" DEFAULT VALUES;')
        await self.scon.execute(
            'INSERT INTO "Document" (owner_id) SELECT id FROM "User" LIMIT 1'
        )
        res = await self.squery_values('SELECT owner_id FROM "Document"')
        self.assert_shape(res, rows=1, columns=1)

        # insert multiple
        await self.scon.execute('INSERT INTO "User" DEFAULT VALUES;')
        await self.scon.execute(
            'INSERT INTO "Document" (owner_id) SELECT id FROM "User"'
        )
        res = await self.squery_values('SELECT owner_id FROM "Document"')
        self.assert_shape(res, rows=3, columns=1)

        # insert a null link
        await self.scon.execute(
            'INSERT INTO "Document" (owner_id) VALUES (NULL)'
        )

        # insert multiple, with nulls
        await self.scon.execute(
            '''
            INSERT INTO "Document" (owner_id) VALUES
                ((SELECT id from "User" LIMIT 1)),
                (NULL)
            '''
        )

    async def test_sql_dml_insert_06(self):
        # insert in a subquery: syntax error