diff options
| author | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-05-28 00:30:18 +0000 |
|---|---|---|
| committer | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-05-28 00:30:18 +0000 |
| commit | 217e215e5487b53db7d64fe3d809c47289cd83ae (patch) | |
| tree | acead961488299e640f73365ccd4949f9a002ab3 /lib/oracle-knex/README.md | |
| parent | 1d86653b12ec52cd6ba4b92a7b6a841506a190c5 (diff) | |
(김준회) 오라클 DB 연결을 위한 처리
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 |
