Database Tables Analysis & ORM Mapping Plan

#![allow(unused)]
fn main() {
// crates/core/src/domain/entities/{domain}/table_name.rs
use serde::{Deserialize, Serialize};

#[derive(Debug, Clone, Serialize, Deserialize)]
pub struct TableName {
    pub id: i32,
    pub field_name: Option<String>,
    pub created_at: Option<String>,
    pub foreign_id: Option<i32>,
}

impl TableName {
    pub fn new(id: i32) -> Self {
        Self {
            id,
            field_name: None,
            created_at: None,
            foreign_id: None,
        }
    }
    
    // Business logic methods here
}
}

Repository Trait Template

#![allow(unused)]
fn main() {
// crates/core/src/domain/repositories/{domain}/table_name_repository.rs
use crate::domain::entities::TableName;
use anyhow::Result;

#[async_trait::async_trait]
pub trait TableNameRepository: Send + Sync {
    async fn find_by_id(&self, id: i32) -> Result<Option<TableName>>;
    async fn find_all(&self) -> Result<Vec<TableName>>;
    async fn count(&self) -> Result<i32>;
}
}

Testing Template

#![allow(unused)]
fn main() {
// crates/core/tests/test_table_name.rs
#[cfg(test)]
mod tests {
    use efision_core::infrastructure::config::DatabaseConfig;
    use efision_core::infrastructure::sqlserver::TableNameRepo;
    use efision_core::domain::repositories::TableNameRepository;

    #[tokio::test]
    async fn test_count() {
        let config = DatabaseConfig::from_region("AU");
        let repo = TableNameRepo::new(config).await.unwrap();
        let count = repo.count().await.unwrap();
        assert!(count > 0);
        println!("Total records: {}", count);
    }
}
}

Naming Conventions

Rust (Snake Case for modules, PascalCase for types)

Module: table_name.rs
Struct: TableName
Repository trait: TableNameRepository
Implementation: SqlServerTableNameRepo
Service: TableNameService

Column Name Mapping Strategy

SQL Server uses PascalCase for column names (e.g., ProductID, CreateTime).

Python: Use sa_column_kwargs={"name": "ColumnName"} to map snake_case to PascalCase.

Rust: Use SQL aliases in queries: SELECT ProductID as product_id.

Database Connection Settings

All tables use the same connection settings as current implementation:

#![allow(unused)]
fn main() {
config.encryption(tiberius::EncryptionLevel::NotSupported);
config.application_name("efision");
config.readonly(true);
}

Documentation Requirements

For each new table mapping, create/update:

Entity: Add to crates/core/src/domain/entities/{domain}/
Repository: Add trait to crates/core/src/domain/repositories/{domain}/
SQL Implementation: Add to crates/core/src/infrastructure/sqlserver/{domain}/
Tests: Document test results
Relationships: Document foreign key relationships (even if not enforced)
Business logic: Document any business rules in domain models

Progress Tracking

Overall completion: 15/230+ tables (6.5%)

By category:

✅ Product Management: 15/21 (71%)
⏸️ Sales & Orders: 0/20 (0%)
⏸️ Warehouse: 0/21 (0%)
⏸️ Finance: 0/35+ (0%)
⏸️ Manufacturing: 0/30+ (0%)
⏸️ CRM: 0/15+ (0%)
⏸️ User Management: 0/25+ (0%)
⏸️ Invoicing: 0/5 (0%)
⏸️ Content: 0/15+ (0%)
⏸️ Reference Data: 0/10+ (0%)
⏸️ Dashboard: 0/2 (0%)

Next Actions

Review this document with Henry ✅
Confirm Phase 1 priority tables ✅
Phase 1 implementation ✅ (2026-02-05)
Start Phase 2: Sales & Orders ⏳

Last updated: 2026-02-05 Maintained by: Lobster 🦞

Keyboard shortcuts

Efision CLI Documentation