package jsonbench

import (
	"database/sql"
	"testing"

	_ "github.com/go-sql-driver/mysql"
)

var db *sql.DB

func init() {
	var err error
	db, err = sql.Open("mysql", "root@/test_json")
	if err != nil {
		panic("failed to establish a database connection: " + err.Error())
	}
	db.SetMaxOpenConns(1000)
	db.SetMaxIdleConns(100)
}

func BenchmarkInsertDataText(b *testing.B) {
	for i := 0; i < b.N; i++ {
		InsertDataText(db)
	}
}

func BenchmarkInsertDataJson(b *testing.B) {
	for i := 0; i < b.N; i++ {
		InsertDataJson(db)
	}
}

func BenchmarkUpdateDataText(b *testing.B) {
	for i := 0; i < b.N; i++ {
		UpdateDataText(db)
	}
}

func BenchmarkUpdateDataJson(b *testing.B) {
	for i := 0; i < b.N; i++ {
		UpdateDataJson(db)
	}
}

func BenchmarkReadDataText(b *testing.B) {
	for i := 0; i < b.N; i++ {
		ReadDataText(db)
	}
}

func BenchmarkReadDataJson(b *testing.B) {
	for i := 0; i < b.N; i++ {
		ReadDataJson(db)
	}
}