sequelize-typescript icon indicating copy to clipboard operation
sequelize-typescript copied to clipboard

BaseModel Column order ?

Open fortezhuo opened this issue 3 years ago • 2 comments

Issue

BaseModel.ts

import {
  CreatedAt,
  UpdatedAt,
  Model,
  Column,
  DeletedAt,
} from "sequelize-typescript"

export class BaseModel<T extends Model<T>> extends Model<T> {
  @CreatedAt
  _createdAt: Date

  @Column
  _createdBy: string

  @UpdatedAt
  _updatedAt: Date

  @Column
  _updatedBy: string

  @DeletedAt
  _deletedAt?: Date
}

And while we create User that extends BaseModel<User>

class User extends BaseModel<User> {
  @Column(DataType.TEXT)
  firstName: string

  @Column(DataType.TEXT)
  lastName: string

  @Column(DataType.TEXT)
  fullName: string
}

Versions

  • "sequelize": "^6.20.1",
  • "sequelize-typescript": "^2.1.3",
  • "typescript": "4.7.2"

Issue type

  • [ ] bug report
  • [x] feature request

Actual behavior

The columns will be generated with order like this

id
_createdBy
_updatedBy
firstName
lastName
fullName
_createdAt
_updatedAt
_deletedAt

Expected behavior

How to create class User that order like

id
firstName
lastName
fullName
_createdBy
_updatedBy
_createdAt
_updatedAt
_deletedAt

fortezhuo avatar Jun 18 '22 12:06 fortezhuo

My question on top of this exact issue would be how do you change column order without changing your model

Coinhexa avatar Oct 15 '22 05:10 Coinhexa

Any updates? I also encountered this problem.

Oscaner avatar Jan 07 '24 11:01 Oscaner