# HG changeset patch # User viric # Date 1346708131 -7200 # Node ID d5750f4e6e8c0c938bdb74bc5439868d505dfee2 # Parent 66becdcbe5d97301ff1ffebdb0ac272d02f12e5f Adding a first attempt at go code diff -r 66becdcbe5d9 -r d5750f4e6e8c go/main.go --- /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) + } +}