This REST Layer resource storage backend stores data in a PostgreSQL Database using database/sql and pq.
import "github.com/safad/rest-layer-pgsql"Open an SQL connection to PostgreSQL using database/sql:
const (
DB_USER = "postgres"
DB_PASSWORD = "postgres"
DB_NAME = "test"
)
dbinfo := fmt.Sprintf("user=%s password=%s dbname=%s sslmode=disable",
DB_USER, DB_PASSWORD, DB_NAME)
db, err := sql.Open("postgres", dbinfo)Create a resource storage handler with a given DB/collection:
users_handler := pgsql.NewHandler(db, "users")Use this handler with a resource:
index.Bind("users", users, users_handler, resource.DefaultConf)