From 649f06759d933f4aacdfbb302e845e2bcb5e7641 Mon Sep 17 00:00:00 2001 From: Rodrigo Menezes Date: Thu, 14 Aug 2014 14:47:23 -0400 Subject: Added support for postgres_relkind. --- test/requirements.py | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'test/requirements.py') diff --git a/test/requirements.py b/test/requirements.py index e8705d145..927c94bfb 100644 --- a/test/requirements.py +++ b/test/requirements.py @@ -716,6 +716,14 @@ class DefaultRequirements(SuiteRequirements): "oracle_db_link option not specified in config" ) + @property + def postgresql_test_dblink(self): + return skip_if( + lambda config: not config.file_config.has_option( + 'sqla_testing', 'postgres_test_db_link'), + "postgres_test_db_link option not specified in config" + ) + @property def percent_schema_names(self): return skip_if( -- cgit v1.2.1 From fbd2d70a5cfd7b5c219c51cb5b7866c4ab89cece Mon Sep 17 00:00:00 2001 From: Rodrigo Menezes Date: Wed, 3 Sep 2014 16:38:43 -0400 Subject: Fixing some pep8s and adding get_foreign_tables. --- test/requirements.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'test/requirements.py') diff --git a/test/requirements.py b/test/requirements.py index 46c19389a..14bb25691 100644 --- a/test/requirements.py +++ b/test/requirements.py @@ -712,7 +712,7 @@ class DefaultRequirements(SuiteRequirements): 'sqla_testing', 'postgres_test_db_link'), "postgres_test_db_link option not specified in config" ) - + @property def percent_schema_names(self): return skip_if( -- cgit v1.2.1 From cb23fa243f5138aac7acb2a134d567f1a297d42e Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Wed, 17 Sep 2014 15:15:21 -0400 Subject: - Added :meth:`.Inspector.get_temp_table_names` and :meth:`.Inspector.get_temp_view_names`; currently, only the SQLite dialect supports these methods. The return of temporary table and view names has been **removed** from SQLite's version of :meth:`.Inspector.get_table_names` and :meth:`.Inspector.get_view_names`; other database backends cannot support this information (such as MySQL), and the scope of operation is different in that the tables can be local to a session and typically aren't supported in remote schemas. fixes #3204 --- test/requirements.py | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'test/requirements.py') diff --git a/test/requirements.py b/test/requirements.py index 14bb25691..cfdfc8054 100644 --- a/test/requirements.py +++ b/test/requirements.py @@ -296,6 +296,17 @@ class DefaultRequirements(SuiteRequirements): "sqlite" ) + @property + def temp_table_names(self): + """target dialect supports listing of temporary table names""" + + return only_on(['sqlite']) + + @property + def temporary_views(self): + """target database supports temporary views""" + return only_on(['sqlite', 'postgresql']) + @property def update_nowait(self): """Target database must support SELECT...FOR UPDATE NOWAIT""" -- cgit v1.2.1 From e3f07f7206cf0d6a5f2ff9344a365f4657645338 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Wed, 17 Sep 2014 19:43:45 -0400 Subject: - Added support for the Oracle table option ON COMMIT. This is being kept separate from Postgresql's ON COMMIT for now even though ON COMMIT is in the SQL standard; the option is still very specific to temp tables and we eventually would provide a more first class temporary table feature. - oracle can apparently do get_temp_table_names() too, so implement that, fix its get_table_names(), and add it to #3204. fixes #3204 again. --- test/requirements.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'test/requirements.py') diff --git a/test/requirements.py b/test/requirements.py index cfdfc8054..80bd135e9 100644 --- a/test/requirements.py +++ b/test/requirements.py @@ -300,7 +300,7 @@ class DefaultRequirements(SuiteRequirements): def temp_table_names(self): """target dialect supports listing of temporary table names""" - return only_on(['sqlite']) + return only_on(['sqlite', 'oracle']) @property def temporary_views(self): -- cgit v1.2.1 From 50d2432a9efa65c9798ef207e3f887cb5c0071e1 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Sun, 12 Oct 2014 20:14:32 -0400 Subject: - Mysqlconnector as of version 2.0, probably as a side effect of the python 3 merge, now does not expect percent signs (e.g. as used as the modulus operator and others) to be doubled, even when using the "pyformat" bound parameter format (this change is not documented by Mysqlconnector). The dialect now checks for py2k and for mysqlconnector less than version 2.0 when detecting if the modulus operator should be rendered as ``%%`` or ``%``. - Unicode SQL is now passed for MySQLconnector version 2.0 and above; for Py2k and MySQL < 2.0, strings are encoded. Note that mysqlconnector as of 2.0.1 appears to have a bug with unicode DDL on py2k, so the tests here are skipping until we observe it's fixed. - take out profiling on mysqlconnector, callcounts vary too much with its current development speed --- test/requirements.py | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'test/requirements.py') diff --git a/test/requirements.py b/test/requirements.py index 80bd135e9..0a695b641 100644 --- a/test/requirements.py +++ b/test/requirements.py @@ -420,6 +420,12 @@ class DefaultRequirements(SuiteRequirements): no_support('oracle', 'FIXME: no support in database?'), no_support('sybase', 'FIXME: guessing, needs confirmation'), no_support('mssql+pymssql', 'no FreeTDS support'), + LambdaPredicate( + lambda config: against(config, "mysql+mysqlconnector") and + config.db.dialect._mysqlconnector_version_info > (2, 0) and + util.py2k, + "bug in mysqlconnector 2.0" + ), LambdaPredicate( lambda config: against(config, 'mssql+pyodbc') and config.db.dialect.freetds and -- cgit v1.2.1 From d2c1edfb15334a2fb6ada5b064563c144ac22ad7 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Wed, 29 Oct 2014 14:55:42 -0400 Subject: - added new backend for pysqlcipher, as we will probably get requests for it soon. --- test/requirements.py | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'test/requirements.py') diff --git a/test/requirements.py b/test/requirements.py index 0a695b641..05ca8d717 100644 --- a/test/requirements.py +++ b/test/requirements.py @@ -449,7 +449,7 @@ class DefaultRequirements(SuiteRequirements): after an insert() construct executes. """ return fails_on_everything_except('mysql', - 'sqlite+pysqlite', + 'sqlite+pysqlite', 'sqlite+pysqlcipher', 'sybase', 'mssql') @property @@ -466,7 +466,7 @@ class DefaultRequirements(SuiteRequirements): """ return skip_if('mssql+pymssql', 'crashes on pymssql') + \ fails_on_everything_except('mysql', - 'sqlite+pysqlite') + 'sqlite+pysqlite', 'sqlite+pysqlcipher') @property def sane_multi_rowcount(self): -- cgit v1.2.1