diff options
Diffstat (limited to 'lib/oracle-knex/README.md')
| -rw-r--r-- | lib/oracle-knex/README.md | 54 |
1 files changed, 0 insertions, 54 deletions
diff --git a/lib/oracle-knex/README.md b/lib/oracle-knex/README.md deleted file mode 100644 index fdff6e2f..00000000 --- a/lib/oracle-knex/README.md +++ /dev/null @@ -1,54 +0,0 @@ -# oracledb / knex.js 사용 방법 - -1. oracledb로 SQL 직접 사용하기 - -```ts - // Oracle DB 연결 설정 - const connection = await oracledb.getConnection({ - user: process.env.ORACLE_USER, - password: process.env.ORACLE_PASSWORD, - connectString: process.env.ORACLE_CONNECTION_STRING - - }); - - // 쿼리 수행 - const result = await connection.execute('SELECT 1 FROM DUAL'); - - // 연결 종료 - await connection.close(); -``` - -2. knex.js에서 SQL 직접 사용하기 - -```ts -export const oracleKnex = knex({ - client: 'oracledb', - connection: { - user: process.env.ORACLE_USER, - password: process.env.ORACLE_PASSWORD, - connectString: process.env.ORACLE_CONNECTION_STRING, - }, - pool: { min: 0, max: 5 } -}); - -sql = 'SELECT 1 FROM DUAL;' -const result = await oracleKnex.raw(sql); -``` - -3. knex.js에서 쿼리빌더 사용하기 -```ts -export const oracleKnex = knex({ - client: 'oracledb', - connection: { - user: process.env.ORACLE_USER, - password: process.env.ORACLE_PASSWORD, - connectString: process.env.ORACLE_CONNECTION_STRING, - }, - pool: { min: 0, max: 5 } -}); - -const result = await knex -.qb -.select('column1', 'column2', 'column3') -.from('table_name') -```
\ No newline at end of file |
