it('ISO8601', (done) => {
let ISO8601 = new Query(r.ISO8601('1986-11-03T08:30:00-07:00').build())
co(function * () {
try {
let result = yield ISO8601.run()
expect(result).to.be.instanceof(Date)
done()
} catch (e) {
done(e)
}
})
})
r.db(item).table('_stats_writes').filter(function (row) {
return row('timestamp').gt(r.ISO8601(last_timestamp.toISOString())).and(row('timestamp').le(r.ISO8601(enddate.toISOString())))
}).sum('writeCount').run(conn, function (err, results) {
r.table('players').get(1)('score').ge(10),
r.table('players').get(1)('score').lt(10),
r.table('players').get(1)('score').le(10),
r(true).not(),
r.not(true),
r.random(),
r.round(12.345),
r.ceil(12.345),
r.floor(12.345),
r.table('users').insert({
name: 'John',
subscription_date: r.now()
}),
r.table('user').get('John').update({birthdate: r.time(1986, 11, 3, 'Z')}),
r.table('user').get('John').update({birthdate: r.epochTime(531360000)}),
r.table('user').get('John').update({birth: r.ISO8601('1986-11-03T08:30:00-07:00')}),
r.now().inTimezone('-08:00').hours(),
r.table('users').filter(function (user) {
return user('subscriptionDate').timezone().eq('-07:00')
}),
r.table('posts').filter(
r.row('date').during(r.time(2013, 12, 1), r.time(2013, 12, 10))
),
r.table('users').filter(function (user) {
return user('birthdate').date().eq(r.now().date())
}),
r.table('posts').filter(
r.row('date').timeOfDay().le(12 * 60 * 60)
),
r.table('users').filter(function (user) {
return user('birthdate').year().eq(1986)
BRANCH: r.branch(0, 0, 0),
OR: r(0).or(0),
AND: r(0).and(0),
FOR_EACH: r([]).forEach(function () { return 0 }),
FUNC: r(function () { return 0 }),
ASC: r.asc(),
DESC: r.desc(),
INFO: r.info(),
MATCH: r('').match(''),
UPCASE: r('').upcase(),
DOWNCASE: r('').downcase(),
SAMPLE: r([]).sample(0),
DEFAULT: r({}).default(0),
JSON: r.json(''),
TO_JSON_STRING: r('').toJsonString(),
ISO8601: r.ISO8601(''),
TO_ISO8601: r.now().toISO8601(),
EPOCH_TIME: r.epochTime(0),
TO_EPOCH_TIME: r.now().toEpochTime(),
NOW: r.now(),
IN_TIMEZONE: r.now().inTimezone(''),
DURING: r('').during(r.now(), r.now()),
DATE: r.now().date(),
TIME_OF_DAY: r.now().timeOfDay(),
TIMEZONE: r.now().timezone(),
YEAR: r.now().year(),
MONTH: r.now().month(),
DAY: r.now().day(),
DAY_OF_WEEK: r.now().dayOfWeek(),
DAY_OF_YEAR: r.now().dayOfYear(),
HOURS: r.now().hours(),
it('timezone - 2', function(done) {
var query = r.ISO8601('1986-11-03T08:30:00+04:30').inTimezone('-03:00');
compare(query, done);
});
it('inTimezone - 3', function(done) {
var query = r.ISO8601('1986-11-03T08:30:00+04:30').inTimezone(3).hours();
compare(query, done);
});
it('iso8601 - 9', function(done) {
var query = r.ISO8601(2);
compare(query, done);
});
it('iso8601 - 8', function(done) {
var query = r.ISO8601(r.args(['1986-11-03T08:30:00+04:30', '1986-11-03T08:30:00+04:30']));
compare(query, done);
});
it('iso8601 - 7', function(done) {
var query = r.ISO8601('1986-11-03T08:30:00+04:30');
compare(query, done);
});