--- /dev/null
+package gorm_test
+
+import (
+ "os"
+ "reflect"
+ "testing"
+ "time"
+
+ "github.com/jinzhu/now"
+)
+
+func TestCreate(t *testing.T) {
+ float := 35.03554004971999
+ now := time.Now()
+ user := User{Name: "CreateUser", Age: 18, Birthday: &now, UserNum: Num(111), PasswordHash: []byte{'f', 'a', 'k', '4'}, Latitude: float}
+
+ if !DB.NewRecord(user) || !DB.NewRecord(&user) {
+ t.Error("User should be new record before create")
+ }
+
+ if count := DB.Save(&user).RowsAffected; count != 1 {
+ t.Error("There should be one record be affected when create record")
+ }
+
+ if DB.NewRecord(user) || DB.NewRecord(&user) {
+ t.Error("User should not new record after save")
+ }
+
+ var newUser User
+ if err := DB.First(&newUser, user.Id).Error; err != nil {
+ t.Errorf("No error should happen, but got %v", err)
+ }
+
+ if !reflect.DeepEqual(newUser.PasswordHash, []byte{'f', 'a', 'k', '4'}) {
+ t.Errorf("User's PasswordHash should be saved ([]byte)")
+ }
+
+ if newUser.Age != 18 {
+ t.Errorf("User's Age should be saved (int)")
+ }
+
+ if newUser.UserNum != Num(111) {
+ t.Errorf("User's UserNum should be saved (custom type), but got %v", newUser.UserNum)
+ }
+
+ if newUser.Latitude != float {
+ t.Errorf("Float64 should not be changed after save")
+ }
+
+ if user.CreatedAt.IsZero() {
+ t.Errorf("Should have created_at after create")
+ }
+
+ if newUser.CreatedAt.IsZero() {
+ t.Errorf("Should have created_at after create")
+ }
+
+ DB.Model(user).Update("name", "create_user_new_name")
+ DB.First(&user, user.Id)
+ if user.CreatedAt.Format(time.RFC3339Nano) != newUser.CreatedAt.Format(time.RFC3339Nano) {
+ t.Errorf("CreatedAt should not be changed after update")
+ }
+}
+
+func TestCreateEmptyStrut(t *testing.T) {
+ type EmptyStruct struct {
+ ID uint
+ }
+ DB.AutoMigrate(&EmptyStruct{})
+
+ if err := DB.Create(&EmptyStruct{}).Error; err != nil {
+ t.Errorf("No error should happen when creating user, but got %v", err)
+ }
+}
+
+func TestCreateWithExistingTimestamp(t *testing.T) {
+ user := User{Name: "CreateUserExistingTimestamp"}
+
+ timeA := now.MustParse("2016-01-01")
+ user.CreatedAt = timeA
+ user.UpdatedAt = timeA
+ DB.Save(&user)
+
+ if user.CreatedAt.UTC().Format(time.RFC3339) != timeA.UTC().Format(time.RFC3339) {
+ t.Errorf("CreatedAt should not be changed")
+ }
+
+ if user.UpdatedAt.UTC().Format(time.RFC3339) != timeA.UTC().Format(time.RFC3339) {
+ t.Errorf("UpdatedAt should not be changed")
+ }
+
+ var newUser User
+ DB.First(&newUser, user.Id)
+
+ if newUser.CreatedAt.UTC().Format(time.RFC3339) != timeA.UTC().Format(time.RFC3339) {
+ t.Errorf("CreatedAt should not be changed")
+ }
+
+ if newUser.UpdatedAt.UTC().Format(time.RFC3339) != timeA.UTC().Format(time.RFC3339) {
+ t.Errorf("UpdatedAt should not be changed")
+ }
+}
+
+type AutoIncrementUser struct {
+ User
+ Sequence uint `gorm:"AUTO_INCREMENT"`
+}
+
+func TestCreateWithAutoIncrement(t *testing.T) {
+ if dialect := os.Getenv("GORM_DIALECT"); dialect != "postgres" {
+ t.Skip("Skipping this because only postgres properly support auto_increment on a non-primary_key column")
+ }
+
+ DB.AutoMigrate(&AutoIncrementUser{})
+
+ user1 := AutoIncrementUser{}
+ user2 := AutoIncrementUser{}
+
+ DB.Create(&user1)
+ DB.Create(&user2)
+
+ if user2.Sequence-user1.Sequence != 1 {
+ t.Errorf("Auto increment should apply on Sequence")
+ }
+}
+
+func TestCreateWithNoGORMPrimayKey(t *testing.T) {
+ if dialect := os.Getenv("GORM_DIALECT"); dialect == "mssql" {
+ t.Skip("Skipping this because MSSQL will return identity only if the table has an Id column")
+ }
+
+ jt := JoinTable{From: 1, To: 2}
+ err := DB.Create(&jt).Error
+ if err != nil {
+ t.Errorf("No error should happen when create a record without a GORM primary key. But in the database this primary key exists and is the union of 2 or more fields\n But got: %s", err)
+ }
+}
+
+func TestCreateWithNoStdPrimaryKeyAndDefaultValues(t *testing.T) {
+ animal := Animal{Name: "Ferdinand"}
+ if DB.Save(&animal).Error != nil {
+ t.Errorf("No error should happen when create a record without std primary key")
+ }
+
+ if animal.Counter == 0 {
+ t.Errorf("No std primary key should be filled value after create")
+ }
+
+ if animal.Name != "Ferdinand" {
+ t.Errorf("Default value should be overrided")
+ }
+
+ // Test create with default value not overrided
+ an := Animal{From: "nerdz"}
+
+ if DB.Save(&an).Error != nil {
+ t.Errorf("No error should happen when create an record without std primary key")
+ }
+
+ // We must fetch the value again, to have the default fields updated
+ // (We can't do this in the update statements, since sql default can be expressions
+ // And be different from the fields' type (eg. a time.Time fields has a default value of "now()"
+ DB.Model(Animal{}).Where(&Animal{Counter: an.Counter}).First(&an)
+
+ if an.Name != "galeone" {
+ t.Errorf("Default value should fill the field. But got %v", an.Name)
+ }
+}
+
+func TestAnonymousScanner(t *testing.T) {
+ user := User{Name: "anonymous_scanner", Role: Role{Name: "admin"}}
+ DB.Save(&user)
+
+ var user2 User
+ DB.First(&user2, "name = ?", "anonymous_scanner")
+ if user2.Role.Name != "admin" {
+ t.Errorf("Should be able to get anonymous scanner")
+ }
+
+ if !user2.Role.IsAdmin() {
+ t.Errorf("Should be able to get anonymous scanner")
+ }
+}
+
+func TestAnonymousField(t *testing.T) {
+ user := User{Name: "anonymous_field", Company: Company{Name: "company"}}
+ DB.Save(&user)
+
+ var user2 User
+ DB.First(&user2, "name = ?", "anonymous_field")
+ DB.Model(&user2).Related(&user2.Company)
+ if user2.Company.Name != "company" {
+ t.Errorf("Should be able to get anonymous field")
+ }
+}
+
+func TestSelectWithCreate(t *testing.T) {
+ user := getPreparedUser("select_user", "select_with_create")
+ DB.Select("Name", "BillingAddress", "CreditCard", "Company", "Emails").Create(user)
+
+ var queryuser User
+ DB.Preload("BillingAddress").Preload("ShippingAddress").
+ Preload("CreditCard").Preload("Emails").Preload("Company").First(&queryuser, user.Id)
+
+ if queryuser.Name != user.Name || queryuser.Age == user.Age {
+ t.Errorf("Should only create users with name column")
+ }
+
+ if queryuser.BillingAddressID.Int64 == 0 || queryuser.ShippingAddressId != 0 ||
+ queryuser.CreditCard.ID == 0 || len(queryuser.Emails) == 0 {
+ t.Errorf("Should only create selected relationships")
+ }
+}
+
+func TestOmitWithCreate(t *testing.T) {
+ user := getPreparedUser("omit_user", "omit_with_create")
+ DB.Omit("Name", "BillingAddress", "CreditCard", "Company", "Emails").Create(user)
+
+ var queryuser User
+ DB.Preload("BillingAddress").Preload("ShippingAddress").
+ Preload("CreditCard").Preload("Emails").Preload("Company").First(&queryuser, user.Id)
+
+ if queryuser.Name == user.Name || queryuser.Age != user.Age {
+ t.Errorf("Should only create users with age column")
+ }
+
+ if queryuser.BillingAddressID.Int64 != 0 || queryuser.ShippingAddressId == 0 ||
+ queryuser.CreditCard.ID != 0 || len(queryuser.Emails) != 0 {
+ t.Errorf("Should not create omitted relationships")
+ }
+}
OSDN Git Service
