JKHeadley/rest-hapi

Add "onDelete" option for associations

Open

#96 opened on Feb 18, 2018

View on GitHub
 (0 comments) (0 reactions) (0 assignees)JavaScript (1,181 stars) (156 forks)batch import
enhancementhelp wanted

Description

"RESTRICT"|"CASCADE"|"SET NULL" - specifies how foreign keys should behave when referenced object is deleted

Contributor guide

Tech stack
javascriptnodejsrest api
Domain
backenddatabase
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.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
stale
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
clear
Prerequisites
Basic knowledge of SQL foreign keysNode.js development setup
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
65
Research direction
Examine the association definition files in the repository to locate where foreign key constraints are currently handled. Look for existing options like 'onUpdate' and add a similar 'onDelete' option supporting 'RESTRICT', 'CASCADE', and 'SET NULL'. The change will likely be in the model generation or association configuration module, such as lib/models/associations.js.