def test_user_insert_same_uuid(db_session):
test_uuid = uuid4()
with pytest.raises(IntegrityError):
UserFactory.create(uuid=test_uuid)
db_session.commit()
UserFactory.create(uuid=test_uuid)
db_session.commit()
def test_user_update_same_provider_user_id(db_session):
UserFactory.create(provider_user_id="1")
obj = UserFactory.create(provider_user_id="2")
db_session.commit()
with pytest.raises(IntegrityError):
obj.provider_user_id = "1"
db_session.commit()
def test_user_service_get_create_oauth(service, db_perm_session):
assert len(service.db_session.query(User).all()) == 0
assert len(service.db_session.query(OAuth).all()) == 0
obj = service.get_create_oauth(provider="google",
provider_user_id="test",
token={})
assert obj.provider_user_id == "test"
assert obj.user is None
test_user = UserFactory.create()
obj = OAuthFactory.create()
obj.user = test_user
db_perm_session.commit()
assert len(service.db_session.query(User).all()) == 1
assert len(service.db_session.query(OAuth).all()) == 1
obj = service.get_create_oauth(
provider=test_user.oauth.provider,
provider_user_id=test_user.oauth.provider_user_id,
token={})
assert obj.id == test_user.oauth.id
assert obj.uuid == test_user.oauth.uuid
assert obj.user == test_user
def test_user_insert(db_session):
obj = UserFactory.create()
db_session.commit()
assert db_session.query(User).one()
assert db_session.query(User).filter(User.id == obj.id).one()
assert db_session.query(User).filter(User.uuid == obj.uuid).one()
def test_user_dict(db_session):
obj = UserFactory.create()
db_session.commit()
obj_dict = obj.to_dict()
assert len(obj_dict.keys()) == 3
for key in ["name", "email", "picture"]:
assert key in obj_dict
def test_user_insert_oauth(db_session):
user = UserFactory.create()
oauth = OAuthFactory.create()
oauth.user = user
db_session.commit()
assert db_session.query(User).one()
assert db_session.query(OAuth).one()
assert db_session.query(User).filter(User.oauth == oauth).one()
def test_user_single_parent_constraint(db_session):
obj = UserFactory.create()
obj2 = UserFactory.create()
assert obj.oauth is None
assert obj2.oauth is None
test_oauth = OAuthFactory.create()
obj.oauth = test_oauth
db_session.commit()
assert obj.oauth is not None
assert obj2.oauth is None
res = obj.oauth
obj2.oauth = res
db_session.commit()
assert obj.oauth is None
assert obj2.oauth is not None
assert obj2.oauth == res
def test_user_delete(db_session):
obj = UserFactory.create()
obj.oauth = OAuthFactory.create()
db_session.commit()
assert db_session.query(User).one()
assert db_session.query(OAuth).one()
result = db_session.query(User).filter(User.id == obj.id).delete()
assert result == 1
db_session.commit()
assert db_session.query(User).one_or_none() is None
assert db_session.query(OAuth).one_or_none() is None
def test_user_update_oauth(db_session):
user = UserFactory.create()
db_session.commit()
assert db_session.query(User).one()
assert db_session.query(OAuth).one_or_none() is None
oauth = OAuthFactory.create()
oauth.user = user
db_session.commit()
assert db_session.query(User).one()
assert db_session.query(OAuth).one()
assert db_session.query(User).filter(User.oauth == oauth).one()
result = db_session.query(OAuth).filter(OAuth.id == oauth.id).delete()
db_session.commit()
assert result == 1
assert db_session.query(User).one()
assert db_session.query(User).one().oauth is None
assert db_session.query(OAuth).one_or_none() is None
def test_user_insert_same_provider_user_id(db_session):
with pytest.raises(IntegrityError):
UserFactory.create(provider_user_id="1")
db_session.commit()
UserFactory.create(provider_user_id="1")
db_session.commit()
