codenotary / codenotary/immugw

Add transaction support to Immugw

Open
#31 0 comments 0 reactions 0 assignees View on GitHub
enhancement
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.