def test_by_email_wrong_email(self, db_session):
        add_user(db_session)
        queried_user = User.by_email('wrong_email', db_session=db_session)

        assert queried_user is None
    def test_by_email_none(self, db_session):
        add_user(db_session)
        queried_user = User.by_email(None, db_session=db_session)

        assert queried_user is None
    def test_by_email(self, db_session):
        created_user = add_user(db_session)
        queried_user = User.by_email('email', db_session=db_session)

        assert created_user == queried_user
    def test_by_email_wrong_email(self, db_session):
        add_user(db_session)
        queried_user = User.by_email('wrong_email', db_session=db_session)

        assert queried_user is None
    def test_by_email_none(self, db_session):
        add_user(db_session)
        queried_user = User.by_email(None, db_session=db_session)

        assert queried_user is None
    def test_by_email(self, db_session):
        created_user = add_user(db_session)
        queried_user = User.by_email('email', db_session=db_session)

        assert created_user == queried_user