Files

XuJiacheng 286b605e4f feat(数据库): 实现双数据库写入功能并优化数据同步

添加对G5数据库的支持，实现双数据库同时写入功能
重构数据库配置和连接管理，支持主库和G5库的独立配置
优化数据同步逻辑，添加缺失字段并保持现有字段不变
改进数据过滤和事务处理，增强错误处理和日志记录

2026-04-03 18:47:31 +08:00

2026-04-03 18:47:31 +08:00

2026-04-03 18:47:31 +08:00

2026-02-02 09:10:53 +08:00

.env

2026-04-03 18:47:31 +08:00

.env.example

2026-02-02 09:10:53 +08:00

local.db

2026-02-02 09:10:53 +08:00

package-lock.json

2026-03-13 09:27:55 +08:00

package.json

2026-03-13 09:27:55 +08:00

project1.md

2026-02-02 09:10:53 +08:00

README.md

2026-02-02 09:10:53 +08:00

Temporary Project Management

This is a local Node.js project for fetching hotel data and loop addresses, managing them in a local SQLite database.

Prerequisites

Clone or navigate to the project directory.
Install dependencies:
```
npm install
```
Copy .env.example to .env and configure:
```
cp .env.example .env
```
(On Windows: copy .env.example .env)

PORT: App port (default 3000)
DB_FILE: Path to SQLite database file (default ./local.db)
ENABLED_HOTEL_IDS: Comma-separated list of Hotel IDs to fetch loops for (e.g., 1085,2144)
API_BASE_URL: Base URL for external APIs

Database Locks: If you encounter SQLITE_BUSY, ensure no other process (like a DB viewer) has the file open. The app handles some concurrency but file locks can block it.
API Timeouts: If the API is slow, the app is configured with a 100s timeout and 2 retries. Check your network connection.
Logs: Check logs/ directory for daily application logs and error snapshots.