Method test_sql_dml_insert_02

tests/test_sql_dml.py:121–140

(self)

        self.assertEqual(res, [['Meeting report (new)']])

    async def test_sql_dml_insert_02(self):
        # when columns are not specified, all columns are expected,
        # in alphabetical order:
        # id, __type__, owner, title

        await self.scon.execute("SET LOCAL allow_user_specified_id TO TRUE")
        with self.assertRaisesRegex(
            asyncpg.DataError,
            "cannot assign to link '__type__': it is protected",
            # TODO: positions are hard to recover since we don't even know which
            # DML stmt this error is originating from
            # position="30",
        ):
            await self.scon.execute(
                '''
                INSERT INTO "Document" VALUES (NULL, NULL, NULL, 'Report')
                '''
            )
            res = await self.squery_values('SELECT title FROM "Document"')
            self.assertEqual(res, [['Report (new)']])

    async def test_sql_dml_insert_03(self):
        # multiple rows at once