mORMot Open Source

mrbar2000

Member

From: Brazil

Registered: 2016-10-26

Posts: 108

About property name case on json serialize

I have this TOrm and DTO:

TMPOrm = class(TOrm)
  private
    FDataCriacao: TDateTime;
    FUltimaAlteracao: TDateTime;
    FEmpresaID: TID;
  published
    property DataCriacao: TDateTime read FDataCriacao write FDataCriacao;
    property UltimaAlteracao: TDateTime read FUltimaAlteracao write FUltimaAlteracao;
    property EmpresaID: TID read FEmpresaID write FEmpresaID;
  end;

  TPosto = class(TMPOrm)
  private
    FNome: RawUtf8;
    FIdExterno: Int64;
  published
    property Nome: RawUTF8 index 100 read FNome write FNome;
    property IdExterno: Int64 read FIdExterno write FIdExterno;
  end;

  TDTOPosto = packed record
    Nome: RawUtf8;
    ID: Int64;
    IDExterno: Int64;
  end;

when using CreatingMissingTables all fields names are translated to loweercase.

when retrieve information of database i get this json:

{
    "ID": 1,
    "datacriacao": "2024-10-09T16:19:11",
    "ultimaalteracao": "2025-01-14T10:02:45",
    "empresaid": 1,
    "nome": "Posto G",
    "idexterno": 32
}

How json property follow the same name case of DTO or ORM?

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,934

Website

Re: About property name case on json serialize

On which database backend?
With which database library?

The JSON uses the column naming as returned by the DB layer itself.

mrbar2000

Member

From: Brazil

Registered: 2016-10-26

Posts: 108

Re: About property name case on json serialize

Database: Postgress

Ok, on database, mormot create all fields in lowercase, how change this to create conform the ORM class?

property DataCriacao. i dont want on database like "datacriacao"

I would Like Json com property  "DataCriacao".

If I make retrieve with collumns defined, json is generated "DataCriacao", but if i want retrieve all columns, mormot retrieve "datacriacao"
This are generating problems on frontend plataform because to it DataCriacao <> datacriacao