Constructor
GeoPackage object this dao belongs to
Readonly dbDatabase connection to the sqlite file
Readonly geoGeoPackage
Readonly gpkgName of the table within the GeoPackage
Readonly idID Columns for this DAO
Builds a where args array
argument values to push
Build where or selection statement for fields
where clause
columns and values
Optional operation: string = 'and'AND or OR
Builds a where args array
argument values to push
Build where (or selection) LIKE statement for fields
where clause
columns and values
Optional operation: stringAND or OR
Builds a where clause from the field and value with an optional operation. If the value is empty, 'is null' is added to the query for the field
where clause
field name
Optional value: DBValueoptional value to filter on
Optional operation: string = '='optional operation
Count rows in the table optionally filtered by the parameters specified
count of objects
Optional fields: string | FieldValuesEither a ColumnValues object or a string specifying a field name
Optional value: DBValuevalue to filter on if fields is a string
Insert the object into the table
id of the inserted object
object to be inserted
Create an extended relations object
Optional result: Record<string, DBValue>Queries for the object by id, and if it exists, updates it, otherwise creates a new object
number of objects modified
object to update or create
Delete the object passed in. Object is deleted by id
number of objects deleted
object to delete
Get all relations for the given base table name
base table name
Get all relations for the base table with the relation name
base table name
relation name
Get all relations for the given related table name
related table name
Get the relations matching the non null provided values
extended relations
Optional baseTable: stringbase table name
Optional baseColumn: stringbase primary column name
Optional relatedTable: stringrelated table name
Optional relatedColumn: stringrelated primary column name
Optional relation: stringrelation name
Optional mappingTable: stringmapping table name
Get all relations to the table. Returns relations where the table is the base table and relations where the table is the related table.
table name to query for
Get all relations by the mapping table name
name of the mapping table
Queries for all matches and returns them in the callback. Be aware this pulls all results into memory
raw object array from the database
Optional where: stringOptional where clause
Optional whereArgs: DBValue[]Optional where args array
Queries for all matches and returns them in the callback. Be aware this pulls all results into memory
raw object array from the database
Optional where: stringOptional where clause
Optional whereArgs: DBValue[]Optional where args array
Query for all rows in the table that match
array of raw database objects
field to match
value to match
Optional groupBy: stringgroup by clause
Optional having: stringhaving clause
Optional orderBy: stringorder by clause
Queries for all items in the table with a page size and page number
raw object array from the database
size of the chunk to query for
chunk number to query for
Queries for all matches and returns them. Only queries for the specified column name Be aware this pulls all results into memory
raw object array from the database
name of the column to query for
Optional fieldValues: FieldValuesoptional values to filter on
Iterate all items in the table one at a time. If no parameters are passed, iterates the entire table. Returns an Iterable object
iterable of database objects
Optional field: stringfield to filter on
Optional value: DBValuevalue to filter on
Optional groupBy: stringgroup by clause
Optional having: stringhaving clause
Optional orderBy: stringorder by clause
Optional columns: string[]columns to retrieve
Query for equal
Iterate all objects in thet able that match the ColumnValues passed in
ColumnValues to query for
Query for object by id
object created from the raw database object
ID of the object to query for
Queries for all matches and returns them in the callback. Be aware this pulls all results into memory
raw object array from the database
name of the field to query for
value of the like clause
Query for object by multi id
object created from the raw database object
ColumnValues with the multi id
Iterate all matching objects
join clause
Optional where: stringwhere clause
Optional whereArgs: DBValue[]array of where query values
Optional columns: string[]columns to query for
Iterate all matching rows
Optional where: stringwhere clause
Optional whereArgs: DBValue[]array of where query values
Optional groupBy: stringgroup by clause
Optional having: stringhaving clause
Optional orderBy: stringorder by clause
Optional limit: numberlimit clause
Iterate all distinct matching rows in the table
where clause
Optional whereArgs: DBValue[]array of where query values
Refreshes the object by id
object to refresh
Update the object specified
number of objects updated
object with updated values
Update all rows that match the query
number of objects updated
Static createGenerated using TypeDoc
Extended Relations Data Access Object