This package is a wrapper of many third party database drivers. The goal of this abstraction is to provide a common, simplified and consistent layer for working with different databases without the need of SQL statements.
Use go get to download and install gosexy/db.
# Getting gosexy/db
$ go get github.com/gosexy/dbThe gosexy/db package provides shared interfaces and datatypes only, in order to connect to an actual database
a wrapper is required.
Let's suppose we want to use the mongo driver for MongoDB.
# Installing the driver
$ go get github.com/gosexy/db/mongoOnce the driver is installed, import it into your project.
// Importing driver and abstraction layer
import (
"github.com/gosexy/db"
/* Import the driver to the blank namespace */
_ "github.com/gosexy/db/mongo"
)Set up a variable to hold your database connection credentials.
settings := db.DataSource{
Host: "localhost",
Database: "dbname",
User: "myusername",
Password: "mysecret",
}Then use db.Open to connect to the database you've just set up.
// Connect using the mongo driver.
sess, err := db.Open("mongo", settings)
if err != nil {
panic(err)
}
defer sess.Close()Now you can query the database.
animals, _ := sess.Collection("animals")
animals.Append(db.Item{
"animal": "Bird",
"young": "Chick",
"female": "Hen",
"male": "Cock",
"group": "flock",
})
animals.Append(db.Item{
"animal": "Bovidae",
"young": "Calf",
"female": "Cow",
"male": "Bull",
"group": "Herd",
})
animals.Append(db.Item{
"animal": "Canidae",
"young": sugar.List{"Puppy", "Pup"},
"female": "Bitch",
"male": "Dog",
"group": "Pack",
})
items := animals.FindAll()
for _, item := range items {
fmt.Printf("animal: %s, young: %s\n", item["animal"], item["young"])
}The same example goes for other drivers with few modifications, just change the driver name to
mysql, postgresql or sqlite. Please consider that SQL databases do not accept datatypes like
sugar.List{} and that they expect an existing table.
// _examples/mongo.go
package main
import (
"fmt"
"github.com/gosexy/db"
_ "github.com/gosexy/db/mongo"
"github.com/gosexy/sugar"
)
const host = "debian"
const dbname = "dev"
func main() {
sess, err := db.Open("mongo", db.DataSource{Host: host, Database: dbname})
if err != nil {
panic(err)
}
defer sess.Close()
sess.Drop()
animals, _ := sess.Collection("animals")
animals.Append(db.Item{
"animal": "Bird",
"young": "Chick",
"female": "Hen",
"male": "Cock",
"group": "flock",
})
animals.Append(db.Item{
"animal": "Bovidae",
"young": "Calf",
"female": "Cow",
"male": "Bull",
"group": "Herd",
})
animals.Append(db.Item{
"animal": "Canidae",
"young": sugar.List{"Puppy", "Pup"},
"female": "Bitch",
"male": "Dog",
"group": "Pack",
})
items := animals.FindAll()
for _, item := range items {
fmt.Printf("animal: %s, young: %s\n", item["animal"], item["young"])
}
}There is an online reference.
You can also read gosexy/db documentation from a terminal.
# Reading gosexy/db docs.
$ go doc github.com/gosexy/db
# Reading driver docs.
$ go doc github.com/gosexy/dbThis is an evolving project, there are still some things to do:
- Add db.Upsert and db.Modify for SQL databases.
- Add CouchDB support.
2012/12/02 - Changing db.Table.Collection and adding db.Open().
2012/09/21 - Changing some methods parameters and return values, improving error handling and testing many data types.
2012/08/29 - Created the main site docs and moved the repo to "http://github.com/gosexy".
2012/07/23 - Splitted database wrappers into packages. Changed ``db.Where`` to ``db.Cond``.
2012/07/09 - First public beta with MySQL, MongoDB, PostgreSQL and SQLite3.