1

npm install @testcontainers/oraclefree --save-dev

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22

const customDatabase = "TESTDB";
const customUsername = "CUSTOMUSER";
const customPassword = "customPassword";
await using container = await new OracleDbContainer(IMAGE)
  .withDatabase(customDatabase)
  .withUsername(customUsername)
  .withPassword(customPassword)
  .start();

const connection = await oracledb.getConnection({
  user: container.getUsername(),
  password: container.getPassword(),
  connectString: container.getUrl(),
});

const result = await connection.execute("SELECT SYS_CONTEXT('USERENV', 'CON_NAME') FROM DUAL");
expect(result.rows?.[0]).toEqual([customDatabase]);

const resultUser = await connection.execute("SELECT USER FROM DUAL");
expect(resultUser.rows?.[0]).toEqual([customUsername]);

await connection.close();