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
Creates a object from the result
Optional results: 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
Checks if the ID exists
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
Query for MetaadataReference using the key
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
Metadata Reference Data Access Object