Your Question I wanted to generate the query files for my exist

You can try: <div class="snippet-clipboard-content notranslate position-relative o

Query generation with existing database table named "fields" about gen HOT 1 OPEN

pbarnum commented on September 28, 2024

Query generation with existing database table named "fields"

from gen.

Comments (1)

tranvantri commented on September 28, 2024

You can try:

gormDb, err = gorm.Open(postgres.Open(dsn), &gorm.Config{
		NamingStrategy: schema.NamingStrategy{
			IdentifierMaxLength: 64, // Default Identifier length is 64
			SingularTable:       true,
		},
	})

The SingularTable config is used for the table name and field name. When SingularTable equals:

True: table name and field name are plural form
False: table name and field name are singular form

For me, I want to keep the table name in singular form. Field names like database

gormDb, err := gorm.Open(postgres.Open(dsn))

	if err != nil {
		panic(err)
	}

	tableList, err := gormDb.Migrator().GetTables()
	if err != nil {
		panic(fmt.Errorf("get all tables fail: %w", err))
	}

	modelNames := map[string]string{}
	for _, tableName := range tableList {
		modelNames[tableName] = gormDb.NamingStrategy.SchemaName(tableName)
	}

	db, err := gormDb.DB()
	if err != nil {
		panic(err)
	}

	err = db.Close()
	if err != nil {
		panic(err)
	}

	gormDb, err = gorm.Open(postgres.Open(dsn), &gorm.Config{
		NamingStrategy: schema.NamingStrategy{
			IdentifierMaxLength: 64, // Default Identifier length is 64
			SingularTable:       true,
		},
	})

	g.UseDB(gormDb)

	tables := make([]interface{}, len(tableList))
	for i, tableName := range tableList {
		tables[i] = g.GenerateModelAs(tableName, modelNames[tableName])
	}

	// generate target setting
	g.ApplyBasic(tables...)

	// Generate the code

from gen.

Recommend Projects