关于自动化平台的动态菜单设计

class Menu(models.Model):
    menu_type_choices = (
        ('dashborad', u'平台看板'),
        ('cmdb', u'资产管理'),
        ('env_deploy', u'环境部署'),
        ('backup', u'数据备份'),
        ('recover', u'数据恢复'),
        ('scheduler', u'任务调度'),
        ('global_config', u'全局配置'),
        ('user_center', u'用户中心'),
    )
    server_status_choices = (
        ('1', 'valid'),
        ('0', 'invalid'),
    )
    menu_id = models.SmallIntegerField(primary_key=True,verbose_name='菜单ID')
    menu_title = models.CharField(max_length=50,verbose_name='菜单标题')
    menu_url = models.CharField(max_length=50,verbose_name='菜单URL',unique=False)
    menu_level = models.SmallIntegerField(blank=True,null=False,verbose_name='菜单等级')
    menu_parent_level = models.SmallIntegerField(blank=True,null=False,verbose_name='菜单父等级')
    menu_style = models.CharField(max_length=50,verbose_name='菜单选用的组件风格')
    menu_type = models.CharField(max_length=50,choices=menu_type_choices,null=False,verbose_name='菜单大类')
    create_date = models.DateTimeField(auto_now_add=True)
    update_date = models.DateTimeField(auto_now_add=True)
    user_role = models.ManyToManyField(User)
    menu_status = models.SmallIntegerField(choices=server_status_choices,null=False,verbose_name='菜单状态')

    class Meta:
        db_table = 'menu'
        permissions = (
            ("can_read_menu", "读取菜单权限"),
            ("can_change_menu", "更改菜单权限"),
            ("can_add_menu", "添加菜单权限"),
            ("can_delete_menu", "删除菜单权限"),
        )
        verbose_name = '菜单配置'
        verbose_name_plural = '菜单配置'

BEGIN;
CREATE TABLE `menu` (`menu_id` smallint NOT NULL PRIMARY KEY, `menu_title` varchar(50) NOT NULL, `menu_url` varchar(50) NOT NULL, `menu_level` smallint NULL, `menu_parent_level` smallint NULL, `menu_style` varchar(50) NOT NULL, `menu_type` smallint NOT NULL, `create_date` datetime(6) NOT NULL, `update_date` datetime(6) NOT NULL, `menu_status` smallint NOT NULL);
CREATE TABLE `menu_user_role` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `menu_id` smallint NOT NULL, `user_id` integer NOT NULL, UNIQUE (`menu_id`, `user_id`));
ALTER TABLE `menu_user_role` ADD CONSTRAINT `menu_user_role_menu_id_15dc921823a77a3f_fk_menu_menu_id` FOREIGN KEY (`menu_id`) REFERENCES `menu` (`menu_id`);
ALTER TABLE `menu_user_role` ADD CONSTRAINT `menu_user_role_user_id_52439a830d70516d_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`);

COMMIT;

>>> from django.contrib.auth.models import User
>>> from db_ops.models import Menu
>>> Menu.objects.all()
(0.001) QUERY = u'SELECT "menu"."menu_id", "menu"."menu_title", "menu"."menu_url", "menu"."menu_level", "menu"."menu_parent_level", "menu"."menu_style", "menu"."menu_type", "menu"."create_date", "me
nu"."update_date", "menu"."menu_status" FROM "menu" LIMIT 21' - PARAMS = (); args=()
[]

User.objects.create(password='admin2',is_superuser=0,username='admin2',first_name='admin',last_name='admin',email='aa@aa.com',is_staff=0,is_active=1,date_joined='2018-01-04')

Menu.objects.create(menu_id=1,menu_title='元数据管理',menu_url='cmdb_manage',menu_level=2,menu_parent_level=1,menu_type='cmdb',create_date='2018-01-04',update_date='2018-01-04',menu_status=1)

user = User.objects.get(pk=2)
menu = Menu.objects.get(pk=1)

>>> menu.user_role.add(user)
(0.000) QUERY = u'BEGIN' - PARAMS = (); args=None
(0.000) QUERY = u'SELECT "menu_user_role"."user_id" FROM "menu_user_role" WHERE ("menu_user_role"."menu_id" = %s AND "menu_user_role"."user_id" IN (%s))' - PARAMS = (1, 2); args=(1, 2)
(0.081) QUERY = u'INSERT INTO "menu_user_role" ("menu_id", "user_id") SELECT %s AS "menu_id", %s AS "user_id"' - PARAMS = (1, 2); args=(1, 2)

>>>User.objects.filter(menu__user_role=1)