1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
|
/**
* Tests the behavior of views when the backing view or collection is changed.
* @tags: [
* assumes_superuser_permissions,
* requires_find_command,
* requires_non_retryable_commands,
* ]
*/
(function() {
"use strict";
// For arrayEq.
load("jstests/aggregation/extras/utils.js");
let viewDB = db.getSiblingDB("views_change");
let collection = viewDB.collection;
let view = viewDB.view;
let viewOnView = viewDB.viewOnView;
// Convenience functions.
let resetCollectionAndViews = function() {
viewDB.runCommand({drop: "collection"});
viewDB.runCommand({drop: "view"});
viewDB.runCommand({drop: "viewOnView"});
assert.commandWorked(viewDB.runCommand({create: "collection"}));
assert.commandWorked(
viewDB.runCommand({create: "view", viewOn: "collection", pipeline: [{$match: {a: 1}}]}));
assert.commandWorked(
viewDB.runCommand({create: "viewOnView", viewOn: "view", pipeline: [{$match: {b: 1}}]}));
};
let assertFindResultEq = function(collName, expected) {
let res = viewDB.runCommand({find: collName, filter: {}, projection: {_id: 0, a: 1, b: 1}});
assert.commandWorked(res);
let arr = new DBCommandCursor(db, res).toArray();
let errmsg = tojson({expected: expected, got: arr});
assert(arrayEq(arr, expected), errmsg);
};
let doc = {a: 1, b: 1};
resetCollectionAndViews();
// A view is updated when its viewOn is modified. When auth is enabled, we expect collMod to
// fail when specifying "viewOn" but not "pipeline".
assert.writeOK(collection.insert(doc));
assertFindResultEq("view", [doc]);
let res = viewDB.runCommand({collMod: "view", viewOn: "nonexistent"});
if (jsTest.options().auth) {
assert.commandFailedWithCode(res, ErrorCodes.InvalidOptions);
} else {
assert.commandWorked(res);
assertFindResultEq("view", []);
}
resetCollectionAndViews();
// A view is updated when its pipeline is modified. When auth is enabled, we expect collMod to
// fail when specifying "pipeline" but not "viewOn".
assert.writeOK(collection.insert(doc));
assert.writeOK(collection.insert({a: 7}));
assertFindResultEq("view", [doc]);
res = viewDB.runCommand({collMod: "view", pipeline: [{$match: {a: {$gt: 4}}}]});
if (jsTest.options().auth) {
assert.commandFailedWithCode(res, ErrorCodes.InvalidOptions);
} else {
assert.commandWorked(res);
assertFindResultEq("view", [{a: 7}]);
}
resetCollectionAndViews();
// A view is updated when the backing collection is updated.
assert.writeOK(collection.insert(doc));
assertFindResultEq("view", [doc]);
assert.writeOK(collection.update({a: 1}, {$set: {a: 2}}));
assertFindResultEq("view", []);
resetCollectionAndViews();
// A view is updated when a backing view is updated.
assert.writeOK(collection.insert(doc));
assertFindResultEq("viewOnView", [doc]);
assert.commandWorked(viewDB.runCommand(
{collMod: "view", viewOn: "collection", pipeline: [{$match: {nonexistent: 1}}]}));
assertFindResultEq("viewOnView", []);
resetCollectionAndViews();
// A view appears empty if the backing collection is dropped.
assert.writeOK(collection.insert(doc));
assertFindResultEq("view", [doc]);
assert.commandWorked(viewDB.runCommand({drop: "collection"}));
assertFindResultEq("view", []);
resetCollectionAndViews();
// A view appears empty if a backing view is dropped.
assert.writeOK(collection.insert(doc));
assertFindResultEq("viewOnView", [doc]);
assert.commandWorked(viewDB.runCommand({drop: "view"}));
assertFindResultEq("viewOnView", []);
}());
|
