const Hyperbee = require('hyperbee2') const definition = require('./fixtures/definition') const { test } = require('./helpers') const tmp = require('test-tmp') test('basic full example', async function ({ create }, t) { const db = await create(definition) await db.insert('members', { id: 'maf', age: 34 }) await db.insert('members', { id: 'andrew', age: 34 }) await db.insert('members', { id: 'anna', age: 32 }) await db.flush() { const result = await db.find('members/by-age', { gte: { age: 33 }, lt: { age: 99 } }).toArray() t.alike(result, [ { id: 'andrew', age: 34 }, { id: 'maf', age: 34 } ]) } // // stop lying await db.insert('members', { id: 'maf', age: 37 }) { const result = await db.find('members/by-age', { gte: { age: 33 }, lt: { age: 99 } }).toArray() t.alike(result, [ { id: 'andrew', age: 34 }, { id: 'maf', age: 37 } ]) } { const result = await db .find('members/by-age', { gte: { age: 33 }, lt: { age: 99 } }, { reverse: true }) .toArray() t.alike(result, [ { id: 'maf', age: 37 }, { id: 'andrew', age: 34 } ]) } { const result = await db.find('members').toArray() t.alike(result, [ { id: 'andrew', age: 34 }, { id: 'anna', age: 32 }, { id: 'maf', age: 37 } ]) } t.alike(await db.get('members', { id: 'maf' }), { id: 'maf', age: 37 }) t.alike(await db.get('members', { id: 'anna' }), { id: 'anna', age: 32 }) t.alike(await db.get('members', { id: 'andrew' }), { id: 'andrew', age: 34 }) await db.close() }) test('basic multi get', async function ({ create }, t) { const db = await create(definition) await db.insert('members', { id: 'maf', age: 34 }) await db.insert('members', { id: 'andrew', age: 34 }) await db.insert('members', { id: 'anna', age: 32 }) await db.flush() { const result = await db.find('members/by-age', { gte: { age: 33 }, lt: { age: 99 } }).toArray() t.alike(result, [ { id: 'andrew', age: 34 }, { id: 'maf', age: 34 } ]) } // // stop lying await db.insert('members', { id: 'maf', age: 37 }) { const result = await db.find('members/by-age', { gte: { age: 33 }, lt: { age: 99 } }).toArray() t.alike(result, [ { id: 'andrew', age: 34 }, { id: 'maf', age: 37 } ]) } { const result = await db .find('members/by-age', { gte: { age: 33 }, lt: { age: 99 } }, { reverse: true }) .toArray() t.alike(result, [ { id: 'maf', age: 37 }, { id: 'andrew', age: 34 } ]) } { const result = await db.find('members').toArray() t.alike(result, [ { id: 'andrew', age: 34 }, { id: 'anna', age: 32 }, { id: 'maf', age: 37 } ]) } const [a, b, c] = await db.getAll([ ['members', { id: 'maf' }], ['members', { id: 'anna' }], ['members', { id: 'andrew' }] ]) t.alike(a, { id: 'maf', age: 37 }) t.alike(b, { id: 'anna', age: 32 }) t.alike(c, { id: 'andrew', age: 34 }) await db.close() }) test('delete record', async function ({ create }, t) { const db = await create(definition) await db.insert('members', { id: 'maf', age: 34 }) await db.insert('members', { id: 'andrew', age: 34 }) await db.flush() await db.delete('members', { id: 'maf' }) { const result = await db.find('members').toArray() t.alike(result, [{ id: 'andrew', age: 34 }]) } { const result = await db.find('members/by-age', { gte: { age: 33 }, lt: { age: 99 } }).toArray() t.alike(result, [{ id: 'andrew', age: 34 }]) } await db.flush() { const result = await db.find('members').toArray() t.alike(result, [{ id: 'andrew', age: 34 }]) } { const result = await db.find('members/by-age', { gte: { age: 33 }, lt: { age: 99 } }).toArray() t.alike(result, [{ id: 'andrew', age: 34 }]) } t.alike(await db.get('members', { id: 'maf' }), null) t.alike(await db.get('members', { id: 'andrew' }), { id: 'andrew', age: 34 }) await db.close() }) test('generated full example', async function ({ create }, t) { const db = await create() await db.insert('@db/members', { id: 'maf', age: 34 }) await db.insert('@db/members', { id: 'andrew', age: 34 }) await db.insert('@db/members', { id: 'anna', age: 32 }) await db.flush() { const result = await db .find('@db/members-by-age', { gte: { age: 33 }, lt: { age: 99 } }) .toArray() t.alike(result, [ { id: 'andrew', age: 34 }, { id: 'maf', age: 34 } ]) } // // stop lying await db.insert('@db/members', { id: 'maf', age: 37 }) { const result = await db .find('@db/members-by-age', { gte: { age: 33 }, lt: { age: 99 } }) .toArray() t.alike(result, [ { id: 'andrew', age: 34 }, { id: 'maf', age: 37 } ]) } { const result = await db .find('@db/members-by-age', { gte: { age: 33 }, lt: { age: 99 } }, { reverse: true }) .toArray() t.alike(result, [ { id: 'maf', age: 37 }, { id: 'andrew', age: 34 } ]) } { const result = await db.find('@db/members').toArray() t.alike(result, [ { id: 'andrew', age: 34 }, { id: 'anna', age: 32 }, { id: 'maf', age: 37 } ]) } t.alike(await db.get('@db/members', { id: 'maf' }), { id: 'maf', age: 37 }) t.alike(await db.get('@db/members', { id: 'anna' }), { id: 'anna', age: 32 }) t.alike(await db.get('@db/members', { id: 'andrew' }), { id: 'andrew', age: 34 }) await db.close() }) test('generated delete record', async function ({ create }, t) { const db = await create() await db.insert('@db/members', { id: 'maf', age: 34 }) await db.insert('@db/members', { id: 'andrew', age: 34 }) await db.flush() await db.delete('@db/members', { id: 'maf' }) { const result = await db.find('@db/members').toArray() t.alike(result, [{ id: 'andrew', age: 34 }]) } { const result = await db .find('@db/members-by-age', { gte: { age: 33 }, lt: { age: 99 } }) .toArray() t.alike(result, [{ id: 'andrew', age: 34 }]) } await db.flush() { const result = await db.find('@db/members').toArray() t.alike(result, [{ id: 'andrew', age: 34 }]) } { const result = await db .find('@db/members-by-age', { gte: { age: 33 }, lt: { age: 99 } }) .toArray() t.alike(result, [{ id: 'andrew', age: 34 }]) } t.alike(await db.get('@db/members', { id: 'maf' }), null) t.alike(await db.get('@db/members', { id: 'andrew' }), { id: 'andrew', age: 34 }) await db.close() }) test('delete from memview', async function ({ create }, t) { const db = await create() await db.insert('@db/members', { id: 'maf', age: 34 }) await db.delete('@db/members', { id: 'maf' }) t.is(await db.get('@db/members', { id: 'maf' }), null) await db.close() }) test('watch', async function ({ create }, t) { t.plan(4) const db = await create() let changed = false db.watch(function () { changed = true }) await db.insert('@db/members', { id: 'maf', age: 34 }) await db.flush() t.ok(changed) changed = false // noop await db.insert('@db/members', { id: 'maf', age: 34 }) await db.flush() t.ok(!changed) changed = false // also noop await db.insert('@db/members', { id: 'maf2', age: 34 }) await db.delete('@db/members', { id: 'maf2' }) await db.flush() t.ok(!changed) changed = false await db.insert('@db/members', { id: 'maf3', age: 34 }) await db.flush() t.ok(changed) await db.close() // hack due to hc releasing something slowly, fix there await new Promise((resolve) => setTimeout(resolve, 1000)) }) test('basic reopen', async function ({ create }, t) { const storage = await tmp(t) { const db = await create(definition, { storage }) await db.insert('members', { id: 'maf', age: 34 }) await db.flush() await db.close() } { const db = await create(definition, { storage }) const all = await db.find('members').toArray() t.is(all.length, 1) await db.close() } }) test('cork/uncork', async function ({ create }, t) { const db = await create() db.cork() const all = [ db.insert('@db/members', { id: 'maf', age: 34 }), db.insert('@db/members', { id: 'andrew', age: 30 }) ] db.uncork() await Promise.all(all) t.pass('did not crash') await db.close() }) test('updates can be queryies', async function ({ create }, t) { const db = await create() t.is(db.updated(), false) await db.insert('@db/members', { id: 'maf', age: 50 }) t.is(db.updated(), true) t.is(db.updated('@db/members', { id: 'maf' }), true) await db.insert('@db/members', { id: 'maf', age: 50 }) t.is(db.updated(), true) t.is(db.updated('@db/members', { id: 'maf' }), true) await db.delete('@db/members', { id: 'maf' }) t.is(db.updated(), false) t.is(db.updated('@db/members', { id: 'maf' }), false) await db.close() }) test('changes - bee2', { bee2: true }, async function ({ create }, t) { const db = await create() if (!db.core) { t.comment('not supported on rocks') await db.close() return } await db.ready() if (!(db.engine.db instanceof Hyperbee)) { t.comment('only for bee2') await db.close() return } { const head = db.engine.head() await db.insert('@db/members', { id: 'maf', age: 50 }) await db.insert('@db/members', { id: 'andrew', age: 40 }) await db.flush() const ops = [] for await (const op of db.changes({ from: head })) ops.push(op) const latest = db.engine.head() t.alike(ops, [ { type: 'insert', head: latest, collection: '@db/members', value: { id: 'andrew', age: 40 } }, { type: 'insert', head: latest, collection: '@db/members', value: { id: 'maf', age: 50 } } ]) } { const head = db.engine.head() await db.delete('@db/members', { id: 'andrew' }) await db.flush() const ops = [] t.comment('deleted') for await (const op of db.changes({ from: head })) ops.push(op) const latest = db.engine.head() t.alike(ops, [ { type: 'delete', head: latest, collection: '@db/members', value: { id: 'andrew' } } ]) } await db.close() }) test('changes', { bee2: false }, async function ({ create }, t) { const db = await create() if (!db.core) { t.comment('not supported on rocks') await db.close() return } await db.insert('@db/members', { id: 'maf', age: 50 }) await db.insert('@db/members', { id: 'andrew', age: 40 }) await db.flush() let ops = [] for await (const op of db.changes()) ops.push(op) t.alike(ops, [ { type: 'insert', seq: 2, collection: '@db/members', value: { id: 'andrew', age: 40 } }, { type: 'insert', seq: 4, collection: '@db/members', value: { id: 'maf', age: 50 } } ]) await db.delete('@db/members', { id: 'andrew' }) await db.flush() ops = [] for await (const op of db.changes()) ops.push(op) t.alike(ops, [ { type: 'insert', seq: 2, collection: '@db/members', value: { id: 'andrew', age: 40 } }, { type: 'insert', seq: 4, collection: '@db/members', value: { id: 'maf', age: 50 } }, { type: 'delete', seq: 6, collection: '@db/members', value: { id: 'andrew' } } ]) ops = [] for await (const op of db.changes({ gt: 4 })) ops.push(op) t.alike(ops, [{ type: 'delete', seq: 6, collection: '@db/members', value: { id: 'andrew' } }]) await db.close() }) test('update does not break existing snaps', async function ({ create }, t) { const db = await create() await db.insert('@db/members', { id: 'maf', age: 50 }) await db.insert('@db/members', { id: 'andrew', age: 40 }) await db.flush() const ite = db.find('@db/members') db.update() const all = await ite.toArray() t.is(all.length, 2) await db.close() }) test('nested keys', { bee2: false }, async function ({ create, bee }, t) { const db = await create({ fixture: 4 }) await db.insert('@db/nested-members', { member: { id: 'maf', age: 50 }, fun: true }) await db.insert('@db/nested-members', { member: { id: 'andrew', age: 40 }, fun: false }) await db.flush() const all = await db.find('@db/nested-members').toArray() t.is(all.length, 2) const one = await db.get('@db/nested-members', { member: { id: 'maf' } }) t.alike(one, { member: { id: 'maf', age: 50 }, fun: true }) await db.delete('@db/nested-members', { member: { id: 'andrew' } }) await db.flush() if (bee) { t.comment('only test changes feed on bee engine') const ops = [] for await (const op of db.changes()) ops.push(op) t.alike(ops, [ { type: 'insert', seq: 1, collection: '@db/nested-members', value: { member: { id: 'andrew', age: 40 }, fun: false } }, { type: 'insert', seq: 2, collection: '@db/nested-members', value: { member: { id: 'maf', age: 50 }, fun: true } }, { type: 'delete', seq: 3, collection: '@db/nested-members', value: { member: { id: 'andrew' } } } ]) } await db.close() }) test('collection - register - missing nested keys', async function ({ build }, t) { t.plan(1) const db = await build(createDB) await db.close() function createDB(HyperDB, Hyperschema, paths) { const schema = Hyperschema.from(paths.schema) const example = schema.namespace('db') example.register({ name: 'bar', fields: [ { name: 'baz', type: 'string', required: true } ] }) example.register({ name: 'foo', fields: [ { name: 'bar', type: '@db/bar', required: true } ] }) Hyperschema.toDisk(schema) const db = HyperDB.from(paths.schema, paths.db) const exampleDB = db.namespace('db') t.exception( () => exampleDB.collections.register({ name: 'nonexistents', schema: '@db/foo', key: ['bar.nonexistent'] }), /Field not found: bar\.nonexistent/, 'Throws when given bad key' ) HyperDB.toDisk(db) } }) test('undo mutation without deletion', async function ({ create }, t) { const db = await create() await db.insert('@db/members', { id: 'maf', age: 50 }) await db.flush() await db.insert('@db/members', { id: 'maf', age: 40 }) await db.insert('@db/members', { id: 'maf', age: 50 }) await db.flush() const maf = await db.findOne('@db/members') t.alike(maf, { id: 'maf', age: 50 }) await db.close() }) test('basic example with booleans', async function ({ create }, t) { const db = await create({ fixture: 5 }) await db.insert('@db/members', { id: 'maf', present: true }) await db.insert('@db/members', { id: 'andrew', present: false }) await db.flush() { const result = await db .find('@db/members-by-present', { gte: { present: true }, lte: { present: true } }) .toArray() t.alike(result, [{ id: 'maf', present: true }]) } { const result = await db .find('@db/members-by-present', { gte: { present: false }, lte: { present: false } }) .toArray() t.alike(result, [{ id: 'andrew', present: false }]) } await db.close() }) test('read tracing', async function ({ create }, t) { const db = await create({ trace }) await db.insert('@db/members', { id: 'user1', age: 44 }) await db.insert('@db/members', { id: 'user2', age: 50 }) await db.insert('@db/members', { id: 'user3', age: 100 }) await db.flush() const collections = new Set() const names = new Set() await db.find('@db/members').toArray() t.is(names.size, 3) t.is(collections.size, 1) t.ok(names.has('user1')) t.ok(names.has('user2')) t.ok(names.has('user3')) t.ok(collections.has('@db/members')) await db.close() function trace(collection, record) { collections.add(collection) names.add(record.id) } }) test('no read tracing on transactions', async function ({ create }, t) { const db = await create({ trace }) const collections = new Set() const names = new Set() { const tx = db.transaction() await tx.insert('@db/members', { id: 'user1', age: 44 }) await tx.insert('@db/members', { id: 'user2', age: 50 }) await tx.insert('@db/members', { id: 'user3', age: 100 }) await tx.flush() } { const tx = db.transaction() await tx.find('@db/members').toArray() t.is(names.size, 0) t.is(collections.size, 0) await tx.close() } await db.close() function trace(collection, record) { collections.add(collection) names.add(record.id) } }) test('exclusive transactions', async function ({ create }, t) { const db = await create() { const tx = await db.exclusiveTransaction() await tx.insert('@db/members', { id: 'user1', age: 44 }) await tx.insert('@db/members', { id: 'user2', age: 50 }) await tx.insert('@db/members', { id: 'user3', age: 100 }) await tx.flush() } { const tx = await db.exclusiveTransaction() t.is((await tx.find('@db/members').toArray()).length, 3) await tx.close() } await db.close() }) test('enum as key type', async function ({ create, bee }, t) { const db = await create({ fixture: 6 }) const builder = require('./fixtures/generated/6/hyperschema') const { NotSpecified, Male, Female } = builder.getEnum('@db/gender') await db.insert('@db/members', { name: 'Doe', gender: NotSpecified }) await db.insert('@db/members', { name: 'John', gender: Male }) await db.insert('@db/members', { name: 'Jane', gender: Female }) await db.flush() { const john = await db.get('@db/members', { name: 'John', gender: Male }) t.alike(john, { name: 'John', gender: Male }) } { const females = await db .find('@db/members-by-gender', { lte: { gender: Female }, gte: { gender: Female } }) .toArray() t.alike(females, [{ name: 'Jane', gender: Female }]) } await db.close() }) test('flushing with pending insert/delete throws', async ({ create }, t) => { const db = await create(definition) // Insert record so that engines cannot immediately return previous value when inserting because it knows its blank, eg bee2 await db.insert('members', { id: 'sean', age: 37 }) await db.flush() { // Intentionally dont wait to force a pending insertion when flushing const p = db.insert('members', { id: 'maf', age: 34 }) await t.exception(db.flush(), /Insert\/delete in progress, refusing to commit/) await p } { // Intentionally dont wait to force a pending delete when flushing const p = db.delete('members', { id: 'maf' }) await t.exception(db.flush(), /Insert\/delete in progress, refusing to commit/) await p } await db.close() })