Column name

[Gabriel-Paulucci]

Add a way to define the database column name, the same as the table name

#[sea_orm(table_name = "User")] // set the table name (currently exists)
pub struct Model {
    #[sea_orm(primary_key)]
    pub id: u64,
    #[sea_orm(unique)]
    pub name: String,
    pub password: String,
    pub salt: String,
    #[sea_orm(colunm_name = "createAt")] // set column name (does not currently exist)
    pub create_at: DateTime,
    #[sea_orm(colunm_name = "updateAt")] // set column name (does not currently exist)
    pub update_at: Option<DateTime>,
}

[billy1624]

Hey @Gabriel-Paulucci, I think you can.

sea-orm/src/entity/column.rs

Line 550 in acf8eac

#[sea_orm(column_name = "ONE")]

[tyt2y3]

The original code has a typo

#[sea_orm(colunm_name = "createAt")]

[Gabriel-Paulucci]

Well I found that it doesn't exist because it wasn't working, when I executed an insert in my database it generated a SQL with create_at not createAt

Log

INSERT INTO `User` (`name`, …; rows: 0, elapsed: 384.090ms

INSERT INTO
  `User` (`name`, `password`, `salt`)
VALUES
  (?, ?, ?)

SET sql_mode=(SELECT CONCAT(@@sql_mode, ',PIPES_AS_CONCAT,NO_ENGINE_SUBSTITUTION')),time_zone='+00:00',NAMES …; rows: 0, elapsed: 189.689ms

SET
  sql_mode =(
    SELECT
      CONCAT(
        @ @sql_mode,
        ',PIPES_AS_CONCAT,NO_ENGINE_SUBSTITUTION'
      )
  ),
  time_zone = '+00:00',
  NAMES utf8mb4 COLLATE utf8mb4_unicode_ci;

SELECT `User`.`id`, `User`.`name`, `User`.`password`, …; rows: 0, elapsed: 192.124ms

  ?

thread 'rocket-worker-thread' panicked at 'called `Result::unwrap()` on an `Err` value: Query("error returned from database: 1054 (42S22): Unknown column 'User.create_at' in 'field list'")', src\routes\api\auth.rs:40:40

Entity

//! SeaORM Entity. Generated by sea-orm-codegen 0.3.1

use sea_orm::entity::prelude::*;

#[derive(Clone, Debug, PartialEq, DeriveEntityModel)]
#[sea_orm(table_name = "User")]
pub struct Model {
    #[sea_orm(primary_key)]
    pub id: u64,
    #[sea_orm(unique)]
    pub name: String,
    pub password: String,
    pub salt: String,
    #[sea_orm(colunm_name = "createAt")]
    pub create_at: DateTime,
    pub update_at: Option<DateTime>,
}

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

impl RelationTrait for Relation {
    fn def(&self) -> RelationDef {
        match self {
            _ => panic!("No RelationDef"),
        }
    }
}

impl ActiveModelBehavior for ActiveModel {}

let user = user::ActiveModel {
    name: Set(user.0.name),
    password: Set(hash.get_password().to_string()),
    salt: Set(hash.get_salt().to_string()),
    ..Default::default()
};

user.insert(db.into_inner()).await.unwrap();

And a question I'm having, doesn't sea-orm-cli automatically generate the column_name ?

[billy1624]

Yes, this does not work. Because there is a typo :P

• #[sea_orm(colunm_name = "createAt")] to #[sea_orm(column_name = "createAt")]

//! SeaORM Entity. Generated by sea-orm-codegen 0.3.1

use sea_orm::entity::prelude::*;

#[derive(Clone, Debug, PartialEq, DeriveEntityModel)]
#[sea_orm(table_name = "User")]
pub struct Model {
    #[sea_orm(primary_key)]
    pub id: u64,
    #[sea_orm(unique)]
    pub name: String,
    pub password: String,
    pub salt: String,
    #[sea_orm(colunm_name = "createAt")]
    pub create_at: DateTime,
    pub update_at: Option<DateTime>,
}

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

impl RelationTrait for Relation {
    fn def(&self) -> RelationDef {
        match self {
            _ => panic!("No RelationDef"),
        }
    }
}

impl ActiveModelBehavior for ActiveModel {}

[Gabriel-Paulucci]

wow I hadn't realized this error

a doubt, wasn't this supposed to generate a compilation error?

[billy1624]

a doubt, wasn't this supposed to generate a compilation error?

We should! loll

[Gabriel-Paulucci]

why is it not generating an error then?

[billy1624]

Ohoh, I mean we should implement this feature

[billy1624]

Opened a tracking issue for this #394