Maintain entity relationships across Postgresql schemas

[nicbytes]

I’m interested in organising a database with postgresql schemas. This issue proposes a new flag for the cli along the lines of --split-database-schemas that splits the generated output into separate directories by schema name.

I hope to achieve:

• Layout out rust modules that reflect accessing entities in the same way you reference entities in postgresql, e.g.: Rust: entities::event::signin::Model, SQL: event.signin.
• Maintain the relationships across schemas via codgen.

For example:

CREATE SCHEMA IF NOT EXISTS event;

CREATE TABLE public.user (
    id SERIAL PRIMARY KEY,
    username VARCHAR(50) NOT NULL UNIQUE,
    password_hash VARCHAR(255) NOT NULL
);

CREATE TABLE event.signin (
    id SERIAL PRIMARY KEY,
    user_id INTEGER NOT NULL,
    signin_time TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP,
    ip_address INET,
    user_agent TEXT,
    FOREIGN KEY (user_id) REFERENCES public.user(id) ON DELETE CASCADE
);

Using sea-orm-cli generate entity --with-serde both, the code below is generated:

// Currently generated code
#[derive(Clone, Debug, PartialEq, DeriveEntityModel, Eq, Serialize, Deserialize)]
#[sea_orm(table_name = "user")]
pub struct Model {
    #[sea_orm(primary_key)]
    pub id: i32,
    #[sea_orm(unique)]
    pub username: String,
    pub password_hash: String,
}

#[derive(Copy, Clone, Debug, EnumIter, DeriveRelation)]
pub enum Relation {}

// // Desired relationship code below:
// #[derive(Copy, Clone, Debug, EnumIter, DeriveRelation)]
// pub enum Relation {
//     #[sea_orm(has_many = "super::super::event::signin::Entity")]
//     Signin,
// }

// impl Related<super::super::event::signin::Entity> for Entity {
//     fn to() -> RelationDef {
//         Relation::Signin.def()
//     }
// }

I am happy for any feedback and to do the implementation.