PJS ORM

This is an overview of the files within this project and to show usage of the recently added ORM into PJS.

• Starting with file customers.dbdefn.js

  • This is the business logic and mapper and model builder.

• test.js - server side node program does actions against that dbdefn

Under the covers the data access is all happening by way of this pjs.dataapi object. The dataapi object constructs the basic SQL statements for the supported database. There really is not a whole lot difference, but enought that I seen this object was necessary.

• Check out documentation for profound.util.dataapi

• Soon we will have our DataArea API's, when working against a non IBMi db, use SQL as well. Customer code will not have to change, they will, however, need to "transfer" the data from the ibmi object to that other db with our tool.

• Some things not "yet" being supported

  • Record locking
  • Multiple inserts within a single statements