Skip to content
This repository has been archived by the owner on May 28, 2022. It is now read-only.

Fix the database primary key value #634

Open
SRomansky opened this issue Oct 22, 2014 · 4 comments
Open

Fix the database primary key value #634

SRomansky opened this issue Oct 22, 2014 · 4 comments

Comments

@SRomansky
Copy link
Contributor

The database schema used to in the presentation table has a line
UNIQUE (Speaker, Title) ON CONFLICT IGNORE which makes the Speaker, Title combination behave similar to a primary key. However, no logging is done in the Qt Client or in the database when a user tries to insert a conflicting record.
The schema should be revisited. To either redfine the primary key or to modify the software to notify the user that their speaker-title-event combination is conflicting and that they should chose a different combination.

related #619

@dideler
Copy link
Member

dideler commented Oct 22, 2014

I'm not sure if we should have the speaker-title combo as a unique constraint. Speakers often give the same talk at different events. I think the database should allow two records to exist if the speaker and title are the same, but the event is different.

@SRomansky
Copy link
Contributor Author

Then the user interface should alert the user that they need to pick a different event name if they have a conflicting speaker-title combination?

@dideler
Copy link
Member

dideler commented Oct 25, 2014

That's an option, but it should be when there's a conflicting speaker-title-event combo.

@SRomansky
Copy link
Contributor Author

It looks like the title-speaker combination might be due to the talks_model object which uses a 'Speaker - Title' to define a 'talk'.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants