v0.2.2

[f0rb]

Versions

• core/v0.2.2
• rdb/v0.2.2
• web/v0.2.2

Features

rdb

• support many-to-many/one-to-many/many-to-one/one-to-one queries
• ignore blank strings for the LIKE condition
• ignore empty splices for In/NotIn
• remove suffix Not

web

• make ResolveQuery public

Example for ER queries

Table t_menu has a column parent_id referring to the id column itself as a foreign key.
The parent_id column is used to define the hierarchical parent-child relationship between menu items.
The menus are assigned to the users as a system resource via a general RBAC model.

import . "github.com/doytowin/goooqo/core"

type MenuEntity struct {
	IntId
	ParentId *int    `json:"parentId,omitempty"`
	Name     *string `json:"name,omitempty"`
}

type MenuQuery struct {
	PageQuery
	Id *int

	// many-to-one:
	// Query the submenus of a specific parent menu:
	// parent_id IN (SELECT id FROM t_menu WHERE [conditions])
	Parent *MenuQuery `entitypath:"menu" localField:"ParentId"`

	// one-to-many:
	// Query the parent menu of a specific submenu:
	// id IN (SELECT parent_id FROM t_menu WHERE [conditions])
	Children *MenuQuery `entitypath:"menu" foreignField:"ParentId"`

	/**
	many-to-many:
	Query the menus accessible to a specific user:
	id IN (
		SELECT menu_id FROM a_perm_and_menu WHERE perm_id IN (
			SELECT perm_id FROM a_role_and_perm WHERE role_id IN (
				SELECT role_id FROM a_user_and_role WHERE user_id IN (
					SELECT id FROM t_user WHERE [conditions]
				)
			)
		)
	)*/
	User *UserQuery `entitypath:"menu,perm,role,user"`
}

For more details. check https://goooqo.docs.doyto.win/query-mapping/query-object/er-query-field .

---

This discussion was created from the release v0.2.2.