使用例
// equal to: SELECT id, name, email, created_at, updated_at FROM users WHERE (id = "userId" OR name =
"testname") ORDER BY id ASC LIMIT 1
var users []User
testDB.Select(&User{}).WhereOr(&User{ID: "userId", Name: "testname"}).First(&users)
insertTest := []User{
{ID: "userid1", Name: "user1", Email: "
[email protected]"},
{ID: "userid2", Name: "user2", Email: "
[email protected]"},
}
// equal to: INSERT INTO users (id, name, email) VALUES ("userid1", "user1", "
[email protected]"),
("userid2", "user2", "
[email protected]")
res, err := testDB.Insert(&User{}).SetData(insertTest).Exec()