Db
Constructors
new Db()
new Db():
Db
Returns
Methods
buildQuery()
buildQuery(
connectionId,tableName):TableQueryBuilder
Creates TableQueryBuilder that can be used to construct sql queries.
Parameters
| Parameter | Type | Description |
|---|---|---|
connectionId | string | fully-qualified connection name (see [nqName]) |
tableName | string | database table name |
Returns
Source
query()
query(
connectionId,sql):Promise<DataFrame>
Executes a specified sql against the specified connectionId.
Parameters
| Parameter | Type | Description |
|---|---|---|
connectionId | string | fully-qualified connection name (see [nqName]) |
sql | string | SQL statement |
Returns
Promise <DataFrame>