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()
}
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
}
}