import_controller.go 1.5 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152
  1. package controllers
  2. import (
  3. "fmt"
  4. "xg_fetl/internal/db_executor"
  5. "xg_fetl/internal/global"
  6. "xg_fetl/internal/models"
  7. "xg_fetl/internal/services"
  8. )
  9. func ImportController(outputDir string) {
  10. dbType := global.Cfg.ImportConfig.DBConfig.DBType
  11. dsn := global.Cfg.ImportConfig.DBConfig.GetDSN()
  12. dbName := global.Cfg.ImportConfig.DBConfig.DBName
  13. //dbIp := global.Cfg.ImportConfig.DBConfig.IP
  14. // baseFilePath := global.Cfg.ExportConfig.BaseFilePath
  15. delimiter := global.Cfg.ImportConfig.Delimiter
  16. pageSize := global.Cfg.ImportConfig.PageSize
  17. // !创建数据库链接
  18. executor, err := db_executor.NewDBExecutor(dbType, dsn)
  19. if err != nil {
  20. fmt.Println(fmt.Errorf("create db executor failed, err: %v", err))
  21. panic(err)
  22. }
  23. defer executor.Close()
  24. // ! 获取数据库元信息
  25. dbInfo, err := services.GetDBInfoService(dbName, executor)
  26. if err != nil {
  27. fmt.Println(fmt.Errorf("get db info failed, err: %v", err))
  28. panic(err)
  29. }
  30. // 创建一个新的 map,将普通表和 LOB 表的信息都放进去
  31. allTables := make(map[string]models.TableInfo, len(dbInfo.Tables)+len(dbInfo.LobTables))
  32. // 将 tableInfoMap 中的表信息添加到 allTables 中
  33. for tableName, tableInfo := range dbInfo.Tables {
  34. allTables[tableName] = tableInfo
  35. }
  36. // 将 lobTableInfoMap 中的表信息添加到 allTables 中
  37. for tableName, tableInfo := range dbInfo.LobTables {
  38. allTables[tableName] = tableInfo
  39. }
  40. services.ReaderMain(dbName, outputDir, allTables, delimiter, pageSize, executor)
  41. }