1.0.2 • Published 2 years ago
@rockads/data-suite-db-orm v1.0.2
DATA SUITE DB ORM
This package writed for after the decision of sql injection issues and raw sql queries issues Basicly, this package create orm objects dynamicly with your sql schemas for using backend projects. You can use like this,
const db = require('@rockads/data-suite-db-orm')(config);
const appList =await db.apps()
//or
const appList = await db.apps().where(...)
//or
const appListWithDetail = await db.apps().getWithDetail1(columnsOptions)
//
const appListWithDetailAndMaster = await db.apps().getWithDetail1(columnsOptions).getWithMasterTable(columnOptions);
// inserting
const newApp = await db.app().insertOrUpdate(row);
columnOptions ===> (id,column1,column2)
columnOptions ===> {id:ID,column1:anotherColumnName,column2:foo} if you wish use as word at column
if you dont pass any args to column options system accepting "*" words