go-dbless

Database library with less complexity and less modeling.

Install

go get -u github.com/ddliu/go-dbless

Usage

import (
    "github.com/ddliu/go-dbless"
    _ "github.com/ddliu/go-dbless/driver/mysql"
    _ "github.com/go-sql-driver/mysql"
)
db := dbless.Open("mysql", "dsn")

Basic

• Insert
• Update
• Delete
• GetRows
• GetRow
• Scalar

Schema

• List databases
• List tables
• List columns

Resource

package main
import github.com/ddliu/go-dbless

func main() {
    db := somedb()

    resource := dbless.Resource{
        Name: "user",
        Timestamp: true,
        DB: db,
    }

    id, err := resource.Save(dbless.Record{
        "username": "ddliu",
        "password": "123456",
    })

    user, err := record.Get(id)

    listing := resource.List(dbless.ListInput{
        Pagination: dbless.Pagination {
            PageSize: 20,
            Page: 1,
        },
    })
}