| 614 | argnames="implicit_returning", |
| 615 | ) |
| 616 | def test_insert_via_seq( |
| 617 | self, table_fixture, connection, implicit_returning |
| 618 | ): |
| 619 | Manager, cartitems = table_fixture(implicit_returning) |
| 620 | |
| 621 | connection.execute(cartitems.insert(), dict(description="hi")) |
| 622 | connection.execute(cartitems.insert(), dict(description="there")) |
| 623 | r = connection.execute(cartitems.insert(), dict(description="lala")) |
| 624 | |
| 625 | expected = 2 + testing.db.dialect.default_sequence_base |
| 626 | eq_(r.inserted_primary_key[0], expected) |
| 627 | |
| 628 | eq_( |
| 629 | connection.scalar( |
| 630 | sa.select(cartitems.c.cart_id).where( |
| 631 | cartitems.c.description == "lala" |
| 632 | ), |
| 633 | ), |
| 634 | expected, |
| 635 | ) |
| 636 | |
| 637 | @testing.combinations( |
| 638 | (True, testing.requires.insert_returning), |