Struct PgSchema

pub struct PgSchema { /* private fields */ }

A struct representing a PostgreSQL schema.

Implementations

impl PgSchema

pub fn new(namespace: impl Into<String>) -> Self

Create a new PgSchema instance.

pub fn enums(&self) -> String

Generates a SQL statement for creating all enum types in the schema.

pub fn types(&self) -> String

Generates a SQL statement for creating all composite types in the schema.

pub fn tables(&self) -> String

Generates a SQL statement for creating all tables in the schema.

pub fn views(&self) -> String

Generates a SQL statement for creating all views in the schema.

pub fn mviews(&self) -> String

Generates a SQL statement for creating all materialized views in the schema.

pub fn functions(&self) -> String

Generates a SQL statement for creating all functions in the schema.

pub fn triggers(&self) -> String

Generates a SQL statement for creating all triggers in the schema.

pub fn indexes(&self) -> String

Generates a SQL statement for creating all indexes in the schema.

impl PgSchema

pub async fn get_enums(&self, pool: &PgPool) -> Result<Vec<String>, Error>

Available on crate feature db-postgres only.

Async function that fetches the SQL statements for $name for the specified schema item.

Example usage:

use crate::PgSchema;

let schema = PgSchema::new("my_schema");
let pool = get_pg_pool(); // Function to get a connection pool
let sqls = schema.[<get_ $name>](&pool).await.unwrap();

pub async fn get_types(&self, pool: &PgPool) -> Result<Vec<String>, Error>

Available on crate feature db-postgres only.

Async function that fetches the SQL statements for $name for the specified schema item.

Example usage:

use crate::PgSchema;

let schema = PgSchema::new("my_schema");
let pool = get_pg_pool(); // Function to get a connection pool
let sqls = schema.[<get_ $name>](&pool).await.unwrap();

pub async fn get_tables(&self, pool: &PgPool) -> Result<Vec<String>, Error>

Available on crate feature db-postgres only.

Async function that fetches the SQL statements for $name for the specified schema item.

Example usage:

use crate::PgSchema;

let schema = PgSchema::new("my_schema");
let pool = get_pg_pool(); // Function to get a connection pool
let sqls = schema.[<get_ $name>](&pool).await.unwrap();

pub async fn get_views(&self, pool: &PgPool) -> Result<Vec<String>, Error>

Available on crate feature db-postgres only.

Async function that fetches the SQL statements for $name for the specified schema item.

Example usage:

use crate::PgSchema;

let schema = PgSchema::new("my_schema");
let pool = get_pg_pool(); // Function to get a connection pool
let sqls = schema.[<get_ $name>](&pool).await.unwrap();

pub async fn get_mviews(&self, pool: &PgPool) -> Result<Vec<String>, Error>

Available on crate feature db-postgres only.

Async function that fetches the SQL statements for $name for the specified schema item.

Example usage:

use crate::PgSchema;

let schema = PgSchema::new("my_schema");
let pool = get_pg_pool(); // Function to get a connection pool
let sqls = schema.[<get_ $name>](&pool).await.unwrap();

pub async fn get_functions(&self, pool: &PgPool) -> Result<Vec<String>, Error>

Available on crate feature db-postgres only.

Async function that fetches the SQL statements for $name for the specified schema item.

Example usage:

use crate::PgSchema;

let schema = PgSchema::new("my_schema");
let pool = get_pg_pool(); // Function to get a connection pool
let sqls = schema.[<get_ $name>](&pool).await.unwrap();

pub async fn get_triggers(&self, pool: &PgPool) -> Result<Vec<String>, Error>

Available on crate feature db-postgres only.

Async function that fetches the SQL statements for $name for the specified schema item.

Example usage:

use crate::PgSchema;

let schema = PgSchema::new("my_schema");
let pool = get_pg_pool(); // Function to get a connection pool
let sqls = schema.[<get_ $name>](&pool).await.unwrap();

pub async fn get_indexes(&self, pool: &PgPool) -> Result<Vec<String>, Error>

Available on crate feature db-postgres only.

Async function that fetches the SQL statements for $name for the specified schema item.

Example usage:

use crate::PgSchema;

let schema = PgSchema::new("my_schema");
let pool = get_pg_pool(); // Function to get a connection pool
let sqls = schema.[<get_ $name>](&pool).await.unwrap();

Trait Implementations

impl Clone for PgSchema

fn clone(&self) -> PgSchema

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for PgSchema

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

Formats the value using the given formatter.

impl Hash for PgSchema

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

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 Ord for PgSchema

fn cmp(&self, other: &PgSchema) -> Ordering

This method returns an Ordering between self and other.

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

where Self: Sized,

Compares and returns the maximum of two values.

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

where Self: Sized,

Compares and returns the minimum of two values.

fn clamp(self, min: Self, max: Self) -> Self

where Self: Sized,

Restrict a value to a certain interval.

impl PartialEq for PgSchema

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

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

const 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 PartialOrd for PgSchema

fn partial_cmp(&self, other: &PgSchema) -> Option<Ordering>

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

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

Tests less than (for self and other) and is used by the < operator.

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

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

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

Tests greater than (for self and other) and is used by the > operator.

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

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

impl Eq for PgSchema

impl StructuralPartialEq for PgSchema