gin-rest-drilldown

REST DrillDrown

This package is based on Django Rest Framework DrillDrown and it is on early stages of developments

The goal is to allow fast creation of REST APIs based on models, allowing advanced filtering, running on top of Golang Gin Web framework

Examples

Assuming you have the following models:

type Author struct {
	gorm.Model
	ID        uint64  `json:"id"`
	Name      *string `json:"name" gorm:"index:idx_name,unique" binding:"required"`
	Books     []Book
}

type Book struct {
	gorm.Model
	AuthorID  uint64  `json:"author_id,omitempty" binding:"required"`
	Genre     *string `json:"genre,omitempty"`
	Pages     *int    `json:"pages,omitempty"`
}

You should be able to register a basic CRUD REST interface just adding:

	drilldown.RegisterModel(router, Book{}, "books", nil)
	drilldown.RegisterModel(router, Author{}, "authors", nil)

The first argument is the Gin router (*gin.Engine), the second argument is the instance of the model, and the last argument is the resource path on the URL

Full code connecting to Sqlite database

package main

import (
	drilldown "github.com/dcfranca/gin-rest-drilldown/pkg/drilldown"
	"gorm.io/driver/sqlite"
	"gorm.io/gorm"
)

func main() {
	db, err := gorm.Open(sqlite.Open("test.db"))

	if err != nil {
		panic("Failed to connect to database!")
	}

	drilldown.DB = db

	// Instantiate the router and creates a healthcheck endpoint
	router := drilldown.SetupRouter()

	drilldown.DB.AutoMigrate(&Book{})
	drilldown.DB.AutoMigrate(&Author{})

	drilldown.RegisterModel(router, Book{}, "books", nil)
	drilldown.RegisterModel(router, Author{}, "authors", nil)

	router.Run()
}

For example, this will create the following routes for the books:

GET /books

GET /books/:id

POST /books

PUT /books/:id

DELETE /books/:id

The GET /books endpoint allows for more complex queries Example of some of the possible queries:

Specify fields to retrieve using the fields parameter:

GET /books?fields=title,pages

Specify fields from join table using the syntax tableName.field:

GET /books?fields=title,authors.name

Specify condition using different operators:

GET /books?fields=title,authors.name&pages__gt=500

Possible operators:

• __gt -> Greater than
• __gte -> Greater than or equal
• __lt -> Less than
• __lte -> Less than or equal
• __startswith -> String starts with
• __endswith -> String ends with
• __contains -> String contains

Specify condition by referencing another table with the syntax tableName.field:

GET /books?fields=title,authors.name&authors.name=Chuck Palahniuk&pages__gt=500

Sort your results with order clause, add - prefix to sort in descending order

GET /books?fields=title,authors.name&order=author.name,-title

Paginate your results with offset and limit

GET /books?fields=title,authors.name&order=author.name&offset=21&limit=20

You can also use a different lookup field for single item path For example, here there is a field Slug, you can use it as the lookup field:

type Book struct {
	gorm.Model
	AuthorID  uint64  `json:"author_id,omitempty" binding:"required"`
	Genre     *string `json:"genre,omitempty"`
	Pages     *int    `json:"pages,omitempty"`
	Slug      *string `json:"slug,omitempty" binding:"required"
}

To do that you need to pass an extra parameter, *Apiconfig, to the registerModel call

drilldown.RegisterModel(router, Book{}, "books", &ApiConfig{LookupField: "Slug"})

Now the URLs will be as follow: GET /books

GET /books/:slug

POST /books

PUT /books/:slug

DELETE /books/:slug

You can also add custom Gorm scopes to query items

Ex:

func FilterSciFi(db *gorm.DB) *gorm.DB {
	return db.Model(&Book{}).Where("genre = ?", "scifi")
}

...
	DB.AutoMigrate(&Book{})
	RegisterModel(router, Book{}, "books", &ApiConfig{
		ScopesFind: []func(db *gorm.DB) *gorm.DB{FilterSciFi},
	})
...

This will filter only books of the scifi genre