Class GenericSQLVirtualServerModel

JavaScript-facing DuckDB SQL query builder.

This struct wraps the Rust DuckDBSqlBuilder and exposes it to JavaScript via wasm_bindgen.

Index

Constructors

Methods

[dispose] free getHostedTables tableMakeView tableSchema tableSize tableValidateExpression viewColumnSize viewDelete viewGetData viewSchema viewSize

Constructors

constructor

new GenericSQLVirtualServerModel(args?: any): GenericSQLVirtualServerModel
Creates a new JsDuckDBSqlBuilder instance.
Parameters
- Optionalargs: any
Returns GenericSQLVirtualServerModel
- Defined in rust/perspective-js/dist/wasm/perspective-js.d.ts:235

Methods

[dispose]

"[dispose]"(): void
Returns void
- Defined in rust/perspective-js/dist/wasm/perspective-js.d.ts:227

free

free(): void
Returns void
- Defined in rust/perspective-js/dist/wasm/perspective-js.d.ts:226

getHostedTables

getHostedTables(): string
Returns the SQL query to list all hosted tables.

Returns string
- Defined in rust/perspective-js/dist/wasm/perspective-js.d.ts:231

tableMakeView

tableMakeView(table_id: string, view_id: string, config: any): string
Returns the SQL query to create a view from a table with the given configuration.
Parameters
- table_id: string
- view_id: string
- config: any
Returns string
- Defined in rust/perspective-js/dist/wasm/perspective-js.d.ts:240

tableSchema

tableSchema(table_id: string): string
Returns the SQL query to describe a table's schema.
Parameters
- table_id: string
Returns string
- Defined in rust/perspective-js/dist/wasm/perspective-js.d.ts:244

tableSize

tableSize(table_id: string): string
Returns the SQL query to get the row count of a table.
Parameters
- table_id: string
Returns string
- Defined in rust/perspective-js/dist/wasm/perspective-js.d.ts:248

tableValidateExpression

tableValidateExpression(table_id: string, expression: string): string
Returns the SQL query to validate an expression against a table.
Parameters
- table_id: string
- expression: string
Returns string
- Defined in rust/perspective-js/dist/wasm/perspective-js.d.ts:252

viewColumnSize

viewColumnSize(view_id: string): string
Returns the SQL query to get the column count of a view.
Parameters
- view_id: string
Returns string
- Defined in rust/perspective-js/dist/wasm/perspective-js.d.ts:256

viewDelete

viewDelete(view_id: string): string
Returns the SQL query to delete a view.
Parameters
- view_id: string
Returns string
- Defined in rust/perspective-js/dist/wasm/perspective-js.d.ts:260

viewGetData

viewGetData(view_id: string, config: any, viewport: any, schema: any): string
Returns the SQL query to fetch data from a view with the given viewport.
Parameters
- view_id: string
- config: any
- viewport: any
- schema: any
Returns string
- Defined in rust/perspective-js/dist/wasm/perspective-js.d.ts:264

viewSchema

viewSchema(view_id: string): string
Returns the SQL query to describe a view's schema.
Parameters
- view_id: string
Returns string
- Defined in rust/perspective-js/dist/wasm/perspective-js.d.ts:268

viewSize

viewSize(view_id: string): string
Returns the SQL query to get the row count of a view.
Parameters
- view_id: string
Returns string
- Defined in rust/perspective-js/dist/wasm/perspective-js.d.ts:272