codenotary / codenotary/immugw
Add transaction support to Immugw
- Dominant language
- Go
- Stars
- 27
- Forks
- 5
- PR merge metrics
- No merged PRs in 30d
Description
**What would you like to be added or enhanced**
Hi!
I would like to have the ability to run multiple queries and/or sqlexecs within a single ImmuDB transaction using Immugw. As I understand and as @jeroiraz confirmed, Immugw ability to use session-based authentication (openSession/closeSession) is missing.
**Why is this needed**
This feature is needed in order to support multiple changes, queries, and/or requests withing a single transaction, e.g. the ability to effectively commit or rollback the transaction.
**Additional context**
At this moment there is a hack to put multiple SQL requests into single sqlexec but that is suboptimal.
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by reviewing Immugw's existing sqlexec handling and the openSession/closeSession behavior mentioned in the issue. Define how multiple queries or sqlexecs share one transaction and how commit or rollback is exposed; done means session-based authentication supports those operations within a single transaction.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- go, sql
- Domain
- api, databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 25/100