IBDataSync/.env.template at main · IB-il/IBDataSync · GitHub

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
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
# IBDataSync Environment Configuration Template
# Copy this file to .env and fill in your actual values

# =============================================================================
# DATABASE CONFIGURATION
# =============================================================================
DB_SERVER=iba-reporting-srv.database.windows.net
DB_NAME=IBAR.Master
DB_USER=ReadOnlyIBARMaster
DB_PASSWORD=Boston_25

# Database Connection Settings
DB_TIMEOUT=30
DB_MAX_CONNECTIONS=10
DB_ALLOWED_TABLES=dbo.TradesExes,dbo.TradeAccounts,dbo.AssociatedPersons,dbo.TradeCommBDs

# =============================================================================
# ZOHO CRM API CONFIGURATION
# =============================================================================
ZOHO_CLIENT_ID=your_existing_client_id
ZOHO_CLIENT_SECRET=your_existing_secret
ZOHO_REFRESH_TOKEN=your_existing_refresh_token
ZOHO_BASE_URL=https://www.zohoapis.com/crm/v8
ZOHO_ACCOUNTS_API_DOMAIN=https://accounts.zoho.com

# =============================================================================
# SYNCHRONIZATION SETTINGS
# =============================================================================
# Batch processing settings
SYNC_BATCH_SIZE=1000
ZOHO_BULK_LIMIT=100
MAX_RETRY_ATTEMPTS=3

# Processing intervals (in seconds)
SYNC_INTERVAL=86400  # Daily = 24 hours
HEALTH_CHECK_INTERVAL=300  # 5 minutes

# =============================================================================
# LOGGING CONFIGURATION
# =============================================================================
LOG_LEVEL=INFO
LOG_FILE_PATH=logs/sync_{date}.log
LOG_MAX_SIZE_MB=50
LOG_BACKUP_COUNT=7

# =============================================================================
# SECURITY SETTINGS
# =============================================================================
# Enable audit logging
ENABLE_AUDIT_LOGGING=true

# Hash algorithm settings
HASH_ALGORITHM=sha256
HASH_FIELDS_ENCODING=utf-8

# =============================================================================
# PERFORMANCE TUNING
# =============================================================================
# Memory management
MAX_MEMORY_USAGE_MB=1024
ENABLE_STREAMING_MODE=false

# File processing
XML_PROCESSING_THREADS=4
TEMP_FILE_CLEANUP=true

# =============================================================================
# MONITORING & ALERTS
# =============================================================================
# Performance thresholds
MAX_PROCESSING_TIME_MINUTES=30
MAX_CHANGE_PERCENTAGE=10

# Alert settings (optional)
[email protected]
SLACK_WEBHOOK_URL=https://hooks.slack.com/services/your/webhook/url