def test_get_classifier_ids(dbapp):
dbapp.engine.execute(classifiers.insert().values(
id=1,
classifier="Test :: Classifier",
))
dbapp.engine.execute(classifiers.insert().values(
id=2,
classifier="Test :: Another",
))
dbapp.engine.execute(classifiers.insert().values(
id=3,
classifier="Test :: The Other One",
))
test_classifiers = dbapp.models.packaging.get_classifier_ids(
["Test :: Classifier", "Test :: The Other One"])
assert test_classifiers == {
"Test :: Classifier": 1,
"Test :: The Other One": 3
}
def test_get_classifier_ids(dbapp):
dbapp.engine.execute(classifiers.insert().values(
id=1,
classifier="Test :: Classifier",
))
dbapp.engine.execute(classifiers.insert().values(
id=2,
classifier="Test :: Another",
))
dbapp.engine.execute(classifiers.insert().values(
id=3,
classifier="Test :: The Other One",
))
test_classifiers = dbapp.db.packaging.get_classifier_ids(
["Test :: Classifier", "Test :: The Other One"]
)
assert test_classifiers == {
"Test :: Classifier": 1,
"Test :: The Other One": 3
}
def test_search_by_classifier(search, result, dbapp):
dbapp.engine.execute(classifiers.insert().values(
id=1,
classifier="Test :: Classifier",
l2=1,
))
dbapp.engine.execute(classifiers.insert().values(
id=2, classifier="Test :: Classifier :: More", l2=1, l3=2))
dbapp.engine.execute(classifiers.insert().values(
id=5, classifier="Test :: Classifier :: Alternative", l2=1, l3=5))
dbapp.engine.execute(classifiers.insert().values(
id=3, classifier="Test :: Classifier :: More :: Wow", l2=1, l3=2,
l4=3))
dbapp.engine.execute(classifiers.insert().values(
id=4,
classifier="Test :: Classifier :: More :: Wow :: So Classifier",
l2=1,
l3=2,
l4=3,
l5=4))
dbapp.engine.execute(classifiers.insert().values(
id=6, classifier="Other :: Thing", l2=6))
dbapp.engine.execute(classifiers.insert().values(
id=7, classifier="Other :: Thing :: Moar", l2=6, l3=7))
def add_project(name, classifiers):
dbapp.engine.execute(packages.insert().values(name=name))
dbapp.engine.execute(releases.insert().values(name=name, version="1"))
for trove_id in classifiers:
dbapp.engine.execute(release_classifiers.insert().values(
name=name,
version="1",
trove_id=trove_id,
))
add_project('one', [1])
add_project('two', [2])
add_project('four-six', [4, 6])
add_project('seven', [7])
response = dbapp.models.packaging.search_by_classifier(search)
assert sorted(response) == sorted(result)
def test_get_classifiers(dbapp):
dbapp.engine.execute(packages.insert().values(name="test-project"))
dbapp.engine.execute(releases.insert().values(
name="test-project",
version="1.0",
))
dbapp.engine.execute(classifiers.insert().values(
id=1,
classifier="Test :: Classifier",
))
dbapp.engine.execute(release_classifiers.insert().values(
name="test-project",
version="1.0",
trove_id=1,
))
test_classifiers = dbapp.models.packaging.get_classifiers(
"test-project",
"1.0",
)
assert test_classifiers == ["Test :: Classifier"]
def test_get_classifiers(dbapp):
dbapp.engine.execute(packages.insert().values(name="test-project"))
dbapp.engine.execute(releases.insert().values(
name="test-project",
version="1.0",
))
dbapp.engine.execute(classifiers.insert().values(
id=1,
classifier="Test :: Classifier",
))
dbapp.engine.execute(release_classifiers.insert().values(
name="test-project",
version="1.0",
trove_id=1,
))
test_classifiers = dbapp.db.packaging.get_classifiers(
"test-project",
"1.0",
)
assert test_classifiers == ["Test :: Classifier"]
def test_search_by_classifier(search, result, dbapp):
dbapp.engine.execute(classifiers.insert().values(
id=1,
classifier="Test :: Classifier",
l2=1,
))
dbapp.engine.execute(classifiers.insert().values(
id=2,
classifier="Test :: Classifier :: More",
l2=1,
l3=2
))
dbapp.engine.execute(classifiers.insert().values(
id=5,
classifier="Test :: Classifier :: Alternative",
l2=1,
l3=5
))
dbapp.engine.execute(classifiers.insert().values(
id=3,
classifier="Test :: Classifier :: More :: Wow",
l2=1,
l3=2,
l4=3
))
dbapp.engine.execute(classifiers.insert().values(
id=4,
classifier="Test :: Classifier :: More :: Wow :: So Classifier",
l2=1,
l3=2,
l4=3,
l5=4
))
dbapp.engine.execute(classifiers.insert().values(
id=6,
classifier="Other :: Thing",
l2=6
))
dbapp.engine.execute(classifiers.insert().values(
id=7,
classifier="Other :: Thing :: Moar",
l2=6,
l3=7
))
def add_project(name, classifiers):
dbapp.engine.execute(packages.insert().values(name=name))
dbapp.engine.execute(releases.insert().values(name=name, version="1"))
for trove_id in classifiers:
dbapp.engine.execute(release_classifiers.insert().values(
name=name,
version="1",
trove_id=trove_id,
))
add_project('one', [1])
add_project('two', [2])
add_project('four-six', [4, 6])
add_project('seven', [7])
response = dbapp.db.packaging.search_by_classifier(search)
assert sorted(response) == sorted(result)
