Advertisement
Guest User

Untitled

a guest
May 30th, 2017
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.64 KB | None | 0 0
  1. import "github.com/jinzhu/gorm"
  2. databaseURL:= "user=abc password=abc dbname=db host=localhost port=5432"
  3. db, err := gorm.Open("postgres", databaseURL)
  4. if err != nil {
  5. fmt.Printf("DBERR %s", err.Error())
  6. }
  7. db.DB().SetMaxIdleConns(10)
  8. db.DB().SetMaxOpenConns(10)
  9. db.LogMode(true)
  10. m := &MessageDetailRecord{
  11. AccountId: 123,
  12. SubAccountId: 456,
  13. }
  14. query := "INSERT INTO Table(accountid, subaccountid) VALUES (?,?);"
  15. a := time.Now()
  16. tx := db.Begin()
  17. for i:=0 ; i<100 ; i++ {
  18. _ = tx.Exec(query, m.AccountId, m.SubAccountId).Error
  19. }
  20. tx.Commit()
  21. delta := time.Now().Sub(a)
  22. fmt.Println(delta.Nanoseconds())
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement