Enum datafusion_sql::TableReference

pub enum TableReference<'a> {
    Bare {
        table: Cow<'a, str>,
    },
    Partial {
        schema: Cow<'a, str>,
        table: Cow<'a, str>,
    },
    Full {
        catalog: Cow<'a, str>,
        schema: Cow<'a, str>,
        table: Cow<'a, str>,
    },
}

TableReferences represent a multi part identifier (path) to a table that may require further resolution.

Creating TableReference

When converting strings to TableReferences, the string is parsed as though it were a SQL identifier, normalizing (convert to lowercase) any unquoted identifiers.

See TableReference::bare to create references without applying normalization semantics

Examples

// Get a table reference to 'mytable'
let table_reference = TableReference::from("mytable");
assert_eq!(table_reference, TableReference::bare("mytable"));

// Get a table reference to 'mytable' (note the capitalization)
let table_reference = TableReference::from("MyTable");
assert_eq!(table_reference, TableReference::bare("mytable"));

// Get a table reference to 'MyTable' (note the capitalization) using double quotes
// (programatically it is better to use `TableReference::bare` for this)
let table_reference = TableReference::from(r#""MyTable""#);
assert_eq!(table_reference, TableReference::bare("MyTable"));

// Get a table reference to 'myschema.mytable' (note the capitalization)
let table_reference = TableReference::from("MySchema.MyTable");
assert_eq!(table_reference, TableReference::partial("myschema", "mytable"));

Variants

Bare

Fields

table: Cow<'a, str>

The table name

An unqualified table reference, e.g. “table”

Partial

Fields

schema: Cow<'a, str>

The schema containing the table

table: Cow<'a, str>

The table name

A partially resolved table reference, e.g. “schema.table”

Full

Fields

catalog: Cow<'a, str>

The catalog (aka database) containing the table

schema: Cow<'a, str>

The schema containing the table

table: Cow<'a, str>

The table name

A fully resolved table reference, e.g. “catalog.schema.table”

Implementations

impl<'a> TableReference<'a>

pub fn none() -> Option<TableReference<'a>>

Convenience method for creating a typed none None

pub fn bare(table: impl Into<Cow<'a, str>>) -> TableReference<'a>

Convenience method for creating a TableReference::Bare

As described on TableReference this does NO parsing at all, so “Foo.Bar” stays as a reference to the table named “Foo.Bar” (rather than “foo”.“bar”)

pub fn partial( schema: impl Into<Cow<'a, str>>, table: impl Into<Cow<'a, str>> ) -> TableReference<'a>

Convenience method for creating a TableReference::Partial.

As described on TableReference this does NO parsing at all.

pub fn full( catalog: impl Into<Cow<'a, str>>, schema: impl Into<Cow<'a, str>>, table: impl Into<Cow<'a, str>> ) -> TableReference<'a>

Convenience method for creating a TableReference::Full

As described on TableReference this does NO parsing at all.

pub fn table(&self) -> &str

Retrieve the actual table name, regardless of qualification

pub fn schema(&self) -> Option<&str>

Retrieve the schema name if in the Partial or Full qualification

pub fn catalog(&self) -> Option<&str>

Retrieve the catalog name if in the Full qualification

pub fn resolved_eq(&self, other: &TableReference<'a>) -> bool

Compare with another TableReference as if both are resolved. This allows comparing across variants, where if a field is not present in both variants being compared then it is ignored in the comparison.

e.g. this allows a TableReference::Bare to be considered equal to a fully qualified TableReference::Full if the table names match.

pub fn resolve( self, default_catalog: &'a str, default_schema: &'a str ) -> ResolvedTableReference<'a>

Given a default catalog and schema, ensure this table reference is fully resolved

pub fn to_owned_reference(&self) -> TableReference<'static>

Converts directly into an OwnedTableReference by cloning the underlying data.

pub fn to_quoted_string(&self) -> String

Forms a string where the identifiers are quoted

Example

let table_reference = TableReference::partial("myschema", "mytable");
assert_eq!(table_reference.to_quoted_string(), "myschema.mytable");

let table_reference = TableReference::partial("MySchema", "MyTable");
assert_eq!(table_reference.to_quoted_string(), r#""MySchema"."MyTable""#);

pub fn parse_str(s: &'a str) -> TableReference<'a>

Forms a TableReference by parsing s as a multipart SQL identifier. See docs on TableReference for more details.

pub fn to_vec(&self) -> Vec<String, Global>

Decompose a TableReference to separate parts. The result vector contains at most three elements in the following sequence:

[<catalog>, <schema>, table]

Trait Implementations

impl<'a> Clone for TableReference<'a>

fn clone(&self) -> TableReference<'a>

Returns a copy of the value.

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

Performs copy-assignment from source.

impl<'a> Debug for TableReference<'a>

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

Formats the value using the given formatter.

impl Display for TableReference<'_>

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

Formats the value using the given formatter.

impl<'a> From<&'a String> for TableReference<'a>

fn from(s: &'a String) -> TableReference<'a>

Converts to this type from the input type.

impl<'a> From<&'a TableReference<'static>> for TableReference<'a>

fn from(value: &'a TableReference<'static>) -> TableReference<'a>

Converts to this type from the input type.

impl<'a> From<&'a str> for TableReference<'a>

Parse a string into a TableReference, normalizing where appropriate

See full details on TableReference::parse_str

fn from(s: &'a str) -> TableReference<'a>

Converts to this type from the input type.

impl<'a> From<ResolvedTableReference<'a>> for TableReference<'a>

fn from(resolved: ResolvedTableReference<'a>) -> TableReference<'a>

Converts to this type from the input type.

impl From<String> for TableReference<'static>

Parse a String into a OwnedTableReference as a multipart SQL identifier.

fn from(s: String) -> TableReference<'static>

Converts to this type from the input type.

impl<'a> Hash for TableReference<'a>

fn hash<__H>(&self, state: &mut __H)where __H: Hasher,

Feeds this value into the given Hasher.

fn hash_slice<H>(data: &[Self], state: &mut H)where H: Hasher, Self: Sized,

Feeds a slice of this type into the given Hasher.

impl<'a> Ord for TableReference<'a>

fn cmp(&self, other: &TableReference<'a>) -> Ordering

This method returns an Ordering between self and other.

fn max(self, other: Self) -> Selfwhere Self: Sized,

Compares and returns the maximum of two values.

fn min(self, other: Self) -> Selfwhere Self: Sized,

Compares and returns the minimum of two values.

fn clamp(self, min: Self, max: Self) -> Selfwhere Self: Sized + PartialOrd<Self>,

Restrict a value to a certain interval.

impl<'a> PartialEq<TableReference<'a>> for TableReference<'a>

fn eq(&self, other: &TableReference<'a>) -> bool

This method tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

This method tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl<'a> PartialOrd<TableReference<'a>> for TableReference<'a>

fn partial_cmp(&self, other: &TableReference<'a>) -> Option<Ordering>

This method returns an ordering between self and other values if one exists.

fn lt(&self, other: &Rhs) -> bool

This method tests less than (for self and other) and is used by the < operator.

fn le(&self, other: &Rhs) -> bool

This method tests less than or equal to (for self and other) and is used by the <= operator.

fn gt(&self, other: &Rhs) -> bool

This method tests greater than (for self and other) and is used by the > operator.

fn ge(&self, other: &Rhs) -> bool

This method tests greater than or equal to (for self and other) and is used by the >= operator.

impl<'a> Eq for TableReference<'a>

impl<'a> StructuralEq for TableReference<'a>

impl<'a> StructuralPartialEq for TableReference<'a>