123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248 |
- 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")
- }
- }
- func TestCreateIgnore(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.Create(&user).RowsAffected; count != 1 {
- t.Error("There should be one record be affected when create record")
- }
- if DB.Dialect().GetName() == "mysql" && DB.Set("gorm:insert_modifier", "IGNORE").Create(&user).Error != nil {
- t.Error("Should ignore duplicate user insert by insert modifier:IGNORE ")
- }
- }
|