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
>