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 Unit
Run 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.