r.tableDrop(exports.DB.tables.MESSAGES).run(connection, function (err, results) {
r.tableDrop(exports.DB.tables.SOCKETS).run(connection, function (err, results) {
r.dbDrop(config.rethinkdb.db).run(connection, function(err, results){
callback(null, {dropped: 1});
});
});
});
.then(function() {
return r.tableDrop('entries').run(_conn)
.catch(function() {})
.then(function() {
return r.tableCreate('entries').run(_conn);
})
.catch(function(err) {
throw err;
})
.finally(function(result) {
console.log('RethinkDB ready');
});
})
let test = async () => {
let conn = await r.connect({
host: 'localhost',
port: 28015
});
try {
let table1 = idGen();
log(table1);
await r.tableCreate(table1).run(conn);
// insert data
await r.table(table1).insert([{
id: 1,
what: 2
}, {
id: 2,
what: 3
}, {
id: 3,
what: 2
}]).run(conn);
log('table1');
let c1 = await r.table(table1).run(conn);
log(await c1.toArray());
log('getAll');
let c2 = await r.table(table1).getAll(1).run(conn);
log(await c2.toArray());
log('getAll2');
// build index
await r.table(table1).indexCreate('what').run(conn);
await r.table(table1).indexWait().run(conn);
//
let c3 = await r.table(table1).getAll(2, {
index: 'what'
}).run(conn);
log(await c3.toArray());
//
await r.tableDrop(table1).run(conn);
} catch (err) {
log(err);
}
log('close');
//
await conn.close();
};
dbDropTable({reqId}) {
return r.tableDrop(this.table).run(this.dbConn).then((dbResult) => {
this.logger.trace({
reqId,
dbResult,
table: this.table,
}, 'Dropped table');
return this.table;
}).catch((err) => {
this.logger.error({
reqId,
err,
}, 'Cannot drop table');
throw err;
});
}
r.connect(config.rethinkdb, function (err, connection) {
if (err) {
callback(err, null);
} else {
r.tableDrop(exports.DB.tables.USERS).run(connection, function (err, results) {
r.tableDrop(exports.DB.tables.DOMAINS).run(connection, function (err, results) {
r.tableDrop(exports.DB.tables.MESSAGES).run(connection, function (err, results) {
r.tableDrop(exports.DB.tables.SOCKETS).run(connection, function (err, results) {
r.dbDrop(config.rethinkdb.db).run(connection, function(err, results){
callback(null, {dropped: 1});
});
});
});
});
});
}
});
RANGE: r.range(),
INSERT_AT: r([]).insertAt(),
DELETE_AT: r([]).deleteAt(),
CHANGE_AT: r([]).changeAt(),
SPLICE_AT: r([]).spliceAt(),
COERCE_TO: r([]).coerceTo(),
TYPE_OF: r([]).typeOf(),
UPDATE: r([]).update({}),
DELETE: r([]).delete(),
REPLACE: r([]).replace({}),
INSERT: r([]).insert({}),
DB_CREATE: r.dbCreate(),
DB_DROP: r.dbDrop(),
DB_LIST: r.dbList(),
TABLE_CREATE: r.tableCreate(''),
TABLE_DROP: r.tableDrop(''),
TABLE_LIST: r.tableList(),
CONFIG: r([]).config(),
STATUS: r([]).status(),
WAIT: r.table('superheroes').wait(),
RECONFIGURE: r.table('superheroes').reconfigure(),
REBALANCE: r.table('superheroes').rebalance(),
SYNC: r([]).sync(),
INDEX_CREATE: r([]).indexCreate(''),
INDEX_DROP: r([]).indexDrop(''),
INDEX_LIST: r([]).indexList(),
INDEX_STATUS: r([]).indexStatus(),
INDEX_WAIT: r([]).indexWait(),
INDEX_RENAME: r([]).indexRename('', ''),
FUNCALL: r.do(function () { return 0 }),
BRANCH: r.branch(0, 0, 0),
function(callback) {
r.tableDrop('person').run(connection, callback);
},
dbConnect(conn => {
r.tableDrop('events').run(conn, () => {
createTables();
});
})
after(() => {
return pool.run(r.tableDrop('foo'))
})
it('tableDrop - 8', function(done) {
var query = r.tableDrop(1, {foo: 'bar'});
compare(query, done);
});
it('tableDrop - 7', function(done) {
var query = r.tableDrop(TEST_TABLE, {foo: 'bar'});
compare(query, done);
});
it('tableDrop - 6', function(done) {
var query = r.tableDrop(TEST_TABLE);
compare(query, done);
});
it('tableCreate - 9 - follow up', function(done) {
var query = r.tableDrop('foo_bar');
compare(query, done, function(result) {
return result.tables_dropped;
});
});
let test = async () => {
let conn = await r.connect({
host: 'localhost',
port: 28015
});
try {
let table1 = idGen();
log(table1);
await r.tableCreate(table1).run(conn);
let table2 = idGen();
log(table2);
await r.tableCreate(table2).run(conn);
// insert data
await r.table(table1).insert({
a: 1,
join: 10
}).run(conn);
await r.table(table1).insert({
a: 2,
join: 6
}).run(conn);
await r.table(table1).insert({
a: 133,
join: 100
}).run(conn);
await r.table(table2).insert({
a: 1111,
b: 2,
join: 12
}).run(conn);
await r.table(table2).insert({
b: 3,
join: 11
}).run(conn);
await r.table(table2).insert({
b: 5,
join: 0
}).run(conn);
log('table1');
let c1 = await r.table(table1).run(conn);
log(await c1.toArray());
log('table2');
let c2 = await r.table(table2).run(conn);
log(await c2.toArray());
log('innerjoin');
// inner join
let cursor = await r.table(table1).innerJoin(
r.table(table2), (t1Row, t2Row) => {
return t1Row('join').lt(t2Row('join'));
}
).zip().run(conn);
let rets = await cursor.toArray();
log(rets);
await r.tableDrop(table1).run(conn);
await r.tableDrop(table2).run(conn);
} catch (err) {
log(err);
}
//
log('close');
//
await conn.close();
};