Module

Yoga.SQLite.SQLite

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

#Connection Source

data Connection

#Transaction Source

data Transaction

#SQLiteValue Source

data SQLiteValue

#SQL Source

newtype SQL

Constructors

SQL String

Instances

#ToSQLiteValue Source

class ToSQLiteValue a  where

Members

toSQLiteValue :: a -> SQLiteValue

Instances

ToSQLiteValue String
ToSQLiteValue Int
ToSQLiteValue Number
ToSQLiteValue BigInt
ToSQLiteValue Boolean
ToSQLiteValue DateTime
(ToSQLiteValue a) => ToSQLiteValue (Maybe a)
ToSQLiteValue Foreign

#param Source

param :: forall a. ToSQLiteValue a => a -> Array SQLiteValue

#params Source

params :: forall a. ToSQLiteValue a => Array a -> Array SQLiteValue

#Row Source

type Row = Foreign

#QueryResult Source

type QueryResult = { columnTypes :: Array String, columns :: Array String, lastInsertRowid :: Maybe BigInt, rows :: Array Row, rowsAffected :: Int }

#QueryResultImpl Source

type QueryResultImpl = { columnTypes :: Array String, columns :: Array String, lastInsertRowid :: Nullable BigInt, rows :: Array Row, rowsAffected :: Int }

#fromQueryResultImpl Source

fromQueryResultImpl :: QueryResultImpl -> QueryResult

#SQLiteConfigImpl Source

type SQLiteConfigImpl :: Row Typetype SQLiteConfigImpl = (authToken :: String, concurrency :: Int, encryptionKey :: String, intMode :: String, syncInterval :: Number, syncUrl :: String, tls :: Boolean, url :: String)

#createClientImpl Source

createClientImpl :: forall opts. EffectFn1 (Record opts) Connection

#closeImpl Source

closeImpl :: EffectFn1 Connection Unit

#closedImpl Source

closedImpl :: EffectFn1 Connection Boolean

#protocolImpl Source

protocolImpl :: EffectFn1 Connection String

#queryImpl Source

queryImpl :: EffectFn3 Connection String (Array SQLiteValue) (Promise QueryResultImpl)

#queryOneImpl Source

queryOneImpl :: EffectFn3 Connection String (Array SQLiteValue) (Promise (Nullable Row))

#executeImpl Source

executeImpl :: EffectFn3 Connection String (Array SQLiteValue) (Promise Int)

#querySimpleImpl Source

querySimpleImpl :: EffectFn2 Connection String (Promise QueryResultImpl)

#executeSimpleImpl Source

executeSimpleImpl :: EffectFn2 Connection String (Promise Int)

#beginImpl Source

beginImpl :: EffectFn1 Connection (Promise Transaction)

#beginWithModeImpl Source

beginWithModeImpl :: EffectFn2 Connection String (Promise Transaction)

#commitImpl Source

commitImpl :: EffectFn1 Transaction (Promise Unit)

#rollbackImpl Source

rollbackImpl :: EffectFn1 Transaction (Promise Unit)

#txQueryImpl Source

txQueryImpl :: EffectFn3 Transaction String (Array SQLiteValue) (Promise QueryResultImpl)

#txQueryOneImpl Source

txQueryOneImpl :: EffectFn3 Transaction String (Array SQLiteValue) (Promise (Nullable Row))

#txExecuteImpl Source

txExecuteImpl :: EffectFn3 Transaction String (Array SQLiteValue) (Promise Int)

#txCloseImpl Source

txCloseImpl :: EffectFn1 Transaction Unit

#txClosedImpl Source

txClosedImpl :: EffectFn1 Transaction Boolean

#txBatchImpl Source

txBatchImpl :: EffectFn2 Transaction (Array BatchStatement) (Promise (Array QueryResultImpl))

#txExecuteMultipleImpl Source

txExecuteMultipleImpl :: EffectFn2 Transaction String (Promise Unit)

#BatchStatement Source

type BatchStatement = { args :: Array SQLiteValue, sql :: String }

#batchImpl Source

batchImpl :: EffectFn3 Connection (Array BatchStatement) String (Promise (Array QueryResultImpl))

#ReplicatedImpl Source

type ReplicatedImpl = { frame_no :: Number, frames_synced :: Number }

#Replicated Source

type Replicated = { frame_no :: Number, frames_synced :: Number }

#syncImpl Source

syncImpl :: EffectFn1 Connection (Promise (Nullable ReplicatedImpl))

#executeMultipleImpl Source

executeMultipleImpl :: EffectFn2 Connection String (Promise Unit)

#migrateImpl Source

migrateImpl :: EffectFn2 Connection (Array BatchStatement) (Promise (Array QueryResultImpl))

#pingImpl Source

pingImpl :: EffectFn1 Connection (Promise Boolean)

#dateTimeToStringImpl Source

dateTimeToStringImpl :: JSDate -> String

#f32VectorFromArrayImpl Source

f32VectorFromArrayImpl :: Array Number -> Foreign

#f32VectorFromArray Source

f32VectorFromArray :: Array Number -> Foreign

#f32VectorToArrayImpl Source

f32VectorToArrayImpl :: Foreign -> Array Number

#f32VectorToArray Source

f32VectorToArray :: Foreign -> Array Number

#f64VectorFromArrayImpl Source

f64VectorFromArrayImpl :: Array Number -> Foreign

#f64VectorFromArray Source

f64VectorFromArray :: Array Number -> Foreign

#f64VectorToArrayImpl Source

f64VectorToArrayImpl :: Foreign -> Array Number

#f64VectorToArray Source

f64VectorToArray :: Foreign -> Array Number

#sqlite Source

sqlite :: forall opts opts_. Union opts opts_ SQLiteConfigImpl => Record opts -> Effect Connection

#close Source

close :: Connection -> Effect Unit

#closed Source

closed :: Connection -> Effect Boolean

#protocol Source

protocol :: Connection -> Effect String

#ping Source

ping :: Connection -> Aff Boolean

#query Source

query :: SQL -> Array SQLiteValue -> Connection -> Aff QueryResult

#querySimple Source

querySimple :: SQL -> Connection -> Aff QueryResult

#queryOne Source

queryOne :: SQL -> Array SQLiteValue -> Connection -> Aff (Maybe Row)

#execute Source

execute :: SQL -> Array SQLiteValue -> Connection -> Aff Int

#executeSimple Source

executeSimple :: SQL -> Connection -> Aff Int

#batch Source

batch :: TransactionMode -> Array BatchStatement -> Connection -> Aff (Array QueryResult)

#sync Source

sync :: Connection -> Aff (Maybe Replicated)

#executeMultiple Source

executeMultiple :: String -> Connection -> Aff Unit

#migrate Source

migrate :: Array BatchStatement -> Connection -> Aff (Array QueryResult)

#TransactionMode Source

data TransactionMode

Constructors

Instances

Eq TransactionMode
Show TransactionMode

#transactionModeToString Source

transactionModeToString :: TransactionMode -> String

#begin Source

begin :: Connection -> Aff Transaction

#beginWithMode Source

beginWithMode :: TransactionMode -> Connection -> Aff Transaction

#commit Source

commit :: Transaction -> Aff Unit

#rollback Source

rollback :: Transaction -> Aff Unit

#txQuery Source

txQuery :: SQL -> Array SQLiteValue -> Transaction -> Aff QueryResult

#txQueryOne Source

txQueryOne :: SQL -> Array SQLiteValue -> Transaction -> Aff (Maybe Row)

#txExecute Source

txExecute :: SQL -> Array SQLiteValue -> Transaction -> Aff Int

#txClose Source

txClose :: Transaction -> Effect Unit

#txClosed Source

txClosed :: Transaction -> Effect Boolean

#txBatch Source

txBatch :: Array BatchStatement -> Transaction -> Aff (Array QueryResult)

#txExecuteMultiple Source

txExecuteMultiple :: String -> Transaction -> Aff Unit

#dateTimeToString Source

dateTimeToString :: JSDate -> String

Modules: Yoga.SQLite.SQLite; Yoga.SQLite.Schema