def test_get_user_with_email(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(emails.insert().values(
user_id=1,
email="*****@*****.**",
primary=True,
verified=True,
))
assert {
"id": 1,
"date_joined": mock.ANY,
"email": "*****@*****.**",
"name": "Test User",
"username": "******",
} == dbapp.db.accounts.get_user("test-user")
def test_get_user_with_email(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(emails.insert().values(
user_id=1,
email="*****@*****.**",
primary=True,
verified=True,
))
assert {
"id": 1,
"date_joined": mock.ANY,
"email": "*****@*****.**",
"name": "Test User",
"username": "******",
} == dbapp.db.accounts.get_user("test-user")
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_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": "*****@*****.**"
},
]
