def check_constraint_reflection(self):
return fails_on_everything_except(
"postgresql",
"sqlite",
"oracle",
self._mysql_and_check_constraints_exist,
)
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 dbapi_lastrowid(self):
""""target backend includes a 'lastrowid' accessor on the DBAPI
cursor object.
"""
return fails_on_everything_except('mysql+mysqldb', 'mysql+oursql',
'sqlite+pysqlite', 'mysql+pymysql')
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 unique_constraint_reflection(self):
return fails_on_everything_except(
"postgresql",
"mysql",
"sqlite",
"oracle"
)
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 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 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 emulated_lastrowid(self):
""""target dialect retrieves cursor.lastrowid or an equivalent
after an insert() construct executes.
"""
return fails_on_everything_except(
"mysql+mysqldb",
"mysql+oursql",
"sqlite+pysqlite",
"mysql+pymysql",
"mysql+cymysql",
"sybase",
"mssql+pyodbc",
"mssql+mxodbc",
)
def nullsordering(self):
"""Target backends that support nulls ordering."""
return fails_on_everything_except('postgresql', 'oracle', 'firebird')
def nullsordering(self):
"""Target backends that support nulls ordering."""
return fails_on_everything_except("postgresql", "oracle", "firebird")
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 check_constraint_reflection(self):
return fails_on_everything_except(
"postgresql",
"sqlite"
)
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 check_constraint_reflection(self):
return fails_on_everything_except(
"postgresql", "sqlite", "oracle",
self._mariadb_102
)
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 check_constraint_reflection(self):
return fails_on_everything_except("postgresql", "sqlite", "oracle",
self._mariadb_102)
def nullsordering(self):
"""Target backends that support nulls ordering."""
return fails_on_everything_except("postgresql", "oracle", "firebird")
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 unique_constraint_reflection(self):
return fails_on_everything_except("postgresql", "mysql", "sqlite",
"oracle")
def no_referential_integrity(self):
"""test will fail if referential integrity is enforced"""
return exclusions.fails_on_everything_except("sqlite")
def nullsordering(self):
"""Target backends that support nulls ordering."""
return fails_on_everything_except('postgresql', 'oracle', 'firebird')
def check_constraint_reflection(self):
return fails_on_everything_except("postgresql", "sqlite")
def reflects_pk_names(self):
"""Target driver reflects the name of primary key constraints."""
return fails_on_everything_except('postgresql', 'oracle', 'mssql',
'sybase')
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 reflects_pk_names(self):
"""Target driver reflects the name of primary key constraints."""
return fails_on_everything_except('postgresql', 'oracle', 'mssql',
'sybase', 'sqlite')
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', 'sybase',
'mssql')