Is it possible to output more info when "Assertion Failed"? about dexie.js HOT 7 OPEN

Here's the initialization:

class SetListDb extends Dexie {
	public metaNames: Dexie.Table<MetaNames, number>;
	public tunes: Dexie.Table<Tune, number>;
	public lists: Dexie.Table<List, number>;
	public tunesInLists: Dexie.Table<TuneInList, [number, number, number]>;
	constructor(name: string, options?: any) {
		super(name, options);
		this.version(2).stores({
			tunes: '@id, name, abc, leader, roadMap, countOff, key, bpm',
			lists: '@id, name',
			tunesInLists: '[tuneId+listId+order],tuneId,listId,order',
			metaNames: '@id, tabTitle'
		});
		this.metaNames = this.table('metaNames');
		this.tunes = this.table('tunes');
		this.lists = this.table('lists');
		this.tunesInLists = this.table('tunesInLists');
	}
}

And the model:

export class MetaNames {
	tabTitle: string;
    constructor(name:string) {}
}

export class Tune {
    id:number;
    name: string;
	abc: string;
	leader: string;
	roadMap: string;
	countOff: string;
	key: string;
	tempo: string;
    lists: List[];
	order?: number;
    constructor(name:string) {this.name = name}
}

export class List {
    id:number;
    name: string;
    tunes:Tune[];
    constructor(name:string) {this.name=name}
}

export class TuneInList {
	id?: number;
	tuneId: number;
	listId: number;
	order: number;
	constructor() {}
}

from dexie.js.

Yes! can confirm - it works. And I ran npx dexie-cloud@latest export all-data.json and all the data is there.

from dexie.js.

One thing that would give me a little clue is if I could see what is stored on the cloud for my account. Is there a way to dump that out? Or is the a "Dashboard" website I could log into? If the problem were data-related I can try to remove that record and see if the rest works.

I'll try to delete my indexedDB and put records in one at a time and see if I get a pattern. I don't have time today for that, though.

from dexie.js.

Thanks for the log printouts - seems as the problem is related a table with compound primary keys but the keys are not arrays as expected but plain strings. This could indicate a bug in dexie-cloud. I'll see if I can reproduce the issue from your database if I get a chance tomorrow. You can export everything to a JSON file if that would help using npx dexie-cloud@latest export. Compound primary keys are stored as JSON strings and it might be a problem with that. I might get wiser after looking into your db.

An admin dashboard with database and subscription management is under development as the last part before the service goes into production in the end of the summer. For now, it's only npx dexie-cloud export and the REST API available to inspect what's stored in the cloud.

from dexie.js.

all-data.txt

That is what export gives me - but did you want the contents of indexedDB instead? That is much larger.

from dexie.js.

A little more info:

I split the writes into sections and I successfully wrote all the MetaNames, Tunes, and Lists. That synced up properly.

But when I went to write TuneInList it started failing. That is doing a many-to-many relationship.

from dexie.js.

I found the issue and it's really a bug occurring when client is about to sync a table with inbound compound keys. I've released a new version with "test" tag for you to try out:

npm i [email protected]

Let me know if this fixes it.

Another thing I noticed is that the typings for IDs in your code are all numbers while they really should be strings ('@'-keys) and the relation table should be:

export class TuneInList {
        //id?: number; not there!
	tuneId: string; // not number
	listId: string; // not number
	order: number;
	constructor() {}
}

Please try out the fix and let me know if everything is working properly with it.

from dexie.js.