| 586 | class TestQuery(unittest.TestCase): |
| 587 | |
| 588 | def setUp(self): |
| 589 | # Define self.db in a subclass. |
| 590 | # Create test tables. |
| 591 | self.db.create("persons", fields=[ |
| 592 | db.primary_key("id"), |
| 593 | db.field("name", db.STRING), |
| 594 | db.field("age", db.INTEGER), |
| 595 | db.field("gender", db.INTEGER) |
| 596 | ]) |
| 597 | self.db.create("gender", fields=[ |
| 598 | db.primary_key("id"), |
| 599 | db.field("name", db.STRING) |
| 600 | ]) |
| 601 | # Create test data. |
| 602 | self.db.persons.insert(name="john", age="30", gender=2) |
| 603 | self.db.persons.insert(name="jack", age="20", gender=2) |
| 604 | self.db.persons.insert(name="jane", age="30", gender=1) |
| 605 | self.db.gender.insert(name="female") |
| 606 | self.db.gender.insert(name="male") |
| 607 | |
| 608 | def tearDown(self): |
| 609 | # Drop test tables. |