Lunny Xiao
bd20c37bfb
* add SetSchema for engine * fix user * fix postgres with schema * fix test * fix test * fix test * fix tablename * refactor tableName * fix schema support * improve the interface of EngineInterface
131 lines
3.0 KiB
Go
131 lines
3.0 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"
|
|
"testing"
|
|
"time"
|
|
|
|
"github.com/go-xorm/core"
|
|
"github.com/stretchr/testify/assert"
|
|
)
|
|
|
|
func TestTransaction(t *testing.T) {
|
|
assert.NoError(t, prepareEngine())
|
|
assertSync(t, new(Userinfo))
|
|
|
|
counter := func() {
|
|
total, err := testEngine.Count(&Userinfo{})
|
|
if err != nil {
|
|
t.Error(err)
|
|
}
|
|
fmt.Printf("----now total %v records\n", total)
|
|
}
|
|
|
|
counter()
|
|
//defer counter()
|
|
|
|
session := testEngine.NewSession()
|
|
defer session.Close()
|
|
|
|
err := session.Begin()
|
|
assert.NoError(t, err)
|
|
|
|
user1 := Userinfo{Username: "xiaoxiao", Departname: "dev", Alias: "lunny", Created: time.Now()}
|
|
_, err = session.Insert(&user1)
|
|
assert.NoError(t, err)
|
|
|
|
user2 := Userinfo{Username: "yyy"}
|
|
_, err = session.Where("(id) = ?", 0).Update(&user2)
|
|
assert.NoError(t, err)
|
|
|
|
_, err = session.Delete(&user2)
|
|
assert.NoError(t, err)
|
|
|
|
err = session.Commit()
|
|
assert.NoError(t, err)
|
|
}
|
|
|
|
func TestCombineTransaction(t *testing.T) {
|
|
assert.NoError(t, prepareEngine())
|
|
assertSync(t, new(Userinfo))
|
|
|
|
counter := func() {
|
|
total, err := testEngine.Count(&Userinfo{})
|
|
if err != nil {
|
|
t.Error(err)
|
|
}
|
|
fmt.Printf("----now total %v records\n", total)
|
|
}
|
|
|
|
counter()
|
|
//defer counter()
|
|
session := testEngine.NewSession()
|
|
defer session.Close()
|
|
|
|
err := session.Begin()
|
|
assert.NoError(t, err)
|
|
|
|
user1 := Userinfo{Username: "xiaoxiao2", Departname: "dev", Alias: "lunny", Created: time.Now()}
|
|
_, err = session.Insert(&user1)
|
|
assert.NoError(t, err)
|
|
|
|
user2 := Userinfo{Username: "zzz"}
|
|
_, err = session.Where("id = ?", 0).Update(&user2)
|
|
assert.NoError(t, err)
|
|
|
|
_, err = session.Exec("delete from "+testEngine.TableName("userinfo", true)+" where username = ?", user2.Username)
|
|
assert.NoError(t, err)
|
|
|
|
err = session.Commit()
|
|
assert.NoError(t, err)
|
|
}
|
|
|
|
func TestCombineTransactionSameMapper(t *testing.T) {
|
|
assert.NoError(t, prepareEngine())
|
|
|
|
oldMapper := testEngine.GetColumnMapper()
|
|
testEngine.UnMapType(rValue(new(Userinfo)).Type())
|
|
testEngine.SetMapper(core.SameMapper{})
|
|
defer func() {
|
|
testEngine.UnMapType(rValue(new(Userinfo)).Type())
|
|
testEngine.SetMapper(oldMapper)
|
|
}()
|
|
|
|
assertSync(t, new(Userinfo))
|
|
|
|
counter := func() {
|
|
total, err := testEngine.Count(&Userinfo{})
|
|
if err != nil {
|
|
t.Error(err)
|
|
}
|
|
fmt.Printf("----now total %v records\n", total)
|
|
}
|
|
|
|
counter()
|
|
defer counter()
|
|
|
|
session := testEngine.NewSession()
|
|
defer session.Close()
|
|
|
|
err := session.Begin()
|
|
assert.NoError(t, err)
|
|
|
|
user1 := Userinfo{Username: "xiaoxiao2", Departname: "dev", Alias: "lunny", Created: time.Now()}
|
|
_, err = session.Insert(&user1)
|
|
assert.NoError(t, err)
|
|
|
|
user2 := Userinfo{Username: "zzz"}
|
|
_, err = session.Where("(id) = ?", 0).Update(&user2)
|
|
assert.NoError(t, err)
|
|
|
|
_, err = session.Exec("delete from "+testEngine.TableName("`Userinfo`", true)+" where `Username` = ?", user2.Username)
|
|
assert.NoError(t, err)
|
|
|
|
err = session.Commit()
|
|
assert.NoError(t, err)
|
|
}
|