1645624551

Committed 13 Sep 2024 11:58AM UTC coverage: 70.971% (-14.3%) from 85.226%

Build # 1645624551

Build Type

push

gitlab-ci

Committed by

web-flow

Commit Message

Merge pull request #432 from mzedel/chore/deprecate

Chore/deprecate

Run Details

2792 of 3934 relevant lines covered (70.97%)

40.83 hits per line

Source File
Press 'n' to go to next uncovered line, 'b' for previous

86.86

/store/mongo/datastore_mongo.go

// Copyright 2023 Northern.tech AS
//
//    Licensed under the Apache License, Version 2.0 (the "License");
//    you may not use this file except in compliance with the License.
//    You may obtain a copy of the License at
//
//        http://www.apache.org/licenses/LICENSE-2.0
//
//    Unless required by applicable law or agreed to in writing, software
//    distributed under the License is distributed on an "AS IS" BASIS,
//    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
//    See the License for the specific language governing permissions and
//    limitations under the License.

package mongo

import (
        "context"
        "crypto/tls"
        "strings"
        "time"

        _ "github.com/mendersoftware/go-lib-micro/mongo/codec"
        "github.com/mendersoftware/go-lib-micro/mongo/oid"
        mstore "github.com/mendersoftware/go-lib-micro/store/v2"
        "github.com/pkg/errors"
        "go.mongodb.org/mongo-driver/bson"
        "go.mongodb.org/mongo-driver/mongo"
        mopts "go.mongodb.org/mongo-driver/mongo/options"
        "golang.org/x/crypto/bcrypt"

        "github.com/mendersoftware/useradm/jwt"
        "github.com/mendersoftware/useradm/model"
        "github.com/mendersoftware/useradm/store"
)

const (
        DbUsersColl        = "users"
        DbTokensColl       = "tokens"
        DbSettingsColl     = "settings"
        DbUserSettingsColl = "user_settings"

        DbUserEmail       = "email"
        DbUserPass        = "password"
        DbUserLoginTs     = "login_ts"
        DbTokenSubject    = "sub"
        DbTokenExpiresAt  = "exp"
        DbTokenExpireTime = "exp.time"
        DbTokenIssuedAt   = "iat"
        DbTokenTenant     = "tenant"
        DbTokenUser       = "user"
        DbTokenIssuer     = "iss"
        DbTokenScope      = "scp"
        DbTokenAudience   = "aud"
        DbTokenNotBefore  = "nbf"
        DbTokenLastUsed   = "last_used"
        DbTokenName       = "name"
        DbID              = "_id"

        DbTokenIssuedAtTime = DbTokenIssuedAt + ".time"

        DbUniqueEmailIndexName           = "email_1"
        DbUniqueTokenNameIndexName       = "token_name_1"
        DbTokenSubjectIndexName          = "token_subject_1"
        brokenDbTokenExpirationIndexName = "token_expiration"

        DbTenantUniqueTokenNameIndexName = "tenant_1_subject_1_name_1"
        DbTenantTokenSubjectIndexName    = "tenant_1_subject_1"

        DbSettingsEtag            = "etag"
        DbSettingsTenantIndexName = "tenant"
        DbSettingsUserID          = "user_id"
)

type DataStoreMongoConfig struct {
        // MGO connection string
        ConnectionString string

        // SSL support
        SSL           bool
        SSLSkipVerify bool

        // Overwrites credentials provided in connection string if provided
        Username string
        Password string
}

type DataStoreMongo struct {
        client      *mongo.Client
        automigrate bool
        multitenant bool
}

func GetDataStoreMongo(config DataStoreMongoConfig) (*DataStoreMongo, error) {
        d, err := NewDataStoreMongo(config)
        if err != nil {
                return nil, errors.Wrap(err, "database connection failed")
        }
        return d, nil
}

func NewDataStoreMongoWithClient(client *mongo.Client) (*DataStoreMongo, error) {

        db := &DataStoreMongo{
                client: client,
        }

        return db, nil
}

func NewDataStoreMongo(config DataStoreMongoConfig) (*DataStoreMongo, error) {
        var err error
        var mongoURL string

        clientOptions := mopts.Client()
        if !strings.Contains(config.ConnectionString, "://") {
                mongoURL = "mongodb://" + config.ConnectionString
        } else {
                mongoURL = config.ConnectionString

        }
        clientOptions.ApplyURI(mongoURL)

        if config.Username != "" {
                credentials := mopts.Credential{
                        Username: config.Username,
                }
                if config.Password != "" {
                        credentials.Password = config.Password
                        credentials.PasswordSet = true
                }
                clientOptions.SetAuth(credentials)
        }

        if config.SSL {
                tlsConfig := &tls.Config{
                        InsecureSkipVerify: config.SSLSkipVerify,
                }
                clientOptions.SetTLSConfig(tlsConfig)
        }

        ctx, cancel := context.WithTimeout(context.Background(), 10*time.Second)
        defer cancel()
        c, err := mongo.Connect(ctx, clientOptions)
        if err != nil {
                return nil, err
        }

        // Validate connection
        if err = c.Ping(ctx, nil); err != nil {
                return nil, err
        }

        db, err := NewDataStoreMongoWithClient(c)
        if err != nil {
                return nil, err
        }

        return db, nil
}

func (db *DataStoreMongo) Ping(ctx context.Context) error {
        res := db.client.Database(DbName).RunCommand(ctx, bson.M{"ping": 1})
        return res.Err()
}

func (db *DataStoreMongo) CreateUser(ctx context.Context, u *model.User) error {
        now := time.Now().UTC()

        u.CreatedTs = &now
        u.UpdatedTs = &now

        _, err := db.client.
                Database(mstore.DbFromContext(ctx, DbName)).
                Collection(DbUsersColl).
                InsertOne(ctx, mstore.WithTenantID(ctx, u))

        if err != nil {
                if strings.Contains(err.Error(), "duplicate key error") {
                        return store.ErrDuplicateEmail
                }

                return errors.Wrap(err, "failed to insert user")
        }

        return nil
}

func isDuplicateKeyError(err error) bool {
        const errCodeDupKey = 11000
        switch errType := err.(type) {
        case mongo.WriteException:
                if len(errType.WriteErrors) > 0 {
                        for _, we := range errType.WriteErrors {
                                if we.Code == errCodeDupKey {
                                        return true
                                }
                        }
                }
        case mongo.CommandError:
                if errType.Code == errCodeDupKey {
                        return true
                }
        }
        return false
}

// UpdateUser updates the user of a given ID.
// NOTE: This function supports using ETag matching using UserUpdate,
// but defaults to wildcard matching
func (db *DataStoreMongo) UpdateUser(
        ctx context.Context,
        id string,
        u *model.UserUpdate,
) (*model.User, error) {
        var updatedUser = new(model.User)
        //compute/set password hash
        if u.Password != "" {
                hash, err := bcrypt.GenerateFromPassword([]byte(u.Password), bcrypt.DefaultCost)
                if err != nil {
                        return nil, errors.Wrap(err,
                                "failed to generate password hash")
                }
                u.Password = string(hash)
        }

        now := time.Now().UTC()
        u.UpdatedTs = &now

        collUsers := db.client.
                Database(mstore.DbFromContext(ctx, DbName)).
                Collection(DbUsersColl)

        f := bson.M{"_id": id}
        if u.ETag != nil {
                if *u.ETag == model.ETagNil {
                        f["etag"] = bson.D{{Key: "$exists", Value: false}}
                } else {
                        f["etag"] = *u.ETag
                }
                if u.ETagUpdate == nil {
                        next := *u.ETag
                        next.Increment()
                        u.ETagUpdate = &next
                }
        }
        up := bson.M{"$set": u}
        fuOpts := mopts.FindOneAndUpdate().
                SetReturnDocument(mopts.Before)
        err := collUsers.FindOneAndUpdate(ctx, mstore.WithTenantID(ctx, f), up, fuOpts).
                Decode(updatedUser)

        switch {
        case err == mongo.ErrNoDocuments:
                return nil, store.ErrUserNotFound
        case isDuplicateKeyError(err):
                return nil, store.ErrDuplicateEmail
        case err != nil:
                return nil, errors.Wrap(err, "store: failed to update user")
        }

        return updatedUser, nil
}

func (db *DataStoreMongo) UpdateLoginTs(ctx context.Context, id string) error {
        collUsrs := db.client.
                Database(mstore.DbFromContext(ctx, DbName)).
                Collection(DbUsersColl)

        _, err := collUsrs.UpdateOne(ctx,
                mstore.WithTenantID(ctx, bson.D{{Key: "_id", Value: id}}),
                bson.D{{Key: "$set", Value: bson.D{
                        {Key: DbUserLoginTs, Value: time.Now()}},
                }},
        )
        return err
}

func (db *DataStoreMongo) GetUserByEmail(
        ctx context.Context,
        email model.Email,
) (*model.User, error) {
        var user model.User

        err := db.client.Database(mstore.DbFromContext(ctx, DbName)).
                Collection(DbUsersColl).
                FindOne(ctx, mstore.WithTenantID(ctx, bson.M{DbUserEmail: email})).
                Decode(&user)

        if err != nil {
                if err == mongo.ErrNoDocuments {
                        return nil, nil
                } else {
                        return nil, errors.Wrap(err, "failed to fetch user")
                }
        }

        return &user, nil
}

func (db *DataStoreMongo) GetUserById(ctx context.Context, id string) (*model.User, error) {
        user, err := db.GetUserAndPasswordById(ctx, id)
        if user != nil {
                user.Password = ""
        }
        return user, err
}

func (db *DataStoreMongo) GetUserAndPasswordById(
        ctx context.Context,
        id string,
) (*model.User, error) {
        var user model.User

        err := db.client.Database(mstore.DbFromContext(ctx, DbName)).
                Collection(DbUsersColl).
                FindOne(ctx, mstore.WithTenantID(ctx, bson.M{"_id": id})).
                Decode(&user)

        if err != nil {
                if err == mongo.ErrNoDocuments {
                        return nil, nil
                } else {
                        return nil, errors.Wrap(err, "failed to fetch user")
                }
        }

        return &user, nil
}

func (db *DataStoreMongo) GetTokenById(ctx context.Context, id oid.ObjectID) (*jwt.Token, error) {
        var token jwt.Token

        err := db.client.Database(mstore.DbFromContext(ctx, DbName)).
                Collection(DbTokensColl).
                FindOne(ctx, mstore.WithTenantID(ctx, bson.M{"_id": id})).
                Decode(&token)

        if err != nil {
                if err == mongo.ErrNoDocuments {
                        return nil, nil
                } else {
                        return nil, errors.Wrap(err, "failed to fetch token")
                }
        }

        return &token, nil
}

func (db *DataStoreMongo) GetUsers(
        ctx context.Context,
        fltr model.UserFilter,
) ([]model.User, error) {
        findOpts := mopts.Find().
                SetProjection(bson.M{DbUserPass: 0})

        collUsers := db.client.
                Database(mstore.DbFromContext(ctx, DbName)).
                Collection(DbUsersColl)

        var mgoFltr = bson.D{}
        if fltr.ID != nil {
                mgoFltr = append(mgoFltr, bson.E{Key: "_id", Value: bson.D{{
                        Key: "$in", Value: fltr.ID,
                }}})
        }
        if fltr.Email != nil {
                mgoFltr = append(mgoFltr, bson.E{Key: "email", Value: bson.D{{
                        Key: "$in", Value: fltr.Email,
                }}})
        }
        if fltr.CreatedAfter != nil {
                mgoFltr = append(mgoFltr, bson.E{
                        Key: "created_ts", Value: bson.D{{
                                Key: "$gt", Value: *fltr.CreatedAfter,
                        }},
                })
        }
        if fltr.CreatedBefore != nil {
                mgoFltr = append(mgoFltr, bson.E{
                        Key: "created_ts", Value: bson.D{{
                                Key: "$lt", Value: *fltr.CreatedBefore,
                        }},
                })
        }
        if fltr.UpdatedAfter != nil {
                mgoFltr = append(mgoFltr, bson.E{
                        Key: "updated_ts", Value: bson.D{{
                                Key: "$gt", Value: *fltr.UpdatedAfter,
                        }},
                })
        }
        if fltr.UpdatedBefore != nil {
                mgoFltr = append(mgoFltr, bson.E{
                        Key: "updated_ts", Value: bson.D{{
                                Key: "$lt", Value: *fltr.UpdatedBefore,
                        }},
                })
        }
        cur, err := collUsers.Find(ctx, mstore.WithTenantID(ctx, mgoFltr), findOpts)
        if err != nil {
                return nil, errors.Wrap(err, "store: failed to fetch users")
        }

        users := []model.User{}
        err = cur.All(ctx, &users)
        switch err {
        case nil, mongo.ErrNoDocuments:
                return users, nil
        default:
                return nil, errors.Wrap(err, "store: failed to decode users")
        }
}

func (db *DataStoreMongo) DeleteUser(ctx context.Context, id string) error {
        _, err := db.client.Database(mstore.DbFromContext(ctx, DbName)).
                Collection(DbUsersColl).
                DeleteOne(ctx, mstore.WithTenantID(ctx, bson.M{"_id": id}))

        if err != nil {
                return err
        }

        return nil
}

func (db *DataStoreMongo) SaveToken(ctx context.Context, token *jwt.Token) error {
        _, err := db.client.Database(mstore.DbFromContext(ctx, DbName)).
                Collection(DbTokensColl).
                InsertOne(ctx, mstore.WithTenantID(ctx, token))

        if isDuplicateKeyError(err) {
                return store.ErrDuplicateTokenName
        } else if err != nil {
                return errors.Wrap(err, "failed to store token")
        }
        return err
}

func (db *DataStoreMongo) EnsureSessionTokensLimit(ctx context.Context, userID oid.ObjectID,
        tokensLimit int) error {
        opts := &mopts.FindOptions{}
        opts.SetLimit(int64(tokensLimit))
        opts.SetSkip(int64(tokensLimit) - 1)
        opts.SetSort(bson.M{
                DbTokenIssuedAtTime: -1,
        })

        cur, err := db.client.Database(mstore.DbFromContext(ctx, DbName)).
                Collection(DbTokensColl).
                Find(ctx, mstore.WithTenantID(ctx, bson.M{
                        DbTokenSubject: userID,
                        DbTokenName:    bson.M{"$exists": false},
                }), opts)
        if err != nil {
                return err
        }

        tokens := []jwt.Token{}
        err = cur.All(ctx, &tokens)
        if err == mongo.ErrNoDocuments || len(tokens) == 0 {
                return nil
        } else if err != nil {
                return err
        }

        _, err = db.client.
                Database(mstore.DbFromContext(ctx, DbName)).
                Collection(DbTokensColl).
                DeleteMany(ctx, mstore.WithTenantID(ctx, bson.M{
                        DbTokenSubject: userID,
                        DbTokenName:    bson.M{"$exists": false},
                        DbTokenIssuedAtTime: bson.M{
                                "$lt": tokens[0].IssuedAt.Time,
                        },
                }))

        return err
}

// WithMultitenant enables multitenant support and returns a new datastore based
// on current one
func (db *DataStoreMongo) WithMultitenant() *DataStoreMongo {
        return &DataStoreMongo{
                client:      db.client,
                automigrate: db.automigrate,
                multitenant: true,
        }
}

// WithAutomigrate enables automatic migration and returns a new datastore based
// on current one
func (db *DataStoreMongo) WithAutomigrate() *DataStoreMongo {
        return &DataStoreMongo{
                client:      db.client,
                automigrate: true,
                multitenant: db.multitenant,
        }
}

func (db *DataStoreMongo) DeleteToken(ctx context.Context, userID, tokenID oid.ObjectID) error {
        _, err := db.client.
                Database(mstore.DbFromContext(ctx, DbName)).
                Collection(DbTokensColl).
                DeleteOne(ctx, mstore.WithTenantID(ctx, bson.M{DbID: tokenID, DbTokenSubject: userID}))
        return err
}

// deletes all tenant's tokens (identity in context)
func (db *DataStoreMongo) DeleteTokens(ctx context.Context) error {
        d, err := db.client.
                Database(mstore.DbFromContext(ctx, DbName)).
                Collection(DbTokensColl).
                DeleteMany(ctx, mstore.WithTenantID(ctx, bson.M{}))

        if err != nil {
                return err
        }

        if d.DeletedCount == 0 {
                return store.ErrTokenNotFound
        }

        return err
}

// deletes all user's tokens
func (db *DataStoreMongo) DeleteTokensByUserId(ctx context.Context, userId string) error {
        return db.DeleteTokensByUserIdExceptCurrentOne(ctx, userId, oid.ObjectID{})
}

// deletes all user's tokens except the current one
func (db *DataStoreMongo) DeleteTokensByUserIdExceptCurrentOne(
        ctx context.Context,
        userId string,
        tokenID oid.ObjectID,
) error {
        c := db.client.
                Database(mstore.DbFromContext(ctx, DbName)).
                Collection(DbTokensColl)

        id := oid.FromString(userId)
        filter := bson.M{
                "sub": id,
        }

        if tokenID != (oid.ObjectID{}) {
                filter["_id"] = bson.M{
                        "$ne": tokenID,
                }
        }

        _, err := c.DeleteMany(ctx, mstore.WithTenantID(ctx, filter))
        if err != nil {
                return errors.Wrap(err, "failed to remove tokens")
        }

        return nil
}

func (db *DataStoreMongo) SaveSettings(ctx context.Context, s *model.Settings, etag string) error {
        c := db.client.Database(mstore.DbFromContext(ctx, DbName)).
                Collection(DbSettingsColl)

        o := &mopts.ReplaceOptions{}
        o.SetUpsert(true)

        filters := bson.M{}
        if etag != "" {
                filters[DbSettingsEtag] = etag
        }
        _, err := c.ReplaceOne(ctx,
                mstore.WithTenantID(ctx, filters),
                mstore.WithTenantID(ctx, s),
                o,
        )
        if err != nil && !mongo.IsDuplicateKeyError(err) {
                return errors.Wrapf(err, "failed to store settings %v", s)
        } else if mongo.IsDuplicateKeyError(err) && etag != "" {
                return store.ErrETagMismatch
        }

        return err
}

func (db *DataStoreMongo) SaveUserSettings(ctx context.Context, userID string,
        s *model.Settings, etag string) error {
        c := db.client.Database(mstore.DbFromContext(ctx, DbName)).
                Collection(DbUserSettingsColl)

        o := &mopts.ReplaceOptions{}
        o.SetUpsert(true)

        filters := bson.M{
                DbSettingsUserID: userID,
        }
        if etag != "" {
                filters[DbSettingsEtag] = etag
        }
        settings := mstore.WithTenantID(ctx, s)
        settings = append(settings, bson.E{
                Key:   DbSettingsUserID,
                Value: userID,
        })
        _, err := c.ReplaceOne(ctx,
                mstore.WithTenantID(ctx, filters),
                settings,
                o,
        )
        if err != nil && !mongo.IsDuplicateKeyError(err) {
                return errors.Wrapf(err, "failed to store settings %v", s)
        } else if mongo.IsDuplicateKeyError(err) && etag != "" {
                return store.ErrETagMismatch
        }

        return err
}

func (db *DataStoreMongo) GetSettings(ctx context.Context) (*model.Settings, error) {
        c := db.client.Database(mstore.DbFromContext(ctx, DbName)).
                Collection(DbSettingsColl)

        var settings *model.Settings
        err := c.FindOne(ctx, mstore.WithTenantID(ctx, bson.M{})).Decode(&settings)

        switch err {
        case nil:
                return settings, nil
        case mongo.ErrNoDocuments:
                return nil, nil
        default:
                return nil, errors.Wrapf(err, "failed to get settings")
        }
}

func (db *DataStoreMongo) GetUserSettings(ctx context.Context,
        userID string) (*model.Settings, error) {
        c := db.client.Database(mstore.DbFromContext(ctx, DbName)).
                Collection(DbUserSettingsColl)

        filters := bson.M{
                DbSettingsUserID: userID,
        }
        var settings *model.Settings
        err := c.FindOne(ctx, mstore.WithTenantID(ctx, filters)).Decode(&settings)

        switch err {
        case nil:
                return settings, nil
        case mongo.ErrNoDocuments:
                return nil, nil
        default:
                return nil, errors.Wrapf(err, "failed to get settings")
        }
}

func (db *DataStoreMongo) GetPersonalAccessTokens(
        ctx context.Context,
        userID string,
) ([]model.PersonalAccessToken, error) {
        findOpts := mopts.Find().
                SetProjection(
                        bson.M{
                                DbID:             1,
                                DbTokenName:      1,
                                DbTokenExpiresAt: 1,
                                DbTokenLastUsed:  1,
                                DbTokenIssuedAt:  1,
                        },
                )

        collTokens := db.client.
                Database(mstore.DbFromContext(ctx, DbName)).
                Collection(DbTokensColl)

        var mgoFltr = bson.M{
                DbTokenSubject: oid.FromString(userID),
                DbTokenName:    bson.M{"$exists": true},
        }
        cur, err := collTokens.Find(ctx, mstore.WithTenantID(ctx, mgoFltr), findOpts)
        if err != nil {
                return nil, errors.Wrap(err, "store: failed to fetch tokens")
        }

        tokens := []model.PersonalAccessToken{}
        err = cur.All(ctx, &tokens)
        switch err {
        case nil, mongo.ErrNoDocuments:
                return tokens, nil
        default:
                return nil, errors.Wrap(err, "store: failed to decode tokens")
        }
}

func (db *DataStoreMongo) UpdateTokenLastUsed(ctx context.Context, id oid.ObjectID) error {
        collTokens := db.client.
                Database(mstore.DbFromContext(ctx, DbName)).
                Collection(DbTokensColl)

        _, err := collTokens.UpdateOne(ctx,
                mstore.WithTenantID(ctx, bson.D{{Key: DbID, Value: id}}),
                bson.D{{Key: "$set", Value: bson.D{
                        {Key: DbTokenLastUsed, Value: time.Now()}},
                }},
        )

        return err
}

func (db *DataStoreMongo) CountPersonalAccessTokens(
        ctx context.Context,
        userID string,
) (int64, error) {
        collTokens := db.client.
                Database(mstore.DbFromContext(ctx, DbName)).
                Collection(DbTokensColl)

        var mgoFltr = bson.M{
                DbTokenSubject: oid.FromString(userID),
                DbTokenName:    bson.M{"$exists": true},
        }
        count, err := collTokens.CountDocuments(ctx, mstore.WithTenantID(ctx, mgoFltr))
        if err != nil {
                return -1, errors.Wrap(err, "store: failed to count tokens")
        }
        return count, nil
}

mendersoftware / useradm / 1645624551

Source File Press 'n' to go to next uncovered line, 'b' for previous

Source File
Press 'n' to go to next uncovered line, 'b' for previous