kurtbuilds_sql_openapi 0.26.2

Crate to create sql models from openapi v3 spec
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
26
27
28
29
30
31
32

use std::fs::File;

use anyhow::Result;
use openapiv3::OpenAPI;

use sql::{Dialect, MigrationOptions, Schema, ToSql};
use sql_openapi::{FromOpenApi, FromOpenApiOptions};

const OPENAPI_YAML_FILEPATH: &str = concat!(env!("CARGO_MANIFEST_DIR"), "/tests/spec/openapi.yaml");

#[test]
pub fn test_run_sql_migration() -> Result<()> {
    let yaml = File::open(OPENAPI_YAML_FILEPATH)?;
    let spec: OpenAPI = serde_yaml::from_reader(yaml)?;
    let current = Schema::default();
    let mut desired = Schema::try_from_openapi(spec, &FromOpenApiOptions::default())?;
    desired.name_schema("public");
    let migration = current.migrate_to(
        desired,
        &MigrationOptions {
            debug: false,
            allow_destructive: false,
        },
    )?;

    assert_eq!(migration.statements.len(), 5);
    for statement in migration.statements {
        let statement = statement.to_sql(Dialect::Postgres);
        assert!(statement.starts_with(r#"CREATE TABLE "public".""#));
    }
    Ok(())
}