Skip to content
This repository was archived by the owner on Jan 10, 2023. It is now read-only.
This repository was archived by the owner on Jan 10, 2023. It is now read-only.

Error when trying to use persistentIndex(true) #260

@danbritt

Description

@danbritt

Version: 2.1.12

Using persistentIndex(true) causes an error when calling schemaBuilder.connect(), making it unusable since you can't get past that step.

Code to reproduce: (link to jsfiddle: https://jsfiddle.net/ouwgrdtn/3/)

/**
* Running this the first time will create the database and insert a record, 
* but there will be no data in the pk index table
*
* Running this the second time gives an error when calling connect()
*
* If you change it to persistentIndex(false), it works fine.
*/
var sb = lf.schema.create('test_db', 1);

sb.createTable('Asset')
  .addColumn('id', lf.Type.NUMBER)
  .addColumn('asset', lf.Type.STRING)
  .addPrimaryKey(['id'])
  .persistentIndex(true);
 console.log('schema builder created');

// Schema is defined, now connect to the database instance.
sb.connect().then(async function(testDb) {
  console.log('connect successful');
  let localTable = testDb.getSchema().table('Asset');
  await testDb
    .insertOrReplace()
    .into(localTable)
    .values([
    localTable.createRow({ id: Date.now(), asset: 'test' })
  ])
    .exec();
  console.log('insert successful');
});

Screenshot of console errors:
image

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions