()
| 131 | |
| 132 | |
| 133 | def setup_objects(): |
| 134 | metadata = sa.MetaData() |
| 135 | parent = sa.Table( |
| 136 | class="st">"parent", |
| 137 | metadata, |
| 138 | sa.Column(class="st">"id", sa.Integer, primary_key=True), |
| 139 | sa.Column(class="st">"data", sa.String(20)), |
| 140 | ) |
| 141 | child = sa.Table( |
| 142 | class="st">"child", |
| 143 | metadata, |
| 144 | sa.Column(class="st">"id", sa.Integer, primary_key=True), |
| 145 | sa.Column(class="st">"data", sa.String(20)), |
| 146 | sa.Column( |
| 147 | class="st">"parent_id", sa.Integer, sa.ForeignKey(class="st">"parent.id"), nullable=False |
| 148 | ), |
| 149 | ) |
| 150 | |
| 151 | class Parent: |
| 152 | pass |
| 153 | |
| 154 | class Child: |
| 155 | pass |
| 156 | |
| 157 | registry = orm.registry() |
| 158 | registry.map_imperatively( |
| 159 | Parent, |
| 160 | parent, |
| 161 | properties={class="st">"children": orm.relationship(Child, backref=class="st">"parent")}, |
| 162 | ) |
| 163 | registry.map_imperatively(Child, child) |
| 164 | |
| 165 | many_types = sa.Table( |
| 166 | class="st">"large", |
| 167 | metadata, |
| 168 | sa.Column(class="st">"col_ARRAY", sa.ARRAY(sa.Integer)), |
| 169 | sa.Column(class="st">"col_BIGINT", sa.BIGINT), |
| 170 | sa.Column(class="st">"col_BigInteger", sa.BigInteger), |
| 171 | sa.Column(class="st">"col_BINARY", sa.BINARY), |
| 172 | sa.Column(class="st">"col_BLOB", sa.BLOB), |
| 173 | sa.Column(class="st">"col_BOOLEAN", sa.BOOLEAN), |
| 174 | sa.Column(class="st">"col_Boolean", sa.Boolean), |
| 175 | sa.Column(class="st">"col_CHAR", sa.CHAR), |
| 176 | sa.Column(class="st">"col_CLOB", sa.CLOB), |
| 177 | sa.Column(class="st">"col_DATE", sa.DATE), |
| 178 | sa.Column(class="st">"col_Date", sa.Date), |
| 179 | sa.Column(class="st">"col_DATETIME", sa.DATETIME), |
| 180 | sa.Column(class="st">"col_DateTime", sa.DateTime), |
| 181 | sa.Column(class="st">"col_DECIMAL", sa.DECIMAL), |
| 182 | sa.Column(class="st">"col_DOUBLE", sa.DOUBLE), |
| 183 | sa.Column(class="st">"col_Double", sa.Double), |
| 184 | sa.Column(class="st">"col_DOUBLE_PRECISION", sa.DOUBLE_PRECISION), |
| 185 | sa.Column(class="st">"col_Enum", sa.Enum), |
| 186 | sa.Column(class="st">"col_FLOAT", sa.FLOAT), |
| 187 | sa.Column(class="st">"col_Float", sa.Float), |
| 188 | sa.Column(class="st">"col_INT", sa.INT), |
| 189 | sa.Column(class="st">"col_INTEGER", sa.INTEGER), |
| 190 | sa.Column(class="st">"col_Integer", sa.Integer), |
no test coverage detected