Module

Yoga.BunSQLite.TypedQuery

Package: purescript-yoga-bun-sqlite
Repository: rowtype-yoga/purescript-yoga-bun-sqlite

#sqlParamToForeign Source

sqlParamToForeign :: SQLParameter -> Foreign

Convert a SQLParameter to Foreign for Bun SQLite

#executeSql Source

executeSql :: forall @params @result. HFoldlWithIndex TurnIntoSQLParam (Map String SQLParameter) (Record params) (Map String SQLParameter) => ReadForeign result => SQLQuery params -> Record params -> Database -> Effect (Either String (Array result))

Execute a typed SQL query and parse results with yoga-json

#executeSqlOne Source

executeSqlOne :: forall @params @result. HFoldlWithIndex TurnIntoSQLParam (Map String SQLParameter) (Record params) (Map String SQLParameter) => ReadForeign result => SQLQuery params -> Record params -> Database -> Effect (Either String (Maybe result))

Execute a typed SQL query and return a single row

#executeMutation Source

executeMutation :: forall @params. HFoldlWithIndex TurnIntoSQLParam (Map String SQLParameter) (Record params) (Map String SQLParameter) => SQLQuery params -> Record params -> Database -> Effect Unit

Execute a mutation (INSERT/UPDATE/DELETE)

Modules: Yoga.BunSQLite.BunSQLite; Yoga.BunSQLite.TypedQuery