Method test_sql_dml_insert_17b

tests/test_sql_dml.py:423–443

(self)

        )

    async def test_sql_dml_insert_17b(self):
        # more default values
        await self.scon.execute(
            '''
            INSERT INTO "Post" (id, title, content) VALUES
              (DEFAULT, 'foo', 'bar'),
              (DEFAULT, 'post', DEFAULT),
              (DEFAULT, DEFAULT, 'content'),
              (DEFAULT, DEFAULT, DEFAULT);
            '''
        )
        res = await self.squery_values('SELECT title, content FROM "Post"')
        self.assert_data_shape(
            res,
            tb.bag([
                ['foo', 'bar'],
                ['post', 'This page intentionally left blank'],
                ['untitled', 'content'],
                ['untitled', 'This page intentionally left blank'],
            ]),
        )

    async def test_sql_dml_insert_18(self):
        res = await self.scon.fetch(