Lunny Xiao
d874b64b71
fix time test add test for time format sign codes according to contributing rules. format time when sqlTypeName is core.Varchar. Same with core.DateTime or core.TimeStamp Add test for second insert error (#1527) Add test for second insert error Reviewed-on: xorm/xorm#1527 Add tests for table name (#1517) add tests for table name Fix test (#1526) Fix test Reviewed-on: xorm/xorm#1526 Fix test (#1526) Fix test Reviewed-on: xorm/xorm#1526 Fix wrong warning log on autoincrement column when sync table (#1525) improve doc Fix wrong warning log on autoincrement column when sync table Reviewed-on: xorm/xorm#1525 Fixed Join strings on func Exist (#1520) fix test fixed Join strings on func Exist Co-authored-by: Tomofumi Kusana <tkusana@morisawa.co.jp> Reviewed-on: xorm/xorm#1520 For nullable columns, store nil values as NULL (#531) Merge branch 'master' into jcsalem/fix/nil_ptr_is_nullable fix bug when buffersize with iterate (#941) Merge branch 'master' into lunny/fix_buffer_iterate Exclude schema from index name (#1505) Merge branch 'master' into fix-schema-idx SetExpr support more go types (#1499) Improve tests SetExpr support more go types fix vet fix drone lint remove go1.10 test on drone Reviewed-on: xorm/xorm#1499 fix vet fix drone lint remove go1.10 test on drone Exclude schema from the index name Co-authored-by: Guillermo Prandi <guillep2k@users.noreply.github.com> Co-authored-by: Lunny Xiao <xiaolunwen@gmail.com> Reviewed-on: xorm/xorm#1505 fix test fix bug fix bug when buffersize with iterate SetExpr support more go types (#1499) Improve tests SetExpr support more go types fix vet fix drone lint remove go1.10 test on drone Reviewed-on: xorm/xorm#1499 fix vet fix drone lint remove go1.10 test on drone Fix update with Alias (#1455) Co-authored-by: Guillermo Prandi <guillep2k@noreply.gitea.io> Reviewed-on: xorm/xorm#941 fix update map with version (#1448) fix test fix update map with version SetExpr support more go types (#1499) Improve tests SetExpr support more go types fix vet fix drone lint remove go1.10 test on drone Reviewed-on: xorm/xorm#1499 fix vet fix drone lint remove go1.10 test on drone Fix update with Alias (#1455) Reviewed-on: xorm/xorm#1448 Exclude schema from index name (#1505) Merge branch 'master' into fix-schema-idx SetExpr support more go types (#1499) Improve tests SetExpr support more go types fix vet fix drone lint remove go1.10 test on drone Reviewed-on: xorm/xorm#1499 fix vet fix drone lint remove go1.10 test on drone Exclude schema from the index name Co-authored-by: Guillermo Prandi <guillep2k@users.noreply.github.com> Co-authored-by: Lunny Xiao <xiaolunwen@gmail.com> Reviewed-on: xorm/xorm#1505 SetExpr support more go types (#1499) Improve tests SetExpr support more go types fix vet fix drone lint remove go1.10 test on drone Reviewed-on: xorm/xorm#1499 For nullable columns, store nil values as NULL fix vet fix drone lint remove go1.10 test on drone Fix update with Alias (#1455) Improve ci tests (#1477) Rewrite Engine.QuoteTo() to accept multi-part identifiers (#1476) Support local sql log (#1338) Fix go mod and update version (#1460) Move github.com/go-xorm/xorm to xorm.io/xorm (#1459) add support custom type Nullfloat64 (#1450) fix bug when query map condtion with no quote (#1449) Don't warn when bool column default is 1 but not true (#1447) * don't warn when bool column default is 1 but not true * fix default case sensitive Fix sync2 with custom table name (#1445) * fix sync2 with custom table name * fix bug on postgres * fix bug on postgres fix bug when update with setexpr (#1446) add tidb tests on drone ci (#1444) improve sync2 (#1443) Fix wrong dbmetas (#1442) * add tests for db metas * add more tests * fix bug on mssql Fix default value parse bugs (#1437) * fix default value * fix default value tags * fix postgres default * fix default on postgres * fix default on postgres * fix mssql default fix arg conversion (#1441) * fix arg conversion * fix bugs * fix bug on postgres * use traditional positional parameters on insert into select * remove unnecessary tests upgrade core (#1440) add tests (#1439) add go1.13 tests on drone (#1416) Fix bug on insert where (#1436) * fix bug on insert where * fix bug * fix lint fix bug when insert multiple slices with customize table name (#1433) * fix bug when insert multiple slices with customize table name * fix tests on mssql * fix tests fix insert where with bool bug on mssql (#1432) fix setexpr missing big quotes (#1431) * fix setexpr missing big quotes * fix tests * fix tests Add support subquery on SetExpr (#1428) * add support subquery on SetExpr * fix tests fix go mod (#1427) ... Co-authored-by: DarthPestilane <wangrui.superman@gmail.com> Co-authored-by: kusana <kusana@noreply.gitea.io> Co-authored-by: Guillermo Prandi <guillep2k@noreply.gitea.io> Co-authored-by: Guillermo Prandi <guillep2k@noreply@gitea.io> Co-authored-by: yudppp <yu.d.ppp@gmail.com> Reviewed-on: xorm/xorm#1026
480 lines
14 KiB
Go
480 lines
14 KiB
Go
// Copyright 2017 The Xorm Authors. All rights reserved.
|
|
// Use of this source code is governed by a BSD-style
|
|
// license that can be found in the LICENSE file.
|
|
|
|
package xorm
|
|
|
|
import (
|
|
"fmt"
|
|
"strings"
|
|
"testing"
|
|
"time"
|
|
|
|
"github.com/stretchr/testify/assert"
|
|
)
|
|
|
|
func TestTimeUserTime(t *testing.T) {
|
|
assert.NoError(t, prepareEngine())
|
|
|
|
type TimeUser struct {
|
|
Id string
|
|
OperTime time.Time
|
|
}
|
|
|
|
assertSync(t, new(TimeUser))
|
|
|
|
var user = TimeUser{
|
|
Id: "lunny",
|
|
OperTime: time.Now(),
|
|
}
|
|
|
|
fmt.Println("user", user.OperTime)
|
|
|
|
cnt, err := testEngine.Insert(&user)
|
|
assert.NoError(t, err)
|
|
assert.EqualValues(t, 1, cnt)
|
|
|
|
var user2 TimeUser
|
|
has, err := testEngine.Get(&user2)
|
|
assert.NoError(t, err)
|
|
assert.True(t, has)
|
|
assert.EqualValues(t, user.OperTime.Unix(), user2.OperTime.Unix())
|
|
assert.EqualValues(t, formatTime(user.OperTime), formatTime(user2.OperTime))
|
|
fmt.Println("user2", user2.OperTime)
|
|
}
|
|
|
|
func TestTimeUserTimeDiffLoc(t *testing.T) {
|
|
assert.NoError(t, prepareEngine())
|
|
loc, err := time.LoadLocation("Asia/Shanghai")
|
|
assert.NoError(t, err)
|
|
testEngine.SetTZLocation(loc)
|
|
dbLoc, err := time.LoadLocation("America/New_York")
|
|
assert.NoError(t, err)
|
|
testEngine.SetTZDatabase(dbLoc)
|
|
|
|
type TimeUser2 struct {
|
|
Id string
|
|
OperTime time.Time
|
|
}
|
|
|
|
assertSync(t, new(TimeUser2))
|
|
|
|
var user = TimeUser2{
|
|
Id: "lunny",
|
|
OperTime: time.Now(),
|
|
}
|
|
|
|
fmt.Println("user", user.OperTime)
|
|
|
|
cnt, err := testEngine.Insert(&user)
|
|
assert.NoError(t, err)
|
|
assert.EqualValues(t, 1, cnt)
|
|
|
|
var user2 TimeUser2
|
|
has, err := testEngine.Get(&user2)
|
|
assert.NoError(t, err)
|
|
assert.True(t, has)
|
|
assert.EqualValues(t, user.OperTime.Unix(), user2.OperTime.Unix())
|
|
assert.EqualValues(t, formatTime(user.OperTime.In(loc)), formatTime(user2.OperTime))
|
|
fmt.Println("user2", user2.OperTime)
|
|
}
|
|
|
|
func TestTimeUserCreated(t *testing.T) {
|
|
assert.NoError(t, prepareEngine())
|
|
|
|
type UserCreated struct {
|
|
Id string
|
|
CreatedAt time.Time `xorm:"created"`
|
|
}
|
|
|
|
assertSync(t, new(UserCreated))
|
|
|
|
var user = UserCreated{
|
|
Id: "lunny",
|
|
}
|
|
|
|
fmt.Println("user", user.CreatedAt)
|
|
|
|
cnt, err := testEngine.Insert(&user)
|
|
assert.NoError(t, err)
|
|
assert.EqualValues(t, 1, cnt)
|
|
|
|
var user2 UserCreated
|
|
has, err := testEngine.Get(&user2)
|
|
assert.NoError(t, err)
|
|
assert.True(t, has)
|
|
assert.EqualValues(t, user.CreatedAt.Unix(), user2.CreatedAt.Unix())
|
|
assert.EqualValues(t, formatTime(user.CreatedAt), formatTime(user2.CreatedAt))
|
|
fmt.Println("user2", user2.CreatedAt)
|
|
}
|
|
|
|
func TestTimeUserCreatedDiffLoc(t *testing.T) {
|
|
assert.NoError(t, prepareEngine())
|
|
loc, err := time.LoadLocation("Asia/Shanghai")
|
|
assert.NoError(t, err)
|
|
testEngine.SetTZLocation(loc)
|
|
dbLoc, err := time.LoadLocation("America/New_York")
|
|
assert.NoError(t, err)
|
|
testEngine.SetTZDatabase(dbLoc)
|
|
|
|
type UserCreated2 struct {
|
|
Id string
|
|
CreatedAt time.Time `xorm:"created"`
|
|
}
|
|
|
|
assertSync(t, new(UserCreated2))
|
|
|
|
var user = UserCreated2{
|
|
Id: "lunny",
|
|
}
|
|
|
|
fmt.Println("user", user.CreatedAt)
|
|
|
|
cnt, err := testEngine.Insert(&user)
|
|
assert.NoError(t, err)
|
|
assert.EqualValues(t, 1, cnt)
|
|
|
|
var user2 UserCreated2
|
|
has, err := testEngine.Get(&user2)
|
|
assert.NoError(t, err)
|
|
assert.True(t, has)
|
|
assert.EqualValues(t, user.CreatedAt.Unix(), user2.CreatedAt.Unix())
|
|
assert.EqualValues(t, formatTime(user.CreatedAt), formatTime(user2.CreatedAt))
|
|
fmt.Println("user2", user2.CreatedAt)
|
|
}
|
|
|
|
func TestTimeUserUpdated(t *testing.T) {
|
|
assert.NoError(t, prepareEngine())
|
|
|
|
type UserUpdated struct {
|
|
Id string
|
|
CreatedAt time.Time `xorm:"created"`
|
|
UpdatedAt time.Time `xorm:"updated"`
|
|
}
|
|
|
|
assertSync(t, new(UserUpdated))
|
|
|
|
var user = UserUpdated{
|
|
Id: "lunny",
|
|
}
|
|
|
|
fmt.Println("user", user.CreatedAt, user.UpdatedAt)
|
|
|
|
cnt, err := testEngine.Insert(&user)
|
|
assert.NoError(t, err)
|
|
assert.EqualValues(t, 1, cnt)
|
|
|
|
var user2 UserUpdated
|
|
has, err := testEngine.Get(&user2)
|
|
assert.NoError(t, err)
|
|
assert.True(t, has)
|
|
assert.EqualValues(t, user.CreatedAt.Unix(), user2.CreatedAt.Unix())
|
|
assert.EqualValues(t, formatTime(user.CreatedAt), formatTime(user2.CreatedAt))
|
|
assert.EqualValues(t, user.UpdatedAt.Unix(), user2.UpdatedAt.Unix())
|
|
assert.EqualValues(t, formatTime(user.UpdatedAt), formatTime(user2.UpdatedAt))
|
|
fmt.Println("user2", user2.CreatedAt, user2.UpdatedAt)
|
|
|
|
var user3 = UserUpdated{
|
|
Id: "lunny2",
|
|
}
|
|
|
|
cnt, err = testEngine.Update(&user3)
|
|
assert.NoError(t, err)
|
|
assert.EqualValues(t, 1, cnt)
|
|
assert.True(t, user.UpdatedAt.Unix() <= user3.UpdatedAt.Unix())
|
|
|
|
var user4 UserUpdated
|
|
has, err = testEngine.Get(&user4)
|
|
assert.NoError(t, err)
|
|
assert.True(t, has)
|
|
assert.EqualValues(t, user.CreatedAt.Unix(), user4.CreatedAt.Unix())
|
|
assert.EqualValues(t, formatTime(user.CreatedAt), formatTime(user4.CreatedAt))
|
|
assert.EqualValues(t, user3.UpdatedAt.Unix(), user4.UpdatedAt.Unix())
|
|
assert.EqualValues(t, formatTime(user3.UpdatedAt), formatTime(user4.UpdatedAt))
|
|
fmt.Println("user3", user.CreatedAt, user4.UpdatedAt)
|
|
}
|
|
|
|
func TestTimeUserUpdatedDiffLoc(t *testing.T) {
|
|
assert.NoError(t, prepareEngine())
|
|
loc, err := time.LoadLocation("Asia/Shanghai")
|
|
assert.NoError(t, err)
|
|
testEngine.SetTZLocation(loc)
|
|
dbLoc, err := time.LoadLocation("America/New_York")
|
|
assert.NoError(t, err)
|
|
testEngine.SetTZDatabase(dbLoc)
|
|
|
|
type UserUpdated2 struct {
|
|
Id string
|
|
CreatedAt time.Time `xorm:"created"`
|
|
UpdatedAt time.Time `xorm:"updated"`
|
|
}
|
|
|
|
assertSync(t, new(UserUpdated2))
|
|
|
|
var user = UserUpdated2{
|
|
Id: "lunny",
|
|
}
|
|
|
|
fmt.Println("user", user.CreatedAt, user.UpdatedAt)
|
|
|
|
cnt, err := testEngine.Insert(&user)
|
|
assert.NoError(t, err)
|
|
assert.EqualValues(t, 1, cnt)
|
|
|
|
var user2 UserUpdated2
|
|
has, err := testEngine.Get(&user2)
|
|
assert.NoError(t, err)
|
|
assert.True(t, has)
|
|
assert.EqualValues(t, user.CreatedAt.Unix(), user2.CreatedAt.Unix())
|
|
assert.EqualValues(t, formatTime(user.CreatedAt), formatTime(user2.CreatedAt))
|
|
assert.EqualValues(t, user.UpdatedAt.Unix(), user2.UpdatedAt.Unix())
|
|
assert.EqualValues(t, formatTime(user.UpdatedAt), formatTime(user2.UpdatedAt))
|
|
fmt.Println("user2", user2.CreatedAt, user2.UpdatedAt)
|
|
|
|
var user3 = UserUpdated2{
|
|
Id: "lunny2",
|
|
}
|
|
|
|
cnt, err = testEngine.Update(&user3)
|
|
assert.NoError(t, err)
|
|
assert.EqualValues(t, 1, cnt)
|
|
assert.True(t, user.UpdatedAt.Unix() <= user3.UpdatedAt.Unix())
|
|
|
|
var user4 UserUpdated2
|
|
has, err = testEngine.Get(&user4)
|
|
assert.NoError(t, err)
|
|
assert.True(t, has)
|
|
assert.EqualValues(t, user.CreatedAt.Unix(), user4.CreatedAt.Unix())
|
|
assert.EqualValues(t, formatTime(user.CreatedAt), formatTime(user4.CreatedAt))
|
|
assert.EqualValues(t, user3.UpdatedAt.Unix(), user4.UpdatedAt.Unix())
|
|
assert.EqualValues(t, formatTime(user3.UpdatedAt), formatTime(user4.UpdatedAt))
|
|
fmt.Println("user3", user.CreatedAt, user4.UpdatedAt)
|
|
}
|
|
|
|
func TestTimeUserDeleted(t *testing.T) {
|
|
assert.NoError(t, prepareEngine())
|
|
|
|
type UserDeleted struct {
|
|
Id string
|
|
CreatedAt time.Time `xorm:"created"`
|
|
UpdatedAt time.Time `xorm:"updated"`
|
|
DeletedAt time.Time `xorm:"deleted"`
|
|
CreatedAtStr string `xorm:"datetime created"`
|
|
UpdatedAtStr string `xorm:"datetime updated"`
|
|
}
|
|
|
|
assertSync(t, new(UserDeleted))
|
|
|
|
var user = UserDeleted{
|
|
Id: "lunny",
|
|
}
|
|
|
|
cnt, err := testEngine.Insert(&user)
|
|
assert.NoError(t, err)
|
|
assert.EqualValues(t, 1, cnt)
|
|
fmt.Println("user", user.CreatedAt, user.UpdatedAt, user.DeletedAt)
|
|
|
|
var user2 UserDeleted
|
|
has, err := testEngine.Get(&user2)
|
|
assert.NoError(t, err)
|
|
assert.True(t, has)
|
|
assert.EqualValues(t, user.CreatedAt.Unix(), user2.CreatedAt.Unix())
|
|
assert.EqualValues(t, formatTime(user.CreatedAt), formatTime(user2.CreatedAt))
|
|
assert.EqualValues(t, user.UpdatedAt.Unix(), user2.UpdatedAt.Unix())
|
|
assert.EqualValues(t, formatTime(user.UpdatedAt), formatTime(user2.UpdatedAt))
|
|
assert.True(t, isTimeZero(user2.DeletedAt))
|
|
fmt.Println("user2", user2.CreatedAt, user2.UpdatedAt, user2.DeletedAt)
|
|
fmt.Println("user2 str", user2.CreatedAtStr, user2.UpdatedAtStr)
|
|
|
|
var user3 UserDeleted
|
|
cnt, err = testEngine.Where("id = ?", "lunny").Delete(&user3)
|
|
assert.NoError(t, err)
|
|
assert.EqualValues(t, 1, cnt)
|
|
assert.True(t, !isTimeZero(user3.DeletedAt))
|
|
|
|
var user4 UserDeleted
|
|
has, err = testEngine.Unscoped().Get(&user4)
|
|
assert.NoError(t, err)
|
|
assert.True(t, has)
|
|
assert.EqualValues(t, user3.DeletedAt.Unix(), user4.DeletedAt.Unix())
|
|
assert.EqualValues(t, formatTime(user3.DeletedAt), formatTime(user4.DeletedAt))
|
|
fmt.Println("user3", user3.DeletedAt, user4.DeletedAt)
|
|
}
|
|
|
|
func TestTimeUserDeletedDiffLoc(t *testing.T) {
|
|
assert.NoError(t, prepareEngine())
|
|
loc, err := time.LoadLocation("Asia/Shanghai")
|
|
assert.NoError(t, err)
|
|
testEngine.SetTZLocation(loc)
|
|
dbLoc, err := time.LoadLocation("America/New_York")
|
|
assert.NoError(t, err)
|
|
testEngine.SetTZDatabase(dbLoc)
|
|
|
|
type UserDeleted2 struct {
|
|
Id string
|
|
CreatedAt time.Time `xorm:"created"`
|
|
UpdatedAt time.Time `xorm:"updated"`
|
|
DeletedAt time.Time `xorm:"deleted"`
|
|
}
|
|
|
|
assertSync(t, new(UserDeleted2))
|
|
|
|
var user = UserDeleted2{
|
|
Id: "lunny",
|
|
}
|
|
|
|
cnt, err := testEngine.Insert(&user)
|
|
assert.NoError(t, err)
|
|
assert.EqualValues(t, 1, cnt)
|
|
fmt.Println("user", user.CreatedAt, user.UpdatedAt, user.DeletedAt)
|
|
|
|
var user2 UserDeleted2
|
|
has, err := testEngine.Get(&user2)
|
|
assert.NoError(t, err)
|
|
assert.True(t, has)
|
|
assert.EqualValues(t, user.CreatedAt.Unix(), user2.CreatedAt.Unix())
|
|
assert.EqualValues(t, formatTime(user.CreatedAt), formatTime(user2.CreatedAt))
|
|
assert.EqualValues(t, user.UpdatedAt.Unix(), user2.UpdatedAt.Unix())
|
|
assert.EqualValues(t, formatTime(user.UpdatedAt), formatTime(user2.UpdatedAt))
|
|
assert.True(t, isTimeZero(user2.DeletedAt))
|
|
fmt.Println("user2", user2.CreatedAt, user2.UpdatedAt, user2.DeletedAt)
|
|
|
|
var user3 UserDeleted2
|
|
cnt, err = testEngine.Where("id = ?", "lunny").Delete(&user3)
|
|
assert.NoError(t, err)
|
|
assert.EqualValues(t, 1, cnt)
|
|
assert.True(t, !isTimeZero(user3.DeletedAt))
|
|
|
|
var user4 UserDeleted2
|
|
has, err = testEngine.Unscoped().Get(&user4)
|
|
assert.NoError(t, err)
|
|
assert.True(t, has)
|
|
assert.EqualValues(t, user3.DeletedAt.Unix(), user4.DeletedAt.Unix())
|
|
assert.EqualValues(t, formatTime(user3.DeletedAt), formatTime(user4.DeletedAt))
|
|
fmt.Println("user3", user3.DeletedAt, user4.DeletedAt)
|
|
}
|
|
|
|
type JsonDate time.Time
|
|
|
|
func (j JsonDate) MarshalJSON() ([]byte, error) {
|
|
if time.Time(j).IsZero() {
|
|
return []byte(`""`), nil
|
|
}
|
|
return []byte(`"` + time.Time(j).Format("2006-01-02 15:04:05") + `"`), nil
|
|
}
|
|
|
|
func (j *JsonDate) UnmarshalJSON(value []byte) error {
|
|
var v = strings.TrimSpace(strings.Trim(string(value), "\""))
|
|
|
|
t, err := time.ParseInLocation("2006-01-02 15:04:05", v, time.Local)
|
|
if err != nil {
|
|
return err
|
|
}
|
|
*j = JsonDate(t)
|
|
return nil
|
|
}
|
|
|
|
func (j *JsonDate) Unix() int64 {
|
|
return (*time.Time)(j).Unix()
|
|
}
|
|
|
|
func TestCustomTimeUserDeleted(t *testing.T) {
|
|
assert.NoError(t, prepareEngine())
|
|
|
|
type UserDeleted3 struct {
|
|
Id string
|
|
CreatedAt JsonDate `xorm:"created"`
|
|
UpdatedAt JsonDate `xorm:"updated"`
|
|
DeletedAt JsonDate `xorm:"deleted"`
|
|
}
|
|
|
|
assertSync(t, new(UserDeleted3))
|
|
|
|
var user = UserDeleted3{
|
|
Id: "lunny",
|
|
}
|
|
|
|
cnt, err := testEngine.Insert(&user)
|
|
assert.NoError(t, err)
|
|
assert.EqualValues(t, 1, cnt)
|
|
fmt.Println("user", user.CreatedAt, user.UpdatedAt, user.DeletedAt)
|
|
|
|
var user2 UserDeleted3
|
|
has, err := testEngine.Get(&user2)
|
|
assert.NoError(t, err)
|
|
assert.True(t, has)
|
|
assert.EqualValues(t, user.CreatedAt.Unix(), user2.CreatedAt.Unix())
|
|
assert.EqualValues(t, formatTime(time.Time(user.CreatedAt)), formatTime(time.Time(user2.CreatedAt)))
|
|
assert.EqualValues(t, user.UpdatedAt.Unix(), user2.UpdatedAt.Unix())
|
|
assert.EqualValues(t, formatTime(time.Time(user.UpdatedAt)), formatTime(time.Time(user2.UpdatedAt)))
|
|
assert.True(t, isTimeZero(time.Time(user2.DeletedAt)))
|
|
fmt.Println("user2", user2.CreatedAt, user2.UpdatedAt, user2.DeletedAt)
|
|
|
|
var user3 UserDeleted3
|
|
cnt, err = testEngine.Where("id = ?", "lunny").Delete(&user3)
|
|
assert.NoError(t, err)
|
|
assert.EqualValues(t, 1, cnt)
|
|
assert.True(t, !isTimeZero(time.Time(user3.DeletedAt)))
|
|
|
|
var user4 UserDeleted3
|
|
has, err = testEngine.Unscoped().Get(&user4)
|
|
assert.NoError(t, err)
|
|
assert.True(t, has)
|
|
assert.EqualValues(t, user3.DeletedAt.Unix(), user4.DeletedAt.Unix())
|
|
assert.EqualValues(t, formatTime(time.Time(user3.DeletedAt)), formatTime(time.Time(user4.DeletedAt)))
|
|
fmt.Println("user3", user3.DeletedAt, user4.DeletedAt)
|
|
}
|
|
|
|
func TestCustomTimeUserDeletedDiffLoc(t *testing.T) {
|
|
assert.NoError(t, prepareEngine())
|
|
loc, err := time.LoadLocation("Asia/Shanghai")
|
|
assert.NoError(t, err)
|
|
testEngine.SetTZLocation(loc)
|
|
dbLoc, err := time.LoadLocation("America/New_York")
|
|
assert.NoError(t, err)
|
|
testEngine.SetTZDatabase(dbLoc)
|
|
|
|
type UserDeleted4 struct {
|
|
Id string
|
|
CreatedAt JsonDate `xorm:"created"`
|
|
UpdatedAt JsonDate `xorm:"updated"`
|
|
DeletedAt JsonDate `xorm:"deleted"`
|
|
}
|
|
|
|
assertSync(t, new(UserDeleted4))
|
|
|
|
var user = UserDeleted4{
|
|
Id: "lunny",
|
|
}
|
|
|
|
cnt, err := testEngine.Insert(&user)
|
|
assert.NoError(t, err)
|
|
assert.EqualValues(t, 1, cnt)
|
|
fmt.Println("user", user.CreatedAt, user.UpdatedAt, user.DeletedAt)
|
|
|
|
var user2 UserDeleted4
|
|
has, err := testEngine.Get(&user2)
|
|
assert.NoError(t, err)
|
|
assert.True(t, has)
|
|
assert.EqualValues(t, user.CreatedAt.Unix(), user2.CreatedAt.Unix())
|
|
assert.EqualValues(t, formatTime(time.Time(user.CreatedAt)), formatTime(time.Time(user2.CreatedAt)))
|
|
assert.EqualValues(t, user.UpdatedAt.Unix(), user2.UpdatedAt.Unix())
|
|
assert.EqualValues(t, formatTime(time.Time(user.UpdatedAt)), formatTime(time.Time(user2.UpdatedAt)))
|
|
assert.True(t, isTimeZero(time.Time(user2.DeletedAt)))
|
|
fmt.Println("user2", user2.CreatedAt, user2.UpdatedAt, user2.DeletedAt)
|
|
|
|
var user3 UserDeleted4
|
|
cnt, err = testEngine.Where("id = ?", "lunny").Delete(&user3)
|
|
assert.NoError(t, err)
|
|
assert.EqualValues(t, 1, cnt)
|
|
assert.True(t, !isTimeZero(time.Time(user3.DeletedAt)))
|
|
|
|
var user4 UserDeleted4
|
|
has, err = testEngine.Unscoped().Get(&user4)
|
|
assert.NoError(t, err)
|
|
assert.True(t, has)
|
|
assert.EqualValues(t, user3.DeletedAt.Unix(), user4.DeletedAt.Unix())
|
|
assert.EqualValues(t, formatTime(time.Time(user3.DeletedAt)), formatTime(time.Time(user4.DeletedAt)))
|
|
fmt.Println("user3", user3.DeletedAt, user4.DeletedAt)
|
|
}
|