Abstract The class that the code will be operating on.
Constructor
GeoPackageConnection object
Optional tableName: stringtableName
Readonly dbDatabase connection to the sqlite file
Readonly geoGeoPackage
Name of the table within the GeoPackage
ID 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
Abstract createQueries 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
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
Iterate all objects in thet able that match the ColumnValues passed in
ColumnValues to query for
Abstract queryQueries 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
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
Update all rows that match the query
number of objects updated
Generated using TypeDoc
Abstract GeoPackage DAO