#sql-query #sql-database #database-schema #database-migrations #postgresql #orm #auto-generate

sqlmo

SQL data primitives. Use it to generate SQL queries, auto-generate SQL migrations, and more.

42 releases (14 breaking)

new 0.23.1 Jan 26, 2025
0.22.7 Nov 20, 2024
0.17.0 Jun 2, 2024
0.16.3 Nov 11, 2023
0.11.2 Mar 27, 2023

#749 in Database interfaces

Download history 564/week @ 2024-10-06 259/week @ 2024-10-13 78/week @ 2024-10-20 83/week @ 2024-10-27 45/week @ 2024-11-03 11/week @ 2024-11-10 148/week @ 2024-11-17 115/week @ 2024-11-24 123/week @ 2024-12-01 131/week @ 2024-12-08 20/week @ 2024-12-15 3/week @ 2024-12-22 21/week @ 2024-12-29 43/week @ 2025-01-05 24/week @ 2025-01-12 21/week @ 2025-01-19

109 downloads per month
Used in 13 crates (11 directly)

MIT license

71KB
2K SLoC

GitHub Contributors Stars Build Status Downloads Crates.io

sqlmo

sqlmo is a set of primitives to represent SQL tables and queries. Use these primitives to:

  • Auto-generate migrations: Load SQL representations in a standardized form (sqlmo::Schema), calculate differences between schemas (sqlmo::Migration), and generate SQL to apply the migration (sqlmo::Migration::to_sql).
  • Build SQL queries: Represent SQL queries in a data model, to create APIs for query generation. Then, generate the SQL query. Note: this library does not support parsing SQL queries (yet).

For auto-generating migrations, there are a few built-in schema sources:

If you need another source, you should define a way to build a sqlmo::Schema from your data source, then use sqlmo to auto-generate migrations.

Current tools that support this:

If you use this library, submit a PR to be added to this list.

Usage

This example reads the schema from a postgres database, defines an empty schema (which should be filled in), and then computes the migration to apply to the database.

use sqlmo_sqlx::FromPostgres;

#[tokio::main]
async fn main() {
    let url = std::env::var("DATABASE_URL").unwrap();
    let mut conn = sqlx::postgres::PgConnection::connect(&url).await?;
    let current = Schema::try_from_postgres(&mut conn, schema_name).await?;
    let end_state = Schema::default(); // Load your end-state by manually defining it, or building it from another source
    let migration = current.migrate_to(end_state, &sqlmo::Options::default());
    
    for statement in migration.statements {
        let statement = statement.to_sql(Dialect::Postgres);
        println!("{}", statement);
    }
}

Roadmap

  • When calculating migrations, create commented out lines for column deletion
  • ? When calculating migrations, do alter column by calculating word distance between column names

Dependencies

~105–370KB