Module
QueryDsl.SQLite3
- Package
- purescript-querydsl
- Repository
- Dretch/purescript-querydsl
Allows running Querydsl queries against SQLite3 databases.
DateTime values are represented in the database as text columns in ISO8601 format (YYYY-MM-DDTHH:mm:ss.SSSZ)
#runQuery Source
runQuery :: forall q. Query q => DBConnection -> q -> Aff UnitRun a query and ignore any results.
#runSelectManyQuery Source
runSelectManyQuery :: forall cols. ConstantsToRecord cols => DBConnection -> SelectQuery cols -> Aff (Array (Record cols))Run a SelectQuery and return all the results.
#runSelectOneQuery Source
runSelectOneQuery :: forall cols. ConstantsToRecord cols => DBConnection -> SelectQuery cols -> Aff (Record cols)Run a SelectQuery and either return the single result, or throw an error
if there is more than one result or none at all.
#runSelectMaybeQuery Source
runSelectMaybeQuery :: forall cols. ConstantsToRecord cols => DBConnection -> SelectQuery cols -> Aff (Maybe (Record cols))Run a SelectQuery and either return Nothing, if there are no results,
Just result if there is a single result, or otherwise throw an error.