生产数据库演练 · 2026-04-27 03:24:03

备份、恢复、表结构、鉴权 API 回读已完成演练

本页用于给客户确认生产数据库上线前的技术准备状态。当前使用 SQLite DB 模式完成可重复演练，并已按 RBAC 收紧后的登录态读取配送与生产化数据；拿到生产 MySQL 地址、账号和备份目录后，同一流程切换到真实生产实例执行。

PASS演练结论
22已核验业务表
PASS鉴权 API 回读

关键检查

API 健康：PASS；订单 API 回读：1；生产化检查 API 回读：9；当前生产化阻断：2；恢复库订单/账单/反馈计数：{"orders":1,"bills":1,"readinessItems":9,"feedback":0}。

表结构清单

BillBillItemCommissionRecordDeliveryOrderFulfillmentOrderOrderOrderItemPaymentRecordProductReleaseEventProductReleaseVersionProductStateProductionReadinessActionProductionReadinessItemSalesmanStoreBindingSettlementRuleSignImageSignItemSignRecordStoreWalletSupplierSettlementSupplierSettlementItemTestFeedback

机器可读报告

打开 report.json

{
  "title": "龙虾供应链配送系统生产数据库演练报告",
  "updatedAt": "2026-04-27 03:24:03",
  "mode": "sqlite-drill",
  "status": "PASS",
  "databaseFile": "/tmp/xia-production-db-drill/production-drill.db",
  "backupFile": "/tmp/xia-production-db-drill/production-drill.backup.db",
  "restoreFile": "/tmp/xia-production-db-drill/production-drill.restore.db",
  "checks": {
    "health": "PASS",
    "seededOrdersFromApi": 1,
    "readinessItemsFromApi": 9,
    "readinessBlockersFromApi": 2,
    "rbacAuthenticatedApiRead": "PASS",
    "restoreCounts": {
      "orders": 1,
      "bills": 1,
      "readinessItems": 9,
      "feedback": 0
    },
    "schemaTables": [
      "Bill",
      "BillItem",
      "CommissionRecord",
      "DeliveryOrder",
      "FulfillmentOrder",
      "Order",
      "OrderItem",
      "PaymentRecord",
      "ProductReleaseEvent",
      "ProductReleaseVersion",
      "ProductState",
      "ProductionReadinessAction",
      "ProductionReadinessItem",
      "SalesmanStoreBinding",
      "SettlementRule",
      "SignImage",
      "SignItem",
      "SignRecord",
      "StoreWallet",
      "SupplierSettlement",
      "SupplierSettlementItem",
      "TestFeedback"
    ]
  },
  "nextProductionStep": "开发侧 DB 初始化、鉴权 API 回读、备份、恢复和计数校验已可复跑；拿到生产 MySQL 地址、账号和备份目录后，将同一套流程切换到真实实例。"
}