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<String>	JSON	TEXT[]	TEXT
Vec<UUID>	JSON	UUID[]	TEXT
Map	JSON	JSONB	TEXT

Structs

• ConnectionPool
  A database connection pool with metadata.
• 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 functions.

Traits

• DecodeRow
  A collection of values that can be decoded from a single row.
• EncodeColumn
  Encodes the 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.
• ModelHelper
  Helper utilities for models.
• PoolManager
  A manager of the connection pool.
• 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.