Yoga.NodeSQLite.NodeSQLite

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

execImpl :: EffectFn2 String Database Unit

prepareImpl :: EffectFn2 String Database Statement

runImpl :: EffectFn2 (Array Foreign) Statement Unit

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

allImpl :: EffectFn2 (Array Foreign) Statement (Array Foreign)

finalizeImpl :: EffectFn1 Statement Unit

open :: DatabasePath -> Effect Database

Open a database connection

close :: Database -> Effect Unit

Close a database connection

exec :: String -> Database -> Effect Unit

Execute SQL (for DDL/DML without results)

prepare :: String -> Database -> Effect Statement

Prepare a statement

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

Run a statement (INSERT/UPDATE/DELETE)

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

Get a single row

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

Get all rows

finalize :: Statement -> Effect Unit

Finalize a statement