Function Test_DBVacuumInto

db/db_vacuum_test.go:69–154

(t *testing.T)

}

func Test_DBVacuumInto(t *testing.T) {
	db, path := mustCreateOnDiskDatabaseWAL()
	defer db.Close()
	defer os.Remove(path)

	r, err := db.ExecuteStringStmt("CREATE TABLE foo (id INTEGER NOT NULL PRIMARY KEY, name TEXT)")
	if err != nil {
		t.Fatalf("failed to create table: %s", err.Error())
	}
	if exp, got := `[{}]`, asJSON(r); exp != got {
		t.Fatalf("unexpected results for query, expected %s, got %s", exp, got)
	}
	for range 1000 {
		_, err = db.ExecuteStringStmt(`INSERT INTO foo(name) VALUES("fiona")`)
		if err != nil {
			t.Fatalf("error executing insertion into table: %s", err.Error())
		}
	}

	testQ := func(d *DB) {
		t.Helper()
		q, err := d.QueryStringStmt("SELECT COUNT(*) FROM foo")
		if err != nil {
			t.Fatalf("failed to query empty table: %s", err.Error())
		}
		if exp, got := `[{"columns":["COUNT(*)"],"types":["integer"],"values":[[1000]]}]`, asJSON(q); exp != got {
			t.Fatalf("unexpected results for query, expected %s, got %s", exp, got)
		}
	}
	testQ(db)

	// VACUUM INTO an empty file, open the database, and check it's correct.
	tmpPath := mustTempFile()
	defer os.Remove(tmpPath)
	if err := db.VacuumInto(tmpPath); err != nil {
		t.Fatalf("failed to vacuum database: %s", err.Error())
	}
	vDB, err := Open(tmpPath, false, false)
	if err != nil {
		t.Fatalf("failed to open database: %s", err.Error())
	}
	defer vDB.Close()
	testQ(vDB)

	// VACUUM INTO an non-existing file, should still work.
	tmpPath2 := mustTempPath()
	defer os.Remove(tmpPath2)
	if err := db.VacuumInto(tmpPath2); err != nil {
		t.Fatalf("failed to vacuum database: %s", err.Error())
	}
	vDB2, err := Open(tmpPath2, false, false)
	if err != nil {
		t.Fatalf("failed to open database: %s", err.Error())
	}
	defer vDB2.Close()
	testQ(vDB2)

	// VACUUM INTO a path containing a single quote should work.