def emulated_lastrowid(self):
""" "target dialect retrieves cursor.lastrowid or an equivalent
after an insert() construct executes.
"""
return fails_on_everything_except("mysql", "sqlite+pysqlite",
"sqlite+pysqlcipher", "sybase",
"mssql")
def datetime_literals(self):
"""target dialect supports rendering of a date, time, or datetime as a
literal string, e.g. via the TypeEngine.literal_processor() method.
"""
return fails_on_everything_except("sqlite")
def check_constraint_reflection(self):
return fails_on_everything_except(
"postgresql",
"sqlite",
"oracle",
self._mysql_and_check_constraints_exist,
)
def dbapi_lastrowid(self):
""" "target backend includes a 'lastrowid' accessor on the DBAPI
cursor object.
"""
return skip_if("mssql+pymssql",
"crashes on pymssql") + fails_on_everything_except(
"mysql", "sqlite+pysqlite", "sqlite+pysqlcipher")
def non_updating_cascade(self):
"""target database must *not* support ON UPDATE..CASCADE behavior in
foreign keys."""
return fails_on_everything_except("sqlite", "oracle",
"+zxjdbc") + skip_if("mssql")
def reflects_pk_names(self):
"""Target driver reflects the name of primary key constraints."""
return fails_on_everything_except("postgresql", "oracle", "mssql",
"sybase", "sqlite")
def nullsordering(self):
"""Target backends that support nulls ordering."""
return fails_on_everything_except("postgresql", "oracle", "firebird",
"sqlite >= 3.30.0")
def unique_constraint_reflection(self):
return fails_on_everything_except("postgresql", "mysql", "sqlite",
"oracle")