/node_modules/rethinkdbdash/test/selecting-data.js
JavaScript | 388 lines | 340 code | 45 blank | 3 comment | 15 complexity | 1897705fb590461db5d985ce454d7a9c MD5 | raw file
- var config = require(__dirname+'/config.js');
- var r = require(__dirname+'/../lib')(config);
- var util = require(__dirname+'/util/common.js');
- var assert = require('assert');
- var Promise = require('bluebird');
- var uuid = util.uuid;
- var It = util.It;
- var uuid = util.uuid;
- var dbName, tableName, result, pks;
- It('Init for `selecting-data.js`', function* (done) {
- try {
- dbName = uuid();
- tableName = uuid();
- result = yield r.dbCreate(dbName).run();
- assert.equal(result.dbs_created, 1);
- result = yield r.db(dbName).tableCreate(tableName).run();
- assert.equal(result.tables_created, 1);
- result = yield r.db(dbName).table(tableName).insert(eval('['+new Array(100).join('{}, ')+'{}]')).run();
- assert.equal(result.inserted, 100);
- pks = result.generated_keys;
- done();
- }
- catch(e) {
- done(e);
- }
- })
- It('`db` should work', function* (done) {
- try {
- result = yield r.db(dbName).info().run();
- assert.equal(result.name, dbName);
- assert.equal(result.type, 'DB');
- done();
- }
- catch(e) {
- done(e);
- }
- })
- It('`table` should work', function* (done) {
- try {
- result = yield r.db(dbName).table(tableName).info().run();
- assert.equal(result.name, tableName)
- assert.equal(result.type, 'TABLE')
- assert.equal(result.primary_key, 'id')
- assert.equal(result.db.name, dbName)
- result = yield r.db(dbName).table(tableName).run();
- assert.equal(result.length, 100)
- done();
- }
- catch(e) {
- done(e);
- }
- })
- It('`table` should work with readMode', function* (done) {
- try {
- var result = yield r.db(dbName).table(tableName, {readMode: 'majority'}).run();
- assert.equal(result.length, 100)
- result = yield r.db(dbName).table(tableName, {readMode: 'majority'}).run();
- assert.equal(result.length, 100)
- done();
- }
- catch(e) {
- done(e);
- }
- })
- It('`table` should throw with non valid otpions', function* (done) {
- try {
- var result = yield r.db(dbName).table(tableName, {nonValidKey: false}).run();
- }
- catch(e) {
- if (e.message === 'Unrecognized option `nonValidKey` in `table` after:\nr.db("'+dbName+'")\nAvailable option is readMode <string>') {
- done();
- }
- else {
- done(e);
- }
- }
- })
- It('`get` should work', function* (done) {
- try {
- result = yield r.db(dbName).table(tableName).get(pks[0]).run();
- assert.deepEqual(result, {id: pks[0]})
- done();
- }
- catch(e) {
- done(e);
- }
- })
- It('`get` should throw if no argument is passed', function* (done) {
- try {
- result = yield r.db(dbName).table(tableName).get().run();
- }
- catch(e) {
- assert(e instanceof r.Error.ReqlDriverError);
- assert(e instanceof Error);
- if (e.message === '`get` takes 1 argument, 0 provided after:\nr.db("'+dbName+'").table("'+tableName+'")') {
- done();
- }
- else{
- done(e);
- }
- }
- })
- It('`getAll` should work with multiple values - primary key', function* (done) {
- try {
- var table = r.db(dbName).table(tableName);
- var query = table.getAll.apply(table, pks);
- result = yield query.run();
- assert.equal(result.length, 100);
- table = r.db(dbName).table(tableName);
- query = table.getAll.apply(table, pks.slice(0, 50));
- result = yield query.run();
- assert.equal(result.length, 50);
- done();
- }
- catch(e) {
- done(e);
- }
- })
- It('`getAll` should work with no argument - primary key', function* (done) {
- try {
- var result = yield r.db(dbName).table(tableName).getAll().run();
- assert.equal(result.length, 0);
- done();
- }
- catch(e) {
- done(e);
- }
- })
- It('`getAll` should work with no argument - index', function* (done) {
- try {
- var result = yield r.db(dbName).table(tableName).getAll({index: 'id'}).run();
- assert.equal(result.length, 0);
- done();
- }
- catch(e) {
- done(e);
- }
- })
- It('`getAll` should work with multiple values - secondary index 1', function* (done) {
- try {
- var result = yield r.db(dbName).table(tableName).update({field: 0}).run();
- assert.equal(result.replaced, 100);
- result = yield r.db(dbName).table(tableName).sample(20).update({field: 10}).run();
- assert.equal(result.replaced, 20);
- result = yield r.db(dbName).table(tableName).indexCreate('field').run();
- assert.deepEqual(result, {created: 1});
- result = yield r.db(dbName).table(tableName).indexWait('field').pluck('index', 'ready').run();
- assert.deepEqual(result, [{'index':'field','ready':true}]);
- // Yield one second -- See https://github.com/rethinkdb/rethinkdb/issues/2170
- var p = new Promise(function(resolve, reject) {
- setTimeout(function() { resolve() }, 1000)
- });
- yield p;
- result = yield r.db(dbName).table(tableName).getAll(10, {index: 'field'}).run();
- assert(result);
- assert.equal(result.length, 20);
- done();
- }
- catch(e) {
- done(e);
- }
- })
- It('`getAll` should return native dates (and cursor should handle them)', function* (done) {
- try {
- var result = yield r.db(dbName).table(tableName).insert({field: -1, date: r.now()}).run();
- result = yield r.db(dbName).table(tableName).getAll(-1, {index: 'field'}).run();
- assert(result[0].date instanceof Date);
- // Clean for later
- result = yield r.db(dbName).table(tableName).getAll(-1, {index: 'field'}).delete().run();
- done();
- }
- catch(e) {
- done(e);
- }
- })
- It('`getAll` should work with multiple values - secondary index 2', function* (done) {
- try {
- var result = yield r.db(dbName).table(tableName).indexCreate('fieldAddOne', function(doc) { return doc('field').add(1) }).run();
- assert.deepEqual(result, {created: 1});
- result = yield r.db(dbName).table(tableName).indexWait('fieldAddOne').pluck('index', 'ready').run();
- assert.deepEqual(result, [{'index':'fieldAddOne','ready':true}]);
- // Yield one second -- See https://github.com/rethinkdb/rethinkdb/issues/2170
- var p = new Promise(function(resolve, reject) {
- setTimeout(function() { resolve() }, 1000)
- });
- yield p;
- result = yield r.db(dbName).table(tableName).getAll(11, {index: 'fieldAddOne'}).run();
- assert(result);
- assert.equal(result.length, 20);
- done();
- }
- catch(e) {
- done(e);
- }
- })
- It('`between` should wrok -- secondary index', function* (done) {
- try {
- var result = yield r.db(dbName).table(tableName).between(5, 20, {index: 'fieldAddOne'}).run();
- assert(result);
- assert.equal(result.length, 20);
- done();
- }
- catch(e) {
- done(e);
- }
- })
- It('`between` should wrok -- all args', function* (done) {
- try {
- var result = yield r.db(dbName).table(tableName).between(5, 20, {index: 'fieldAddOne', leftBound: 'open', rightBound: 'closed'}).run();
- assert(result);
- assert.equal(result.length, 20);
- done();
- }
- catch(e) {
- done(e);
- }
- })
- It('`between` should throw if no argument is passed', function* (done) {
- try {
- var result = yield r.db(dbName).table(tableName).between().run();
- }
- catch(e) {
- assert(e instanceof r.Error.ReqlDriverError);
- assert(e instanceof Error);
- if (e.message === "`between` takes at least 2 arguments, 0 provided after:\nr.db(\""+dbName+"\").table(\""+tableName+"\")") {
- done();
- }
- else{
- done(e);
- }
- }
- })
- It('`between` should throw if non valid arg', function* (done) {
- try {
- var result = yield r.db(dbName).table(tableName).between(1, 2, {nonValidKey: true}).run();
- }
- catch(e) {
- assert(e instanceof r.Error.ReqlDriverError);
- assert(e instanceof Error);
- if (e.message === 'Unrecognized option `nonValidKey` in `between` after:\nr.db("'+dbName+'").table("'+tableName+'")\nAvailable options are index <string>, leftBound <string>, rightBound <string>') {
- done();
- }
- else{
- done(e);
- }
- }
- })
- It('`filter` should work -- with an object', function* (done) {
- try {
- var result = yield r.db(dbName).table(tableName).filter({field: 10}).run();
- assert(result);
- assert.equal(result.length, 20);
- done();
- }
- catch(e) {
- done(e);
- }
- })
- It('`filter` should work -- with an object -- looking for an undefined field', function* (done) {
- try {
- var result = yield r.db(dbName).table(tableName).filter({nonExistingField: 10}).run();
- assert(result);
- assert.equal(result.length, 0);
- done();
- }
- catch(e) {
- done(e);
- }
- })
- It('`filter` should work -- with an anonymous function', function* (done) {
- try {
- var result = yield r.db(dbName).table(tableName).filter(function(doc) { return doc("field").eq(10) }).run();
- assert(result);
- assert.equal(result.length, 20);
- done();
- }
- catch(e) {
- done(e);
- }
- })
- It('`filter` should work -- default true', function* (done) {
- try {
- var result = yield r.db(dbName).table(tableName).filter({nonExistingField: 10}, {default: true}).run();
- assert(result);
- assert.equal(result.length, 100);
- done();
- }
- catch(e) {
- done(e);
- }
- })
- It('`filter` should work -- default false', function* (done) {
- try {
- var result = yield r.db(dbName).table(tableName).filter({nonExistingField: 10}, {default: false}).run();
- assert(result);
- assert.equal(result.length, 0);
- done();
- }
- catch(e) {
- done(e);
- }
- })
- It('`filter` should work -- default false', function* (done) {
- try{
- var result = yield r.expr([{a:1}, {}]).filter(r.row("a"), {default: r.error()}).run();
- }
- catch(e) {
- if (e.message.match(/^No attribute `a` in object:/)) {
- done()
- }
- else {
- done(e);
- }
- }
- })
- It('`filter` should throw if no argument is passed', function* (done) {
- try {
- var result = yield r.db(dbName).table(tableName).filter().run();
- }
- catch(e) {
- assert(e instanceof r.Error.ReqlDriverError);
- assert(e instanceof Error);
- if (e.message === "`filter` takes at least 1 argument, 0 provided after:\nr.db(\""+dbName+"\").table(\""+tableName+"\")") {
- done();
- }
- else{
- done(e);
- }
- }
- })
- It('`filter` should throw with a non valid option', function* (done) {
- try {
- var result = yield r.db(dbName).table(tableName).filter(true, {nonValidKey: false}).run();
- }
- catch(e) {
- if (e.message.match(/^Unrecognized option `nonValidKey` in `filter` after:/)) {
- done();
- }
- else{
- done(e);
- }
- }
- })