diff options
Diffstat (limited to 'blavote.go')
-rw-r--r-- | blavote.go | 12 |
1 files changed, 8 insertions, 4 deletions
@@ -1,5 +1,6 @@ package main +// import "blavote" import "fmt" import "github.com/mxk/go-sqlite/sqlite3" import "github.com/jessevdk/go-flags" @@ -55,6 +56,9 @@ func main() { addPoll(db, opts.Args.Title, opts.Args.Rest) } + createUser(db, "l_bratch", true) + getUserForId(db, 1) + } func connectDb(name string) (*sqlite3.Conn, error) { @@ -83,10 +87,10 @@ func initTables(db *sqlite3.Conn) { db.Exec("create table info(id int, key text, value text)") db.Exec("insert into info (key, value) values('version', '0.01')") - db.Exec("create table users(id int, name text, admin boolean)") - db.Exec("create table polls(id int, text text, user_id int)") - db.Exec("create table options(id int, text text, poll_id int)") - db.Exec("create table votes(id int, user_id int, poll_id int, option_id int)") + db.Exec("create table users(id integer primary key autoincrement, name text, admin boolean)") + db.Exec("create table polls(id integer primary key autoincrement, text text, user_id int)") + db.Exec("create table options(id integer primary key autoincrement, text text, poll_id int)") + db.Exec("create table votes(id integer primary key autoincrement, user_id int, poll_id int, option_id int)") } |