Lunny Xiao
af30c17b0d
All checks were successful
continuous-integration/drone/push Build is passing
Fix dump Fix dump bug Reviewed-on: #1613
119 lines
2.7 KiB
Go
119 lines
2.7 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 (
|
|
"context"
|
|
"fmt"
|
|
"os"
|
|
"testing"
|
|
"time"
|
|
|
|
"github.com/stretchr/testify/assert"
|
|
"xorm.io/xorm/schemas"
|
|
)
|
|
|
|
func TestPingContext(t *testing.T) {
|
|
assert.NoError(t, prepareEngine())
|
|
|
|
ctx, canceled := context.WithTimeout(context.Background(), time.Nanosecond)
|
|
defer canceled()
|
|
|
|
time.Sleep(time.Nanosecond)
|
|
|
|
err := testEngine.(*Engine).PingContext(ctx)
|
|
assert.Error(t, err)
|
|
assert.Contains(t, err.Error(), "context deadline exceeded")
|
|
}
|
|
|
|
func TestAutoTransaction(t *testing.T) {
|
|
assert.NoError(t, prepareEngine())
|
|
|
|
type TestTx struct {
|
|
Id int64 `xorm:"autoincr pk"`
|
|
Msg string `xorm:"varchar(255)"`
|
|
Created time.Time `xorm:"created"`
|
|
}
|
|
|
|
assert.NoError(t, testEngine.Sync2(new(TestTx)))
|
|
|
|
engine := testEngine.(*Engine)
|
|
|
|
// will success
|
|
engine.Transaction(func(session *Session) (interface{}, error) {
|
|
_, err := session.Insert(TestTx{Msg: "hi"})
|
|
assert.NoError(t, err)
|
|
|
|
return nil, nil
|
|
})
|
|
|
|
has, err := engine.Exist(&TestTx{Msg: "hi"})
|
|
assert.NoError(t, err)
|
|
assert.EqualValues(t, true, has)
|
|
|
|
// will rollback
|
|
_, err = engine.Transaction(func(session *Session) (interface{}, error) {
|
|
_, err := session.Insert(TestTx{Msg: "hello"})
|
|
assert.NoError(t, err)
|
|
|
|
return nil, fmt.Errorf("rollback")
|
|
})
|
|
assert.Error(t, err)
|
|
|
|
has, err = engine.Exist(&TestTx{Msg: "hello"})
|
|
assert.NoError(t, err)
|
|
assert.EqualValues(t, false, has)
|
|
}
|
|
|
|
func TestDump(t *testing.T) {
|
|
assert.NoError(t, prepareEngine())
|
|
|
|
type TestDumpStruct struct {
|
|
Id int64
|
|
Name string
|
|
}
|
|
|
|
assertSync(t, new(TestDumpStruct))
|
|
|
|
testEngine.Insert([]TestDumpStruct{
|
|
{Name: "1"},
|
|
{Name: "2\n"},
|
|
{Name: "3;"},
|
|
{Name: "4\n;\n''"},
|
|
{Name: "5'\n"},
|
|
})
|
|
|
|
fp := testEngine.Dialect().URI().DBName + ".sql"
|
|
os.Remove(fp)
|
|
assert.NoError(t, testEngine.DumpAllToFile(fp))
|
|
|
|
assert.NoError(t, prepareEngine())
|
|
|
|
sess := testEngine.NewSession()
|
|
defer sess.Close()
|
|
assert.NoError(t, sess.Begin())
|
|
_, err := sess.ImportFile(fp)
|
|
assert.NoError(t, err)
|
|
assert.NoError(t, sess.Commit())
|
|
|
|
for _, tp := range []schemas.DBType{schemas.SQLITE, schemas.MYSQL, schemas.POSTGRES, schemas.MSSQL} {
|
|
t.Run(fmt.Sprintf("dump_%v", tp), func(t *testing.T) {
|
|
assert.NoError(t, testEngine.DumpAllToFile(fp, tp))
|
|
})
|
|
}
|
|
}
|
|
|
|
func TestSetSchema(t *testing.T) {
|
|
assert.NoError(t, prepareEngine())
|
|
|
|
if testEngine.Dialect().URI().DBType == schemas.POSTGRES {
|
|
oldSchema := testEngine.Dialect().URI().Schema
|
|
testEngine.SetSchema("my_schema")
|
|
assert.EqualValues(t, "my_schema", testEngine.Dialect().URI().Schema)
|
|
testEngine.SetSchema(oldSchema)
|
|
assert.EqualValues(t, oldSchema, testEngine.Dialect().URI().Schema)
|
|
}
|
|
}
|