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
|
/**
* Basic tests for the $trim, $ltrim, and $rtrim expressions.
*/
(function() {
"use strict";
load("jstests/aggregation/extras/utils.js"); // For assertErrorCode, testExpression and
// testExpressionWithCollation.
const coll = db.trim_expressions;
testExpression(coll, {$trim: {input: " abc "}}, "abc");
testExpression(coll, {$trim: {input: " a b\nc "}}, "a b\nc");
testExpression(coll, {$ltrim: {input: "\t abc "}}, "abc ");
testExpression(coll, {$rtrim: {input: "\t abc "}}, "\t abc");
testExpression(
coll,
{$map: {input: {$split: ["4, 5, 6, 7,8,9, 10", ","]}, in : {$trim: {input: "$$this"}}}},
["4", "5", "6", "7", "8", "9", "10"]);
// Test that the trim expressions do not respect the collation.
const caseInsensitive = {
locale: "en_US",
strength: 2
};
testExpressionWithCollation(coll, {$trim: {input: "xXx", chars: "x"}}, "X", caseInsensitive);
testExpressionWithCollation(coll, {$rtrim: {input: "xXx", chars: "x"}}, "xX", caseInsensitive);
testExpressionWithCollation(coll, {$ltrim: {input: "xXx", chars: "x"}}, "Xx", caseInsensitive);
// Test using inputs from documents.
coll.drop();
assert.writeOK(coll.insert([
{_id: 0, name: ", Charlie"},
{_id: 1, name: "Obama\t, Barack"},
{_id: 2, name: " Ride, Sally "}
]));
assert.eq(
coll.aggregate([
{$sort: {_id: 1}},
{$project: {firstName: {$trim: {input: {$arrayElemAt: [{$split: ["$name", ","]}, 1]}}}}}
])
.toArray(),
[{_id: 0, firstName: "Charlie"}, {_id: 1, firstName: "Barack"}, {_id: 2, firstName: "Sally"}]);
coll.drop();
assert.writeOK(coll.insert([
{_id: 0, poorlyParsedWebTitle: "The title of my document"},
{_id: 1, poorlyParsedWebTitle: "\u2001\u2002 Odd unicode indentation"},
{_id: 2, poorlyParsedWebTitle: "\u2001\u2002 Odd unicode indentation\u200A"},
]));
assert.eq(
coll.aggregate(
[{$sort: {_id: 1}}, {$project: {title: {$ltrim: {input: "$poorlyParsedWebTitle"}}}}])
.toArray(),
[
{_id: 0, title: "The title of my document"},
{_id: 1, title: "Odd unicode indentation"},
{_id: 2, title: "Odd unicode indentation\u200A"}
]);
coll.drop();
assert.writeOK(coll.insert([
{_id: 0, proof: "Left as an exercise for the reader∎"},
{_id: 1, proof: "∎∃ proof∎"},
{_id: 2, proof: "Just view the problem as a continuous DAG whose elements are taylor series∎"},
{_id: 3, proof: null},
{_id: 4},
]));
assert.eq(
coll.aggregate(
[{$sort: {_id: 1}}, {$project: {proof: {$rtrim: {input: "$proof", chars: "∎"}}}}])
.toArray(),
[
{_id: 0, proof: "Left as an exercise for the reader"},
{_id: 1, proof: "∎∃ proof"},
{
_id: 2,
proof: "Just view the problem as a continuous DAG whose elements are taylor series"
},
{_id: 3, proof: null},
{_id: 4, proof: null},
]);
// Test that errors are reported correctly.
assertErrorCode(coll, [{$project: {x: {$trim: " x "}}}], 50696);
assertErrorCode(coll, [{$project: {x: {$trim: {input: 4}}}}], 50699);
assertErrorCode(coll, [{$project: {x: {$trim: {input: {$add: [4, 2]}}}}}], 50699);
assertErrorCode(coll, [{$project: {x: {$trim: {input: "$_id"}}}}], 50699);
assertErrorCode(coll, [{$project: {x: {$trim: {input: " x ", chars: "$_id"}}}}], 50700);
}());
|
