Test datetime handling
(self)
| 347 | session.close() |
| 348 | |
| 349 | def test_datetime_operations(self): |
| 350 | """Test datetime handling""" |
| 351 | session = self.Session() |
| 352 | try: |
| 353 | now = datetime.now() |
| 354 | |
| 355 | user = User( |
| 356 | username="datetime_test", |
| 357 | email="datetime@example.com", |
| 358 | created_at=now, |
| 359 | birth_date=date(1990, 1, 1) |
| 360 | ) |
| 361 | session.add(user) |
| 362 | session.commit() |
| 363 | |
| 364 | # Test datetime filtering |
| 365 | result = session.query(User).filter( |
| 366 | User.created_at >= now - timedelta(minutes=1) |
| 367 | ).first() |
| 368 | assert result is not None |
| 369 | |
| 370 | # Test date operations |
| 371 | result = session.query(User).filter( |
| 372 | User.birth_date < date(2000, 1, 1) |
| 373 | ).first() |
| 374 | assert result is not None |
| 375 | |
| 376 | finally: |
| 377 | session.close() |
| 378 | |
| 379 | def test_subqueries(self): |
| 380 | """Test subquery operations""" |