database.go 821 B

12345678910111213141516171819202122232425262728293031323334353637383940
  1. package models
  2. // DatabaseInfo 包含数据库的总大小、表数量和表名列表
  3. type DatabaseInfo struct {
  4. SizeMB float64
  5. TableCount int
  6. Tables map[string]TableInfo
  7. LobTables map[string]TableInfo
  8. Functions []FunctionInfo
  9. Triggers []TriggerInfo
  10. }
  11. type TableInfo struct {
  12. Name string
  13. Size float64
  14. DDL string
  15. Count int
  16. }
  17. type FunctionInfo struct {
  18. Name string
  19. Type string // "FUNCTION" 或 "PROCEDURE"
  20. Definition string
  21. }
  22. type TriggerInfo struct {
  23. Name string
  24. Event string // "INSERT", "UPDATE", "DELETE" 等
  25. Table string
  26. Timing string // "BEFORE" 或 "AFTER"
  27. Statement string
  28. }
  29. // DbConnParams 定义了数据库连接参数的结构体
  30. type DbConnParams struct {
  31. Host string
  32. Port string
  33. Database string
  34. User string
  35. Password string
  36. }