1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
|
# 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')
```
|
