New package supports Mysql and PostgresSQL...

Install

cargo install sql_reverse

rbatis-tools

Generate the RUST structure based on the MySQL table structure

Install

cargo install rbatis-tools

Exec，you need to make sure you're in the same directory as templates.

rbatis-tools mysql -f reverse.yml

Custom Exec

rbatis-tools mysql -f reverse.yml -p 'templates/*' -n base.tera

reverse.yml

database: db_name
conn_str: root:password@127.0.0.1:3306/db_name
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,
    /// NO, YES
    pub is_null: String,
}

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 -%}
    pub {{ v.field_name }}: Option<{{ v.field_type }}>,
{%- 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>,
}