(cls, metadata)
| 50 | |
| 51 | @classmethod |
| 52 | def define_tables(cls, metadata): |
| 53 | Table( |
| 54 | "publication", |
| 55 | metadata, |
| 56 | Column( |
| 57 | "id", Integer, primary_key=True, test_needs_autoincrement=True |
| 58 | ), |
| 59 | Column("name", String(45), default=""), |
| 60 | ) |
| 61 | Table( |
| 62 | "issue", |
| 63 | metadata, |
| 64 | Column( |
| 65 | "id", Integer, primary_key=True, test_needs_autoincrement=True |
| 66 | ), |
| 67 | Column("publication_id", Integer, ForeignKey("publication.id")), |
| 68 | Column("issue", Integer), |
| 69 | ) |
| 70 | Table( |
| 71 | "location", |
| 72 | metadata, |
| 73 | Column( |
| 74 | "id", Integer, primary_key=True, test_needs_autoincrement=True |
| 75 | ), |
| 76 | Column("issue_id", Integer, ForeignKey("issue.id")), |
| 77 | Column("ref", CHAR(3), default=""), |
| 78 | Column( |
| 79 | "location_name_id", Integer, ForeignKey("location_name.id") |
| 80 | ), |
| 81 | ) |
| 82 | Table( |
| 83 | "location_name", |
| 84 | metadata, |
| 85 | Column( |
| 86 | "id", Integer, primary_key=True, test_needs_autoincrement=True |
| 87 | ), |
| 88 | Column("name", String(45), default=""), |
| 89 | ) |
| 90 | Table( |
| 91 | "magazine", |
| 92 | metadata, |
| 93 | Column( |
| 94 | "id", Integer, primary_key=True, test_needs_autoincrement=True |
| 95 | ), |
| 96 | Column("location_id", Integer, ForeignKey("location.id")), |
| 97 | Column("page_size_id", Integer, ForeignKey("page_size.id")), |
| 98 | ) |
| 99 | Table( |
| 100 | "page", |
| 101 | metadata, |
| 102 | Column( |
| 103 | "id", Integer, primary_key=True, test_needs_autoincrement=True |
| 104 | ), |
| 105 | Column("page_no", Integer), |
| 106 | Column("type", CHAR(1), default="p"), |
| 107 | ) |
| 108 | Table( |
| 109 | "magazine_page", |
nothing calls this directly
no test coverage detected