From 70b4b1dc65bfd493088443c20c4670a62c06f317 Mon Sep 17 00:00:00 2001
From: Joe Robinson <joe@mumsnet.com>
Date: Fri, 18 Jul 2014 18:27:00 +0100
Subject: Added initial voting functionality

---
 option.go | 29 +++++++++++++++++++++++++++++
 1 file changed, 29 insertions(+)
 create mode 100644 option.go

(limited to 'option.go')

diff --git a/option.go b/option.go
new file mode 100644
index 0000000..d8cb697
--- /dev/null
+++ b/option.go
@@ -0,0 +1,29 @@
+package main
+
+import "github.com/mxk/go-sqlite/sqlite3"
+
+type Option struct {
+    id int
+    text string
+    pollId int64
+}
+
+func getOptionFromText(db*sqlite3.Conn, text string) Option {
+
+    args := sqlite3.NamedArgs{"$a": text}
+    sql := "SELECT * FROM options WHERE text = $a"
+    s, err := db.Query(sql, args)
+    row := make(sqlite3.RowMap)
+    
+    for ; err == nil ; err = s.Next() {
+        var rowid int
+        s.Scan(&rowid, row)     // Assigns 1st column to rowid, the rest to row
+
+        option := Option{id:rowid, text:row["text"].(string), pollId:row["poll_id"].(int64)}
+        return option
+    }
+
+    //If we get here there are no matching users
+    return Option{id:0, text:"", pollId:0}
+
+}
\ No newline at end of file
-- 
cgit v1.2.3