#1 mORMot 1 » Datasnap Performance xe7 Vs Mormot » 2014-10-16 00:03:44

Roberiopraciano
Replies: 1

I'm doing some tests with datasnap performance , not yet translated into English but if you can take a look, I'll be happy

http://datasnapperformance.wordpress.com/

#2 Re: mORMot 1 » I want use mormot in my erp in Brazil help me please » 2014-04-25 03:51:20

But I would like to use any mormot both the ORM as the HTTP Server.

Sorry for my English poorly but still have questions to ask:

I currently have no way to use my class with the explicit Id field?

At least let him in class with some tag for mormot not handle, just show up?

#3 Re: mORMot 1 » I want use mormot in my erp in Brazil help me please » 2014-04-13 18:32:53

I currently have a small erp which has 386 classes with DataSnap server and client, all classes inherit from a class type jsonvo created by me, which implement functions Marchal and json serialization, so that serialization method is slow DataSnap and lasting memory leak. Finally I would take all my classes, however all use the id field as integer and primary key, is to use my classes that inherit from jsonvo and make jsonvo inherit from sqlrecord, but how has the class sqlrecord ignore my property id? So I can convert my application quickly without having to change my existing classes thanks for the great product

#4 Re: mORMot 1 » I want use mormot in my erp in Brazil help me please » 2014-04-06 14:45:54

ok I understand , I can not use  (id ) in the class definition because mormot manage this for me right? , but I can view it on the client in a grid ? ?, but Id is Autoincremet in database??? (postgres sample)

Using DataSnap can make objects aligned as follows one inside the other , any tips on how to do this in mormot? , I'm reading the extensive documentation but paradgma is another and I'm still learning , following example:

type: " ProdutoVO.TProdutoVO "
ID: 1
-fields : {
FID : 1
FGTIN : " 7896019606226 "
FNOME : " 01 PRODUCT OF THE GROUP SUBGROUP 01 01 "
FID_UNIDADE_PRODUTO 1
FID_ALMOXARIFADO 1
FID_GRUPO_TRIBUTARIO 1
FID_TRIBUT_ICMS_CUSTOM_CAB 1
FID_MARCA_PRODUTO 1
FID_SUB_GRUPO 1
FCODIGO_INTERNO : " 622 "
FNCM : " 17049010 "
FDESCRICAO : " 01 PRODUCT OF THE GROUP SUBGROUP 01 01 "
FDESCRICAO_PDV : "PRODUCT OF SUBGROUP 01 01 "
FVALOR_COMPRA : 4
FVALOR_VENDA 6
FPRECO_VENDA_MINIMO : 0
FPRECO_SUGERIDO : 0
FCUSTO_MEDIO_LIQUIDO : 0
FPRECO_LUCRO_ZERO : 0
FPRECO_LUCRO_MINIMO : 0
FPRECO_LUCRO_MAXIMO : 0
FMARKUP : 0
FQUANTIDADE_ESTOQUE : 0
FQUANTIDADE_ESTOQUE_ANTERIOR : 0
FESTOQUE_MINIMO 10
FESTOQUE_MAXIMO : 200
FESTOQUE_IDEAL : 100
FEXCLUIDO : " "
FINATIVO : " N "
FDATA_CADASTRO : 41367
FFOTO_PRODUTO : " "
FEX_TIPI : " "
FCODIGO_LST : " "
FCLASSE_ABC : "A"
FIAT : " T "
FIPPT : " T "
FTIPO_ITEM_SPED " 00"
FPESO : 0
FPORCENTO_COMISSAO : 0
FPONTO_PEDIDO : 0
FLOTE_ECONOMICO_COMPRA : 0
FALIQUOTA_ICMS_PAF 17
FALIQUOTA_ISSQN_PAF : 0
FTOTALIZADOR_PARCIAL : " 01T1700 "
FCODIGO_BALANCA : 0
FDATA_ALTERACAO : 41367
FVALIDADE : 0
Ftype : " V "
FTributIcmsCustomCabDescricao : " 15 % GST CUSTOM "
FUnidadeProdutoSigla : "UN "
FAlmoxarifadoNome : " test"
FTributGrupoTributarioDescricao : "PRODUCT SUBJECT TO OWN MANUFACTURE ICMS ST "
FProdutoMarcaNome : " test"
FProdutoSubGrupoNome : " SUB-GROUP 01 GROUP 01 "
FProdutoGrupoNome : " GROUP 01 "
FImagem : " "
FTipoImagem : " "
- FTributIcmsCustomCabVO : {
type: " TributIcmsCustomCabVO.TTributIcmsCustomCabVO "
ID: 2
-fields : {
FID : 1
FID_EMPRESA 1
FDESCRICAO : " 15 % GST CUSTOM "
FORIGEM_MERCADORIA : " "
FListaTributIcmsCustomDetVO : null
}
}
- FUnidadeProdutoVO : {
type: " UnidadeProdutoVO.TUnidadeProdutoVO "
id: 3
-fields : {
FID : 1
FSIGLA : "UN "
FDESCRICAO : " UNIT "
FPODE_FRACIONAR " S"
}
}
- FAlmoxarifadoVO : {
type: " AlmoxarifadoVO.TAlmoxarifadoVO "
ID: 4
-fields : {
FID : 1
FID_EMPRESA 1
FNOME : " test"
FEmpresaRazaoSocial : " "
FEmpresaVO : null
}
}
- FGrupoTributarioVO : {
type: " TributGrupoTributarioVO.TTributGrupoTributarioVO "
id: 5
-fields : {
FID : 1
FID_EMPRESA 1
FDESCRICAO : "PRODUCT SUBJECT TO OWN MANUFACTURE ICMS ST "
FORIGEM_MERCADORIA " 0 "
FOBSERVACAO : " 1 own manufacturing products ( subject to ICMS ST ) . "
}
}
- FProdutoMarcaVO : {
type: " ProdutoMarcaVO.TProdutoMarcaVO "
ID: 6
-fields : {
FID : 1
FNOME : " test"
FDESCRICAO : " "
}
}
- FProdutoSubGrupoVO : {
type: " ProdutoSubGrupoVO.TProdutoSubGrupoVO "
ID: 7
-fields : {
FID : 1
FID_GRUPO 1
FNOME : " SUB-GROUP 01 GROUP 01 "
FDESCRICAO : " SUB-GROUP 01 GROUP 01 "
FProdutoGrupoNome : " "
- FProdutoGrupoVO : {
type: " ProdutoGrupoVO.TProdutoGrupoVO "
ID: 8
-fields : {
FID : 1
FNOME : " GROUP 01 "
FDESCRICAO : " GROUP 01 "
}
}
}
}
}
}

#5 mORMot 1 » I want use mormot in my erp in Brazil help me please » 2014-04-06 05:14:51

Roberiopraciano
Replies: 7

good night , great job with the mormot , I have some questions:

I'm starting a restructuring of my erp and would like to make it 3 layers , so I started testing our DataSnap friend, but it does not seem very stable , so thank my countryman Roberto who tested DataSnap and mormot met your project , since then I have disclosed to all my fellow developers in Brazil but :

although WalterAlex have posted some videos and providing some examples , and you have spoken to think of the object and not in the database adopting mormot 'm almost definitely in my project , I hope you help me with some questions :

I have a Bank ( postgresql ) to the tables :

TB_UNIT
ID : integer ( auto generate controlled by postgresql ) primary key
Description : Varchar ( 50 )

TB_STOCK
ID : integer ( auto generate controlled by postgresql ) primary key
Description : Varchar ( 50 )

TB_PRODUCT
ID : integer ( auto generate controlled by postgresql ) primary key
Description : Varchar ( 50 )
ID_STOCK ( FOREIGN KEY FOR ID IN TB_STOCK )
ID_UNIT ( FOREIGN KEY FOR ID IN TB_UNIT )
VALUE_SALE (CURRENCY )
VALUE_COST (CURRENCY )

imagine you have a class :

Tunit = class ( TSQLRecord )

property id integer ;
property description : rawutf8 ;


Tstock = class ( TSQLRecord )
property id integer ;
property description : rawutf8 ;



TProducts = class ( TSQLRecord )
property id integer ;
property description : rawutf8 ;
id_stock property : integer ;
id_unit property : integer ;
valuesale property : currency ;
valuecost property : currency ;
_unit property Description : rawutf8 ; ( transient )
_stock property Description : rawutf8 ; ( transient )

grid because the product has the records aperecer thus:

Id | description | Product Id Stock | Unit Id | Value of sale | Value Cost | Drive Description | Description of stock

sample row on the client

1 | Egg | 1 | 1 | $ 3.5 | $ 1.4 | Box | Kitchen

I would like to know where can I start this?

another thing : you already work with objects lazy ?

and finally :


  how do I bring to an application and its items in a single query to the server mormot ? , and how do i update them one by one ? ?

#6 Re: mORMot 1 » Wizard endpoint » 2013-05-01 20:19:54

Thanks , beautiful work, i love it

#7 mORMot 1 » Wizard endpoint » 2013-05-01 08:19:47

Roberiopraciano
Replies: 2

Do you have think about

wizard or a http endpoint generating C# wrappers or object c or java android Dalkin ?

Needs Help?

#8 Re: mORMot 1 » FishFacts for mORMot » 2013-04-27 07:31:42

Congratulations, Warley Alex and Ab Great Work

Board footer

Powered by FluxBB