@jetsadaton/igsdbclient

IGS Db Client

MSSQL

   const instant = new MSSqlConnect(
   process.env.JWT as string,
   'mssql',
   'development',
   'TEST CLIENT'
 );
   const res = await instant.query<{ ID: number }>({
     sql: `SELECT ISNULL(max(id),0) + 1 as id from ERPDB.KPDBA.TEST t `,
   });

   const res = await instant.command({
     sql: `insert into ERPDB.KPDBA.test (id,first_name,last_name) values (${id} , 'firstname${id}', 'lastname${id}')`,
   });

ORACLE

   const instant = new OracleConnect(
   process.env.JWT as string,
   'oracle',
   'KPRAUD.KIMPAI.COM',
   'TEST CLIENT'
 );
   const res = await instant.query<{ ID: number }>({
     sql: `SELECT NVL(max(ID),0) + 1 as ID from KPDBA.TEST t `,
   });
 
   const res = await instant.command({
     sql: `insert into KPDBA.test (id,first_name,last_name) values (${id} , 'firstname${id}', 'lastname${id}')`,
   });