```typescript 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
npm install @jetsadaton/igsdbclientIGS Db Clienttypescript
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
`typescript
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}'),
});
``