def test_get_roles_for_user(dbapp):
dbapp.engine.execute(users.insert().values(
id=1,
password="******",
username="******",
name="Test User",
last_login=datetime.datetime.utcnow(),
is_active=True,
is_superuser=False,
is_staff=False,
))
dbapp.engine.execute(users.insert().values(
id=2,
password="******",
username="******",
name="Test User",
last_login=datetime.datetime.utcnow(),
is_active=True,
is_superuser=False,
is_staff=False,
))
dbapp.engine.execute(packages.insert().values(name="test-project"))
dbapp.engine.execute(packages.insert().values(name="test-project2"))
dbapp.engine.execute(packages.insert().values(name="test-project3"))
dbapp.engine.execute(roles.insert().values(
package_name="test-project",
user_name="test-user",
role_name="Owner",
))
dbapp.engine.execute(roles.insert().values(
package_name="test-project",
user_name="test-user",
role_name="Maintainer",
))
dbapp.engine.execute(roles.insert().values(
package_name="test-project2",
user_name="a-test-user",
role_name="Maintainer",
))
dbapp.engine.execute(roles.insert().values(
package_name="test-project2",
user_name="test-user",
role_name="Maintainer",
))
assert dbapp.models.packaging.get_roles_for_user("test-user") == [
{
"package_name": "test-project",
"role_name": 'Maintainer'
},
{
"package_name": "test-project",
"role_name": "Owner"
},
{
"package_name": "test-project2",
"role_name": 'Maintainer'
},
]
def test_get_users_for_project(dbapp):
dbapp.engine.execute(users.insert().values(
id=1,
password="******",
username="******",
name="Test User",
last_login=datetime.datetime.utcnow(),
is_active=True,
is_superuser=False,
is_staff=False,
))
dbapp.engine.execute(users.insert().values(
id=2,
password="******",
username="******",
name="Test User",
last_login=datetime.datetime.utcnow(),
is_active=True,
is_superuser=False,
is_staff=False,
))
dbapp.engine.execute(users.insert().values(
id=3,
password="******",
username="******",
name="Test User2",
last_login=datetime.datetime.utcnow(),
is_active=True,
is_superuser=False,
is_staff=False,
))
dbapp.engine.execute(emails.insert().values(
user_id=3,
email="*****@*****.**",
primary=True,
verified=True,
))
dbapp.engine.execute(packages.insert().values(name="test-project"))
dbapp.engine.execute(roles.insert().values(
package_name="test-project",
user_name="test-user",
role_name="Owner",
))
dbapp.engine.execute(roles.insert().values(
package_name="test-project",
user_name="test-user2",
role_name="Maintainer",
))
dbapp.engine.execute(roles.insert().values(
package_name="test-project",
user_name="a-test-user",
role_name="Maintainer",
))
assert dbapp.models.packaging.get_users_for_project("test-project") == [
{"username": "******", "email": None},
{"username": "******", "email": None},
{"username": "******", "email": "*****@*****.**"},
]
def test_get_roles_for_project(dbapp):
dbapp.engine.execute(users.insert().values(
id=1,
password="******",
username="******",
name="Test User",
last_login=datetime.datetime.utcnow(),
is_active=True,
is_superuser=False,
is_staff=False,
))
dbapp.engine.execute(users.insert().values(
id=2,
password="******",
username="******",
name="Test User",
last_login=datetime.datetime.utcnow(),
is_active=True,
is_superuser=False,
is_staff=False,
))
dbapp.engine.execute(users.insert().values(
id=3,
password="******",
username="******",
name="Test User2",
last_login=datetime.datetime.utcnow(),
is_active=True,
is_superuser=False,
is_staff=False,
))
dbapp.engine.execute(packages.insert().values(name="test-project"))
dbapp.engine.execute(roles.insert().values(
package_name="test-project",
user_name="test-user",
role_name="Owner",
))
dbapp.engine.execute(roles.insert().values(
package_name="test-project",
user_name="test-user",
role_name="Maintainer",
))
dbapp.engine.execute(roles.insert().values(
package_name="test-project",
user_name="a-test-user",
role_name="Maintainer",
))
assert dbapp.db.packaging.get_roles_for_project("test-project") == [
{"user_name": "a-test-user", "role_name": 'Maintainer'},
{"user_name": "test-user", "role_name": 'Maintainer'},
{"user_name": "test-user", "role_name": "Owner"},
]
def test_get_projects_for_user(dbapp):
dbapp.engine.execute(users.insert().values(
password="******",
username="******",
name="Test User",
last_login=datetime.datetime.utcnow(),
is_active=True,
is_superuser=False,
is_staff=False,
))
dbapp.engine.execute(packages.insert().values(name="test-project"))
dbapp.engine.execute(releases.insert().values(
name="test-project",
version="1.0",
summary="test summmary",
_pypi_ordering=1,
))
dbapp.engine.execute(releases.insert().values(
name="test-project",
version="2.0",
summary="test summmary 2.0",
_pypi_ordering=2,
))
dbapp.engine.execute(roles.insert().values(
package_name="test-project",
user_name="test-user",
role_name="Owner",
))
assert dbapp.models.packaging.get_projects_for_user("test-user") == [
{
"name": "test-project",
"summary": "test summmary 2.0"
},
]
def test_get_projects_for_user(dbapp):
dbapp.engine.execute(users.insert().values(
password="******",
username="******",
name="Test User",
last_login=datetime.datetime.utcnow(),
is_active=True,
is_superuser=False,
is_staff=False,
))
dbapp.engine.execute(packages.insert().values(name="test-project"))
dbapp.engine.execute(releases.insert().values(
name="test-project",
version="1.0",
summary="test summmary",
_pypi_ordering=1,
))
dbapp.engine.execute(releases.insert().values(
name="test-project",
version="2.0",
summary="test summmary 2.0",
_pypi_ordering=2,
))
dbapp.engine.execute(roles.insert().values(
package_name="test-project",
user_name="test-user",
role_name="Owner",
))
assert dbapp.db.packaging.get_projects_for_user("test-user") == [
{"name": "test-project", "summary": "test summmary 2.0"},
]
def test_get_users_for_project(dbapp):
dbapp.engine.execute(users.insert().values(
id=1,
password="******",
username="******",
name="Test User",
last_login=datetime.datetime.utcnow(),
is_active=True,
is_superuser=False,
is_staff=False,
))
dbapp.engine.execute(users.insert().values(
id=2,
password="******",
username="******",
name="Test User",
last_login=datetime.datetime.utcnow(),
is_active=True,
is_superuser=False,
is_staff=False,
))
dbapp.engine.execute(users.insert().values(
id=3,
password="******",
username="******",
name="Test User2",
last_login=datetime.datetime.utcnow(),
is_active=True,
is_superuser=False,
is_staff=False,
))
dbapp.engine.execute(emails.insert().values(
user_id=3,
email="*****@*****.**",
primary=True,
verified=True,
))
dbapp.engine.execute(packages.insert().values(name="test-project"))
dbapp.engine.execute(roles.insert().values(
package_name="test-project",
user_name="test-user",
role_name="Owner",
))
dbapp.engine.execute(roles.insert().values(
package_name="test-project",
user_name="test-user2",
role_name="Maintainer",
))
dbapp.engine.execute(roles.insert().values(
package_name="test-project",
user_name="test-user",
role_name="Maintainer",
))
dbapp.engine.execute(roles.insert().values(
package_name="test-project",
user_name="a-test-user",
role_name="Maintainer",
))
assert dbapp.models.packaging.get_users_for_project("test-project") == [
{
"username": "******",
"email": None
},
{
"username": "******",
"email": None
},
{
"username": "******",
"email": "*****@*****.**"
},
]