| 282 | eq_(connection.execute(s, dict(id=7)).first()._mapping["user_id"], 7) |
| 283 | |
| 284 | def test_compiled_insert_execute(self, connection): |
| 285 | users = self.tables.users |
| 286 | connection.execute( |
| 287 | users.insert().compile(connection), |
| 288 | dict(user_id=7, user_name="jack"), |
| 289 | ) |
| 290 | s = ( |
| 291 | select(users) |
| 292 | .where(users.c.user_id == bindparam("id")) |
| 293 | .compile(connection) |
| 294 | ) |
| 295 | eq_(connection.execute(s, dict(id=7)).first()._mapping["user_id"], 7) |
| 296 | |
| 297 | def test_repeated_bindparams(self, connection): |
| 298 | """Tests that a BindParam can be used more than once. |