Configuração

# 1. Extrair o pacote
unzip ctc-extrator.zip
cd ctc-extrator

# 2. Copiar o template de configuração
cp .env.example .env

# 3. Preencher com as credenciais e parâmetros do seu ambiente
nano .env

# 4. Iniciar
docker compose up --build

SRC_TYPE="oracle"
SRC_CONNECTION_STR="host:1521/service_name"
SRC_USER="usuario"
SRC_PASSWORD="senha"

# Banco compartilhado (fallback para todos os domínios)
SRC_TYPE="oracle"
SRC_CONNECTION_STR="host-principal:1521/DB_PRINCIPAL"
SRC_USER="usuario"
SRC_PASSWORD="senha"

# Produtividade usa banco próprio
PROD_SRC_CONNECTION_STR="host-prod:1521/DB_PROD"
PROD_SRC_USER="usuario_prod"
PROD_SRC_PASSWORD="senha_prod"

# Plantio usa outro banco
PLANT_SRC_CONNECTION_STR="host-plant:1521/DB_PLANT"
PLANT_SRC_USER="usuario_plant"
PLANT_SRC_PASSWORD="senha_plant"

LOG_LEVEL=info

# OAuth2
AUTH_URL=https://login.microsoftonline.com/{tenant-id}/oauth2/v2.0/token
CLIENT_ID=seu-client-id
CLIENT_SECRET=seu-client-secret

# API CTC
API_BASE_URL=https://api.ctc.com.br/v1/integrations/{partnerId}

# Oracle compartilhado
SRC_TYPE=oracle
SRC_CONNECTION_STR=meu-oracle.empresa.com.br:1521/PROD
SRC_USER=ctc_extrator
SRC_PASSWORD=senha_segura

# Produtividade
PROD_CRON=0 5 * * *
PROD_SRC_QUERY_LIMIT=1000
PROD_QUERY_CTRL_MIN_DEFAULT=2020-03-01
PROD_LOG_QUERIES=true
PROD_QUERY_CTRL_MAX=SELECT MAX(DT_DATA_REALIZADO) AS CTRL_MAX FROM VW_CTC_PRODUCAO WHERE DT_DATA_REALIZADO > TO_DATE('{{ctrl_min}}', 'YYYY-MM-DD HH24:MI:SS')
PROD_QUERY_TEMPLATE=SELECT * FROM ( SELECT inner_query.*, ROWNUM rn FROM ( SELECT * FROM VW_CTC_PRODUCAO WHERE DT_DATA_REALIZADO > TO_DATE('{{ctrl_min}}', 'YYYY-MM-DD HH24:MI:SS') AND DT_DATA_REALIZADO <= TO_DATE('{{ctrl_max}}', 'YYYY-MM-DD HH24:MI:SS') ORDER BY DT_DATA_REALIZADO ASC ) inner_query WHERE ROWNUM <= {{offset}} + {{limit}} ) WHERE rn > {{offset}}

# Plantio
PLANT_CRON=0 5 * * *
PLANT_SRC_QUERY_LIMIT=1000
PLANT_QUERY_CTRL_MIN_DEFAULT=2024-01-01
PLANT_LOG_QUERIES=true
PLANT_QUERY_CTRL_MAX=SELECT MAX(DT_DATA_PLANTIO) AS CTRL_MAX FROM VW_CTC_PLANTIO WHERE DT_DATA_PLANTIO > TO_DATE('{{ctrl_min}}', 'YYYY-MM-DD HH24:MI:SS')
PLANT_QUERY_TEMPLATE=SELECT * FROM ( SELECT inner_query.*, ROWNUM rn FROM ( SELECT * FROM VW_CTC_PLANTIO WHERE DT_DATA_PLANTIO > TO_DATE('{{ctrl_min}}', 'YYYY-MM-DD HH24:MI:SS') AND DT_DATA_PLANTIO <= TO_DATE('{{ctrl_max}}', 'YYYY-MM-DD HH24:MI:SS') ORDER BY DT_DATA_PLANTIO ASC ) inner_query WHERE ROWNUM <= {{offset}} + {{limit}} ) WHERE rn > {{offset}}

# CTT
CTT_CRON=0 5 * * *
CTT_SRC_QUERY_LIMIT=1000
CTT_QUERY_CTRL_MIN_DEFAULT=2020-01-01
CTT_LOG_QUERIES=true
CTT_QUERY_CTRL_MAX=SELECT MAX(DT_DATA_COLHEITA) AS CTRL_MAX FROM VW_CTC_CTT WHERE DT_DATA_COLHEITA > TO_DATE('{{ctrl_min}}', 'YYYY-MM-DD HH24:MI:SS')
CTT_QUERY_TEMPLATE=SELECT * FROM ( SELECT inner_query.*, ROWNUM rn FROM ( SELECT * FROM VW_CTC_CTT WHERE DT_DATA_COLHEITA > TO_DATE('{{ctrl_min}}', 'YYYY-MM-DD HH24:MI:SS') AND DT_DATA_COLHEITA <= TO_DATE('{{ctrl_max}}', 'YYYY-MM-DD HH24:MI:SS') ORDER BY DT_DATA_COLHEITA ASC ) inner_query WHERE ROWNUM <= {{offset}} + {{limit}} ) WHERE rn > {{offset}}

# Ordem de Serviço
ORDEM_CRON=0 5 * * *
ORDEM_SRC_QUERY_LIMIT=1000
ORDEM_QUERY_CTRL_MIN_DEFAULT=2020-01-01
ORDEM_LOG_QUERIES=true
ORDEM_QUERY_CTRL_MAX=SELECT MAX(DT_DATA_ORDEM) AS CTRL_MAX FROM VW_CTC_ORDEM WHERE DT_DATA_ORDEM > TO_DATE('{{ctrl_min}}', 'YYYY-MM-DD HH24:MI:SS')
ORDEM_QUERY_TEMPLATE=SELECT * FROM ( SELECT inner_query.*, ROWNUM rn FROM ( SELECT * FROM VW_CTC_ORDEM WHERE DT_DATA_ORDEM > TO_DATE('{{ctrl_min}}', 'YYYY-MM-DD HH24:MI:SS') AND DT_DATA_ORDEM <= TO_DATE('{{ctrl_max}}', 'YYYY-MM-DD HH24:MI:SS') ORDER BY DT_DATA_ORDEM ASC ) inner_query WHERE ROWNUM <= {{offset}} + {{limit}} ) WHERE rn > {{offset}}

# Pragas
PRAGAS_CRON=0 5 * * *
PRAGAS_SRC_QUERY_LIMIT=1000
PRAGAS_QUERY_CTRL_MIN_DEFAULT=2020-01-01
PRAGAS_LOG_QUERIES=true
PRAGAS_QUERY_CTRL_MAX=SELECT MAX(DT_DATA_PRAGA) AS CTRL_MAX FROM VW_CTC_PRAGAS WHERE DT_DATA_PRAGA > TO_DATE('{{ctrl_min}}', 'YYYY-MM-DD HH24:MI:SS')
PRAGAS_QUERY_TEMPLATE=SELECT * FROM ( SELECT inner_query.*, ROWNUM rn FROM ( SELECT * FROM VW_CTC_PRAGAS WHERE DT_DATA_PRAGA > TO_DATE('{{ctrl_min}}', 'YYYY-MM-DD HH24:MI:SS') AND DT_DATA_PRAGA <= TO_DATE('{{ctrl_max}}', 'YYYY-MM-DD HH24:MI:SS') ORDER BY DT_DATA_PRAGA ASC ) inner_query WHERE ROWNUM <= {{offset}} + {{limit}} ) WHERE rn > {{offset}}

# Clima
CLIMA_CRON=0 5 * * *
CLIMA_SRC_QUERY_LIMIT=1000
CLIMA_QUERY_CTRL_MIN_DEFAULT=2020-01-01
CLIMA_LOG_QUERIES=true
CLIMA_QUERY_CTRL_MAX=SELECT MAX(DT_DATA_CLIMA) AS CTRL_MAX FROM VW_CTC_CLIMA WHERE DT_DATA_CLIMA > TO_DATE('{{ctrl_min}}', 'YYYY-MM-DD HH24:MI:SS')
CLIMA_QUERY_TEMPLATE=SELECT * FROM ( SELECT inner_query.*, ROWNUM rn FROM ( SELECT * FROM VW_CTC_CLIMA WHERE DT_DATA_CLIMA > TO_DATE('{{ctrl_min}}', 'YYYY-MM-DD HH24:MI:SS') AND DT_DATA_CLIMA <= TO_DATE('{{ctrl_max}}', 'YYYY-MM-DD HH24:MI:SS') ORDER BY DT_DATA_CLIMA ASC ) inner_query WHERE ROWNUM <= {{offset}} + {{limit}} ) WHERE rn > {{offset}}

PROD_CRON=0 */6 * * *    # A cada 6 horas
PROD_CRON=0 2 * * *      # Diariamente às 02:00
PROD_CRON=*/30 * * * *   # A cada 30 minutos
PROD_CRON=0 8 * * 1-5    # Segunda a sexta às 08:00

# Certifique-se que .env está no .gitignore
echo ".env" >> .gitignore

# Versione apenas o template
git add .env.example

docker exec app find /opt/oracle -name "*.so*" | head -20

curl -X POST "$AUTH_URL" \
  -H "Content-Type: application/x-www-form-urlencoded" \
  -d "grant_type=client_credentials&client_id=$CLIENT_ID&client_secret=$CLIENT_SECRET&scope=.default"