Files
feiqiu-ETL/etl_billiards/.env.example
2025-11-30 07:19:05 +08:00

60 lines
1.2 KiB
Plaintext
Raw Permalink Blame History

# 鏁版嵁搴撻厤缃<E58EA4>
PG_DSN=postgresql://user:password@localhost:5432/....
PG_HOST=localhost
PG_PORT=5432
PG_NAME=LLZQ
PG_USER=local-Python
PG_PASSWORD=your_password_here
PG_CONNECT_TIMEOUT=10
# API閰嶇疆
API_BASE=https://api.example.com
API_TOKEN=your_token_here
API_TIMEOUT=20
API_PAGE_SIZE=200
API_RETRY_MAX=3
API_RETRY_BACKOFF=[1,2,4]
# 搴旂敤閰嶇疆
STORE_ID=2790685415443269
TIMEZONE=Asia/Taipei
SCHEMA_OLTP=billiards
SCHEMA_ETL=etl_admin
# 璺<>緞閰嶇疆
EXPORT_ROOT=/path/to/export
LOG_ROOT=/path/to/logs
FETCH_ROOT=/path/to/json_fetch
INGEST_SOURCE_DIR=
WRITE_PRETTY_JSON=false
MANIFEST_NAME=manifest.json
INGEST_REPORT_NAME=ingest_report.json
# ETL閰嶇疆
OVERLAP_SECONDS=120
WINDOW_BUSY_MIN=30
WINDOW_IDLE_MIN=180
IDLE_START=04:00
IDLE_END=16:00
ALLOW_EMPTY_RESULT_ADVANCE=true
# 娓呮礂閰嶇疆
LOG_UNKNOWN_FIELDS=true
HASH_ALGO=sha1
STRICT_NUMERIC=true
ROUND_MONEY_SCALE=2
# 娴嬭瘯/绂荤嚎妯″紡
TEST_MODE=ONLINE
TEST_JSON_ARCHIVE_DIR=tests/source-data-doc
TEST_JSON_TEMP_DIR=/tmp/etl_billiards_json_tmp
# 娴嬭瘯鏁版嵁搴擄紙鍙<E7B499>€夛細鑻ヨ<E991BB><EFBFBD>垯鍗曞厓娴嬭瘯杩炲叆姝<E58F86> DSN锛<4E>
TEST_DB_DSN=
# ODS 重建脚本配置(开发用)
JSON_DOC_DIR=C:\dev\LLTQ\export\test-json-doc
ODS_INCLUDE_FILES=
ODS_DROP_SCHEMA_FIRST=true