sqlxstore

sqlxstore

Gorilla's Session Store Implementation for Sqlx

Installation

Run go get github.com/mbetel/sqlxstore from command line. Gets installed in $GOPATH

Usage

NewSqlxStore takes the following paramaters

endpoint - A sql.Open style endpoint
tableName - table where sessions are to be saved. Required fields are created automatically if the table doesnot exist.
path - path for Set-Cookie header
maxAge 
codecs

Internally, sqlxstore uses this MySQL driver.

e.g.,

  package main

  import (
    "fmt"
    "github.com/mbetel/sqlxstore"
    "net/http"
  )

  var store *sqlxstore.SqlxStore

  func sessTest(w http.ResponseWriter, r *http.Request) {
    session, err := store.Get(r, "foobar")
    session.Values["bar"] = "baz"
    session.Values["baz"] = "foo"
    err = session.Save(r, w)
    fmt.Printf("%#v\n", session)
    fmt.Println(err)
  }

func main() {
    var err error
    store, err = sqlxstore.NewSqlxStore("UN:PASS@tcp(<IP>:<PORT>)/<DB>?parseTime=true&loc=Local", <tablename>, "/", 3600, []byte("<SecretKey>"))
    if err != nil {
      panic(err)
    }
    defer store.Close()

	http.HandleFunc("/", sessTest)
	http.ListenAndServe(":8080", nil)
}