Crate zino_orm 

Database schema and ORM for zino.

Supported database drivers

The following optional features are available:

Feature flag	Description	Default?
orm-mariadb	Enables the MariaDB database driver.	No
orm-mysql	Enables the MySQL database driver.	No
orm-postgres	Enables the PostgreSQL database driver.	No
orm-sqlite	Enables the SQLite database driver.	No
orm-tidb	Enables the TiDB database driver.	No

Mappings of Rust data types

Rust type	MySQL datatype	PostgreSQL datatype	SQLite datatype
bool	BOOLEAN	BOOLEAN	BOOLEAN
i8	TINYINT	SMALLINT	INTEGER
u8	TINYINT UNSIGNED	SMALLINT	INTEGER
i16	SMALLINT	SMALLINT	INTEGER
u16	SMALLINT UNSIGNED	SMALLINT	INTEGER
i32, Option<i32>	INT	INT, SERIAL	INTEGER
u32, Option<u32>	INT UNSIGNED	INT, SERIAL	INTEGER
i64, Option<i64>, isize	BIGINT	BIGINT, BIGSERIAL	INTEGER
u64, Option<u64>, usize	BIGINT UNSIGNED	BIGINT, BIGSERIAL	INTEGER
f32	FLOAT	REAL	REAL
f64	DOUBLE	DOUBLE PRECISION	REAL
Decimal	NUMERIC	NUMERIC	TEXT
String, Option<String>	TEXT, VARCHAR(255)	TEXT	TEXT
Date, NaiveDate	DATE	DATE	DATE
Time, NaiveTime	TIME	TIME	TIME
DateTime	TIMESTAMP(6)	TIMESTAMPTZ	DATETIME
NaiveDateTime	DATETIME(6)	TIMESTAMP	DATETIME
Uuid, Option<Uuid>	CHAR(36), UUID	UUID	TEXT
Vec<u8>	BLOB	BYTEA	BLOB
Vec<i32>, Vec<u32>	JSON	INT[]	TEXT
Vec<i64>, Vec<u64>	JSON	BIGINT[]	TEXT
Vec<f32>	JSON	REAL[]	TEXT
Vec<f64>	JSON	DOUBLE PRECISION[]	TEXT
Vec<String>	JSON	TEXT[]	TEXT
Vec<UUID>	JSON	UUID[]	TEXT
Map	JSON	JSONB	TEXT

Structs

ConnectionPool

A database connection pool with metadata.

DerivedColumn

A column computed dynamically based on other columns or expressions.

GlobalPool

Global access to the shared connection pools.

JoinOn

SQL joins on two tables.

MutationBuilder

A mutation builder for the model entity.

QueryBuilder

A query builder for the model entity.

Window

SQL window functions.

Enums

Aggregation

SQL aggregate expressions.

Traits

DecodeRow

A collection of values that can be decoded from a single row.

EncodeColumn

Encoding a column to be sent to the database.

Entity

An interface for the model entity.

Executor

Executing queries against the database.

IntoSqlValue

A generic interface for converting into SQL values.

ModelAccessor

Access model fields.

ModelColumn

An interface for the model column.

ModelHelper

Helper utilities for models.

PoolManager

A manager of the connection pool.

PrimaryKey

An interface for the primary key.

ScalarQueryorm-sqlx

Query on scalar values.

Schema

Database schema.

Transaction

An in-progress database transaction.

Functions

decodeorm-sqlx

Decodes a single value as T for the field in a row.

decode_arrayorm-sqlx

Decodes a single value as Vec<T> for the field in a row.

decode_decimalorm-sqlx

Decodes a single value as Decimal for the field in a row.

decode_optionalorm-sqlx

Decodes a single value as T for the field in a row, returning None if it was not found.

decode_uuidorm-sqlx

Decodes a single value as Uuid for the field in a row.

Type Aliases

DatabaseConnection

SQLite database connection.

DatabaseDriver

SQLite database driver.

DatabasePool

SQLite database pool.

DatabaseRow

A single row from the SQLite database.