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