Samet IT : Oracle Common

ts backend component

                          __                                                 
  ____  _________ ______/ ___     _________  ____ ___  ____ ___  ____  ____ 
 / __ \/ ___/ __ `/ ___/ / _ \   / ___/ __ \/ __ `__ \/ __ `__ \/ __ \/ __ \
/ /_/ / /  / /_/ / /__/ /  __/  / /__/ /_/ / / / / / / / / / / / /_/ / / / /
\____/_/   \__,_/\___/_/\___/   \___/\____/_/ /_/ /_/_/ /_/ /_/\____/_/ /_/ 

• EN: It should be used by another oracle based component, don't use directly!
• TR: Bu bileşeni sadece oracle'a bağlanan başka bir bileşen kullanmalıdır, direkt kullanmayınız.

Prerequisite

• Help
• 1 - Install Git
• 2 - Build Up a Git Connection
• 3 - Install Node/NPM
• 4 - Create Project Folder
• 5 - Bind Projects Folder to Git

Usage

• EN: How to add into your project?
• TR: Projene nasıl eklersin?

npm i @samet-it/be-oracle-common

Environments

• OracleCommon

| Name | Type | Default | Required | Secret | Description | |----------------------------------|---------|--------------------------------|----------|--------|---------------------------------------------------------------| | ORA_DIR | string | read | ✅ | | Oracle instant client folder | | ORA_PORT | integer | 1521 | | | DB Port number | | ORA_ACQUIRE_CONNECTION_TIMEOUT | integer | 10,000 ms | | | Timeout for acquiring a new connection from pool as msec | | ORA_POOL_MIN | integer | 2 | | | Minimum connections in the pool | | ORA_POOL_MAX | integer | 10 | | | Maximum connections in the pool | | ORA_POOL_IDLE_TIMEOUT_MILLIS | integer | 60,000 ms | | | Idle timeout to clear unused connections in the pool, as msec |

Oracle Instant Client

[!important] Please install Oracle Instant Client at given folder below by OS

| OS | Folder | |-----------|-------------------------------------------------| | Windows | C://projects/samet-it/instant-client | | Mac | /Users/${user}/projects/samet-it/instant-client | | Linux | /home/${user}/projects/samet-it/instant-client | | Docker | /usr/src/app/instant-client |

Contents

• oracleCommonConfig : Oracle connection defaults
• oracleClient : Oracle client for connection

Development

You can start to develop on it

Step 1

• Go to project folder

Step 2

• EN: Clone the project
• TR: Projeyi bilgisayarına çek

git clone https://github.com/samet-digital/be-oracle-common.git -b development

Dependencies

• @samet-it/be-base-common: samet base common
• @leyyo/*: leyyo utilities
• oracledb: oracle client

Commands

• Component Commands

Standards

+ language: TS 
+ lint: eslint
+ inspections: intelli-j code inspections
+ ddd: domain driven development
+ edd: exception driven development
! tdd: test driven development
+ ldd: log driven development
+ ddd: document driven development

History

| Date | Developer | Info | Ticket | |------------|----------------|--------------|----------------| | 2025-08-12 | Mustafa Yelmer | Created | ~~none~~ | | 2025-08-14 | Mustafa Yelmer | Documented | ~~none~~ | | 2026-01-10 | Mustafa Yelmer | Refactored | ~~none~~ |