Be faster with Y. The simplest ORM-like framework for Golang.
go get github.com/lann/squirrel
go get github.com/Repo2/y
Fetch executes SELECT
statement and returns a collection of objects.
type Account struct {
ID int64 `db:"id,pk"`
Name string `db:"name"`
}
c, err := y.New(Account{}).Fetch(db)
if err != nil {
log.Panicln(err)
}
log.Printf("%#v\n", c.List())
Find modifies a query for custom selection.
type Order struct {
ID int64 `db:"id,pk"`
Price int `db:"price"`
}
c, err := y.New(Order{}).
Find(
func(b squirrel.SelectBuilder) squirrel.SelectBuilder {
return b.Where("price > ?", 10)
}).
Fetch(db)
if err != nil {
log.Panicln(err)
}
log.Printf("%#v\n", c.List())
Load executes SELECT
statement for one row and loads the object in self.
type Todo struct {
ID int64 `db:"id,pk"`
Title string `db:"title"`
}
todo := Todo{ID: 1}
err := y.New(&todo).Load(db)
if err != nil {
log.Panicln(err)
}
log.Printf("%#v\n", todo)
Put executes INSERT
statement and assigns auto-increment value.
type User struct {
ID int64 `db:"id,pk,autoincr"`
Name string `db:"name"`
}
user := User{Name: "Harry"}
err := y.New(&user).Put(db)
if err != nil {
log.Panicln(err)
}
log.Printf("%#v\n", user)
Update executes UPDATE
statement. The action compares origin and modified objects by their version in the database.
type Versionable struct {
Version int `db:"_version"`
}
type Car struct {
ID int64 `db:"id,pk"`
Power int `db:"power"`
Versionable
}
car := Car{ID: 1}
updated, err := y.New(&car).Update(db, y.Values{"power": 50})
if err != nil {
log.Panicln(err)
}
if updated {
log.Printf("%#v\n", car)
}
Join builds relations by foreign keys
type Device struct {
ID int64 `db:",pk"`
UserID int64 `db:",fk"`
Name string
}
type User struct {
ID int64 `db:"id,pk"`
DeviceArray []*Device `db:"-"`
}
users, err := y.New(User{}).Fetch(db)
if err != nil {
log.Panicln(err)
}
if !users.Empty() {
devices, _ := y.New(Device{}).Join(db, users)
log.Printf("All users with their devices: %#v\n", users)
log.Printf("All devices: %#v\n", devices)
}
- More tests!
- Add Delete action