codenotary / codenotary/immudb
Unique constraint in SQL (immudb-py)
- Dominant language
- Go
- Stars
- 9k
- Forks
- 378
- Avg merge
- 3d 1h
- Merged PRs (30d)
- 3
Description
**What would you like to be added or enhanced**
Add UNIQUE constraint to SQL
**Why is this needed**
This will allow to create Candidate Keys within a relational table. (Something which is needed quite often in many cases)
**Additional context**
An example usage of Unique constraint would be:
``CREATE TABLE table1 (id INTEGER, title VARCHAR UNIQUE, active BOOLEAN NOT NULL, PRIMARY KEY id)``
Contributor guide
Research direction
Start by tracing the SQL CREATE TABLE path described in the issue and identify how column and table constraints are parsed and enforced. Review the existing SQL tests before deciding coverage. Done means UNIQUE constraints can be declared as shown and duplicate values are rejected consistently.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- go, sql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100