Struct ExportQuery 

pub struct ExportQuery { /* private fields */ }

Builder for constructing EXPORT SQL statements.

Exasol EXPORT statements transfer data from tables or queries to external destinations via HTTP transport using CSV format.

Implementations

impl ExportQuery

pub fn from_table(table: &str) -> Self

Create an export query from a table.

Arguments

• table - The name of the table to export from.

Example

pub fn from_query(sql: &str) -> Self

Create an export query from a SQL query.

Arguments

• sql - The SQL query whose results to export.

Example

pub fn schema(self, schema: &str) -> Self

Set the schema for a table export.

This method only has an effect when exporting from a table, not from a query.

Arguments

• schema - The schema name.

pub fn columns(self, cols: Vec<&str>) -> Self

Set the columns to export from a table.

This method only has an effect when exporting from a table, not from a query.

Arguments

• cols - The column names to export.

pub fn at_address(self, addr: &str) -> Self

Set the HTTP address for the export destination.

The protocol (http:// or https://) will be determined automatically based on whether a public key is set.

Arguments

• addr - The address in the format “host:port”.

pub fn with_public_key(self, fingerprint: &str) -> Self

Set the public key fingerprint for TLS encryption.

When set, the export will use HTTPS and include a PUBLIC KEY clause.

Arguments

• fingerprint - The SHA-256 fingerprint of the public key.

pub fn file_name(self, name: &str) -> Self

Set the output file name.

Default is “001.csv”. The compression extension will be appended automatically if compression is enabled.

Arguments

• name - The file name.

pub fn column_separator(self, sep: char) -> Self

Set the column separator character.

Default is ‘,’.

Arguments

• sep - The separator character.

pub fn column_delimiter(self, delim: char) -> Self

Set the column delimiter character.

Default is ‘“’.

Arguments

• delim - The delimiter character.

pub fn row_separator(self, sep: RowSeparator) -> Self

Set the row separator.

Default is LF (Unix-style line endings).

Arguments

• sep - The row separator.

pub fn encoding(self, enc: &str) -> Self

Set the character encoding.

Default is “UTF-8”.

Arguments

• enc - The encoding name.

pub fn null_value(self, val: &str) -> Self

Set a custom NULL value representation.

By default, NULL values are exported as empty strings.

Arguments

• val - The string to use for NULL values.

pub fn delimit_mode(self, mode: DelimitMode) -> Self

Set the delimit mode.

Default is Auto.

Arguments

• mode - The delimit mode.

pub fn compressed(self, compression: Compression) -> Self

Set the compression type.

The appropriate file extension will be added automatically.

Arguments

• compression - The compression type.

pub fn with_column_names(self, include: bool) -> Self

Set whether to include column names in the output.

Default is false.

Arguments

• include - Whether to include column names.

pub fn build(&self) -> String

Build the EXPORT SQL statement.

Returns

The complete EXPORT SQL statement as a string.

Trait Implementations

impl Clone for ExportQuery

fn clone(&self) -> ExportQuery

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for ExportQuery

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

Formats the value using the given formatter.