const db = rds({
  user: 'USER',
  password: 'PASSWORD',
  connectString: '127.0.0.1:1521/tns',
  // 其他参数
});
// need open pool.
await client.createPool();

let row = {
  test01: 'test2',
  test02: 'test2',
  test03: 'test2',
  test04: 'test2',
}
const result = await this.app.oracle.insert('test', row);
// result is affectedRows :
// 1

let row = {
  test01: 'test3',
  test02: 'test3',
  test03: 'test3',
}
const result = await this.app.oracle.update('test', row, {
  where: {
    test01: 'test2'
  }
});
// result is affectedRows :
// 1

const tests = await this.app.oracle.get('test');
// SELECT * FROM (SELECT t.* ,ROW_NUMBER() OVER( ORDER BY ' ' ) AS NUM FROM test t ) tt WHERE NUM BETWEEN 0 AND 1
// result is rows 

const tests = await this.app.oracle.select('test');
// result is rows 
const tests = await this.app.oracle.select('test', {
  where: {
    test01: ['3','4']
  },
  columns: ['test01', 'test02']
});
// SELECT test01,test02 FROM test WHERE test01 BETWEEN '3' AND '4'  ORDER BY ' '

const result = await this.app.oracle.delete('test', {
  test01: 'test2'
});
// result is affectedRows :
// 1

const tests = await this.app.oracle.count('test');
// result is a number 

const result = await this.app.oracle.transaction(async function(conn) {
  const test1 = await conn.insert('test', {
    test01: 'test4',
    test02: 'test4',
    test03: 'test4',
    test04: 'test4',
  })
  const test2 = await conn.query('select test01,test02 from test where test01=:test01', ['3']);
  const count = await conn.count('test');
  // dont need commit, its autoCommit, when error throw will autoRollback!
  // after run, you can open http://127.0.0.1:7001/count to valid!
  // await conn.commit();
  return {
    test1, count, test2
  };
});

const result = await this.app.oracle.busness(async function(conn) {
  const test1 = await conn.insert('test', {
    test01: 'test4',
    test02: 'test4',
    test03: 'test4',
    test04: 'test4',
  })
  const test2 = await conn.query('select test01,test02 from test where test01=:test01', ['3']);
  const count = await conn.count('test');
  // commit is very important !!!
  // if dont commit() : after run, you can open http://127.0.0.1:7001/count to valid! (default is rollback)
  await conn.commit(); 
  return {
    test1, count, test2
  };
});

const result = await this.app.oracle.query('select test01,test02 from test where test01=:test01', ['3']);