Awesome
QOR Admin
Instantly create a beautiful, cross platform, configurable Admin Interface and API for managing your data in minutes.
For security issues, please send us an email to security@getqor.com and give us time to respond BEFORE posting as an issue or reporting on public forums.
Features
- Generate Admin Interface for managing data
- RESTFul JSON API
- Association handling
- Search and filtering
- Actions/Batch Actions
- Authentication and Authorization
- Extendability
Quick Start
package main
import (
"fmt"
"net/http"
"github.com/jinzhu/gorm"
_ "github.com/mattn/go-sqlite3"
"github.com/qor/admin"
)
// Create a GORM-backend model
type User struct {
gorm.Model
Name string
}
// Create another GORM-backend model
type Product struct {
gorm.Model
Name string
Description string
}
func main() {
DB, _ := gorm.Open("sqlite3", "demo.db")
DB.AutoMigrate(&User{}, &Product{})
// Initialize
Admin := admin.New(&admin.AdminConfig{DB: DB})
// Allow to use Admin to manage User, Product
Admin.AddResource(&User{})
Admin.AddResource(&Product{})
// initialize an HTTP request multiplexer
mux := http.NewServeMux()
// Mount admin interface to mux
Admin.MountTo("/admin", mux)
fmt.Println("Listening on: 9000")
http.ListenAndServe(":9000", mux)
}
go run main.go
and visit localhost:9000/admin
to see the result!
How to use remoteSelector with publish2.version integrated record
For has many relationship
Suppose we have 2 models Factory and Item. Factory has many Items.
In the struct, you need add a field resource.CompositePrimaryKeyField
to the "many" side, which is Item
here.
type Factory struct {
gorm.Model
Name string
publish2.Version
Items []Item `gorm:"many2many:factory_items;association_autoupdate:false"`
ItemsSorter sorting.SortableCollection
}
type Item struct {
gorm.Model
Name string
publish2.Version
// github.com/qor/qor/resource
resource.CompositePrimaryKeyField // Required
}
Then define a remote resource selector. You need configure the ID
meta like below to make it support composite primary key, this is mandatory.
func generateRemoteItemSelector(adm *admin.Admin) (res *admin.Resource) {
res = adm.AddResource(&Item{}, &admin.Config{Name: "ItemSelector"})
res.IndexAttrs("ID", "Name")
// Required. Convert single ID into composite primary key
res.Meta(&admin.Meta{
Name: "ID",
Valuer: func(value interface{}, ctx *qor.Context) interface{} {
if r, ok := value.(*Item); ok {
// github.com/qor/qor/resource
return resource.GenCompositePrimaryKey(r.ID, r.GetVersionName())
}
return ""
},
})
return res
}
Last, use it in the Factory resource.
itemSelector := generateRemoteItemSelector(adm)
factoryRes.Meta(&admin.Meta{
Name: "Items",
Config: &admin.SelectManyConfig{
RemoteDataResource: itemSelector,
},
})
For has one relationship
Suppose we have 2 models. Factory and Manager. Factory has one Manager.
First, In the struct, you need add a field resource.CompositePrimaryKeyField
to the "one" side, which is Manager
here.
type Factory struct {
gorm.Model
Name string
publish2.Version
ManagerID uint
ManagerVersionName string // Required. in "xxxVersionName" format.
Manager Manager
}
type Manager struct {
gorm.Model
Name string
publish2.Version
// github.com/qor/qor/resource
resource.CompositePrimaryKeyField // Required
}
Then define a remote resource selector. You need configure the ID
meta like below to make it support composite primary key, this is mandatory.
func generateRemoteManagerSelector(adm *admin.Admin) (res *admin.Resource) {
res = adm.AddResource(&Manager{}, &admin.Config{Name: "ManagerSelector"})
res.IndexAttrs("ID", "Name")
// Required. Convert single ID into composite primary key
res.Meta(&admin.Meta{
Name: "ID",
Valuer: func(value interface{}, ctx *qor.Context) interface{} {
if r, ok := value.(*Manager); ok {
// github.com/qor/qor/resource
return resource.GenCompositePrimaryKey(r.ID, r.GetVersionName())
}
return ""
},
})
return res
}
Last, use it in the Factory resource.
```go
managerSelector := generateRemoteManagerSelector(adm)
factoryRes.Meta(&admin.Meta{
Name: "Manager",
Config: &admin.SelectOneConfig{
RemoteDataResource: managerSelector,
},
})
If you need to overwrite Collection. you have to pass composite primary key as the first element of the returning array instead of ID.
factoryRes.Meta(&admin.Meta{
Name: "Items",
Config: &admin.SelectManyConfig{
Collection: func(value interface{}, ctx *qor.Context) (results [][]string) {
if c, ok := value.(*Factory); ok {
var items []Item
ctx.GetDB().Model(c).Related(&items, "Items")
for _, p := range items {
// The first element must be the composite primary key instead of ID
results = append(results, []string{resource.GenCompositePrimaryKey(p.ID, p.GetVersionName()), p.Name})
}
}
return
},
RemoteDataResource: itemSelector,
},
})
To support assign associations when creating a new version
If you want to assign associations when creating a new version of object immediately. You need to define a function called AssignVersionName
to the versioned struct with pointer receiver which should contains the generating new version name's logic and assign the new version name to the object.
e.g.
func (fac *Factory) AssignVersionName(db *gorm.DB) {
var count int
name := time.Now().Format("2006-01-02")
if err := db.Model(&CollectionWithVersion{}).Where("id = ? AND version_name like ?", fac.ID, name+"%").Count(&count).Error; err != nil {
panic(err)
}
fac.VersionName = fmt.Sprintf("%s-v%v", name, count+1)
}
Live DEMO
- Live Demo http://demo.getqor.com/admin
- Source Code of Live Demo https://github.com/qor/qor-example
Documentation
To print all registered routes
// adm is a QOR admin instance
adm.GetRouter().PrintRoutes()
ViewPath Note
QOR was developed before go mod was introduced. So it still support go path while finding its template files. The priority is
- check vendor, if not found
- check $GOPATH/pkg/mod/github.com/qor/admin@v0.x/views. the version would be detected automatically by your go.mod file, if still not found
- load view path from $GOPATH/src/github.com/qor/admin/views
So if you want to use the template under the pkg/mod, make sure $GOPATH/src/github.com/qor/admin is absent.
License
Released under the MIT License.