diff options
| author | mike bayer <mike_mp@zzzcomputing.com> | 2022-12-11 15:07:00 +0000 |
|---|---|---|
| committer | Gerrit Code Review <gerrit@ci3.zzzcomputing.com> | 2022-12-11 15:07:00 +0000 |
| commit | a1bba77ce462da7db1808f12a715b13d4ab605df (patch) | |
| tree | c73937182623fd50e5bf9774b6b7a9a8a50af906 | |
| parent | 9920a0dd16be1325026a18dd02d5d4b89d712439 (diff) | |
| parent | 8e83f34a0b4f17764f64479b774fb262e0b81910 (diff) | |
| download | sqlalchemy-a1bba77ce462da7db1808f12a715b13d4ab605df.tar.gz | |
Merge "Specify view columns in HasTableTest" into rel_1_4
| -rw-r--r-- | lib/sqlalchemy/testing/suite/test_reflection.py | 11 |
1 files changed, 7 insertions, 4 deletions
diff --git a/lib/sqlalchemy/testing/suite/test_reflection.py b/lib/sqlalchemy/testing/suite/test_reflection.py index 4e575046d..f1b8d8aaf 100644 --- a/lib/sqlalchemy/testing/suite/test_reflection.py +++ b/lib/sqlalchemy/testing/suite/test_reflection.py @@ -76,15 +76,18 @@ class HasTableTest(OneConnectionTablesTest): @classmethod def define_views(cls, metadata): - query = "CREATE VIEW vv AS SELECT * FROM test_table" + query = "CREATE VIEW vv AS SELECT id, data FROM test_table" event.listen(metadata, "after_create", DDL(query)) event.listen(metadata, "before_drop", DDL("DROP VIEW vv")) if testing.requires.schemas.enabled: - query = "CREATE VIEW %s.vv AS SELECT * FROM %s.test_table_s" % ( - config.test_schema, - config.test_schema, + query = ( + "CREATE VIEW %s.vv AS SELECT id, data FROM %s.test_table_s" + % ( + config.test_schema, + config.test_schema, + ) ) event.listen(metadata, "after_create", DDL(query)) event.listen( |