Yoga.BunSQLite.BunSQLite

data Database

data Statement

newtype DatabasePath

Constructors

• DatabasePath String

Instances

• Newtype DatabasePath _
• Show DatabasePath

inMemory :: DatabasePath

Special in-memory database path

openImpl :: EffectFn1 String Database

closeImpl :: EffectFn1 Database Unit

runImpl :: EffectFn2 String Database Unit

queryImpl :: EffectFn2 String Database (Array Foreign)

prepareImpl :: EffectFn2 String Database Statement

stmtRunImpl :: EffectFn2 (Array Foreign) Statement Unit

stmtGetImpl :: EffectFn2 (Array Foreign) Statement (Nullable Foreign)

stmtAllImpl :: EffectFn2 (Array Foreign) Statement (Array Foreign)

stmtFinalizeImpl :: EffectFn1 Statement Unit

open :: DatabasePath -> Effect Database

Open a database connection

close :: Database -> Effect Unit

Close a database connection

run :: String -> Database -> Effect Unit

Run SQL directly (for DDL/DML without results)

query :: String -> Database -> Effect (Array Foreign)

Query directly (for simple queries)

prepare :: String -> Database -> Effect Statement

Prepare a statement

stmtRun :: Array Foreign -> Statement -> Effect Unit

Run a prepared statement (INSERT/UPDATE/DELETE)

stmtGet :: Array Foreign -> Statement -> Effect (Maybe Foreign)

Get a single row from a prepared statement

stmtAll :: Array Foreign -> Statement -> Effect (Array Foreign)

Get all rows from a prepared statement

stmtFinalize :: Statement -> Effect Unit

Finalize a prepared statement