func TestClose(t *testing.T) {
tempFilename := TempFilename(t)
+ defer os.Remove(tempFilename)
db, err := sql.Open("sqlite3", tempFilename)
if err != nil {
t.Fatal("Failed to open database:", err)
}
- defer os.Remove(tempFilename)
_, err = db.Exec("drop table foo")
_, err = db.Exec("create table foo (id integer)")
func TestInsert(t *testing.T) {
tempFilename := TempFilename(t)
+ defer os.Remove(tempFilename)
db, err := sql.Open("sqlite3", tempFilename)
if err != nil {
t.Fatal("Failed to open database:", err)
}
- defer os.Remove(tempFilename)
defer db.Close()
_, err = db.Exec("drop table foo")
func TestUpdate(t *testing.T) {
tempFilename := TempFilename(t)
+ defer os.Remove(tempFilename)
db, err := sql.Open("sqlite3", tempFilename)
if err != nil {
t.Fatal("Failed to open database:", err)
}
- defer os.Remove(tempFilename)
defer db.Close()
_, err = db.Exec("drop table foo")
func TestDelete(t *testing.T) {
tempFilename := TempFilename(t)
+ defer os.Remove(tempFilename)
db, err := sql.Open("sqlite3", tempFilename)
if err != nil {
t.Fatal("Failed to open database:", err)
}
- defer os.Remove(tempFilename)
defer db.Close()
_, err = db.Exec("drop table foo")
func TestBooleanRoundtrip(t *testing.T) {
tempFilename := TempFilename(t)
+ defer os.Remove(tempFilename)
db, err := sql.Open("sqlite3", tempFilename)
if err != nil {
t.Fatal("Failed to open database:", err)
}
- defer os.Remove(tempFilename)
defer db.Close()
_, err = db.Exec("DROP TABLE foo")
func TestTimestamp(t *testing.T) {
tempFilename := TempFilename(t)
+ defer os.Remove(tempFilename)
db, err := sql.Open("sqlite3", tempFilename)
if err != nil {
t.Fatal("Failed to open database:", err)
}
- defer os.Remove(tempFilename)
defer db.Close()
_, err = db.Exec("DROP TABLE foo")
func TestBoolean(t *testing.T) {
tempFilename := TempFilename(t)
+ defer os.Remove(tempFilename)
db, err := sql.Open("sqlite3", tempFilename)
if err != nil {
t.Fatal("Failed to open database:", err)
}
- defer os.Remove(tempFilename)
defer db.Close()
_, err = db.Exec("CREATE TABLE foo(id INTEGER, fbool BOOLEAN)")
func TestFloat32(t *testing.T) {
tempFilename := TempFilename(t)
+ defer os.Remove(tempFilename)
db, err := sql.Open("sqlite3", tempFilename)
if err != nil {
t.Fatal("Failed to open database:", err)
}
-
- defer os.Remove(tempFilename)
defer db.Close()
_, err = db.Exec("CREATE TABLE foo(id INTEGER)")
func TestNull(t *testing.T) {
tempFilename := TempFilename(t)
+ defer os.Remove(tempFilename)
db, err := sql.Open("sqlite3", tempFilename)
if err != nil {
t.Fatal("Failed to open database:", err)
}
-
- defer os.Remove(tempFilename)
defer db.Close()
rows, err := db.Query("SELECT 3.141592")
func TestTransaction(t *testing.T) {
tempFilename := TempFilename(t)
+ defer os.Remove(tempFilename)
db, err := sql.Open("sqlite3", tempFilename)
if err != nil {
t.Fatal("Failed to open database:", err)
}
-
- defer os.Remove(tempFilename)
defer db.Close()
_, err = db.Exec("CREATE TABLE foo(id INTEGER)")
func TestWAL(t *testing.T) {
tempFilename := TempFilename(t)
+ defer os.Remove(tempFilename)
db, err := sql.Open("sqlite3", tempFilename)
if err != nil {
t.Fatal("Failed to open database:", err)
}
-
- defer os.Remove(tempFilename)
defer db.Close()
+
if _, err = db.Exec("PRAGMA journal_mode=WAL;"); err != nil {
t.Fatal("Failed to Exec PRAGMA journal_mode:", err)
}
zones := []string{"UTC", "US/Central", "US/Pacific", "Local"}
for _, tz := range zones {
tempFilename := TempFilename(t)
+ defer os.Remove(tempFilename)
db, err := sql.Open("sqlite3", tempFilename+"?_loc="+url.QueryEscape(tz))
if err != nil {
t.Fatal("Failed to open database:", err)
}
- defer os.Remove(tempFilename)
defer db.Close()
_, err = db.Exec("DROP TABLE foo")
func TestSuite(t *testing.T) {
tempFilename := TempFilename(t)
+ defer os.Remove(tempFilename)
db, err := sql.Open("sqlite3", tempFilename+"?_busy_timeout=99999")
if err != nil {
t.Fatal(err)
}
- defer os.Remove(tempFilename)
defer db.Close()
sqlite3_test.RunTests(t, db, sqlite3_test.SQLITE)
// https://github.com/mattn/go-sqlite3/issues/82
func TestExecer(t *testing.T) {
tempFilename := TempFilename(t)
+ defer os.Remove(tempFilename)
db, err := sql.Open("sqlite3", tempFilename)
if err != nil {
t.Fatal("Failed to open database:", err)
}
- defer os.Remove(tempFilename)
defer db.Close()
_, err = db.Exec(`
func TestQueryer(t *testing.T) {
tempFilename := TempFilename(t)
+ defer os.Remove(tempFilename)
db, err := sql.Open("sqlite3", tempFilename)
if err != nil {
t.Fatal("Failed to open database:", err)
}
- defer os.Remove(tempFilename)
defer db.Close()
_, err = db.Exec(`
func TestStress(t *testing.T) {
tempFilename := TempFilename(t)
+ defer os.Remove(tempFilename)
db, err := sql.Open("sqlite3", tempFilename)
if err != nil {
t.Fatal("Failed to open database:", err)
func TestDateTimeLocal(t *testing.T) {
zone := "Asia/Tokyo"
tempFilename := TempFilename(t)
+ defer os.Remove(tempFilename)
db, err := sql.Open("sqlite3", tempFilename+"?_loc="+zone)
if err != nil {
t.Fatal("Failed to open database:", err)
func TestNumberNamedParams(t *testing.T) {
tempFilename := TempFilename(t)
+ defer os.Remove(tempFilename)
db, err := sql.Open("sqlite3", tempFilename)
if err != nil {
t.Fatal("Failed to open database:", err)
}
- defer os.Remove(tempFilename)
defer db.Close()
_, err = db.Exec(`
func TestStringContainingZero(t *testing.T) {
tempFilename := TempFilename(t)
+ defer os.Remove(tempFilename)
db, err := sql.Open("sqlite3", tempFilename)
if err != nil {
t.Fatal("Failed to open database:", err)
}
- defer os.Remove(tempFilename)
defer db.Close()
_, err = db.Exec(`
func TestDateTimeNow(t *testing.T) {
tempFilename := TempFilename(t)
+ defer os.Remove(tempFilename)
db, err := sql.Open("sqlite3", tempFilename)
if err != nil {
t.Fatal("Failed to open database:", err)