migrate_payment_fee.py 2.1 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647
  1. import asyncio
  2. from sqlalchemy import text
  3. from app.core.database import engine
  4. async def migrate():
  5. async with engine.begin() as conn:
  6. res = await conn.execute(text("""
  7. SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS
  8. WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'vas_payment';
  9. """))
  10. cols = [r[0] for r in res.fetchall()]
  11. print("Existing columns in vas_payment:", cols)
  12. if "fee_rate" not in cols:
  13. print("Adding fee_rate column...")
  14. await conn.execute(text("ALTER TABLE vas_payment ADD COLUMN fee_rate DECIMAL(6,4) NOT NULL DEFAULT 0.0000 COMMENT '手续费率' AFTER random_offset;"))
  15. print("Added fee_rate.")
  16. else:
  17. print("fee_rate column already exists.")
  18. if "fee_amount" not in cols:
  19. print("Adding fee_amount column...")
  20. await conn.execute(text("ALTER TABLE vas_payment ADD COLUMN fee_amount INT NOT NULL DEFAULT 0 COMMENT '手续费金额' AFTER fee_rate;"))
  21. print("Added fee_amount.")
  22. else:
  23. print("fee_amount column already exists.")
  24. # Also initialize default provider config for fee_rate if null or empty
  25. import json
  26. print("Checking vas_payment_provider configs...")
  27. for name, cfg in [
  28. ('stripe', {'fee_rate': 0.035, 'fee_fixed': 30, 'fee_label': '3.5% + €0.30'}),
  29. ('creem', {'fee_rate': 0.035, 'fee_fixed': 0, 'fee_label': '3.5%'}),
  30. ('wechat', {'fee_rate': 0.0, 'fee_fixed': 0, 'fee_label': '免手续费'}),
  31. ('alipay', {'fee_rate': 0.0, 'fee_fixed': 0, 'fee_label': '免手续费'}),
  32. ]:
  33. await conn.execute(text("""
  34. UPDATE vas_payment_provider
  35. SET config = :cfg
  36. WHERE name = :name AND (config IS NULL OR config = 'null' OR config = '');
  37. """), {'cfg': json.dumps(cfg), 'name': name})
  38. print("Provider configs checked and updated.")
  39. print("Migration finished successfully.")
  40. if __name__ == "__main__":
  41. asyncio.run(migrate())