digitallyinduced/ihp

Create Validation function for UNIQUE constraint over multiple fields

Open

#877 opened on May 18, 2021

View on GitHub
 (2 comments) (0 reactions) (1 assignee)Haskell (221 forks)batch import
enhancementgood first issue

Repository metrics

Stars
 (5,285 stars)
PR merge metrics
 (Avg merge 11h 20m) (21 merged PRs in 30d)

Description

We are currently only able to validate that a single field is unique in its table. However, there are use-cases in which a pair or more of attributes should be unique inside the table. In SQL this can be expressed using a constraint such as:

ALTER TABLE recipes ADD CONSTRAINT recipes_unique_name_in_group UNIQUE (group_id, name);

It would be good if we had a function similar to validateIsUnique that validates this constraint.

Naming suggestions:

  • validateAreUnique
  • validateIsUniqueComposite
  • validateAreUniqueFields
  • validateIsUniqueSet

Contributor guide

Research direction
Examine the existing `validateIsUnique` function in IHP to understand its implementation. Then, design and implement a new function like `validateAreUnique` that accepts multiple fields and checks their combination for uniqueness in the database. Review SQL composite unique constraints for reference.
Tech stack
None
Domain
backendapi
Issue type
Feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
Half day
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
HaskellIHP basicsSQL
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
75