Module

Yoga.NodeSQLite.NodeSQLite

Package
purescript-yoga-node-sqlite
Repository
rowtype-yoga/purescript-yoga-node-sqlite

#Database Source

#Statement Source

#inMemory Source

inMemory :: DatabasePath

Special in-memory database path

#open Source

open :: DatabasePath -> Effect Database

Open a database connection

#close Source

close :: Database -> Effect Unit

Close a database connection

#exec Source

exec :: String -> Database -> Effect Unit

Execute SQL (for DDL/DML without results)

#prepare Source

prepare :: String -> Database -> Effect Statement

Prepare a statement

#run Source

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

Run a statement (INSERT/UPDATE/DELETE)

#get Source

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

Get a single row

#all Source

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

Get all rows

#finalize Source

finalize :: Statement -> Effect Unit

Finalize a statement