diff options
| author | Gord Thompson <gord@gordthompson.com> | 2022-12-09 09:55:34 -0700 |
|---|---|---|
| committer | Gord Thompson <gord@gordthompson.com> | 2022-12-09 16:42:59 -0700 |
| commit | 8e83f34a0b4f17764f64479b774fb262e0b81910 (patch) | |
| tree | 0b00cca82ad7efff290c5188c28358c8d53c8a63 | |
| parent | d17d78a3b35ddd9131213cc9ad08c252f404baf8 (diff) | |
| download | sqlalchemy-8e83f34a0b4f17764f64479b774fb262e0b81910.tar.gz | |
Specify view columns in HasTableTest
Fixes: #8960
Avoid test errors on databases that do not
support CREATE VIEW vv AS SELECT * FROM
Change-Id: Ic9e892aa4466030b9b325c11228dad15cf59a258
(cherry picked from commit 7e9b1450b6899c82c9362cbc92fcc0f01c97b043)
| -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( |