Crate sqlstate

Representations and parsing logic for SQLSTATE return codes.

Examples

Parsing return codes according to the SQL standard:

use sqlstate::standard::{
    class::{DataException::DivisionByZero, Warning::PrivilegeNotGranted},
    SqlState,
};

assert_eq!("00000".parse::<SqlState>()?, SqlState::Success(None));
assert_eq!("01007".parse::<SqlState>()?, SqlState::Warning(Some(PrivilegeNotGranted)));

// Unknown codes are represented as `Other`
assert_eq!("XX001".parse::<SqlState>()?, SqlState::Other(String::from("XX001")));

Examining the pieces of a return code:

use sqlstate::standard::{class::Warning::PrivilegeNotGranted, SqlState};

let success = SqlState::Success(None);
let warning = SqlState::Warning(Some(PrivilegeNotGranted));
assert_eq!((success.class(), success.subclass()), ("00", None));
assert_eq!((warning.class(), warning.subclass()), ("01", Some("007")));

Parsing return codes specific to PostgreSQL:

use sqlstate::{
    postgres::{
        class::{DataException::InvalidJsonText, InternalError::DataCorrupted},
        SqlState::*,
    },
    standard, PostgresSqlState,
};

assert_eq!("22032".parse::<PostgresSqlState>()?,
           PostgresSqlState::Custom(DataException(Some(InvalidJsonText))));
assert_eq!("XX001".parse::<PostgresSqlState>()?,
           PostgresSqlState::Custom(InternalError(Some(DataCorrupted))));

// Can also fall back to standard codes
assert_eq!("00000".parse::<PostgresSqlState>()?,
           PostgresSqlState::Standard(standard::SqlState::Success(None)));

Features

• postgres: Enables PostgreSQL-specific types.

Re-exports

pub use standard::SqlState;

Modules

error

postgrespostgres

Abstractions for PostgreSQL-specific return codes.

standard

Abstractions for standard return codes.

Enums

Category

A category for a given SQLSTATE code.

PostgresSqlStatepostgres

A wrapper around both standard and PostgreSQL-specific SQLSTATE codes.