func insertDataDbrValues(conn *dbr.Connection) error {
sess := conn.NewSession(nil)
t1, err := time.Parse("2006-01-02", "1985-12-31")
t2, err := time.Parse("2006-01-02", "1987-10-31")
t3, err := time.Parse("2006-01-02", "1985-11-10")
result, err := sess.InsertInto("account").
Columns("name", "dob").
Values("8maki", t1).
Values("moqada", t2).
Values("ideyuta", t3).
Exec()
if err != nil {
return err
} else {
count, _ := result.RowsAffected()
log.Printf("%d rows created\n", count)
}
result, err = sess.InsertInto("note").
Columns("account_id", "title", "body").
Values(1, "test title 01", "test body").
Values(1, "test title 02", "test body").
Values(1, "test title 03", "test body").
Values(2, "test title 01", "test body").
Exec()
if err != nil {
return err
} else {
count, _ := result.RowsAffected()
log.Printf("%d rows created\n", count)
}
return nil
}
func insertDataDbrRecord(conn *dbr.Connection) error {
sess := conn.NewSession(nil)
t1, err := time.Parse("2006-01-02", "1985-12-31")
yamaki := Account{
Name: "8maki",
Dob: t1,
}
t2, err := time.Parse("2006-01-02", "1987-10-31")
ideyuta := Account{
Name: "ideyuta",
Dob: t2,
}
t3, err := time.Parse("2006-01-02", "1985-11-10")
moqada := Account{
Name: "moqada",
Dob: t3,
}
result, err := sess.InsertInto("account").
Columns("name", "dob").
Record(yamaki).
Record(moqada).
Record(ideyuta).
Exec()
if err != nil {
return err
} else {
count, _ := result.RowsAffected()
log.Printf("%d rows created\n", count)
}
note1 := Note{
AccountId: 1,
Title: dbr.NewNullString("test title 01"),
Body: dbr.NewNullString("test body"),
}
note2 := Note{
AccountId: 1,
Title: dbr.NewNullString("test title 02"),
Body: dbr.NewNullString("test body"),
}
note3 := Note{
AccountId: 1,
Title: dbr.NewNullString("test title 03"),
Body: dbr.NewNullString("test body"),
}
note4 := Note{
AccountId: 2,
Title: dbr.NewNullString("test title 01"),
Body: dbr.NewNullString("test body"),
}
result, err = sess.InsertInto("note").
Columns("account_id", "title", "body").
Record(note1).
Record(note2).
Record(note3).
Record(note4).
Exec()
if err != nil {
return err
} else {
count, _ := result.RowsAffected()
log.Printf("%d rows created\n", count)
}
return nil
}