| 529 | """) |
| 530 | |
| 531 | def test_out_params(self, connection): |
| 532 | result = connection.execute( |
| 533 | text("begin foo(:x_in, :x_out, :y_out, :z_out); end;").bindparams( |
| 534 | bindparam("x_in", Float), |
| 535 | outparam("x_out", Integer), |
| 536 | outparam("y_out", Float), |
| 537 | outparam("z_out", String), |
| 538 | ), |
| 539 | dict(x_in=5), |
| 540 | ) |
| 541 | eq_(result.out_parameters, {"x_out": 10, "y_out": 75, "z_out": None}) |
| 542 | assert isinstance(result.out_parameters["x_out"], int) |
| 543 | |
| 544 | def test_no_out_params_w_returning(self, connection, metadata): |
| 545 | t = Table("t", metadata, Column("x", Integer), Column("y", Integer)) |