DB2 ORM NPM

This is a node module which extracted from loopback and integrated with all the tools and loopback components you may need.

SETUP

It's going to be simple, just run : npm i -s db2orm

SAMPLE

you can run the code inside the repo by running this inside test folder : npm run debug or for silent test mode : npm run debug:silent

Simply specify your model in a seperate file and include it in the project.

Code for create the sample model: (it will automatically generate the table if does not exist).

CREATE TABLE "MYSCHEMA"."USERENTITY" ( "TITLE" CHAR(5 OCTETS), "FIRSTNAME" CHAR(25 OCTETS) NOT NULL , "SURNAME" CHAR(30 OCTETS) NOT NULL , "ADDRESS_L1" CHAR(30 OCTETS) WITH DEFAULT '' , "ADDRESS_L2" CHAR(30 OCTETS) WITH DEFAULT '' , "ADDRESS_L3" CHAR(30 OCTETS) WITH DEFAULT '' , "ADDRESS_L4" CHAR(30 OCTETS) WITH DEFAULT '' , "POSTCODE" CHAR(10 OCTETS) WITH DEFAULT '' , "MOBILE" CHAR(20 OCTETS) , "MARITAL_STATUS" CHAR(1 OCTETS) NOT NULL , "EMAIL" VARCHAR(254 OCTETS) , "GENDER" CHAR(1 OCTETS) NOT NULL )