Class AttributesResultSet

Attributes Result Set to wrap a database ResultSet for attributes queries

Hierarchy

UserResultSet<AttributesColumn, AttributesTable, AttributesRow>
- AttributesResultSet

Constructors

`Protected` constructor

new AttributesResultSet(table: AttributesTable, columns: string[] | UserColumns<AttributesColumn>, resultSet: ResultSet, sql: string, selectionArgs: DBValue[]): AttributesResultSet
Protected
Constructor
Parameters
- table: AttributesTable
- columns: string[] | UserColumns<AttributesColumn>
- resultSet: ResultSet
- sql: string
- selectionArgs: DBValue[]
Returns AttributesResultSet
Overrides UserResultSet.constructor
- Defined in lib/attributes/attributesResultSet.ts:23

Properties

`Protected` resultSet

resultSet: ResultSet

Result Set

Methods

[iterator]

[iterator](): IterableIterator<AttributesRow>
Returns IterableIterator<AttributesRow>
Inherited from UserResultSet.[iterator]
- Defined in lib/user/userResultSet.ts:224

close

close(): void
Inherit Doc

Returns void
Inherited from UserResultSet.close
- Defined in lib/db/resultSetResult.ts:156

getBuffer

getBuffer(columnName: string): Buffer
Returns the value of the requested column as a byte array.

Returns
bytes value
Parameters
- columnName: string
  
  column name
Returns Buffer
Inherited from UserResultSet.getBuffer
- Defined in lib/db/resultSetResult.ts:132

getColumnCount

getColumnCount(): number
Get the number of columns

Returns
column count

Returns number
Inherited from UserResultSet.getColumnCount
- Defined in lib/db/resultSetResult.ts:80

getColumnNames

getColumnNames(): string[]
Get the name of the columns

Returns
column names

Returns string[]
Inherited from UserResultSet.getColumnNames
- Defined in lib/db/resultSetResult.ts:93

getColumns

getColumns(): AttributesColumns
Get the columns

Returns
columns

Returns AttributesColumns
Overrides UserResultSet.getColumns
- Defined in lib/attributes/attributesResultSet.ts:43

getCount

getCount(): number
Get a count of the records in this result set

Returns
count

Returns number
Inherited from UserResultSet.getCount
- Defined in lib/user/userResultSet.ts:213

getId

getId(): number
Get the id

Returns
the id

Returns number
Inherited from UserResultSet.getId
- Defined in lib/user/userResultSet.ts:123

getNumber

getNumber(columnName: string): number
Returns the value of the requested column as an int.

Returns
int value
Parameters
- columnName: string
  
  column name
Returns number
Inherited from UserResultSet.getNumber
- Defined in lib/db/resultSetResult.ts:119

getResultSet

getResultSet(): ResultSet
Get the Result Set

Returns
result set

Returns ResultSet
Inherited from UserResultSet.getResultSet
- Defined in lib/db/resultSetResult.ts:30

getRow

getRow(): AttributesRow
Get the row

Returns
row

Returns AttributesRow
Inherited from UserResultSet.getRow
- Defined in lib/user/userResultSet.ts:188

getRowWithColumnTypesAndValues

getRowWithColumnTypesAndValues(columnTypes: number[], values: DBValue[]): AttributesRow
Get the row with provided column types and values

Returns
a user row
Parameters
- columnTypes: number[]
- values: DBValue[]
Returns AttributesRow
Overrides UserResultSet.getRowWithColumnTypesAndValues
- Defined in lib/attributes/attributesResultSet.ts:36

getSelectionArgs

getSelectionArgs(): any[]
Get the sql arguments

Returns
args

Returns any[]
Inherited from UserResultSet.getSelectionArgs
- Defined in lib/user/userResultSet.ts:254

getSql

getSql(): string
Get the sql

Returns
sql

Returns string
Inherited from UserResultSet.getSql
- Defined in lib/user/userResultSet.ts:246

getString

getString(columnName: string): string
Returns the value of the requested column as a String.

Returns
string value
Parameters
- columnName: string
  
  column name
Returns string
Inherited from UserResultSet.getString
- Defined in lib/db/resultSetResult.ts:106

getTable

getTable(): AttributesTable
Get the table

Returns
table

Returns AttributesTable
Inherited from UserResultSet.getTable
- Defined in lib/user/userResultSet.ts:164

getTableName

getTableName(): string
Get the table name

Returns
table name

Returns string
Inherited from UserResultSet.getTableName
- Defined in lib/user/userResultSet.ts:172

getValue

getValue(columnName: string, dataType?: GeoPackageDataType): any
Get the value
Parameters
- columnName: string
- Optional dataType: GeoPackageDataType
Returns any
Inherited from UserResultSet.getValue
- Defined in lib/db/resultSetResult.ts:40

getValueForColumn

getValueForColumn(column: AttributesColumn): any
Gets the value for a given column

Returns
Parameters
- column: AttributesColumn
Returns any
Inherited from UserResultSet.getValueForColumn
- Defined in lib/user/userResultSet.ts:97

getValueForColumnName

getValueForColumnName(columnName: string): any
Get the value for a given column name

Returns
Parameters
- columnName: string
Returns any
Inherited from UserResultSet.getValueForColumnName
- Defined in lib/user/userResultSet.ts:115

getValueForIndex

getValueForIndex(index: number): any
Gets the value for a given index

Returns
Parameters
- index: number
Returns any
Inherited from UserResultSet.getValueForIndex
- Defined in lib/user/userResultSet.ts:106

getValueWithIndex

getValueWithIndex(columnIdx: number): any
Gets the value at the index provided
Parameters
- columnIdx: number
Returns any
Inherited from UserResultSet.getValueWithIndex
- Defined in lib/db/resultSetResult.ts:53

ids

ids(): IterableIterator<number>
Get an iterator for id values

Returns IterableIterator<number>
Inherited from UserResultSet.ids
- Defined in lib/user/userResultSet.ts:279

moveToNext

moveToNext(): boolean
Move the cursor to the next row.

Returns
true if another row

Returns boolean
Inherited from UserResultSet.moveToNext
- Defined in lib/db/resultSetResult.ts:67

next(): {
done: boolean;
value: AttributesRow;
}
Returns {
done: boolean;
value: AttributesRow;
}
- done: boolean
- value: AttributesRow
Inherited from UserResultSet.next
- Defined in lib/user/userResultSet.ts:228

wasNull

wasNull(): boolean
Was the last value retrieved null

Returns
true if was null

Returns boolean
Inherited from UserResultSet.wasNull
- Defined in lib/db/resultSetResult.ts:145

Class AttributesResultSet

Hierarchy

Index

Constructors

Properties

Methods

Constructors

Protected constructor

Parameters

table: AttributesTable

columns: string[] | UserColumns<AttributesColumn>

resultSet: ResultSet

sql: string

selectionArgs: DBValue[]

Returns AttributesResultSet

Properties

Protected resultSet

Methods

[iterator]

Returns IterableIterator<AttributesRow>

close

Inherit Doc

Returns void

getBuffer

Returns

Parameters

columnName: string

Returns Buffer

getColumnCount

Returns

Returns number

getColumnNames

Returns

Returns string[]

getColumns

Returns

Returns AttributesColumns

getCount

Returns

Returns number

getId

Returns

Returns number

getNumber

Returns

Parameters

columnName: string

Returns number

getResultSet

Returns

Returns ResultSet

getRow

Returns

Returns AttributesRow

getRowWithColumnTypesAndValues

Returns

Parameters

columnTypes: number[]

values: DBValue[]

Returns AttributesRow

getSelectionArgs

Returns

Returns any[]

getSql

Returns

Returns string

getString

Returns

Parameters

columnName: string

Returns string

getTable

Returns

Returns AttributesTable

getTableName

Returns

Returns string

getValue

Parameters

columnName: string

`Protected` constructor

`Protected` resultSet

`Optional` dataType: GeoPackageDataType

Returns {
done: boolean;
value: AttributesRow;
}