0.1.3 |
|
---|---|
0.1.2 |
|
0.1.1 |
|
0.1.0 |
|
#2 in #reveser
53KB
783 lines
sql_reveser
Generate the RUST structure based on the MySQL/PostgreSQL table structure
Install
cargo install sql_reveser
Exec,you need to make sure you're in the same directory as templates.
sql_reveser mysql -f reverse.yml
sql_reveser postgres -f reverse.yml
Custom Exec
sql_reveser mysql -f reverse.yml -p 'templates/*' -n base.tera
sql_reveser postgres -f reverse.yml -p 'templates/*' -n base.tera
reverse.yml
host: 127.0.0.1
post: 3306
username: root
password: ''
database: db_name
schemaname: test # only postgres enable
include_tables: # Include tables, can be ignored.
# - table_name
exclude_tables: # Exclude, tables, can be ignored.
# - table_name
output_dir: ./dir # code output directory
Template Struct:
#[derive(Serialize)]
pub struct Template {
pub table_name: String,
pub struct_name: String,
pub fields: Vec<Field>,
pub comment: String,
}
#[derive(Serialize, Clone)]
pub struct Field {
pub field_name: String,
pub field_type: String,
pub comment: String,
/// only supported mysql
pub index_key: Vec<Vec<String>>
/// 1: 是, 0: 否
pub is_null: u8,
}
Template:
use serde_derive;
use chrono::prelude::*;
{% if template.comment -%}
/// {{ template.comment }}
{% endif -%}
#[crud_table]
#[derive(Default, Debug, Clone, PartialEq, serde_derive::Serialize, serde_derive::Deserialize)]
pub struct {{ template.struct_name }} {
{%- for v in template.fields %}
{% if v.comment -%}
/// {{ v.comment }}
{% endif -%}
{% if v.is_null == 1 -%}
pub {{ v.field_name }}: Option<{{ v.field_type }}>,
{%- else -%}
pub {{ v.field_name }}: {{ v.field_type }},
{%- endif -%}
{%- endfor %}
}
Gen Struct Example:
use serde_derive;
use chrono::prelude::*;
/// Test
#[crud_table]
#[derive(Default, Debug, Clone, PartialEq, serde_derive::Serialize, serde_derive::Deserialize)
pub struct Test {
pub id: Option<u32>,
/// uuid
pub uuid: Option<String>,
/// 数据
pub content: Option<String>,
/// 版本
pub version: Option<i8>,
/// 1:删除, 0:未删除
pub is_deleted: Option<u8>,
/// 更新时间
pub updated_at: Option<NaiveDateTime>,
/// 创建时间
pub created_at: Option<NaiveDateTime>,
}
Dependencies
~30–45MB
~771K SLoC