Gleipnir/mechaturk

Validate users are known through SSO when making assignments #4

New issue

Open

opened 2026-06-25 15:41:27 +00:00 by eliribble · 1 comment

eliribble commented

2026-06-25 15:41:27 +00:00

Owner

Right now the code allows people to be assigned by name. If you misspell someone's name, you can still make the assignment, but it's not clear if the person will get the task. Instead we should ensure that assignments are made to users that have logged in through SSO at some point.

We probably should use a database-level foreign-key to ensure this is so when making assignments.

Right now the code allows people to be assigned by name. If you misspell someone's name, you can still make the assignment, but it's not clear if the person will get the task. Instead we should ensure that assignments are made to users that have logged in through SSO at some point. We probably should use a database-level [foreign-key](https://www.reddit.com/r/SQL/comments/qras0z/please_explain_foreign_keys_to_me_like_i_am_six/) to ensure this is so when making assignments.

williamribble commented

2026-06-26 02:41:41 +00:00

I agree with the ussage of a foreign key, but I think we should talk about the actual structure of the app first

I agree with the ussage of a foreign key, but I think we should talk about the actual structure of the app first

Sign in to join this conversation.

No labels

No milestone

No project

No assignees

2 participants

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference

Gleipnir/mechaturk#4

No description provided.