MongoDB – Czit notes

Join MongoDB strings array

przez kszyh | 23 sierpnia 2019 - 14:18 |23 sierpnia 2019 Java Script, MongoDB

db.getCollection("abstracts").aggregate([
    {
        "$addFields": {
            "keywordsStr": {
                "$reduce": {
                    "input": "$keywords",
                    "initialValue": "",
                    "in": {
                        '$concat': [
                            '$$value',
                            {
                                '$cond': [
                                    { '$eq': ['$$value', ''] },
                                    '',
                                    ', '
                                ]
                            },
                            '$$this']
                    }
                }
            }
        },
    },
])

db.getCollection("abstracts").aggregate([

{

"$addFields": {

"keywordsStr": {

"$reduce": {

"input": "$keywords",

"initialValue": "",

"in": {

'$concat': [

'$$value',

{

'$cond': [

{ '$eq': ['$$value', ''] },

'',

', '

]

'$$this']

}

])

User LAST LOGIN stats

przez kszyh | 10 maja 2019 - 08:10 |10 maja 2019 Bez kategorii, MongoDB

Dodaj komentarz

Get datetime of last successful login of each user – from logs collection

// Requires official MongoShell 3.6+
db.getCollection("log").aggregate(
    [
        {
            $match: {
                "message": { "$eq": "USER_SUCCESS_LOGIN" }
            }
        },
        {
            $sort: { timestamp: -1 }
        },
        {
            $lookup: {
                "from": "users",
                "localField": "meta.user",
                "foreignField": "_id",
                "as": "user"
            }
        },
        {
            $match: {
                "user": { $ne: [] }
            }
        },
        {
            $unwind: { path: "$user" }
        },
        {
            $project: {
                "timestamp": { $dateToString: { format: "%Y-%m-%d %H:%M:%S:%L", date: "$timestamp" }} ,
                "message": 1,
                "userid": "$user._id",
                "firstName": "$user.firstName",
                "lastName": "$user.lastName",
            }
        },
        {
            $group:
                {
                    "_id": "$userid",
                    "firstName": { $first: "$firstName" },
                    "lastName": { $first: "$lastName" },
                    "lastLogin": { $first: "$timestamp" }
                }
        }

    ],
    {
        "allowDiskUse": true
    }
);

// Requires official MongoShell 3.6+

db.getCollection("log").aggregate(

[

{

$match: {

"message": { "$eq": "USER_SUCCESS_LOGIN" }

}

{

$sort: { timestamp: -1 }

{

$lookup: {

"from": "users",

"localField": "meta.user",

"foreignField": "_id",

"as": "user"

}

{

$match: {

"user": { $ne: [] }

}

{

$unwind: { path: "$user" }

{

$project: {

"timestamp": { $dateToString: { format: "%Y-%m-%d %H:%M:%S:%L", date: "$timestamp" }} ,

"message": 1,

"userid": "$user._id",

"firstName": "$user.firstName",

"lastName": "$user.lastName",

}

{

$group:

{

"_id": "$userid",

"firstName": { $first: "$firstName" },

"lastName": { $first: "$lastName" },

"lastLogin": { $first: "$timestamp" }

}

{

"allowDiskUse": true

}

);

Count documents using Aggregation

przez kszyh | 21 sierpnia 2018 - 07:46 |21 sierpnia 2018 MongoDB, Skrypty

Dodaj komentarz

Counts log entries, with type equal 'CREATE’ , fetch patients data from another collection, remove empty documents (if patients was not found the field is empty array), count by provided user id.

var user_id = '5ad070640c9faddd41a4b665'

db.getCollection('log').aggregate([
{ $match: { message: {$eq: 'CREATE' } }},
{
 $lookup: {
     from: 'patients',
     localField: 'meta.patient',
     foreignField: '_id',
     as: 'patient'
     }   
},
{ $match: { patient: {$not: {$size: 0}} }},
{ $match: {'meta.user': {$eq: ObjectId(user_id)}}},
    {
      $count: "created"
    }
])

var user_id = '5ad070640c9faddd41a4b665'

db.getCollection('log').aggregate([

{ $match: { message: {$eq: 'CREATE' } }},

{

$lookup: {

from: 'patients',

localField: 'meta.patient',

foreignField: '_id',

as: 'patient'

}

{ $match: { patient: {$not: {$size: 0}} }},

{ $match: {'meta.user': {$eq: ObjectId(user_id)}}},

{

$count: "created"

}

])

MongoDB – lookup example

przez kszyh | 11 kwietnia 2018 - 12:07 |11 kwietnia 2018 Java Script, MongoDB

Dodaj komentarz

db.getCollection('log').aggregate([
{
 $lookup: {
     from: 'users',
     localField: 'meta.user',
     foreignField: '_id',
     as: 'user'
     }   
},
{
 $lookup: {
     from: 'patients',
     localField: 'meta.patient',
     foreignField: '_id',
     as: 'patient'
     }   
},
{
  $sort: {
      timestamp: -1
  }
}
])

db.getCollection('log').aggregate([

{

$lookup: {

from: 'users',

localField: 'meta.user',

foreignField: '_id',

as: 'user'

}

{

$lookup: {

from: 'patients',

localField: 'meta.patient',

foreignField: '_id',

as: 'patient'

}

{

$sort: {

timestamp: -1

}

])

MongoDB – usunąć osamotnione dokumenty – błędne $ref

przez kszyh | 29 maja 2017 - 15:39 |29 maja 2017 MongoDB, Skrypty

Dodaj komentarz

ModelInstance jest kolekcją dokumentów w której każdy dokumnt posiada referencję do model, np.

{
    "_id" : ObjectId("57d554df3d8b602c54005bc2"),
    "model" : {
        "$ref" : "Model",
        "$id" : ObjectId("57b1ad893d8b602844004a22"),
        "$db" : "virtrollv2"
    },
    "parameters" : []
}

{

"_id" : ObjectId("57d554df3d8b602c54005bc2"),

"model" : {

"$ref" : "Model",

"$id" : ObjectId("57b1ad893d8b602844004a22"),

"$db" : "virtrollv2"

"parameters" : []

}

Zadanie: usunąć wszystkie dokumenty które wskazują na nieistniejące modele.

db.ModelInstance.find().forEach( function(instance) {
    var cursor = db.Model.find({'_id' : instance.model.$id});
    if(!cursor.hasNext()) {
        db.ModelInstance.remove({_id : instance._id});
    }
});

db.ModelInstance.find().forEach( function(instance) {

var cursor = db.Model.find({'_id' : instance.model.$id});

if(!cursor.hasNext()) {

db.ModelInstance.remove({_id : instance._id});

}

});

Archiwum kategorii: MongoDB

Join MongoDB strings array

User LAST LOGIN stats

Count documents using Aggregation

MongoDB – lookup example

MongoDB – usunąć osamotnione dokumenty – błędne $ref

Ostatnie wpisy

Najnowsze komentarze

Kategorie

Meta