diff options
Diffstat (limited to 'jstests/aggregation/expressions/date_from_string.js')
| -rw-r--r-- | jstests/aggregation/expressions/date_from_string.js | 1490 |
1 files changed, 734 insertions, 756 deletions
diff --git a/jstests/aggregation/expressions/date_from_string.js b/jstests/aggregation/expressions/date_from_string.js index 3e905d9fbfe..56c52de0f7e 100644 --- a/jstests/aggregation/expressions/date_from_string.js +++ b/jstests/aggregation/expressions/date_from_string.js @@ -1,796 +1,774 @@ load("jstests/aggregation/extras/utils.js"); // For assertErrorCode and assertErrMsgContains. (function() { - "use strict"; - - const coll = db.date_from_string; - - /* --------------------------------------------------------------------------------------- */ - /* Normal format tests. */ - - coll.drop(); - assert.writeOK(coll.insert({_id: 0})); - - let testCases = [ - { - expect: "2017-07-04T11:56:02Z", - inputString: "2017-07-04T11:56:02Z", - format: "%Y-%m-%dT%H:%M:%SZ" - }, - { - expect: "2017-07-04T11:56:02.813Z", - inputString: "2017-07-04T11:56:02.813Z", - format: "%Y-%m-%dT%H:%M:%S.%LZ" - }, - { - expect: "2017-07-04T11:56:02.810Z", - inputString: "2017-07-04T11:56:02.81Z", - format: "%Y-%m-%dT%H:%M:%S.%LZ" - }, - { - expect: "2017-07-04T11:56:02.800Z", - inputString: "2017-07-04T11:56:02.8Z", - format: "%Y-%m-%dT%H:%M:%S.%LZ" - }, - { - expect: "2017-07-04T11:56:02Z", - inputString: "2017-07-04T11:56.02", - format: "%Y-%m-%dT%H:%M.%S" - }, - { - expect: "2017-07-04T11:56:02.813Z", - inputString: "2017-07-04T11:56.02.813", - format: "%Y-%m-%dT%H:%M.%S.%L" - }, - { - expect: "2017-07-04T11:56:02.810Z", - inputString: "2017-07-04T11:56.02.81", - format: "%Y-%m-%dT%H:%M.%S.%L" - }, - { - expect: "2017-07-04T11:56:02.800Z", - inputString: "2017-07-04T11:56.02.8", - format: "%Y-%m-%dT%H:%M.%S.%L" - }, - ]; - testCases.forEach(function(testCase) { - assert.eq([{_id: 0, date: ISODate(testCase.expect)}], - coll.aggregate( - {$project: {date: {$dateFromString: {dateString: testCase.inputString}}}}) - .toArray(), - tojson(testCase)); - assert.eq( - [{_id: 0, date: ISODate(testCase.expect)}], - coll.aggregate({ - $project: { - date: { - $dateFromString: - {dateString: testCase.inputString, format: testCase.format} - } - } - }) - .toArray(), - tojson(testCase)); - }); - - /* --------------------------------------------------------------------------------------- */ - /* Normal format tests with timezone. */ - - coll.drop(); - assert.writeOK(coll.insert({_id: 0})); - - testCases = [ - { - expect: "2017-07-04T10:56:02Z", - inputString: "2017-07-04T11:56.02", - format: "%Y-%m-%dT%H:%M.%S" - }, - { - expect: "2017-07-04T10:56:02.813Z", - inputString: "2017-07-04T11:56.02.813", - format: "%Y-%m-%dT%H:%M.%S.%L" - }, - { - expect: "2017-07-04T10:56:02.810Z", - inputString: "2017-07-04T11:56.02.81", - format: "%Y-%m-%dT%H:%M.%S.%L" - }, - { - expect: "2017-07-04T10:56:02.800Z", - inputString: "2017-07-04T11:56.02.8", - format: "%Y-%m-%dT%H:%M.%S.%L" - }, - ]; - testCases.forEach(function(testCase) { - assert.eq( - [{_id: 0, date: ISODate(testCase.expect)}], - coll.aggregate({ - $project: { - date: { - $dateFromString: - {dateString: testCase.inputString, timezone: "Europe/London"} - } +"use strict"; + +const coll = db.date_from_string; + +/* --------------------------------------------------------------------------------------- */ +/* Normal format tests. */ + +coll.drop(); +assert.writeOK(coll.insert({_id: 0})); + +let testCases = [ + { + expect: "2017-07-04T11:56:02Z", + inputString: "2017-07-04T11:56:02Z", + format: "%Y-%m-%dT%H:%M:%SZ" + }, + { + expect: "2017-07-04T11:56:02.813Z", + inputString: "2017-07-04T11:56:02.813Z", + format: "%Y-%m-%dT%H:%M:%S.%LZ" + }, + { + expect: "2017-07-04T11:56:02.810Z", + inputString: "2017-07-04T11:56:02.81Z", + format: "%Y-%m-%dT%H:%M:%S.%LZ" + }, + { + expect: "2017-07-04T11:56:02.800Z", + inputString: "2017-07-04T11:56:02.8Z", + format: "%Y-%m-%dT%H:%M:%S.%LZ" + }, + { + expect: "2017-07-04T11:56:02Z", + inputString: "2017-07-04T11:56.02", + format: "%Y-%m-%dT%H:%M.%S" + }, + { + expect: "2017-07-04T11:56:02.813Z", + inputString: "2017-07-04T11:56.02.813", + format: "%Y-%m-%dT%H:%M.%S.%L" + }, + { + expect: "2017-07-04T11:56:02.810Z", + inputString: "2017-07-04T11:56.02.81", + format: "%Y-%m-%dT%H:%M.%S.%L" + }, + { + expect: "2017-07-04T11:56:02.800Z", + inputString: "2017-07-04T11:56.02.8", + format: "%Y-%m-%dT%H:%M.%S.%L" + }, +]; +testCases.forEach(function(testCase) { + assert.eq( + [{_id: 0, date: ISODate(testCase.expect)}], + coll.aggregate({$project: {date: {$dateFromString: {dateString: testCase.inputString}}}}) + .toArray(), + tojson(testCase)); + assert.eq( + [{_id: 0, date: ISODate(testCase.expect)}], + coll.aggregate({ + $project: { + date: { + $dateFromString: {dateString: testCase.inputString, format: testCase.format} } - }) - .toArray(), - tojson(testCase)); - assert.eq([{_id: 0, date: ISODate(testCase.expect)}], - coll.aggregate({ - $project: { - date: { - $dateFromString: { - dateString: testCase.inputString, - timezone: "Europe/London", - format: testCase.format - } - } + } + }) + .toArray(), + tojson(testCase)); +}); + +/* --------------------------------------------------------------------------------------- */ +/* Normal format tests with timezone. */ + +coll.drop(); +assert.writeOK(coll.insert({_id: 0})); + +testCases = [ + { + expect: "2017-07-04T10:56:02Z", + inputString: "2017-07-04T11:56.02", + format: "%Y-%m-%dT%H:%M.%S" + }, + { + expect: "2017-07-04T10:56:02.813Z", + inputString: "2017-07-04T11:56.02.813", + format: "%Y-%m-%dT%H:%M.%S.%L" + }, + { + expect: "2017-07-04T10:56:02.810Z", + inputString: "2017-07-04T11:56.02.81", + format: "%Y-%m-%dT%H:%M.%S.%L" + }, + { + expect: "2017-07-04T10:56:02.800Z", + inputString: "2017-07-04T11:56.02.8", + format: "%Y-%m-%dT%H:%M.%S.%L" + }, +]; +testCases.forEach(function(testCase) { + assert.eq([{_id: 0, date: ISODate(testCase.expect)}], + coll.aggregate({ + $project: { + date: { + $dateFromString: + {dateString: testCase.inputString, timezone: "Europe/London"} } - }) - .toArray(), - tojson(testCase)); - }); - - /* --------------------------------------------------------------------------------------- */ - /* Normal format tests with UTC offset. */ - - coll.drop(); - assert.writeOK(coll.insert({_id: 0})); - - testCases = [ - { - expect: "2017-07-04T10:56:02Z", - inputString: "2017-07-04T11:56.02", - format: "%Y-%m-%dT%H:%M.%S" - }, - { - expect: "2017-07-04T10:56:02.813Z", - inputString: "2017-07-04T11:56.02.813", - format: "%Y-%m-%dT%H:%M.%S.%L" - }, - { - expect: "2017-07-04T10:56:02.810Z", - inputString: "2017-07-04T11:56.02.81", - format: "%Y-%m-%dT%H:%M.%S.%L" - }, - { - expect: "2017-07-04T10:56:02.800Z", - inputString: "2017-07-04T11:56.02.8", - format: "%Y-%m-%dT%H:%M.%S.%L" - }, - ]; - testCases.forEach(function(testCase) { - assert.eq([{_id: 0, date: ISODate(testCase.expect)}], - coll.aggregate({ - $project: { - date: { - $dateFromString: - {dateString: testCase.inputString, timezone: "+01:00"} + } + }) + .toArray(), + tojson(testCase)); + assert.eq([{_id: 0, date: ISODate(testCase.expect)}], + coll.aggregate({ + $project: { + date: { + $dateFromString: { + dateString: testCase.inputString, + timezone: "Europe/London", + format: testCase.format } } - }) - .toArray(), - tojson(testCase)); - assert.eq([{_id: 0, date: ISODate(testCase.expect)}], - coll.aggregate({ - $project: { - date: { - $dateFromString: { - dateString: testCase.inputString, - timezone: "+01:00", - format: testCase.format - } + } + }) + .toArray(), + tojson(testCase)); +}); + +/* --------------------------------------------------------------------------------------- */ +/* Normal format tests with UTC offset. */ + +coll.drop(); +assert.writeOK(coll.insert({_id: 0})); + +testCases = [ + { + expect: "2017-07-04T10:56:02Z", + inputString: "2017-07-04T11:56.02", + format: "%Y-%m-%dT%H:%M.%S" + }, + { + expect: "2017-07-04T10:56:02.813Z", + inputString: "2017-07-04T11:56.02.813", + format: "%Y-%m-%dT%H:%M.%S.%L" + }, + { + expect: "2017-07-04T10:56:02.810Z", + inputString: "2017-07-04T11:56.02.81", + format: "%Y-%m-%dT%H:%M.%S.%L" + }, + { + expect: "2017-07-04T10:56:02.800Z", + inputString: "2017-07-04T11:56.02.8", + format: "%Y-%m-%dT%H:%M.%S.%L" + }, +]; +testCases.forEach(function(testCase) { + assert.eq( + [{_id: 0, date: ISODate(testCase.expect)}], + coll.aggregate({ + $project: { + date: {$dateFromString: {dateString: testCase.inputString, timezone: "+01:00"}} + } + }) + .toArray(), + tojson(testCase)); + assert.eq([{_id: 0, date: ISODate(testCase.expect)}], + coll.aggregate({ + $project: { + date: { + $dateFromString: { + dateString: testCase.inputString, + timezone: "+01:00", + format: testCase.format } } - }) - .toArray(), - tojson(testCase)); - }); - - /* --------------------------------------------------------------------------------------- */ - /* Normal format tests from data. */ - - coll.drop(); - assert.writeOK(coll.insert([ - {_id: 0, dateString: "2017-07-06T12:35:37Z", format: "%Y-%m-%dT%H:%M:%SZ"}, - {_id: 1, dateString: "2017-07-06T12:35:37.513Z", format: "%Y-%m-%dT%H:%M:%S.%LZ"}, - {_id: 2, dateString: "2017-07-06T12:35:37", format: "%Y-%m-%dT%H:%M:%S"}, - {_id: 3, dateString: "2017-07-06T12:35:37.513", format: "%Y-%m-%dT%H:%M:%S.%L"}, - {_id: 4, dateString: "1960-07-10T12:10:37.448", format: "%Y-%m-%dT%H:%M:%S.%L"}, - ])); - - let expectedResults = [ - {"_id": 0, "date": ISODate("2017-07-06T12:35:37Z")}, - {"_id": 1, "date": ISODate("2017-07-06T12:35:37.513Z")}, - {"_id": 2, "date": ISODate("2017-07-06T12:35:37Z")}, - {"_id": 3, "date": ISODate("2017-07-06T12:35:37.513Z")}, - {"_id": 4, "date": ISODate("1960-07-10T12:10:37.448Z")}, - ]; - assert.eq(expectedResults, - coll.aggregate([ - { - $project: {date: {$dateFromString: {dateString: "$dateString"}}}, - }, - {$sort: {_id: 1}} - ]) - .toArray()); - - // Repeat the test with an explicit format specifier string. - assert.eq( - expectedResults, - coll.aggregate([ - { - $project: - {date: {$dateFromString: {dateString: "$dateString", format: "$format"}}}, - }, - {$sort: {_id: 1}} - ]) - .toArray()); - - expectedResults = [ - {"_id": 0, "date": new Date(1499344537000)}, - {"_id": 1, "date": new Date(1499344537513)}, - {"_id": 2, "date": new Date(1499344537000)}, - {"_id": 3, "date": new Date(1499344537513)}, - {"_id": 4, "date": new Date(-299072962552)}, - ]; - assert.eq(expectedResults, - coll.aggregate([ - { - $project: {date: {$dateFromString: {dateString: "$dateString"}}}, - }, - {$sort: {_id: 1}} - ]) - .toArray()); - - // Repeat the test with an explicit format specifier string. - assert.eq( - expectedResults, - coll.aggregate([ - { - $project: - {date: {$dateFromString: {dateString: "$dateString", format: "$format"}}}, - }, - {$sort: {_id: 1}} - ]) - .toArray()); - - /* --------------------------------------------------------------------------------------- */ - /* Normal format tests from data, with time zone. */ - - coll.drop(); - assert.writeOK(coll.insert([ - {_id: 0, dateString: "2017-07-06T12:35:37.513", timezone: "GMT"}, - {_id: 1, dateString: "2017-07-06T12:35:37.513", timezone: "UTC"}, - {_id: 2, dateString: "1960-07-10T12:35:37.513", timezone: "America/New_York"}, - {_id: 3, dateString: "1960-07-10T12:35:37.513", timezone: "Europe/London"}, - {_id: 4, dateString: "2017-07-06T12:35:37.513", timezone: "America/Los_Angeles"}, - {_id: 5, dateString: "2017-07-06T12:35:37.513", timezone: "Europe/Paris"}, - {_id: 6, dateString: "2017-07-06T12:35:37.513", timezone: "+04:00"}, - ])); - - expectedResults = [ - {"_id": 0, "date": ISODate("2017-07-06T12:35:37.513Z")}, - {"_id": 1, "date": ISODate("2017-07-06T12:35:37.513Z")}, - {"_id": 2, "date": ISODate("1960-07-10T16:35:37.513Z")}, - {"_id": 3, "date": ISODate("1960-07-10T11:35:37.513Z")}, - {"_id": 4, "date": ISODate("2017-07-06T19:35:37.513Z")}, - {"_id": 5, "date": ISODate("2017-07-06T10:35:37.513Z")}, - {"_id": 6, "date": ISODate("2017-07-06T08:35:37.513Z")}, - ]; - - assert.eq( - expectedResults, - coll.aggregate([ - { - $project: - {date: {$dateFromString: {dateString: "$dateString", timezone: "$timezone"}}}, - }, - {$sort: {_id: 1}} - ]) - .toArray()); - - // Repeat the test with an explicit format specifier string. - assert.eq(expectedResults, - coll.aggregate([ - { - $project: { - date: { - $dateFromString: { - dateString: "$dateString", - timezone: "$timezone", - format: "%Y-%m-%dT%H:%M:%S.%L" - } - } - }, - }, - {$sort: {_id: 1}} - ]) - .toArray()); - - /* --------------------------------------------------------------------------------------- */ - /* dateString from data with timezone as constant */ - - coll.drop(); - assert.writeOK(coll.insert([ - {_id: 0, dateString: "2017-07-06T12:35:37"}, - ])); - - assert.eq( - [ - {"_id": 0, "date": ISODate("2017-07-06T03:35:37Z")}, - ], - coll.aggregate([ - { - $project: { - date: {$dateFromString: {dateString: "$dateString", timezone: "Asia/Tokyo"}} - }, - }, - {$sort: {_id: 1}} - ]) - .toArray()); - - /* --------------------------------------------------------------------------------------- */ - /* dateString from constant with timezone from data */ - - coll.drop(); - assert.writeOK(coll.insert([ - {_id: 0, timezone: "Europe/London"}, - {_id: 1, timezone: "America/New_York"}, - {_id: 2, timezone: "-05:00"}, - ])); - - assert.eq( - [ - {"_id": 0, "date": ISODate("2017-07-19T17:52:35.199Z")}, - {"_id": 1, "date": ISODate("2017-07-19T22:52:35.199Z")}, - {"_id": 2, "date": ISODate("2017-07-19T23:52:35.199Z")}, - ], - coll.aggregate([ - { - $project: { - date: { - $dateFromString: - {dateString: "2017-07-19T18:52:35.199", timezone: "$timezone"} } + }) + .toArray(), + tojson(testCase)); +}); + +/* --------------------------------------------------------------------------------------- */ +/* Normal format tests from data. */ + +coll.drop(); +assert.writeOK(coll.insert([ + {_id: 0, dateString: "2017-07-06T12:35:37Z", format: "%Y-%m-%dT%H:%M:%SZ"}, + {_id: 1, dateString: "2017-07-06T12:35:37.513Z", format: "%Y-%m-%dT%H:%M:%S.%LZ"}, + {_id: 2, dateString: "2017-07-06T12:35:37", format: "%Y-%m-%dT%H:%M:%S"}, + {_id: 3, dateString: "2017-07-06T12:35:37.513", format: "%Y-%m-%dT%H:%M:%S.%L"}, + {_id: 4, dateString: "1960-07-10T12:10:37.448", format: "%Y-%m-%dT%H:%M:%S.%L"}, +])); + +let expectedResults = [ + {"_id": 0, "date": ISODate("2017-07-06T12:35:37Z")}, + {"_id": 1, "date": ISODate("2017-07-06T12:35:37.513Z")}, + {"_id": 2, "date": ISODate("2017-07-06T12:35:37Z")}, + {"_id": 3, "date": ISODate("2017-07-06T12:35:37.513Z")}, + {"_id": 4, "date": ISODate("1960-07-10T12:10:37.448Z")}, +]; +assert.eq(expectedResults, + coll.aggregate([ + { + $project: {date: {$dateFromString: {dateString: "$dateString"}}}, }, - }, - {$sort: {_id: 1}} - ]) - .toArray()); - - /* --------------------------------------------------------------------------------------- */ - /* BI format tests. */ - - coll.drop(); - assert.writeOK(coll.insert({_id: 0})); - - let pipelines = [ - { - expect: "2017-01-01T00:00:00Z", - pipeline: {$project: {date: {$dateFromString: {dateString: "2017-01-01 00:00:00"}}}} - }, - { - expect: "2017-07-01T00:00:00Z", - pipeline: {$project: {date: {$dateFromString: {dateString: "2017-07-01 00:00:00"}}}} - }, - { - expect: "2017-07-06T00:00:00Z", - pipeline: {$project: {date: {$dateFromString: {dateString: "2017-07-06"}}}} - }, - { - expect: "2017-07-06T00:00:00Z", - pipeline: {$project: {date: {$dateFromString: {dateString: "2017-07-06 00:00:00"}}}} - }, - { - expect: "2017-07-06T11:00:00Z", - pipeline: {$project: {date: {$dateFromString: {dateString: "2017-07-06 11:00:00"}}}} - }, - { - expect: "2017-07-06T11:36:00Z", - pipeline: {$project: {date: {$dateFromString: {dateString: "2017-07-06 11:36:00"}}}} - }, - { - expect: "2017-07-06T11:36:54Z", - pipeline: {$project: {date: {$dateFromString: {dateString: "2017-07-06 11:36:54"}}}} - }, - ]; - pipelines.forEach(function(pipeline) { - assert.eq([{_id: 0, date: ISODate(pipeline.expect)}], - coll.aggregate(pipeline.pipeline).toArray(), - tojson(pipeline)); - }); - - /* --------------------------------------------------------------------------------------- */ - /* Tests with additional timezone information . */ - - coll.drop(); - assert.writeOK(coll.insert({_id: 0})); - - testCases = [ - // GMT based variants - {expect: "2017-07-14T12:02:44.771Z", inputString: "2017-07-14T12:02:44.771 GMT"}, - {expect: "2017-07-14T12:02:44.771Z", inputString: "2017-07-14T12:02:44.771 GMT+00"}, - {expect: "2017-07-14T12:02:44.771Z", inputString: "2017-07-14T12:02:44.771 GMT+00:00"}, - {expect: "2017-07-14T10:02:44.771Z", inputString: "2017-07-14T12:02:44.771 GMT+02"}, - {expect: "2017-07-14T10:02:44.771Z", inputString: "2017-07-14T12:02:44.771 GMT+02:00"}, - {expect: "2017-07-14T09:02:44.771Z", inputString: "2017-07-14T12:02:44.771+03"}, - {expect: "2017-07-14T08:32:44.771Z", inputString: "2017-07-14T12:02:44.771+0330"}, - {expect: "2017-07-14T08:32:44.771Z", inputString: "2017-07-14T12:02:44.771+03:30"}, - // With timezone abbreviations - {expect: "2017-07-14T12:02:44.771Z", inputString: "2017-07-14T12:02:44.771 UTC"}, - {expect: "2017-07-14T10:02:44.771Z", inputString: "2017-07-14T12:02:44.771 CEST"}, - {expect: "2017-07-14T17:02:44.771Z", inputString: "2017-07-14T12:02:44.771 EST"}, - {expect: "2017-07-14T19:02:44.771Z", inputString: "2017-07-14T12:02:44.771 PDT"}, - // A-I,K-Z are military time zones: - // https://en.wikipedia.org/wiki/List_of_military_time_zones - {expect: "2017-07-14T11:02:44.771Z", inputString: "2017-07-14T12:02:44.771 A"}, - {expect: "2017-07-14T01:02:44.771Z", inputString: "2017-07-14T12:02:44.771 L"}, - {expect: "2017-07-14T15:02:44.771Z", inputString: "2017-07-14T12:02:44.771 P"}, - {expect: "2017-07-14T12:02:44.771Z", inputString: "2017-07-14T12:02:44.771 Z"}, - ]; - testCases.forEach(function(testCase) { - assert.eq([{_id: 0, date: ISODate(testCase.expect)}], - coll.aggregate( - {$project: {date: {$dateFromString: {dateString: testCase.inputString}}}}) - .toArray(), - tojson(testCase)); - assert.eq([{_id: 0, date: ISODate(testCase.expect)}], - coll.aggregate({ - $project: { - date: { - $dateFromString: { - dateString: testCase.inputString, - format: "%Y-%m-%dT%H:%M:%S.%L%z" - } + {$sort: {_id: 1}} + ]) + .toArray()); + +// Repeat the test with an explicit format specifier string. +assert.eq( + expectedResults, + coll.aggregate([ + { + $project: {date: {$dateFromString: {dateString: "$dateString", format: "$format"}}}, + }, + {$sort: {_id: 1}} + ]) + .toArray()); + +expectedResults = [ + {"_id": 0, "date": new Date(1499344537000)}, + {"_id": 1, "date": new Date(1499344537513)}, + {"_id": 2, "date": new Date(1499344537000)}, + {"_id": 3, "date": new Date(1499344537513)}, + {"_id": 4, "date": new Date(-299072962552)}, +]; +assert.eq(expectedResults, + coll.aggregate([ + { + $project: {date: {$dateFromString: {dateString: "$dateString"}}}, + }, + {$sort: {_id: 1}} + ]) + .toArray()); + +// Repeat the test with an explicit format specifier string. +assert.eq( + expectedResults, + coll.aggregate([ + { + $project: {date: {$dateFromString: {dateString: "$dateString", format: "$format"}}}, + }, + {$sort: {_id: 1}} + ]) + .toArray()); + +/* --------------------------------------------------------------------------------------- */ +/* Normal format tests from data, with time zone. */ + +coll.drop(); +assert.writeOK(coll.insert([ + {_id: 0, dateString: "2017-07-06T12:35:37.513", timezone: "GMT"}, + {_id: 1, dateString: "2017-07-06T12:35:37.513", timezone: "UTC"}, + {_id: 2, dateString: "1960-07-10T12:35:37.513", timezone: "America/New_York"}, + {_id: 3, dateString: "1960-07-10T12:35:37.513", timezone: "Europe/London"}, + {_id: 4, dateString: "2017-07-06T12:35:37.513", timezone: "America/Los_Angeles"}, + {_id: 5, dateString: "2017-07-06T12:35:37.513", timezone: "Europe/Paris"}, + {_id: 6, dateString: "2017-07-06T12:35:37.513", timezone: "+04:00"}, +])); + +expectedResults = [ + {"_id": 0, "date": ISODate("2017-07-06T12:35:37.513Z")}, + {"_id": 1, "date": ISODate("2017-07-06T12:35:37.513Z")}, + {"_id": 2, "date": ISODate("1960-07-10T16:35:37.513Z")}, + {"_id": 3, "date": ISODate("1960-07-10T11:35:37.513Z")}, + {"_id": 4, "date": ISODate("2017-07-06T19:35:37.513Z")}, + {"_id": 5, "date": ISODate("2017-07-06T10:35:37.513Z")}, + {"_id": 6, "date": ISODate("2017-07-06T08:35:37.513Z")}, +]; + +assert.eq( + expectedResults, + coll.aggregate([ + { + $project: + {date: {$dateFromString: {dateString: "$dateString", timezone: "$timezone"}}}, + }, + {$sort: {_id: 1}} + ]) + .toArray()); + +// Repeat the test with an explicit format specifier string. +assert.eq(expectedResults, + coll.aggregate([ + { + $project: { + date: { + $dateFromString: { + dateString: "$dateString", + timezone: "$timezone", + format: "%Y-%m-%dT%H:%M:%S.%L" } } - }) - .toArray(), - tojson(testCase)); - }); - - /* --------------------------------------------------------------------------------------- */ - /* BI format tests from data. */ - - coll.drop(); - assert.writeOK(coll.insert([ - {_id: 0, dateString: "2017-01-01 00:00:00"}, - {_id: 1, dateString: "2017-07-01 00:00:00"}, - {_id: 2, dateString: "2017-07-06"}, - {_id: 3, dateString: "2017-07-06 00:00:00"}, - {_id: 4, dateString: "2017-07-06 11:00:00"}, - {_id: 5, dateString: "2017-07-06 11:36:00"}, - {_id: 6, dateString: "2017-07-06 11:36:54"}, - ])); - - assert.eq( - [ - {"_id": 0, "date": ISODate("2017-01-01T00:00:00Z")}, - {"_id": 1, "date": ISODate("2017-07-01T00:00:00Z")}, - {"_id": 2, "date": ISODate("2017-07-06T00:00:00Z")}, - {"_id": 3, "date": ISODate("2017-07-06T00:00:00Z")}, - {"_id": 4, "date": ISODate("2017-07-06T11:00:00Z")}, - {"_id": 5, "date": ISODate("2017-07-06T11:36:00Z")}, - {"_id": 6, "date": ISODate("2017-07-06T11:36:54Z")} - ], - coll.aggregate([ - { - $project: {date: {$dateFromString: {dateString: "$dateString"}}}, + }, + }, + {$sort: {_id: 1}} + ]) + .toArray()); + +/* --------------------------------------------------------------------------------------- */ +/* dateString from data with timezone as constant */ + +coll.drop(); +assert.writeOK(coll.insert([ + {_id: 0, dateString: "2017-07-06T12:35:37"}, +])); + +assert.eq( + [ + {"_id": 0, "date": ISODate("2017-07-06T03:35:37Z")}, + ], + coll.aggregate([ + { + $project: + {date: {$dateFromString: {dateString: "$dateString", timezone: "Asia/Tokyo"}}}, + }, + {$sort: {_id: 1}} + ]) + .toArray()); + +/* --------------------------------------------------------------------------------------- */ +/* dateString from constant with timezone from data */ + +coll.drop(); +assert.writeOK(coll.insert([ + {_id: 0, timezone: "Europe/London"}, + {_id: 1, timezone: "America/New_York"}, + {_id: 2, timezone: "-05:00"}, +])); + +assert.eq( + [ + {"_id": 0, "date": ISODate("2017-07-19T17:52:35.199Z")}, + {"_id": 1, "date": ISODate("2017-07-19T22:52:35.199Z")}, + {"_id": 2, "date": ISODate("2017-07-19T23:52:35.199Z")}, + ], + coll.aggregate([ + { + $project: { + date: { + $dateFromString: + {dateString: "2017-07-19T18:52:35.199", timezone: "$timezone"} + } }, - {$sort: {_id: 1}} - ]) - .toArray()); - - /* --------------------------------------------------------------------------------------- */ - /* Wacky format tests from data. */ - - coll.drop(); - assert.writeOK(coll.insert([ - {_id: 0, dateString: "July 4th, 2017"}, - {_id: 1, dateString: "July 4th, 2017 12:39:30 BST"}, - {_id: 2, dateString: "July 4th, 2017 11am"}, - {_id: 3, dateString: "July 4th, 2017 12pm"}, - {_id: 4, dateString: "7/4/17"}, - {_id: 5, dateString: "04-07-2017"}, - {_id: 6, dateString: "2017-Jul-04 noon"}, - {_id: 7, dateString: "2017-07-04 12:48:07 GMT+0545"}, - {_id: 8, dateString: "2017-07-04 12:48:07 GMT-0200"}, - ])); - + }, + {$sort: {_id: 1}} + ]) + .toArray()); + +/* --------------------------------------------------------------------------------------- */ +/* BI format tests. */ + +coll.drop(); +assert.writeOK(coll.insert({_id: 0})); + +let pipelines = [ + { + expect: "2017-01-01T00:00:00Z", + pipeline: {$project: {date: {$dateFromString: {dateString: "2017-01-01 00:00:00"}}}} + }, + { + expect: "2017-07-01T00:00:00Z", + pipeline: {$project: {date: {$dateFromString: {dateString: "2017-07-01 00:00:00"}}}} + }, + { + expect: "2017-07-06T00:00:00Z", + pipeline: {$project: {date: {$dateFromString: {dateString: "2017-07-06"}}}} + }, + { + expect: "2017-07-06T00:00:00Z", + pipeline: {$project: {date: {$dateFromString: {dateString: "2017-07-06 00:00:00"}}}} + }, + { + expect: "2017-07-06T11:00:00Z", + pipeline: {$project: {date: {$dateFromString: {dateString: "2017-07-06 11:00:00"}}}} + }, + { + expect: "2017-07-06T11:36:00Z", + pipeline: {$project: {date: {$dateFromString: {dateString: "2017-07-06 11:36:00"}}}} + }, + { + expect: "2017-07-06T11:36:54Z", + pipeline: {$project: {date: {$dateFromString: {dateString: "2017-07-06 11:36:54"}}}} + }, +]; +pipelines.forEach(function(pipeline) { + assert.eq([{_id: 0, date: ISODate(pipeline.expect)}], + coll.aggregate(pipeline.pipeline).toArray(), + tojson(pipeline)); +}); + +/* --------------------------------------------------------------------------------------- */ +/* Tests with additional timezone information . */ + +coll.drop(); +assert.writeOK(coll.insert({_id: 0})); + +testCases = [ + // GMT based variants + {expect: "2017-07-14T12:02:44.771Z", inputString: "2017-07-14T12:02:44.771 GMT"}, + {expect: "2017-07-14T12:02:44.771Z", inputString: "2017-07-14T12:02:44.771 GMT+00"}, + {expect: "2017-07-14T12:02:44.771Z", inputString: "2017-07-14T12:02:44.771 GMT+00:00"}, + {expect: "2017-07-14T10:02:44.771Z", inputString: "2017-07-14T12:02:44.771 GMT+02"}, + {expect: "2017-07-14T10:02:44.771Z", inputString: "2017-07-14T12:02:44.771 GMT+02:00"}, + {expect: "2017-07-14T09:02:44.771Z", inputString: "2017-07-14T12:02:44.771+03"}, + {expect: "2017-07-14T08:32:44.771Z", inputString: "2017-07-14T12:02:44.771+0330"}, + {expect: "2017-07-14T08:32:44.771Z", inputString: "2017-07-14T12:02:44.771+03:30"}, + // With timezone abbreviations + {expect: "2017-07-14T12:02:44.771Z", inputString: "2017-07-14T12:02:44.771 UTC"}, + {expect: "2017-07-14T10:02:44.771Z", inputString: "2017-07-14T12:02:44.771 CEST"}, + {expect: "2017-07-14T17:02:44.771Z", inputString: "2017-07-14T12:02:44.771 EST"}, + {expect: "2017-07-14T19:02:44.771Z", inputString: "2017-07-14T12:02:44.771 PDT"}, + // A-I,K-Z are military time zones: + // https://en.wikipedia.org/wiki/List_of_military_time_zones + {expect: "2017-07-14T11:02:44.771Z", inputString: "2017-07-14T12:02:44.771 A"}, + {expect: "2017-07-14T01:02:44.771Z", inputString: "2017-07-14T12:02:44.771 L"}, + {expect: "2017-07-14T15:02:44.771Z", inputString: "2017-07-14T12:02:44.771 P"}, + {expect: "2017-07-14T12:02:44.771Z", inputString: "2017-07-14T12:02:44.771 Z"}, +]; +testCases.forEach(function(testCase) { assert.eq( - [ - {"_id": 0, "date": ISODate("2017-07-04T00:00:00Z")}, - {"_id": 1, "date": ISODate("2017-07-04T11:39:30Z")}, - {"_id": 2, "date": ISODate("2017-07-04T11:00:00Z")}, - {"_id": 3, "date": ISODate("2017-07-04T12:00:00Z")}, - {"_id": 4, "date": ISODate("2017-07-04T00:00:00Z")}, - {"_id": 5, "date": ISODate("2017-07-04T00:00:00Z")}, - {"_id": 6, "date": ISODate("2017-07-04T12:00:00Z")}, - {"_id": 7, "date": ISODate("2017-07-04T07:03:07Z")}, - {"_id": 8, "date": ISODate("2017-07-04T14:48:07Z")}, - ], - coll.aggregate([ - { - $project: {date: {$dateFromString: {dateString: "$dateString"}}}, - }, - {$sort: {_id: 1}} - ]) - .toArray()); - - /* --------------------------------------------------------------------------------------- */ - /* Tests formats that aren't supported with the normal $dateFromString parser. */ - - coll.drop(); - assert.writeOK(coll.insert({_id: 0})); - - testCases = [ - {inputString: "05 12 1988", format: "%d %m %Y", expect: "1988-12-05T00:00:00Z"}, - {inputString: "1992 04 26", format: "%Y %m %d", expect: "1992-04-26T00:00:00Z"}, - {inputString: "05*12*1988", format: "%d*%m*%Y", expect: "1988-12-05T00:00:00Z"}, - {inputString: "1992/04/26", format: "%Y/%m/%d", expect: "1992-04-26T00:00:00Z"}, - {inputString: "1992 % 04 % 26", format: "%Y %% %m %% %d", expect: "1992-04-26T00:00:00Z"}, - { - inputString: "Day: 05 Month: 12 Year: 1988", - format: "Day: %d Month: %m Year: %Y", - expect: "1988-12-05T00:00:00Z" - }, - {inputString: "Date: 1992/04/26", format: "Date: %Y/%m/%d", expect: "1992-04-26T00:00:00Z"}, - {inputString: "4/26/1992:+0445", format: "%m/%d/%Y:%z", expect: "1992-04-25T19:15:00Z"}, - {inputString: "4/26/1992:+285", format: "%m/%d/%Y:%Z", expect: "1992-04-25T19:15:00Z"}, - ]; - testCases.forEach(function(testCase) { - assert.eq( - [{_id: 0, date: ISODate(testCase.expect)}], - coll.aggregate({ - $project: { - date: { - $dateFromString: - {dateString: testCase.inputString, format: testCase.format} - } + [{_id: 0, date: ISODate(testCase.expect)}], + coll.aggregate({$project: {date: {$dateFromString: {dateString: testCase.inputString}}}}) + .toArray(), + tojson(testCase)); + assert.eq( + [{_id: 0, date: ISODate(testCase.expect)}], + coll.aggregate({ + $project: { + date: { + $dateFromString: + {dateString: testCase.inputString, format: "%Y-%m-%dT%H:%M:%S.%L%z"} } - }) - .toArray(), - tojson(testCase)); - }); - - /* --------------------------------------------------------------------------------------- */ - /* Tests for ISO year, week of year, and day of the week. */ - - testCases = [ - {inputString: "2017", format: "%G", expect: "2017-01-02T00:00:00Z"}, - {inputString: "2017, Week 53", format: "%G, Week %V", expect: "2018-01-01T00:00:00Z"}, - {inputString: "2017, Day 5", format: "%G, Day %u", expect: "2017-01-06T00:00:00Z"}, - {inputString: "53.7.2017", format: "%V.%u.%G", expect: "2018-01-07T00:00:00Z"}, - {inputString: "1.1.1", format: "%V.%u.%G", expect: "0001-01-01T00:00:00Z"}, - ]; - testCases.forEach(function(testCase) { - assert.eq( - [{_id: 0, date: ISODate(testCase.expect)}], - coll.aggregate({ - $project: { - date: { - $dateFromString: - {dateString: testCase.inputString, format: testCase.format} - } + } + }) + .toArray(), + tojson(testCase)); +}); + +/* --------------------------------------------------------------------------------------- */ +/* BI format tests from data. */ + +coll.drop(); +assert.writeOK(coll.insert([ + {_id: 0, dateString: "2017-01-01 00:00:00"}, + {_id: 1, dateString: "2017-07-01 00:00:00"}, + {_id: 2, dateString: "2017-07-06"}, + {_id: 3, dateString: "2017-07-06 00:00:00"}, + {_id: 4, dateString: "2017-07-06 11:00:00"}, + {_id: 5, dateString: "2017-07-06 11:36:00"}, + {_id: 6, dateString: "2017-07-06 11:36:54"}, +])); + +assert.eq( + [ + {"_id": 0, "date": ISODate("2017-01-01T00:00:00Z")}, + {"_id": 1, "date": ISODate("2017-07-01T00:00:00Z")}, + {"_id": 2, "date": ISODate("2017-07-06T00:00:00Z")}, + {"_id": 3, "date": ISODate("2017-07-06T00:00:00Z")}, + {"_id": 4, "date": ISODate("2017-07-06T11:00:00Z")}, + {"_id": 5, "date": ISODate("2017-07-06T11:36:00Z")}, + {"_id": 6, "date": ISODate("2017-07-06T11:36:54Z")} + ], + coll.aggregate([ + { + $project: {date: {$dateFromString: {dateString: "$dateString"}}}, + }, + {$sort: {_id: 1}} + ]) + .toArray()); + +/* --------------------------------------------------------------------------------------- */ +/* Wacky format tests from data. */ + +coll.drop(); +assert.writeOK(coll.insert([ + {_id: 0, dateString: "July 4th, 2017"}, + {_id: 1, dateString: "July 4th, 2017 12:39:30 BST"}, + {_id: 2, dateString: "July 4th, 2017 11am"}, + {_id: 3, dateString: "July 4th, 2017 12pm"}, + {_id: 4, dateString: "7/4/17"}, + {_id: 5, dateString: "04-07-2017"}, + {_id: 6, dateString: "2017-Jul-04 noon"}, + {_id: 7, dateString: "2017-07-04 12:48:07 GMT+0545"}, + {_id: 8, dateString: "2017-07-04 12:48:07 GMT-0200"}, +])); + +assert.eq( + [ + {"_id": 0, "date": ISODate("2017-07-04T00:00:00Z")}, + {"_id": 1, "date": ISODate("2017-07-04T11:39:30Z")}, + {"_id": 2, "date": ISODate("2017-07-04T11:00:00Z")}, + {"_id": 3, "date": ISODate("2017-07-04T12:00:00Z")}, + {"_id": 4, "date": ISODate("2017-07-04T00:00:00Z")}, + {"_id": 5, "date": ISODate("2017-07-04T00:00:00Z")}, + {"_id": 6, "date": ISODate("2017-07-04T12:00:00Z")}, + {"_id": 7, "date": ISODate("2017-07-04T07:03:07Z")}, + {"_id": 8, "date": ISODate("2017-07-04T14:48:07Z")}, + ], + coll.aggregate([ + { + $project: {date: {$dateFromString: {dateString: "$dateString"}}}, + }, + {$sort: {_id: 1}} + ]) + .toArray()); + +/* --------------------------------------------------------------------------------------- */ +/* Tests formats that aren't supported with the normal $dateFromString parser. */ + +coll.drop(); +assert.writeOK(coll.insert({_id: 0})); + +testCases = [ + {inputString: "05 12 1988", format: "%d %m %Y", expect: "1988-12-05T00:00:00Z"}, + {inputString: "1992 04 26", format: "%Y %m %d", expect: "1992-04-26T00:00:00Z"}, + {inputString: "05*12*1988", format: "%d*%m*%Y", expect: "1988-12-05T00:00:00Z"}, + {inputString: "1992/04/26", format: "%Y/%m/%d", expect: "1992-04-26T00:00:00Z"}, + {inputString: "1992 % 04 % 26", format: "%Y %% %m %% %d", expect: "1992-04-26T00:00:00Z"}, + { + inputString: "Day: 05 Month: 12 Year: 1988", + format: "Day: %d Month: %m Year: %Y", + expect: "1988-12-05T00:00:00Z" + }, + {inputString: "Date: 1992/04/26", format: "Date: %Y/%m/%d", expect: "1992-04-26T00:00:00Z"}, + {inputString: "4/26/1992:+0445", format: "%m/%d/%Y:%z", expect: "1992-04-25T19:15:00Z"}, + {inputString: "4/26/1992:+285", format: "%m/%d/%Y:%Z", expect: "1992-04-25T19:15:00Z"}, +]; +testCases.forEach(function(testCase) { + assert.eq( + [{_id: 0, date: ISODate(testCase.expect)}], + coll.aggregate({ + $project: { + date: { + $dateFromString: {dateString: testCase.inputString, format: testCase.format} } - }) - .toArray(), - tojson(testCase)); - }); - - /* --------------------------------------------------------------------------------------- */ - /* Testing whether it throws the right assert for missing elements of a date/time string. */ - - coll.drop(); - - assert.writeOK(coll.insert([ - {_id: 0}, - ])); - - pipelines = [ - [{'$project': {date: {$dateFromString: {dateString: "July 4th"}}}}], - [{'$project': {date: {$dateFromString: {dateString: "12:50:53"}}}}], - ]; - - pipelines.forEach(function(pipeline) { - assertErrCodeAndErrMsgContains(coll, - pipeline, - ErrorCodes.ConversionFailure, - "an incomplete date/time string has been found"); - }); - - /* --------------------------------------------------------------------------------------- */ - /* Testing whether it throws the right assert for broken date/time strings. */ - - coll.drop(); - - assert.writeOK(coll.insert([ - {_id: 0}, - ])); - - pipelines = [ - [{'$project': {date: {$dateFromString: {dateString: "2017, 12:50:53"}}}}], - [{'$project': {date: {$dateFromString: {dateString: "60.Monday1770/06:59"}}}}], - ]; - - pipelines.forEach(function(pipeline) { - assertErrCodeAndErrMsgContains( - coll, pipeline, ErrorCodes.ConversionFailure, "Error parsing date string"); - }); - - /* --------------------------------------------------------------------------------------- */ - /* NULL returns. */ - - coll.drop(); - assert.writeOK(coll.insert([ - {_id: 0, date: new ISODate("2017-06-19T15:13:25.713Z")}, - {_id: 1, date: new ISODate("2017-06-19T15:13:25.713Z"), tz: null}, - {_id: 2, date: new ISODate("2017-06-19T15:13:25.713Z"), tz: undefined}, - ])); - - pipelines = [ - [{$project: {date: {$dateFromString: {dateString: "$tz"}}}}, {$sort: {_id: 1}}], - [ - { - $project: - {date: {$dateFromString: {dateString: "2017-07-11T17:05:19Z", timezone: "$tz"}}} - }, - {$sort: {_id: 1}} - ], - ]; - pipelines.forEach(function(pipeline) { - assert.eq([{_id: 0, date: null}, {_id: 1, date: null}, {_id: 2, date: null}], - coll.aggregate(pipeline).toArray(), - tojson(pipeline)); - }); - - coll.drop(); - assert.writeOK(coll.insert([ - {_id: 0}, - {_id: 1, format: null}, - {_id: 2, format: undefined}, - ])); - + } + }) + .toArray(), + tojson(testCase)); +}); + +/* --------------------------------------------------------------------------------------- */ +/* Tests for ISO year, week of year, and day of the week. */ + +testCases = [ + {inputString: "2017", format: "%G", expect: "2017-01-02T00:00:00Z"}, + {inputString: "2017, Week 53", format: "%G, Week %V", expect: "2018-01-01T00:00:00Z"}, + {inputString: "2017, Day 5", format: "%G, Day %u", expect: "2017-01-06T00:00:00Z"}, + {inputString: "53.7.2017", format: "%V.%u.%G", expect: "2018-01-07T00:00:00Z"}, + {inputString: "1.1.1", format: "%V.%u.%G", expect: "0001-01-01T00:00:00Z"}, +]; +testCases.forEach(function(testCase) { assert.eq( - [{_id: 0, date: null}, {_id: 1, date: null}, {_id: 2, date: null}], + [{_id: 0, date: ISODate(testCase.expect)}], coll.aggregate({ $project: { date: { - $dateFromString: {dateString: "2017-07-11T17:05:19Z", format: "$format"} + $dateFromString: {dateString: testCase.inputString, format: testCase.format} } } }) - .toArray()); + .toArray(), + tojson(testCase)); +}); - /* --------------------------------------------------------------------------------------- */ - /* Parse errors. */ +/* --------------------------------------------------------------------------------------- */ +/* Testing whether it throws the right assert for missing elements of a date/time string. */ - let pipeline = [{$project: {date: {$dateFromString: "no-object"}}}]; - assertErrCodeAndErrMsgContains( - coll, pipeline, 40540, "$dateFromString only supports an object as an argument"); +coll.drop(); + +assert.writeOK(coll.insert([ + {_id: 0}, +])); - pipeline = [{$project: {date: {$dateFromString: {"unknown": "$tz"}}}}]; - assertErrCodeAndErrMsgContains(coll, pipeline, 40541, "Unrecognized argument"); +pipelines = [ + [{'$project': {date: {$dateFromString: {dateString: "July 4th"}}}}], + [{'$project': {date: {$dateFromString: {dateString: "12:50:53"}}}}], +]; - pipeline = [{$project: {date: {$dateFromString: {dateString: 5}}}}]; +pipelines.forEach(function(pipeline) { assertErrCodeAndErrMsgContains(coll, pipeline, ErrorCodes.ConversionFailure, - "$dateFromString requires that 'dateString' be a string"); - - /* --------------------------------------------------------------------------------------- */ - /* Passing in time zone with date/time string. */ - - pipeline = { - $project: { - date: { - $dateFromString: - {dateString: "2017-07-12T22:23:55 GMT+02:00", timezone: "Europe/Amsterdam"} - } - } - }; - assertErrorCode(coll, pipeline, ErrorCodes.ConversionFailure); - - pipeline = { - $project: { - date: { - $dateFromString: - {dateString: "2017-07-12T22:23:55Z", timezone: "Europe/Amsterdam"} - } - } - }; - assertErrorCode(coll, pipeline, ErrorCodes.ConversionFailure); - - pipeline = { - $project: { - date: { - $dateFromString: { - dateString: "2017-07-12T22:23:55 America/New_York", - timezone: "Europe/Amsterdam" - } - } - } - }; - assertErrorCode(coll, pipeline, ErrorCodes.ConversionFailure); + "an incomplete date/time string has been found"); +}); - pipeline = { - $project: {date: {$dateFromString: {dateString: "2017-07-12T22:23:55 Europe/Amsterdam"}}} - }; - assertErrorCode(coll, pipeline, ErrorCodes.ConversionFailure); +/* --------------------------------------------------------------------------------------- */ +/* Testing whether it throws the right assert for broken date/time strings. */ - /* --------------------------------------------------------------------------------------- */ - /* Error cases for $dateFromString with format specifier string. */ +coll.drop(); - // Test umatched format specifier string. - pipeline = [{$project: {date: {$dateFromString: {dateString: "2018-01", format: "%Y-%m-%d"}}}}]; - assertErrCodeAndErrMsgContains(coll, pipeline, ErrorCodes.ConversionFailure, "Data missing"); +assert.writeOK(coll.insert([ + {_id: 0}, +])); - pipeline = [{$project: {date: {$dateFromString: {dateString: "2018-01", format: "%Y"}}}}]; - assertErrCodeAndErrMsgContains(coll, pipeline, ErrorCodes.ConversionFailure, "Trailing data"); +pipelines = [ + [{'$project': {date: {$dateFromString: {dateString: "2017, 12:50:53"}}}}], + [{'$project': {date: {$dateFromString: {dateString: "60.Monday1770/06:59"}}}}], +]; - // Test missing specifier prefix '%'. - pipeline = [{$project: {date: {$dateFromString: {dateString: "1992-26-04", format: "Y-d-m"}}}}]; +pipelines.forEach(function(pipeline) { assertErrCodeAndErrMsgContains( - coll, pipeline, ErrorCodes.ConversionFailure, "Format literal not found"); - - pipeline = [{$project: {date: {$dateFromString: {dateString: "1992", format: "%n"}}}}]; - assertErrCodeAndErrMsgContains(coll, pipeline, 18536, "Invalid format character"); - - pipeline = [{ - $project: { - date: { - $dateFromString: - {dateString: "4/26/1992:+0445", format: "%m/%d/%Y:%z", timezone: "+0500"} - } + coll, pipeline, ErrorCodes.ConversionFailure, "Error parsing date string"); +}); + +/* --------------------------------------------------------------------------------------- */ +/* NULL returns. */ + +coll.drop(); +assert.writeOK(coll.insert([ + {_id: 0, date: new ISODate("2017-06-19T15:13:25.713Z")}, + {_id: 1, date: new ISODate("2017-06-19T15:13:25.713Z"), tz: null}, + {_id: 2, date: new ISODate("2017-06-19T15:13:25.713Z"), tz: undefined}, +])); + +pipelines = [ + [{$project: {date: {$dateFromString: {dateString: "$tz"}}}}, {$sort: {_id: 1}}], + [ + { + $project: + {date: {$dateFromString: {dateString: "2017-07-11T17:05:19Z", timezone: "$tz"}}} + }, + {$sort: {_id: 1}} + ], +]; +pipelines.forEach(function(pipeline) { + assert.eq([{_id: 0, date: null}, {_id: 1, date: null}, {_id: 2, date: null}], + coll.aggregate(pipeline).toArray(), + tojson(pipeline)); +}); + +coll.drop(); +assert.writeOK(coll.insert([ + {_id: 0}, + {_id: 1, format: null}, + {_id: 2, format: undefined}, +])); + +assert.eq( + [{_id: 0, date: null}, {_id: 1, date: null}, {_id: 2, date: null}], + coll.aggregate({ + $project: + {date: {$dateFromString: {dateString: "2017-07-11T17:05:19Z", format: "$format"}}} + }) + .toArray()); + +/* --------------------------------------------------------------------------------------- */ +/* Parse errors. */ + +let pipeline = [{$project: {date: {$dateFromString: "no-object"}}}]; +assertErrCodeAndErrMsgContains( + coll, pipeline, 40540, "$dateFromString only supports an object as an argument"); + +pipeline = [{$project: {date: {$dateFromString: {"unknown": "$tz"}}}}]; +assertErrCodeAndErrMsgContains(coll, pipeline, 40541, "Unrecognized argument"); + +pipeline = [{$project: {date: {$dateFromString: {dateString: 5}}}}]; +assertErrCodeAndErrMsgContains(coll, + pipeline, + ErrorCodes.ConversionFailure, + "$dateFromString requires that 'dateString' be a string"); + +/* --------------------------------------------------------------------------------------- */ +/* Passing in time zone with date/time string. */ + +pipeline = { + $project: { + date: { + $dateFromString: + {dateString: "2017-07-12T22:23:55 GMT+02:00", timezone: "Europe/Amsterdam"} } - }]; - assertErrCodeAndErrMsgContains( - coll, - pipeline, - ErrorCodes.ConversionFailure, - "you cannot pass in a date/time string with GMT offset together with a timezone argument"); - - pipeline = [{$project: {date: {$dateFromString: {dateString: "4/26/1992", format: 5}}}}]; - assertErrCodeAndErrMsgContains( - coll, pipeline, 40684, "$dateFromString requires that 'format' be a string"); - - pipeline = [{$project: {date: {$dateFromString: {dateString: "4/26/1992", format: {}}}}}]; - assertErrCodeAndErrMsgContains( - coll, pipeline, 40684, "$dateFromString requires that 'format' be a string"); - - pipeline = - [{$project: {date: {$dateFromString: {dateString: "ISO Day 6", format: "ISO Day %u"}}}}]; - assertErrCodeAndErrMsgContains( - coll, pipeline, ErrorCodes.ConversionFailure, "The parsed date was invalid"); - - pipeline = - [{$project: {date: {$dateFromString: {dateString: "ISO Week 52", format: "ISO Week %V"}}}}]; - assertErrCodeAndErrMsgContains( - coll, pipeline, ErrorCodes.ConversionFailure, "The parsed date was invalid"); - - pipeline = [{ - $project: { - date: {$dateFromString: {dateString: "ISO Week 1, 2018", format: "ISO Week %V, %Y"}} + } +}; +assertErrorCode(coll, pipeline, ErrorCodes.ConversionFailure); + +pipeline = { + $project: { + date: {$dateFromString: {dateString: "2017-07-12T22:23:55Z", timezone: "Europe/Amsterdam"}} + } +}; +assertErrorCode(coll, pipeline, ErrorCodes.ConversionFailure); + +pipeline = { + $project: { + date: { + $dateFromString: + {dateString: "2017-07-12T22:23:55 America/New_York", timezone: "Europe/Amsterdam"} } - }]; - assertErrCodeAndErrMsgContains(coll, - pipeline, - ErrorCodes.ConversionFailure, - "Mixing of ISO dates with natural dates is not allowed"); - - pipeline = - [{$project: {date: {$dateFromString: {dateString: "12/31/2018", format: "%m/%d/%G"}}}}]; - assertErrCodeAndErrMsgContains(coll, - pipeline, - ErrorCodes.ConversionFailure, - "Mixing of ISO dates with natural dates is not allowed"); - - // Test embedded null bytes in the 'dateString' and 'format' fields. - pipeline = - [{$project: {date: {$dateFromString: {dateString: "12/31\0/2018", format: "%m/%d/%Y"}}}}]; - assertErrCodeAndErrMsgContains(coll, pipeline, ErrorCodes.ConversionFailure, "Data missing"); - - pipeline = - [{$project: {date: {$dateFromString: {dateString: "12/31/2018", format: "%m/%d\0/%Y"}}}}]; - assertErrCodeAndErrMsgContains(coll, pipeline, ErrorCodes.ConversionFailure, "Trailing data"); + } +}; +assertErrorCode(coll, pipeline, ErrorCodes.ConversionFailure); + +pipeline = { + $project: {date: {$dateFromString: {dateString: "2017-07-12T22:23:55 Europe/Amsterdam"}}} +}; +assertErrorCode(coll, pipeline, ErrorCodes.ConversionFailure); + +/* --------------------------------------------------------------------------------------- */ +/* Error cases for $dateFromString with format specifier string. */ + +// Test umatched format specifier string. +pipeline = [{$project: {date: {$dateFromString: {dateString: "2018-01", format: "%Y-%m-%d"}}}}]; +assertErrCodeAndErrMsgContains(coll, pipeline, ErrorCodes.ConversionFailure, "Data missing"); + +pipeline = [{$project: {date: {$dateFromString: {dateString: "2018-01", format: "%Y"}}}}]; +assertErrCodeAndErrMsgContains(coll, pipeline, ErrorCodes.ConversionFailure, "Trailing data"); + +// Test missing specifier prefix '%'. +pipeline = [{$project: {date: {$dateFromString: {dateString: "1992-26-04", format: "Y-d-m"}}}}]; +assertErrCodeAndErrMsgContains( + coll, pipeline, ErrorCodes.ConversionFailure, "Format literal not found"); + +pipeline = [{$project: {date: {$dateFromString: {dateString: "1992", format: "%n"}}}}]; +assertErrCodeAndErrMsgContains(coll, pipeline, 18536, "Invalid format character"); + +pipeline = [{ + $project: { + date: { + $dateFromString: + {dateString: "4/26/1992:+0445", format: "%m/%d/%Y:%z", timezone: "+0500"} + } + } +}]; +assertErrCodeAndErrMsgContains( + coll, + pipeline, + ErrorCodes.ConversionFailure, + "you cannot pass in a date/time string with GMT offset together with a timezone argument"); + +pipeline = [{$project: {date: {$dateFromString: {dateString: "4/26/1992", format: 5}}}}]; +assertErrCodeAndErrMsgContains( + coll, pipeline, 40684, "$dateFromString requires that 'format' be a string"); + +pipeline = [{$project: {date: {$dateFromString: {dateString: "4/26/1992", format: {}}}}}]; +assertErrCodeAndErrMsgContains( + coll, pipeline, 40684, "$dateFromString requires that 'format' be a string"); + +pipeline = [{$project: {date: {$dateFromString: {dateString: "ISO Day 6", format: "ISO Day %u"}}}}]; +assertErrCodeAndErrMsgContains( + coll, pipeline, ErrorCodes.ConversionFailure, "The parsed date was invalid"); + +pipeline = + [{$project: {date: {$dateFromString: {dateString: "ISO Week 52", format: "ISO Week %V"}}}}]; +assertErrCodeAndErrMsgContains( + coll, pipeline, ErrorCodes.ConversionFailure, "The parsed date was invalid"); + +pipeline = [{ + $project: {date: {$dateFromString: {dateString: "ISO Week 1, 2018", format: "ISO Week %V, %Y"}}} +}]; +assertErrCodeAndErrMsgContains(coll, + pipeline, + ErrorCodes.ConversionFailure, + "Mixing of ISO dates with natural dates is not allowed"); + +pipeline = [{$project: {date: {$dateFromString: {dateString: "12/31/2018", format: "%m/%d/%G"}}}}]; +assertErrCodeAndErrMsgContains(coll, + pipeline, + ErrorCodes.ConversionFailure, + "Mixing of ISO dates with natural dates is not allowed"); + +// Test embedded null bytes in the 'dateString' and 'format' fields. +pipeline = + [{$project: {date: {$dateFromString: {dateString: "12/31\0/2018", format: "%m/%d/%Y"}}}}]; +assertErrCodeAndErrMsgContains(coll, pipeline, ErrorCodes.ConversionFailure, "Data missing"); + +pipeline = + [{$project: {date: {$dateFromString: {dateString: "12/31/2018", format: "%m/%d\0/%Y"}}}}]; +assertErrCodeAndErrMsgContains(coll, pipeline, ErrorCodes.ConversionFailure, "Trailing data"); })(); |