| 1673 | |
| 1674 | @testing.provide_metadata |
| 1675 | def test_extract_expression(self, connection): |
| 1676 | meta = self.metadata |
| 1677 | table = Table("test", meta, Column("dt", DateTime), Column("d", Date)) |
| 1678 | meta.create_all(connection) |
| 1679 | connection.execute( |
| 1680 | table.insert(), |
| 1681 | { |
| 1682 | "dt": datetime.datetime(2010, 5, 1, 12, 11, 10), |
| 1683 | "d": datetime.date(2010, 5, 1), |
| 1684 | }, |
| 1685 | ) |
| 1686 | rs = connection.execute( |
| 1687 | select(extract("year", table.c.dt), extract("month", table.c.d)) |
| 1688 | ) |
| 1689 | row = rs.first() |
| 1690 | assert row[0] == 2010 |
| 1691 | assert row[1] == 5 |
| 1692 | rs.close() |
| 1693 | |
| 1694 | |
| 1695 | class RegisterTest(fixtures.TestBase, AssertsCompiledSQL): |