Using a keyPath with unique: true

[nielsnl68]

In one of my table i use the following the column: unique: { keyPath: ['userID', 'date', 'time'], unique: true } but not sure of this should work, does it?

At the end, at this moment it dont work; you can insert double records with same userID, date and time.

[ujjwalguptaofficial]

what is the data type of userId, date & time ?

[nielsnl68]

this is the table:

 var metingen = {
        name: 'metingen',
        columns: {
            id: { primaryKey: true, autoIncrement: true },
            userID: { notNull: true, dataType: 'number' },
            date: { notNull: true, dataType: 'string' },
            time: { notNull: true, dataType: 'string' },
            unique: { keyPath: ['userID', 'datum', 'tijd'], unique: true }
        },
        alter: {

        }
    };

[nielsnl68]

userID is a reference to an other table.

[ujjwalguptaofficial]

ok, will check

[ujjwalguptaofficial]

@nielsnl68 it works. Your keypath is referencing wrong column - it should be like this :

  unique: {
                    keyPath: ['userID', 'date', 'time'],
                    unique: true
                }

I have also added test case for this, check this commit - d83cf92

[nielsnl68]

Oww ... that was a bad translation of me.. yes it should have been shown as you said. My mistake, i did not wanted to use the dutch naming but i forgot to change those in the unique.

for me it did not work. i got 2 records with the same values in my db.

[ujjwalguptaofficial]

how have you created this unique column ? i mean using alter or direct ? If using alter was it add or modify ?