Pipelines de agregação complexos com Baunilha PHP e MongoDB

1
<?php
2
require_once __DIR__ . '/vendor/autoload.php';
3
use MongoDB\Client;
4
use MongoDB\Driver\ServerApi;
5
6
// Replace the placeholder with your Atlas connection string
7
$uri = "<your connection string>";
8
9
// Specify Stable API version 1
10
$apiVersion = new ServerApi(ServerApi::V1);
11
12
// Create a new client and connect to the server
13
$client = new MongoDB\Client($uri, [], ['serverApi' => $apiVersion]);
14
15
try {
16
    // Send a ping to confirm a successful connection
17
    $client->selectDatabase('admin')->command(['ping' => 1]);
18
    echo "Pinged your deployment. You successfully connected to MongoDB!\n";
19
} catch (Exception $e) {
20
    printf($e->getMessage());
21
}
22
23
// We will write all the aggregation examples code from here.

1
$> php aggregation.php
2
$> Pinged your deployment. You successfully connected to MongoDB!

1
<?php
2
$commentsCollection = $client->sample_mflix->comments;
3
$pipeline = [
4
    [
5
        '$group' => [
6
            '_id' => '$email', // Group by user email
7
            'totalComments' => ['$sum' => 1] // Sum the total comments of each user
8
        ]
9
    ],
10
    [
11
        '$sort' => ['totalComments' => -1] // Sort by total comments in descending order
12
    ],
13
    [
14
        '$limit' => 5 // Limit the results to the top 5 users
15
    ]
16
];
17
$result = $commentsCollection->aggregate($pipeline);
18
$resultArray = $result->toArray();
19
echo "<pre>" . print_r($resultArray, true) . "</pre>";

1
Pinged your deployment. You successfully connected to MongoDB!
2
[
3
    {
4
        "_id": "roger_ashton-griffiths@gameofthron.es",
5
        "totalComments": 277
6
    },
7
    {
8
        "_id": "ron_donachie@gameofthron.es",
9
        "totalComments": 260
10
    },
11
    {
12
        "_id": "jonathan_pryce@gameofthron.es",
13
        "totalComments": 260
14
    },
15
    {
16
        "_id": "nathalie_emmanuel@gameofthron.es",
17
        "totalComments": 258
18
    },
19
    {
20
        "_id": "robert_jordan@fakegmail.com",
21
        "totalComments": 257
22
    }
23
]

1
<?php
2
$moviesCollection = $client->sample_mflix->movies;
3
$pipeline = [
4
    [
5
        '$match' => [
6
            'imdb.rating' => ['$exists' => true] // Ensure that the movie has an IMDb rating
7
        ]
8
    ],
9
    [
10
        '$addFields' => [
11
            'month' => ['$month' => '$released'], // Extract month from released date
12
            'year' => ['$year' => '$released'], // Extract year from released date
13
        ]
14
    ],
15
    [
16
        '$group' => [
17
            '_id' => [
18
                'year' => '$year',
19
                'month' => '$month'
20
            ],
21
            'averageRating' => ['$avg' => '$imdb.rating'] // Calculate the average rating
22
        ]
23
    ],
24
    [
25
        '$sort' => [
26
            '_id.year' => 1,
27
            '_id.month' => 1
28
        ]
29
    ],
30
];
31
$result = $moviesCollection->aggregate($pipeline);
32
// Convert the result to an array and pretty print
33
$resultArray = $result->toArray();
34
echo "<pre>" . print_r($resultArray, true) . "</pre>";

1
Pinged your deployment. You successfully connected to MongoDB!
2
[
3
    {
4
        "_id": {
5
            "year": 1914,
6
            "month": 3
7
        },
8
        "averageRating": 7.6
9
    },
10
    {
11
        "_id": {
12
            "year": 1914,
13
            "month": 9
14
        },
15
        "averageRating": 7.3
16
    },
17
    {
18
        "_id": {
19
            "year": 1914,
20
            "month": 12
21
        },
22
        "averageRating": 5.8
23
    },
24
    {
25
        "_id": {
26
            "year": 1915,
27
            "month": 1
28
        },
29
        "averageRating": 6.4
30
    },
31
    {
32
        "_id": {
33
            "year": 1915,
34
            "month": 9
35
        },
36
        "averageRating": 6.8
37
    }
38
    ...
39
]

1
<?php
2
$moviesCollection = $client->sample_mflix->movies;
3
$pipeline = [
4
    [
5
        '$lookup' => [
6
            'from' => 'comments',
7
            'localField' => '_id',
8
            'foreignField' => 'movie_id',
9
            'as' => 'comments'
10
        ]
11
    ],
12
    [
13
        '$facet' => [
14
            'mostCommentedMovies' => [
15
                [
16
                    '$project' => [
17
                        '_id' => 0,
18
                        'title' => 1,
19
                        'comment_count' => ['$size' => '$comments']
20
                    ]
21
                ],
22
                [
23
                    '$sort' => ['comment_count' => -1]
24
                ],
25
                [
26
                    '$limit' => 5
27
                ]
28
            ],
29
            'mostCommentedGenre' => [
30
                [
31
                    '$unwind' => '$genres'
32
                ],
33
                [
34
                    '$group' => [
35
                        '_id' => '$genres',
36
                        'totalComments' => ['$sum' => ['$size' => '$comments']]
37
                    ]
38
                ],
39
                [
40
                    '$sort' => ['totalComments' => -1]
41
                ],
42
                [
43
                    '$limit' => 5
44
                ]
45
            ],
46
        ]
47
    ]
48
];
49
$result = $moviesCollection->aggregate($pipeline);
50
// Convert the result to an array and pretty print
51
$resultArray = $result->toArray();
52
echo "<pre>" . print_r($resultArray, true) . "</pre>";

1
Pinged your deployment. You successfully connected to MongoDB!
2
[{
3
    "mostCommentedMovies": [
4
        {
5
            "title": "The Taking of Pelham 1 2 3",
6
            "comment_count": 161
7
        },
8
        {
9
            "title": "Ocean's Eleven",
10
            "comment_count": 158
11
        },
12
        {
13
            "title": "About a Boy",
14
            "comment_count": 158
15
        },
16
        {
17
            "title": "Terminator Salvation",
18
            "comment_count": 158
19
        },
20
        {
21
            "title": "50 First Dates",
22
            "comment_count": 158
23
        }
24
    ],
25
    "mostCommentedGenre": [
26
        {
27
            "_id": "Comedy",
28
            "totalComments": 15435
29
        },
30
        {
31
            "_id": "Adventure",
32
            "totalComments": 12363
33
        },
34
        {
35
            "_id": "Drama",
36
            "totalComments": 12339
37
        },
38
        {
39
            "_id": "Action",
40
            "totalComments": 11419
41
        },
42
        {
43
            "_id": "Fantasy",
44
            "totalComments": 6955
45
        }
46
    ]
47
}]

1
<?php
2
$commentsCollection = $client->sample_mflix->comments;
3
$pipeline = [
4
    ['$lookup' => [
5
        'from' => 'movies',
6
        'localField' => 'movie_id',
7
        'foreignField' => '_id',
8
        'as' => 'movie'
9
    ]],
10
    ['$unwind' => '$movie'],
11
    ['$replaceRoot' => ['newRoot' => [
12
        'comment_id' => '$_id',
13
        'user' => '$name',
14
        'movie_id' => '$movie_id',
15
        'movie_title' => '$movie.title',
16
        'genres' => '$movie.genres',
17
        'rating' => '$movie.imdb.rating',
18
        'comment' => '$text'
19
    ]]],
20
    ['$unwind' => '$genres'],
21
    ['$group' => [
22
        '_id' => [
23
            'user' => '$user',
24
            'genre' => '$genres'
25
        ],
26
        'totalComments' => ['$sum' => 1],
27
        'averageRating' => ['$avg' => '$rating']
28
    ]],
29
    ['$group' => [
30
        '_id' => '$_id.user',
31
        'preferences' => [
32
            '$push' => [
33
                'genre' => '$_id.genre',
34
                'totalComments' => '$totalComments',
35
                'averageRating' => ['$round' => ['$avg' => '$averageRating', 2]]
36
            ]
37
        ],
38
        'totalComments' => ['$sum' => '$totalComments']
39
    ]],
40
    ['$sort' => ['totalComments' => -1]]
41
];
42
43
$result = $commentsCollection->aggregate($pipeline);
44
// Convert the result to an array and pretty print
45
$resultArray = $result->toArray();
46
echo "<pre>" . print_r($resultArray, true) . "</pre>";

1
<?php
2
$commentsCollection = $client->sample_mflix->comments;
3
$liveFeedCollection = $client->sample_mflix->live_feed;
4
$changeStream = $commentsCollection->watch();
5
6
function sendNotification($comment) {
7
    printf("Notification sent for new comment by %s on movie ID %s\n", $comment['name'], $comment['movie_id']);
8
}
9
10
function updateLiveFeed($comment, $liveFeedCollection) {
11
    $liveFeedDocument = [
12
        'user' => $comment['name'],
13
        'movie_id' => $comment['movie_id'],
14
        'comment' => $comment['text'],
15
        'timestamp' => new MongoDB\BSON\UTCDateTime()
16
    ];
17
    $liveFeedCollection->insertOne($liveFeedDocument);
18
    printf("Live feed updated with new comment by %s\n", $comment['name']);
19
}
20
21
for ($changeStream->rewind(); true; $changeStream->next()) {
22
    if (!$changeStream->valid()) {
23
        continue;
24
    }
25
26
    $event = $changeStream->current();
27
28
    if ($event['operationType'] === 'invalidate') {
29
        break;
30
    }
31
32
    if ($event['operationType'] === 'insert') {
33
        $newComment = $event['fullDocument'];
34
        sendNotification($newComment);
35
        updateLiveFeed($newComment, $liveFeedCollection);
36
    }
37
}