AbsaOSS / AbsaOSS/balta

Make it possible to run a custome SQL command from within a test

Open
#84 0 comments 1 reaction 0 assignees View on GitHub
enhancement
Dominant language
Scala
Stars
3
Forks
2
Avg merge
14h 48m
Merged PRs (30d)
1

Description

### Feature Description

Add (a) method(s) to `DBTestSuite` that will allow to execute a custom SQL code as part of the test.

(no need for parametrized queries support, at least yet)

### Problem / Opportunity

Sometimes a database test needs to run a different SQL than just interaction with table or calling a function.

### Acceptance Criteria

1. User of the library can run a custom SQL

### Proposed Solution

Add methods:
* `sql` that returns a result set, similar to table query or function call
* `ddl` that returns no results
* (possible) `dml`, that allows to modify data, returning the rows modified
* auto-adding RETURNING, if not present
* possible to call with verification as table query, or without

### Dependencies / Related

_No response_

### Additional Context

_No response_

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.