Database.Sqlite.Easy.Internal

Connection

newtype ConnectionString

A SQLite3 connection string

Constructors

ConnectionString

Fields

• unConnectionString :: Text

Instances

IsString ConnectionString

Defined in Database.Sqlite.Easy.Internal

Methods

fromString :: String -> ConnectionString

Show ConnectionString

Defined in Database.Sqlite.Easy.Internal

Methods

showsPrec :: Int -> ConnectionString -> ShowS

show :: ConnectionString -> String

showList :: [ConnectionString] -> ShowS

createSqlitePool :: ConnectionString -> IO (Pool Database)

Create a pool of a sqlite3 db with a specific connection string.

withDb :: ConnectionString -> (Database -> IO a) -> IO a

Open a database, run some stuff, close the database.

Execution

newtype SQL

A SQL statement

Constructors

SQL

Fields

• unSQL :: Text

Instances

IsString SQL

Defined in Database.Sqlite.Easy.Internal

Methods

fromString :: String -> SQL

Semigroup SQL

Defined in Database.Sqlite.Easy.Internal

Methods

(<>) :: SQL -> SQL -> SQL

sconcat :: NonEmpty SQL -> SQL

stimes :: Integral b => b -> SQL -> SQL

Show SQL

Defined in Database.Sqlite.Easy.Internal

Methods

showsPrec :: Int -> SQL -> ShowS

show :: SQL -> String

showList :: [SQL] -> ShowS

run :: SQL -> Database -> IO [[SQLData]]

Run a SQL statement on a database and fetch the results.

runWith :: SQL -> [SQLData] -> Database -> IO [[SQLData]]

Run a SQL statement with certain parameters on a database and fetch the results.

fetchAll :: Statement -> IO [[SQLData]]

Run a statement and fetch all of the data.

Transaction

asTransaction :: Typeable a => Database -> IO a -> IO a

Run operations as a transaction. If the action throws an error, the transaction is rolled back.

Note: Transactions do not nest.

For more information, visit: https://www.sqlite.org/lang_transaction.html

asTransaction' :: Database -> IO a -> IO a

cancelTransaction :: Typeable a => a -> IO a

Cancel a transaction by supplying the return value. To be used inside transactions.

data CancelTransaction a

Constructors

CancelTransaction a

Instances

Typeable a => Exception (CancelTransaction a)

Defined in Database.Sqlite.Easy.Internal

Methods

toException :: CancelTransaction a -> SomeException

fromException :: SomeException -> Maybe (CancelTransaction a)

displayException :: CancelTransaction a -> String

Show (CancelTransaction a)

Defined in Database.Sqlite.Easy.Internal

Methods

showsPrec :: Int -> CancelTransaction a -> ShowS

show :: CancelTransaction a -> String

showList :: [CancelTransaction a] -> ShowS