| 3555 | ) |
| 3556 | |
| 3557 | def test_date_between(self): |
| 3558 | import datetime |
| 3559 | |
| 3560 | table = Table("dt", metadata, Column("date", Date)) |
| 3561 | self.assert_compile( |
| 3562 | table.select().where( |
| 3563 | table.c.date.between( |
| 3564 | datetime.date(2006, 6, 1), datetime.date(2006, 6, 5) |
| 3565 | ) |
| 3566 | ), |
| 3567 | "SELECT dt.date FROM dt WHERE dt.date BETWEEN :date_1 AND :date_2", |
| 3568 | checkparams={ |
| 3569 | "date_1": datetime.date(2006, 6, 1), |
| 3570 | "date_2": datetime.date(2006, 6, 5), |
| 3571 | }, |
| 3572 | ) |
| 3573 | |
| 3574 | self.assert_compile( |
| 3575 | table.select().where( |
| 3576 | sql.between( |
| 3577 | table.c.date, |
| 3578 | datetime.date(2006, 6, 1), |
| 3579 | datetime.date(2006, 6, 5), |
| 3580 | ) |
| 3581 | ), |
| 3582 | "SELECT dt.date FROM dt WHERE dt.date BETWEEN :date_1 AND :date_2", |
| 3583 | checkparams={ |
| 3584 | "date_1": datetime.date(2006, 6, 1), |
| 3585 | "date_2": datetime.date(2006, 6, 5), |
| 3586 | }, |
| 3587 | ) |
| 3588 | |
| 3589 | def test_delayed_col_naming(self): |
| 3590 | my_str = Column(String) |