Adding some benchmarks to help on #20

Jos&eacute; Carlos Nieto · Jos&eacute; Carlos Nieto · commit 100dea4fefbb · 2013-06-27T11:41:02.000Z
diff --git a/sqlite/sqlite_test.go b/sqlite/sqlite_test.go
@@ -1,6 +1,7 @@
 package sqlite
 
 import (
+	"database/sql"
 	"fmt"
 	"github.com/kr/pretty"
 	"math/rand"
@@ -738,3 +739,70 @@ func TestDataTypes(t *testing.T) {
 	}
 
 }
+
+func BenchmarkAppendRaw(b *testing.B) {
+	sess, err := db.Open(wrapperName, settings)
+
+	if err != nil {
+		b.Fatalf(err.Error())
+	}
+
+	defer sess.Close()
+
+	people := sess.ExistentCollection("people")
+	people.Truncate()
+
+	driver := sess.Driver().(*sql.DB)
+
+	b.ResetTimer()
+	for i := 0; i < b.N; i++ {
+		_, err := driver.Exec(`INSERT INTO people (name) VALUES("john")`)
+		if err != nil {
+			b.Fatalf(err.Error())
+		}
+	}
+}
+
+// Contributed by wei2912
+// See: https://github.com/gosexy/db/issues/20#issuecomment-20097801
+func BenchmarkAppendDbItem(b *testing.B) {
+	sess, err := db.Open(wrapperName, settings)
+
+	if err != nil {
+		b.Fatalf(err.Error())
+	}
+
+	defer sess.Close()
+
+	people := sess.ExistentCollection("people")
+	people.Truncate()
+
+	b.ResetTimer()
+	for i := 0; i < b.N; i++ {
+		_, err = people.Append(db.Item{"name": "john"})
+		if err != nil {
+			b.Fatalf(err.Error())
+		}
+	}
+}
+
+func BenchmarkAppendStruct(b *testing.B) {
+	sess, err := db.Open(wrapperName, settings)
+
+	if err != nil {
+		b.Fatalf(err.Error())
+	}
+
+	defer sess.Close()
+
+	people := sess.ExistentCollection("people")
+	people.Truncate()
+
+	b.ResetTimer()
+	for i := 0; i < b.N; i++ {
+		_, err = people.Append(struct{ Name string }{"john"})
+		if err != nil {
+			b.Fatalf(err.Error())
+		}
+	}
+}
