CodeYourFuture / CodeYourFuture/scot-min-imece

Use transactions when a series of queries are executed to complete a function

Open
#90 0 comments 0 reactions 0 assignees View on GitHub
enhancement
Dominant language
JavaScript
Stars
1
Forks
4
PR merge metrics
No merged PRs in 30d

Description

To perform the function of:

- adding a new profile
- editing an existing profile
- deleting a profile

multiple queries are executed on different tables (i.e. INSERT into profiles... + INSERT into profile_group...
These queries should be executed inside a transaction, in order to keep the database status consistent in case of failure of one of them.

See [this example](https://github.com/CodeYourFuture/scot-min-imece/commit/a6252b77083fdccf32f4d333489a9c11dea0c7fb)

Contributor guide

Open the contributing guide

Research direction

No source files, tests, or entry points are named in the issue. Trace the implementations for adding, editing, and deleting profiles, then compare their multi-table queries with the linked transaction example; done means a failure in any query leaves the database consistent.

Written by the indexing model from the issue text.

Assessment

Tech stack
javascript, sql
Domain
backend, databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.