Method test_sql_dml_insert_17a

tests/test_sql_dml.py:376–421

(self)

            )

    async def test_sql_dml_insert_17a(self):
        # default values

        await self.scon.execute(
            '''
            INSERT INTO "Document" DEFAULT VALUES;
            '''
        )

        await self.scon.execute(
            '''
            INSERT INTO "Document" (id, title) VALUES (DEFAULT, 'Report');
            '''
        )
        res = await self.squery_values('SELECT title FROM "Document"')
        self.assert_data_shape(res, tb.bag([[None], ['Report (new)']]))

        await self.scon.execute(
            '''
            INSERT INTO "Document" (title) VALUES ('Report2'), (DEFAULT);
            '''
        )
        res = await self.squery_values('SELECT title FROM "Document"')
        self.assert_data_shape(
            res,
            tb.bag([
                [None],
                [None],
                ['Report (new)'],
                ['Report2 (new)'],
            ]),
        )

        await self.scon.execute(
            '''
            INSERT INTO "Post" (title) VALUES ('post'), (DEFAULT);
            '''
        )
        res = await self.squery_values('SELECT title FROM "Post"')
        self.assert_data_shape(
            res,
            tb.bag([
                ['post'],
                ['untitled'],
            ]),
        )

    async def test_sql_dml_insert_17b(self):
        # more default values