| 3121 | ) |
| 3122 | |
| 3123 | def test_iteration(self): |
| 3124 | metadata = MetaData() |
| 3125 | table1 = Table( |
| 3126 | "table1", |
| 3127 | metadata, |
| 3128 | Column("col1", Integer, primary_key=True), |
| 3129 | schema="someschema", |
| 3130 | ) |
| 3131 | table2 = Table( |
| 3132 | "table2", |
| 3133 | metadata, |
| 3134 | Column("col1", Integer, primary_key=True), |
| 3135 | Column("col2", Integer, ForeignKey("someschema.table1.col1")), |
| 3136 | schema="someschema", |
| 3137 | ) |
| 3138 | |
| 3139 | t1 = str(schema.CreateTable(table1).compile(bind=testing.db)) |
| 3140 | t2 = str(schema.CreateTable(table2).compile(bind=testing.db)) |
| 3141 | if testing.db.dialect.preparer(testing.db.dialect).omit_schema: |
| 3142 | assert t1.index("CREATE TABLE table1") > -1 |
| 3143 | assert t2.index("CREATE TABLE table2") > -1 |
| 3144 | else: |
| 3145 | assert t1.index("CREATE TABLE someschema.table1") > -1 |
| 3146 | assert t2.index("CREATE TABLE someschema.table2") > -1 |
| 3147 | |
| 3148 | |
| 3149 | class UseExistingTest(testing.AssertsCompiledSQL, fixtures.TablesTest): |