| .. | ||
| 1.created.md | ||
| README.md | ||
4.Insert data
You can insert objects to database via Insert method.
- Insert one object
user := new(User)
user.Name = "myname"
affected, err := engine.Insert(user)
After inserted, user.ID will be filled if ID is an autoincremented column.
fmt.Println(user.Id)
- Insert multiple objects by Slice on one table
users := make([]User, 1)
users[0].Name = "name0"
...
affected, err := engine.Insert(&users)
- Insert multiple records by Slice of pointer on one table
users := make([]*User, 1)
users[0] = new(User)
users[0].Name = "name0"
...
affected, err := engine.Insert(&users)
- Insert two objects onto two tables.
user := new(User)
user.Name = "myname"
question := new(Question)
question.Content = "whywhywhwy?"
affected, err := engine.Insert(user, question)
- Insert multiple objects on multiple tables.
users := make([]User, 1)
users[0].Name = "name0"
...
questions := make([]Question, 1)
questions[0].Content = "whywhywhwy?"
affected, err := engine.Insert(&users, &questions)
- Insert one or multple objects on multiple tables.
user := new(User)
user.Name = "myname"
...
questions := make([]Question, 1)
questions[0].Content = "whywhywhwy?"
affected, err := engine.Insert(user, &questions)
Notice: If you want to use transaction on inserting, you should use session.Begin() before calling Insert.