Struct GenericSQLVirtualServerModel 

pub struct GenericSQLVirtualServerModel(/* private fields */);

A stateless SQL query builder virtual server operations.

This struct generates SQL query strings without executing them, allowing the caller to execute the queries against a SQL connection.

Implementations

impl GenericSQLVirtualServerModel

pub fn new(args: GenericSQLVirtualServerModelArgs) -> Self

Creates a new GenericSQLVirtualServerModel instance.

pub fn get_hosted_tables(&self) -> GenericSQLResult<String>

Returns the SQL query to list all hosted tables.

Returns

SQL: SHOW ALL TABLES

pub fn table_schema(&self, table_id: &str) -> GenericSQLResult<String>

Returns the SQL query to describe a table’s schema.

Arguments

• table_id - The identifier of the table to describe.

Returns

SQL: DESCRIBE {table_id}

pub fn table_size(&self, table_id: &str) -> GenericSQLResult<String>

Returns the SQL query to get the row count of a table.

Arguments

• table_id - The identifier of the table.

Returns

SQL: SELECT COUNT(*) FROM {table_id}

pub fn view_column_size(&self, view_id: &str) -> GenericSQLResult<String>

Returns the SQL query to get the column count of a view.

Arguments

• view_id - The identifier of the view.

Returns

SQL: SELECT COUNT(*) FROM (DESCRIBE {view_id})

pub fn table_validate_expression( &self, table_id: &str, expression: &str, ) -> GenericSQLResult<String>

Returns the SQL query to validate an expression against a table.

Arguments

• table_id - The identifier of the table.
• expression - The SQL expression to validate.

Returns

SQL: DESCRIBE (SELECT {expression} FROM {table_id})

pub fn view_delete(&self, view_id: &str) -> GenericSQLResult<String>

Returns the SQL query to delete a view.

Arguments

• view_id - The identifier of the view to delete.

Returns

SQL: DROP TABLE IF EXISTS {view_id}

pub fn table_make_view( &self, table_id: &str, view_id: &str, config: &ViewConfig, ) -> GenericSQLResult<String>

Returns the SQL query to create a view from a table with the given configuration.

Arguments

• table_id - The identifier of the source table.
• view_id - The identifier for the new view.
• config - The view configuration specifying columns, group_by, split_by, etc.

Returns

SQL: CREATE TABLE {view_id} AS (...)

pub fn view_get_data( &self, view_id: &str, config: &ViewConfig, viewport: &ViewPort, schema: &IndexMap<String, ColumnType>, ) -> GenericSQLResult<String>

Returns the SQL query to fetch data from a view with the given viewport.

Arguments

• view_id - The identifier of the view.
• config - The view configuration.
• viewport - The viewport specifying row/column ranges.
• schema - The schema of the view (column names to types).

Returns

SQL: SELECT ... FROM {view_id} LIMIT ... OFFSET ...

pub fn view_schema(&self, view_id: &str) -> GenericSQLResult<String>

Returns the SQL query to describe a view’s schema.

Arguments

• view_id - The identifier of the view.

Returns

SQL: DESCRIBE {view_id}

pub fn view_size(&self, view_id: &str) -> GenericSQLResult<String>

Returns the SQL query to get the row count of a view.

Arguments

• view_id - The identifier of the view.

Returns

SQL: SELECT COUNT(*) FROM {view_id}

Trait Implementations

impl Clone for GenericSQLVirtualServerModel

fn clone(&self) -> GenericSQLVirtualServerModel

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for GenericSQLVirtualServerModel

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Default for GenericSQLVirtualServerModel

fn default() -> GenericSQLVirtualServerModel

Returns the “default value” for a type.