108 lines
3.4 KiB
Python
108 lines
3.4 KiB
Python
#!/usr/bin/env python3
|
||
# -*- coding: utf-8 -*-
|
||
"""
|
||
Google Drive 連接測試腳本
|
||
"""
|
||
|
||
import sys
|
||
import os
|
||
|
||
# 確保可以導入專案模組
|
||
sys.path.insert(0, os.path.dirname(os.path.abspath(__file__)))
|
||
|
||
from services.google_drive_service import drive_service
|
||
from services.import_service import import_service
|
||
|
||
|
||
def main():
|
||
print("=" * 60)
|
||
print("Google Drive 連接測試")
|
||
print("=" * 60)
|
||
print()
|
||
|
||
# 測試 1: 認證
|
||
print("🔐 步驟 1: 測試 Google Drive 認證...")
|
||
if drive_service.authenticate():
|
||
print("✅ 認證成功！")
|
||
else:
|
||
print("❌ 認證失敗！")
|
||
print(" 請確認 config/google_credentials.json 檔案存在")
|
||
return
|
||
print()
|
||
|
||
# 測試 2: 取得配置
|
||
print("⚙️ 步驟 2: 讀取匯入配置...")
|
||
folder_path = import_service.get_config('gdrive_folder_path', '業績報表/當日業績')
|
||
file_pattern = import_service.get_config('gdrive_file_pattern', '即時業績_當日')
|
||
print(f" 資料夾路徑: {folder_path}")
|
||
print(f" 檔案模式: {file_pattern}")
|
||
print()
|
||
|
||
# 測試 3: 列出檔案
|
||
print("📁 步驟 3: 列出 Google Drive 檔案...")
|
||
files = drive_service.list_files_in_folder(folder_path, file_pattern)
|
||
|
||
if files:
|
||
print(f"✅ 找到 {len(files)} 個檔案：")
|
||
for i, file in enumerate(files, 1):
|
||
print(f" {i}. {file['name']}")
|
||
print(f" ID: {file['id']}")
|
||
print(f" 大小: {file.get('size', 'N/A')} bytes")
|
||
print(f" 修改時間: {file.get('modifiedTime', 'N/A')}")
|
||
print()
|
||
else:
|
||
print("⚠️ 沒有找到符合條件的檔案")
|
||
print()
|
||
print("💡 提示:")
|
||
print(" 1. 確認 Google Drive 資料夾路徑正確")
|
||
print(" 2. 確認資料夾中有 Excel 檔案")
|
||
print(" 3. 檔案名稱是否包含指定的模式")
|
||
print()
|
||
|
||
# 測試 4: 查詢最近的匯入任務
|
||
print("📊 步驟 4: 查詢最近的匯入任務...")
|
||
jobs = import_service.get_recent_jobs(limit=5)
|
||
|
||
if jobs:
|
||
print(f"✅ 找到 {len(jobs)} 個最近的任務：")
|
||
for job in jobs:
|
||
status_emoji = {
|
||
'pending': '⏳',
|
||
'downloading': '⬇️',
|
||
'importing': '📥',
|
||
'completed': '✅',
|
||
'failed': '❌'
|
||
}.get(job['status'], '❓')
|
||
|
||
print(f" {status_emoji} 任務 {job['id']}: {job['status']}")
|
||
print(f" 檔案: {job.get('drive_file_name', 'N/A')}")
|
||
print(f" 進度: {job.get('progress_percent', 0)}%")
|
||
print(f" 成功: {job.get('success_rows', 0)} 筆")
|
||
if job.get('error_message'):
|
||
print(f" 錯誤: {job['error_message']}")
|
||
print()
|
||
else:
|
||
print("ℹ️ 尚無匯入記錄")
|
||
print()
|
||
|
||
print("=" * 60)
|
||
print("測試完成！")
|
||
print("=" * 60)
|
||
print()
|
||
print("🌐 開啟網頁介面查看詳細資訊:")
|
||
print(" http://localhost/auto_import")
|
||
print()
|
||
|
||
|
||
if __name__ == "__main__":
|
||
try:
|
||
main()
|
||
except KeyboardInterrupt:
|
||
print("\n\n❌ 使用者中斷測試")
|
||
sys.exit(1)
|
||
except Exception as e:
|
||
print(f"\n\n❌ 測試過程發生錯誤: {str(e)}")
|
||
import traceback
|
||
traceback.print_exc()
|
||
sys.exit(1)
|