AbsaOSS / AbsaOSS/balta

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

未關閉
#84 0 則留言 1 個 reaction 已指派 0 人 在 GitHub 檢視
enhancement
主要語言
Scala
星號
3
分支
2
平均合併
14 小時 48 分鐘
30 天內合併 PR
1

描述

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

貢獻指南

這個儲存庫沒有索引到貢獻指南

評估

這個 Issue 還沒有評估資料。

把新 issue 寄到你的電子郵件信箱

精選適合新手參與的 GitHub issue 摘要。