def test_missing_foreign_key_indices(db_session):
""" Test for foreign key constraints that don't have a corresponding
index. """
from sqlalchemy_utils.functions import non_indexed_foreign_keys
from kotti import metadata
assert non_indexed_foreign_keys(metadata) == {}
def test_missing_foreign_key_indices(db_session):
""" Test for foreign key constraints that don't have a corresponding
index. """
from sqlalchemy_utils.functions import non_indexed_foreign_keys
from kotti import metadata
assert non_indexed_foreign_keys(metadata) == {}
def test_finds_all_non_indexed_fks(self):
fks = non_indexed_foreign_keys(self.Base.metadata, self.engine)
assert ('article' in fks)
column_names = [
column_name for column_name in fks['article'][0].columns
]
assert 'category_id' in column_names
assert 'author_id' not in column_names
def test_finds_all_non_indexed_fks(self, session, Base, engine):
fks = non_indexed_foreign_keys(Base.metadata, engine)
assert ('article' in fks)
column_names = list(
chain(*(names for names in (fk.columns.keys()
for fk in fks['article']))))
assert 'category_id' in column_names
assert 'author_id' not in column_names
def test_finds_all_non_indexed_fks(self):
fks = non_indexed_foreign_keys(self.Base.metadata, self.engine)
assert (
'article' in
fks
)
column_names = [
column_name for column_name in fks['article'][0].columns
]
assert 'category_id' in column_names
assert 'author_id' not in column_names
def test_finds_all_non_indexed_fks(self, session, Base, engine):
fks = non_indexed_foreign_keys(Base.metadata, engine)
assert (
'article' in
fks
)
column_names = list(chain(
*(
names for names in (
fk.columns.keys()
for fk in fks['article']
)
)
))
assert 'category_id' in column_names
assert 'author_id' not in column_names
