codenotary / immugw

Apache License 2.0
23 stars 4 forks source link

Add transaction support to Immugw #31

Open NikitaSmall opened 1 year ago

NikitaSmall commented 1 year ago

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.