Struct TableDef 

pub struct TableDef {
    pub name: String,
    pub foreign_keys: Vec<ForeignKeysInfo>,
    pub indexes: Vec<IndexInfo>,
    pub constraints: Vec<IndexInfo>,
    pub columns: Vec<ColumnInfo>,
    pub auto_increment: bool,
}

Defines a table for SQLite

Fields

name: String

The table name

foreign_keys: Vec<ForeignKeysInfo>

A list of foreign keys in the table

indexes: Vec<IndexInfo>

A list of the indexes in the table

constraints: Vec<IndexInfo>

A list of UNIQUE and PRIMARY KEY constraints on the table

columns: Vec<ColumnInfo>

A list of all the columns and their types

auto_increment: bool

Whether the primary key should autoincrement

Implementations

impl TableDef

pub async fn pk_is_autoincrement( &mut self, conn: &impl Connection, ) -> DiscoveryResult<&mut Self>

Check if the primary key in the table is set to autoincrement as a result of using query `SELECT COUNT(*) from sqlite_sequence where name = ‘table_name’;

pub async fn get_constraints( &mut self, conn: &impl Connection, ) -> DiscoveryResult<()>

Get a list of most of the UNIQUE and PRIMARY KEY constraints on the table. These are implemented by indexes in most cases. These indexes have type “u” or “pk”. Note that this does not get the column name mapped by the index. To get the column name mapped by the index, the self.get_single_indexinfo method is invoked

pub async fn get_indexes( &mut self, conn: &impl Connection, ) -> DiscoveryResult<()>

Get a list of all the indexes in the table. Note that this does not get the column name mapped by the index. To get the column name mapped by the index, the self.get_single_indexinfo method is invoked

pub async fn get_foreign_keys( &mut self, conn: &impl Connection, ) -> DiscoveryResult<&mut Self>

Get a list of all the foreign keys in the table

pub async fn get_column_info( &mut self, conn: &impl Connection, ) -> DiscoveryResult<&TableDef>

Get a list of all the columns in the table mapped as ColumnInfo

pub fn write(&self) -> TableCreateStatement

Trait Implementations

impl Clone for TableDef

fn clone(&self) -> TableDef

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for TableDef

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

Formats the value using the given formatter.

impl Default for TableDef

fn default() -> TableDef

Returns the “default value” for a type.

impl From<SqlxRow> for TableDef

Available on non-crate feature sqlx-sqlite only.

fn from(_: SqlxRow) -> Self

Converts to this type from the input type.

impl PartialEq for TableDef

fn eq(&self, other: &TableDef) -> bool

Tests for self and other values to be equal, and is used by ==.

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

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

impl StructuralPartialEq for TableDef