veeso / ic-dbms / 37647333643

95%

Build Type

push

github

Committed by web-flow

Commit Message

feat(canister): expose sql through canister endpoints (#8)

Add an opt-in sql feature to ic-dbms-canister. With it, the DbmsCanister derive generates an sql update endpoint and an sql_query query endpoint that run statements through wasm-dbms-sql. Both take an optional transaction id. Statements are checked against the access control list with the same rules as the typed endpoints, tables reserved for ic-dbms are hidden from SQL, and BEGIN, COMMIT and ROLLBACK go through the transaction ownership ledger. sql_query refuses every statement that is not a SELECT. ic-dbms-api gains the IcDbmsError::Sql variant and ic-dbms-client gains Client::sql and Client::sql_query behind sql features. A new guide documents the feature.

closes #2

Coverage Stats

22 of 22 new or added lines in 1 file covered. (100.0%)

1 existing line in 1 file now uncovered.

1641 of 1727 relevant lines covered (95.02%)

14.54 hits per line