| 1338 | |
| 1339 | @testing.provide_metadata |
| 1340 | def test_extract_expression(self, connection): |
| 1341 | meta = self.metadata |
| 1342 | table = Table("test", meta, Column("dt", DateTime), Column("d", Date)) |
| 1343 | meta.create_all(connection) |
| 1344 | connection.execute( |
| 1345 | table.insert(), |
| 1346 | { |
| 1347 | "dt": datetime.datetime(2010, 5, 1, 12, 11, 10), |
| 1348 | "d": datetime.date(2010, 5, 1), |
| 1349 | }, |
| 1350 | ) |
| 1351 | rs = connection.execute( |
| 1352 | select(extract("year", table.c.dt), extract("month", table.c.d)) |
| 1353 | ) |
| 1354 | row = rs.first() |
| 1355 | assert row[0] == 2010 |
| 1356 | assert row[1] == 5 |
| 1357 | rs.close() |
| 1358 | |
| 1359 | |
| 1360 | class RegisterTest(fixtures.TestBase, AssertsCompiledSQL): |