orm是怎么配置比如菜单资源的上下级的名称的?上下级都是同一个类。
上级是多对一
下级是一对多
里面的名称默认都是类名开头变小写的。
那像这种情况要怎么设置不同名称给他们呢?
有个alias可以指定别名,
orm.single({"departmentId","id"},"Department",{"alias":"myDepartment"})
不过BeetlSQL只支持简单的ORM查询,我不清楚如何完成Hibernate那样的层层映射
也许使用俩个SQL语句,通过orm.single,orm.lazy,可以实现,类似这种,俩个sql互相引用
selectUser
===
select * from user where user_id=#userId#
@if(isNotEmpty(departmentId){
departmentId=#departmentID#
@}
@ orm.single({"departmentId":"id"},"selectDepartment","Department");
selectDepartment
===
select * from department where id=#id#
@ orm.Many({"id":"department},"selectUser","Department");