// Select accepts both string arguments and arrays.
//
//	// Select name and age of user using multiple arguments
//	db.Select("name", "age").Find(&users)
//	// Select name and age of user using an array
//	db.Select([]string{"name", "age"}).Find(&users)
func (db *DB) Select(query interface{}, args ...interface{}) (tx *DB) {
	tx = db.getInstance()

	switch v := query.(type) {

		Email   string    `gorm:"not null;index:,unique"`
		Name    string    `gorm:"notNull;default:foo"`
		Name2   string    `gorm:"size:233;not null;default:'foo'"`
		Name3   string    `gorm:"size:233;notNull;default:''"`
		Age     int       `gorm:"default:18"`
		Created time.Time `gorm:"default:2000-01-02"`
		Enabled bool      `gorm:"default:true"`
	}

	DB.Migrator().DropTable(&Harumph{})

	if err := DB.AutoMigrate(&Harumph{}); err != nil {

		t.Fatalf("failed to create data from map, got error: %v", err)
	}

	var result1 User
	if err := DB.Where("name = ?", "create_from_map_1").First(&result1).Error; err != nil || result1.Age != 18 {
		t.Fatalf("failed to create from map, got error %v", err)
	}

	datas := []map[string]interface{}{
		{"Name": "create_from_map_2", "Age": 19},

	} else if stored.Name != selectOnly.Name || stored.Age != 0 {
		t.Errorf("unexpected select-only user state, got %#v", stored)
	}

	omitAge := User{Name: "GenericsCreateOmitAge", Age: 88}
	if err := gorm.G[User](DB).Omit("age").Create(ctx, &omitAge); err != nil {
		t.Fatalf("failed to create with Omit, got error: %v", err)
	}

	if omitAge.ID == 0 {
		t.Fatalf("no primary key found for omit-age user: %v", omitAge)
	}

		"(CASE WHEN age=18 THEN 1 ELSE 2 END) as age", "name",
	).Count(&count8).Find(&users).Error; err != nil || count8 != 3 {
		t.Fatalf("Count should work, but got err %v", err)
	}

	expects = []User{{Name: "count-1", Age: 1}, {Name: "count-2", Age: 1}, {Name: "count-3", Age: 1}}
	sort.SliceStable(users, func(i, j int) bool {

		t.Fatalf("expected Company assigned, got %+v", got.Company)
	}
}

// Mixed fields + association: update Age and create a pet together
func TestClauseAssociationSetUpdateMixedFieldAndAssociation(t *testing.T) {
	ctx := context.Background()
	user := User{Name: "TestClauseAssociationSetUpdateMixed", Age: 20}
	if err := DB.Create(&user).Error; err != nil {
		t.Fatalf("create user: %v", err)
	}

mc: File data successfully downloaded as inspect.6f96b336.zip
$ xl-meta inspect.6f96b336.zip
{

	}

	AssertObjEqual(t, result, data, "Name", "Gender", "Age")

	if err := DB.Where(data).Assign(ScannerValuerStruct{Age: sql.NullInt64{Int64: 18, Valid: true}}).FirstOrCreate(&result).Error; err != nil {
		t.Errorf("Should not raise any error, but got %v", err)
	}

	if result.Age.Int64 != 18 {
		t.Errorf("should update age to 18")
	}

	var result2 ScannerValuerStruct

from docs_src.python_types.tutorial012_py39 import User


def test_user():
    user = User(name="John Doe", age=30)
    assert user.name == "John Doe"

def get_name_with_age(name: str, age: int):
    name_with_age = name + " is this old: " + age