--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/go/main.go Mon Sep 03 23:35:31 2012 +0200
@@ -0,0 +1,43 @@
+package main
+
+import (
+ "database/sql"
+ "github.com/coopernurse/gorp"
+ _ "github.com/mattn/go-sqlite3"
+ "log"
+ "os"
+)
+
+type Sentence struct {
+ Id int64
+ Word string
+ Sentence string
+}
+
+func main() {
+ db, err := sql.Open("sqlite3", "lingvigilo.db")
+ if err != nil {
+ log.Fatal("Fatal error: ", err)
+ }
+ defer db.Close()
+
+ dbmap := &gorp.DbMap{Db: db, Dialect: gorp.SqliteDialect{}}
+
+ dbmap.TraceOn("dbmap", log.New(os.Stderr, "sql", 0))
+
+ dbmap.AddTableWithName(Sentence{}, "sentences").SetKeys(true, "Id")
+
+ dbmap.DropTables()
+
+ err = dbmap.CreateTables()
+ if err != nil {
+ log.Fatal("Fatal error: ", err)
+ }
+
+ mySentence := &Sentence{0, "potato", "Open the potato"}
+
+ err = dbmap.Insert(mySentence)
+ if err != nil {
+ log.Fatal("Fatal error: ", err)
+ }
+}