yesodweb / yesodweb/persistent
Support for check constraints in `PersistFieldSql`
Open
Nobody has claimed this yet.
- Dominant language
- Haskell
- Stars
- 486
- Forks
- 306
- PR merge metrics
- No merged PRs in 30d
Description
When converting various types, particularly enums, to and from sql, the check constraint is a crucial part of the "sql type".
Adding a checkConstraint method to PersistFieldSql (default Nothing) that stores any associated check constraint which the auto migrator picks up on would be incredibly useful.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by locating the PersistFieldSql definition and the auto migrator path; the issue names no files or tests. Trace how SQL types are converted and how migration constraints are collected, then verify that an associated check constraint is preserved for enum and other relevant conversions.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- haskell, sql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 48/100