Exemple #1
0
func TestCreate(t *testing.T) {
	c, e := Open(testName + "?" + FlagsURL(OpenReadWrite))
	if e != nil {
		t.Fatal("Failed to open existing database")
	}

	_, e = db.ExecuteDirectly(c,
		"CREATE TABLE Users("+
			"login VARCHAR NOT NULL UNIQUE,"+
			"password VARCHAR NOT NULL,"+
			"active BOOLEAN NOT NULL DEFAULT 0,"+
			"last TIMESTAMP,"+
			"PRIMARY KEY (login)"+
			")")
	if e != nil {
		t.Fatal("Failed to create table")
	}

	for _, k := range insertTests {
		_, e = db.ExecuteDirectly(c,
			"INSERT INTO Users (login, password)"+
				"VALUES (?, ?);",
			k.login, k.password)
		if e != nil {
			t.Fatal("Failed to insert")
		}
	}

	c.Close()
}
Exemple #2
0
func main() {
	fmt.Printf("About to query version\n")
	version, e := sqlite3.Version()
	if e != nil {
		fmt.Printf("error: %s\n", e.String())
	}
	for k, v := range version {
		fmt.Printf("version[%s] == %s\n", k, v)
	}

	fmt.Printf("About to connect\n")
	nsc, e := sqlite3.Open("test.db")
	if e != nil {
		fmt.Printf("error: %s\n", e.String())
		return
	}
	fmt.Printf("connection: %s\n", nsc)
	c := nsc.(db.ClassicConnection)

	fmt.Printf("About to prepare statement\n")
	s, e := c.Prepare("SELECT rowid, * FROM users WHERE password=?")
	if e != nil {
		fmt.Printf("error: %s\n", e.String())
		return
	}
	fmt.Printf("statement: %s\n", s)

	fmt.Printf("About to execute query\n")
	cc, e := c.ExecuteClassic(s, "somepassword")
	if e != nil {
		fmt.Printf("error: %s\n", e.String())
		return
	}
	fmt.Printf("cursor: %s\n", cc)

	fmt.Printf("About to fetch all results\n")
	d, e := db.ClassicFetchAll(cc)
	if e != nil {
		fmt.Printf("error: %s\n", e.String())
		return
	}
	fmt.Printf("cursor: %s\n", cc)
	fmt.Printf("data: %s\n", d)

	fmt.Printf("About to close cursor\n")
	e = cc.Close()
	if e != nil {
		fmt.Printf("error: %s\n", e.String())
		return
	}

	fmt.Printf("About to re-execute query\n")
	cc, e = c.ExecuteClassic(s, "somepassword")
	if e != nil {
		fmt.Printf("error: %s\n", e.String())
		return
	}
	fmt.Printf("cursor: %s\n", cc)

	fmt.Printf("About to fetch one row\n")
	r := cc.Fetch()
	if r.Error() != nil {
		fmt.Printf("error: %s\n", r.Error().String())
		return
	}
	fmt.Printf("cursor: %s\n", cc)
	fmt.Printf("data: %s\n", r)

	fmt.Printf("About to fetch another row\n")
	f := cc.Fetch()
	if f.Error() != nil {
		fmt.Printf("error: %s\n", f.Error().String())
		return
	}
	fmt.Printf("cursor: %s\n", cc)
	fmt.Printf("data: %s\n", f)

	fmt.Printf("About to fetch the rest\n")
	g, e := db.ClassicFetchAll(cc) // was cc.FetchMany(10);
	fmt.Printf("%s\n", g)
	if e != nil {
		fmt.Printf("error: %s\n", e.String())
		return
	}
	fmt.Printf("cursor: %s\n", cc)
	for _, y := range g {
		fmt.Printf("data: %s\n", y)
	}

	fmt.Printf("About to close cursor\n")
	e = cc.Close()
	if e != nil {
		fmt.Printf("error: %s\n", e.String())
		return
	}

	fmt.Printf("About to re-execute query\n")
	rs, e := c.Execute(s, "somepassword")
	if e != nil {
		fmt.Printf("error: %s\n", e.String())
		return
	}
	fmt.Printf("resultset: %s\n", rs)

	fmt.Printf("About to fetch all using for range\n")
	for r := range rs.Iter() {
		fmt.Printf("data: %s\n", r.Data())
		fmt.Printf("error: %s\n", r.Error())
	}

	fmt.Printf("About to close resultset\n")
	rs.Close()

	fmt.Printf("About to close statement\n")
	e = s.Close()
	if e != nil {
		fmt.Printf("error: %s\n", e.String())
		return
	}

	fmt.Printf("About to execute directly\n")
	d, e = db.ExecuteDirectly(c, "SELECT * FROM users")
	if e != nil {
		fmt.Printf("error: %s\n", e.String())
		return
	}
	fmt.Printf("data: %s\n", d)

	fmt.Printf("About to close connection\n")
	e = c.Close()
	if e != nil {
		fmt.Printf("error: %s\n", e.String())
		return
	}
}