AbsaOSS / AbsaOSS/balta

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

Aperta
#84 0 commenti 1 reazione 0 assegnatari Vedi su GitHub
enhancement
Lingua principale
Scala
Stelle
3
Fork
2
Merge medio
14h 48m
PR unite (30g)
1

Descrizione

### 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_

Guida per i contributori

Nessuna guida per i contributori indicizzata per questo repository

Valutazione

Questa issue non è ancora stata valutata.

Ricevi le nuove issue nella tua casella

Un breve riepilogo di issue GitHub adatte ai principianti.