dsync
A utility to generate database structs and querying code from diesel schema files. Primarily built for create-rust-app.
Currently, it's more advantageous to generate code over deriving code with macros because intellisense and autocompletion isn't quite there when it comes to macro expansion.
Demo
Given the following schema:
// schema.rs
diesel::table! {
todos (id) {
id -> Int4,
text -> Text,
completed -> Bool,
}
}
We run:
cargo dsync -i schema.rs -o models
Now we have everything we need!
use models::todos;
async fn demo(db: Connection) {
let created_todo = todos::create(&mut db, todos::CreateTodo {
text: "Create a demo",
completed: false,
}).await?;
let todos_list = todos::paginate(&mut db, 1, 10).await?;
let updated_todo = todos::update(&mut db, created_todo.id, UpdateTodo {
text: created_todo.text,
completed: true,
}).await?;
}
For a complete example, see test/simple_schema/schema.rs which generates all the code in test/simple_schema/models.
Usage
-
Add this crate:
cargo add dsync
-
Create a new binary in your project which uses the crate (for example,
bin/dsync.rs)use std::{collections::HashMap, path::PathBuf}; use dsync::{GenerationConfig, TableOptions}; pub fn main() { let dir = env!("CARGO_MANIFEST_DIR"); dsync::generate_files( PathBuf::from_iter([dir, "src/schema.rs"]), PathBuf::from_iter([dir, "src/models"]), GenerationConfig { /* ... your generation options ... */ } ); }
-
Create a
Cargo.tomlbinary entry:[[bin]] name = "dsync" path = "bin/dsync.rs"
-
Execute!
cargo run --bin dsync
Protip: to use cargo dsync, create an alias in .cargo/config:
[alias]
dsync="run --bin dsync"
Pre-built binary
Setting up a custom binary allows you to completely customize the generation; however, if complete customization isn't necessary, you can install the CLI directly (you'll have to make sure you keep it up-to-date by running this periodically):
cargo install dsync
CLI Usage
-i: input argument: path to schema file-o: output argument: path to directory where generated code should be written-c: connection type (for example:diesel::r2d2::PooledConnection<diesel::r2d2::ConnectionManager<diesel::PgConnection>>)-g: (optional) list of columns that are automatically generated by create/update triggers (for example,created_at,updated_at)--tsync: (optional) adds #[tsync] attribute to generated structs (see https://github.com/Wulf/tsync)- note: the CLI has fail-safes to prevent accidental file overwriting
dsync -i src/schema.rs -o src/models
Docs
See dsync --help for more information.
Feel free to open tickets for support or feature requests.
Development/Testing
Use ./test/test_all.sh to run tests. After running the test, there should be no unexpected changes to files in ./test (use git status and git diff to see if there were any changes).
License
This tool is distributed under the terms of both the MIT license and the Apache License (Version 2.0).
See LICENSE-APACHE, LICENSE-MIT, and COPYRIGHT for details.
4 Dec 18, 2022
3 Sep 30, 2023
11 Dec 30, 2022
0 Feb 17, 2022
17 Mar 22, 2023
2 Dec 14, 2022
5 Jul 30, 2023
89 Dec 24, 2022
43 Dec 17, 2022
3 Sep 29, 2022
4 Sep 8, 2023
3 Apr 10, 2024
1 Aug 1, 2022
2 May 30, 2022
3 Nov 21, 2022
97 Jun 26, 2023
4 Oct 30, 2023
9 Oct 25, 2022
7 Jan 2, 2023