Module

Yoga.SQLite.SQLite

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

#DBConnection Source

data DBConnection

#Transaction Source

data Transaction

#Statement Source

data Statement t0 t1

#DatabasePath Source

newtype DatabasePath

Constructors

DatabasePath String

Instances

Newtype DatabasePath _
Show DatabasePath

#NumberOfChanges Source

newtype NumberOfChanges

Constructors

NumberOfChanges Int

Instances

Newtype NumberOfChanges _
Show NumberOfChanges

#RowId Source

newtype RowId

Constructors

RowId Int

Instances

Newtype RowId _
Show RowId

#openImpl Source

openImpl :: EffectFn1 String DBConnection

#closeImpl Source

closeImpl :: EffectFn1 DBConnection Unit

#execImpl Source

execImpl :: EffectFn3 String (Array SQLParameter) DBConnection Unit

#queryImpl Source

queryImpl :: EffectFn3 String (Array SQLParameter) DBConnection (Array (Array SQLResult))

#queryOneImpl Source

queryOneImpl :: EffectFn3 String (Array SQLParameter) DBConnection (Nullable (Array SQLResult))

#lastInsertRowIdImpl Source

lastInsertRowIdImpl :: EffectFn1 DBConnection Int

#beginTransactionImpl Source

beginTransactionImpl :: EffectFn1 DBConnection Transaction

#commitImpl Source

commitImpl :: EffectFn1 Transaction Unit

#rollbackImpl Source

rollbackImpl :: EffectFn1 Transaction Unit

#open Source

open :: DatabasePath -> Effect DBConnection

Open a database connection

#close Source

close :: DBConnection -> Effect Unit

Close a database connection

#exec Source

exec :: String -> Array SQLParameter -> DBConnection -> Effect Unit

Execute a statement (INSERT/UPDATE/DELETE)

#query Source

query :: String -> Array SQLParameter -> DBConnection -> Effect (Array (Array SQLResult))

Query for multiple rows

#queryOne Source

queryOne :: String -> Array SQLParameter -> DBConnection -> Effect (Maybe (Array SQLResult))

Query for a single row

#lastInsertRowId Source

lastInsertRowId :: DBConnection -> Effect Int

Get last inserted row ID

#beginTransaction Source

beginTransaction :: DBConnection -> Effect Transaction

Begin a transaction

#commit Source

commit :: Transaction -> Effect Unit

Commit a transaction

#rollback Source

rollback :: Transaction -> Effect Unit

Rollback a transaction

#PreparedStatement Source

newtype PreparedStatement :: forall k1 k2. k1 -> k2 -> Typenewtype PreparedStatement i o

Constructors

PreparedStatement { db :: DBConnection, sql :: String }

#prepare Source

prepare :: forall @i @o. String -> DBConnection -> Effect (Statement i o)

Prepare a statement

#InfoImpl Source

type InfoImpl = { changes :: Int, lastInsertRowid :: Nullable Int }

#Info Source

type Info = { changes :: NumberOfChanges, lastInsertRowid :: Maybe RowId }

#fromRowInfoImpl Source

fromRowInfoImpl :: InfoImpl -> Info

#run Source

run :: forall i. Array SQLParameter -> Statement i Void -> Effect Info

Run a statement (INSERT/UPDATE/DELETE)

#run_ Source

run_ :: Statement Void Void -> Effect Info

Run a statement with no parameters

#allRaw Source

allRaw :: forall i o. Array SQLParameter -> Statement i o -> Effect (Array (Array SQLResult))

Query all rows (raw results)

#all Source

all :: forall i @o. Array SQLParameter -> (Array SQLResult -> Either String o) -> Statement i o -> Effect (Either String (Array o))

Query all rows with result parsing

#all1 Source

all1 :: forall i o. Array SQLParameter -> (Array SQLResult -> Either String o) -> Statement i o -> Effect (Either String o)

Query exactly one row

#all_ Source

all_ :: forall o. Array SQLParameter -> Statement Void o -> Effect (Array (Array SQLResult))

Query all rows with no parameters

#StatementSource Source

type StatementSource = String

#statementSource Source

statementSource :: forall i o. Statement i o -> StatementSource

Modules: Yoga.SQLite.SQLite