pgorm 0.3.0

A model-definition-first, AI-friendly PostgreSQL ORM for Rust
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25

//! Database schema setup helpers for optimistic locking example

#![allow(dead_code)]

use pgorm::{GenericClient, OrmError, query};

/// Setup schema for articles table with a version column
pub async fn setup_articles_schema(conn: &impl GenericClient) -> Result<(), OrmError> {
    query("DROP TABLE IF EXISTS articles CASCADE")
        .execute(conn)
        .await?;

    query(
        "CREATE TABLE articles (
            id BIGSERIAL PRIMARY KEY,
            title TEXT NOT NULL,
            body TEXT NOT NULL,
            version INT NOT NULL DEFAULT 0
        )",
    )
    .execute(conn)
    .await?;

    Ok(())
}