summaryrefslogtreecommitdiff
path: root/lib/oracle-knex/README.md
diff options
context:
space:
mode:
authordujinkim <dujin.kim@dtsolution.co.kr>2025-05-28 00:30:18 +0000
committerdujinkim <dujin.kim@dtsolution.co.kr>2025-05-28 00:30:18 +0000
commit217e215e5487b53db7d64fe3d809c47289cd83ae (patch)
treeacead961488299e640f73365ccd4949f9a002ab3 /lib/oracle-knex/README.md
parent1d86653b12ec52cd6ba4b92a7b6a841506a190c5 (diff)
(김준회) 오라클 DB 연결을 위한 처리
Diffstat (limited to 'lib/oracle-knex/README.md')
-rw-r--r--lib/oracle-knex/README.md54
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