怎么给生成的表名称加上数据库名称，因为有的场景需要跨库查询

[x-pyrrhus]

[x-pyrrhus]

@qqxhb

[soonio]

我是这么搞的

func datasource(t, ds string) *gen.Generator {
	g := gen.NewGenerator(gen.Config{
		OutPath:       fmt.Sprintf("./db/%s", t),
		FieldNullable: true,
		ModelPkgPath:  t,
	})

	db, err := gorm.Open(mysql.Open(ds),
		&gorm.Config{
			NamingStrategy: schema.NamingStrategy{
				SingularTable: true,
			},
			Logger: logger.Default.LogMode(logger.Warn),
		})
	if err != nil {
		panic(err)
	}
	g.UseDB(db)
	g.WithJSONTagNameStrategy(func(columnName string) (tagContent string) {
		return stringx.ToCamelCase(strings.Replace(cases.Title(language.English).String(strings.Replace(columnName, "_", " ", -1)), " ", "", -1))
	})
	g.WithTableNameStrategy(func(tableName string) (newTableName string) {
		switch t {
		case "srm":
			return fmt.Sprintf("srj_psc.%s", tableName)
		case "yxm":
			return fmt.Sprintf("psc.%s", tableName)
		}
		return ""
	})

	g.WithOpts(
		gen.FieldModify(func(f gen.Field) gen.Field {
			if f.ColumnComment == "" {
				f.ColumnComment = "TODO"
			}
			return f
		}),
		gen.FieldGORMTagReg(".*", func(tag field.GormTag) field.GormTag {
			tag = map[string][]string{
				field.TagKeyGormColumn: tag[field.TagKeyGormColumn],
			}
			return tag.Remove("comment")
		}),
	)

	return g
}