| 3350 | ) |
| 3351 | |
| 3352 | def test_date_between(self): |
| 3353 | import datetime |
| 3354 | |
| 3355 | table = Table("dt", metadata, Column("date", Date)) |
| 3356 | self.assert_compile( |
| 3357 | table.select().where( |
| 3358 | table.c.date.between( |
| 3359 | datetime.date(2006, 6, 1), datetime.date(2006, 6, 5) |
| 3360 | ) |
| 3361 | ), |
| 3362 | "SELECT dt.date FROM dt WHERE dt.date BETWEEN :date_1 AND :date_2", |
| 3363 | checkparams={ |
| 3364 | "date_1": datetime.date(2006, 6, 1), |
| 3365 | "date_2": datetime.date(2006, 6, 5), |
| 3366 | }, |
| 3367 | ) |
| 3368 | |
| 3369 | self.assert_compile( |
| 3370 | table.select().where( |
| 3371 | sql.between( |
| 3372 | table.c.date, |
| 3373 | datetime.date(2006, 6, 1), |
| 3374 | datetime.date(2006, 6, 5), |
| 3375 | ) |
| 3376 | ), |
| 3377 | "SELECT dt.date FROM dt WHERE dt.date BETWEEN :date_1 AND :date_2", |
| 3378 | checkparams={ |
| 3379 | "date_1": datetime.date(2006, 6, 1), |
| 3380 | "date_2": datetime.date(2006, 6, 5), |
| 3381 | }, |
| 3382 | ) |
| 3383 | |
| 3384 | def test_delayed_col_naming(self): |
| 3385 | my_str = Column(String) |