Encapsulates the Quill query that deletes the instance of the case class with the given Id
from the database
Encapsulates the Quill query that returns all instances of the case class from the database
Encapsulates the Quill query that optionally returns the instance of the case class from the database with the given
Id
, or None
if not found.
Encapsulates the Quill query that inserts the given instance of the case class into the database, and returns the case class as it was stored, including any auto-increment fields.
Encapsulates the Quill query that updates the given instance of the case class into the database, and returns the entity.
Encapsulates the Quill query that updates the given instance of the case class into the database, and returns the entity. Throws an Exception if the case class was not previously persisted.
Always fetches from the database; bypass cache, useful for startup code.
Always fetches from the database; bypass cache, useful for startup code. See also CachedPersistence.findAll
Always fetches from the database; bypass cache, useful for startup code.
Always fetches from the database; bypass cache, useful for startup code. See also findById
Sanitizes and inserts caseClass
.
Sanitizes and inserts caseClass
.
Does not check to see if caseClass
was previously persisted
Searches by CaseClass.id
Searches by CaseClass.id
true if CaseClass
was removed (false if the CaseClass
was not defined prior)
This method only has relevance for Postgres databases; it ensures that the next autoInc
value is properly set when the app starts.
This method only has relevance for Postgres databases; it ensures that the next autoInc
value is properly set when the app starts.
Assumes that column named id
is present, and that $${ tableName }_id_seq
exists.
There is no harm in invoking this method of other types of databases,
because it does not do anything unless the database is Postgres.
https://stackoverflow.com/a/244265/553865 List sequences with
\ds
Sanitizes and updates caseClass
.
Sanitizes and updates caseClass
.
Does not check to see if caseClass
was previously persisted
Sanitizes and inserts or updates caseClass
Sanitizes and inserts or updates caseClass
Accesses the table for each query. You can use this abstract class to derive DAOs for case classes that must have direct access to the database so the case classes are not cached. You don't have to subclass
UnCachedPersistence
, but if you do then the DAOs for your cached domain objects will have the same interface as the DAOs for your uncached domain objects.