- add an explicit test for sequences "optional"

1 files changed, 11 insertions, 1 deletions

diff --git a/lib/sqlalchemy/testing/requirements.py b/lib/sqlalchemy/testing/requirements.py
index f7d00afb2..e44a333be 100644
--- a/lib/sqlalchemy/testing/requirements.py
+++ b/lib/sqlalchemy/testing/requirements.py
@@ -155,7 +155,17 @@ class SuiteRequirements(Requirements):
 
         return exclusions.only_if([
                 lambda: self.config.db.dialect.supports_sequences
-            ], "no SEQUENCE support")
+            ], "no sequence support")
+
+    @property
+    def sequences_optional(self):
+        """Target database supports sequences, but also optionally
+        as a means of generating new PK values."""
+
+        return exclusions.only_if([
+                lambda: self.config.db.dialect.supports_sequences and \
+                    self.config.db.dialect.sequences_optional
+            ], "no sequence support, or sequences not optional")
 
     @property
     def reflects_pk_names(self):