From 0d0048d532e6b738653d3c4cd6bde36dcb1d6728 Mon Sep 17 00:00:00 2001 From: Joe Robinson Date: Fri, 18 Jul 2014 16:26:58 +0100 Subject: Added initial user management functions --- blavote.go | 12 ++++++++---- 1 file changed, 8 insertions(+), 4 deletions(-) (limited to 'blavote.go') diff --git a/blavote.go b/blavote.go index f493b1b..4d621b9 100644 --- a/blavote.go +++ b/blavote.go @@ -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)") } -- cgit v1.2.3