Sql_SysRoleMenu_gen.go 1.0 KB

123456789101112131415161718192021222324252627282930313233343536373839
  1. package models
  2. var Insert_sys_role_menu = `
  3. insert into sys_role_menu
  4. (id,role_id,menu_id,domain,create_by,create_time,last_update_by,last_update_date,del_flag)
  5. values
  6. (?id,?role_id,?menu_id,?domain,?create_by,?create_time,?last_update_by,?last_update_date,?del_flag)
  7. `
  8. var Update_sys_role_menu = `
  9. update sys_role_menu set
  10. role_id = ?role_id,
  11. menu_id = ?menu_id,
  12. domain = ?domain,
  13. create_by = ?create_by,
  14. create_time = ?create_time,
  15. last_update_by = ?last_update_by,
  16. last_update_date = ?last_update_date,
  17. del_flag = ?del_flag
  18. where id = ?id
  19. `
  20. var Deleteone_sys_role_menu = `
  21. delete from sys_role_menu
  22. where id =?id
  23. `
  24. var Selectone_sys_role_menu = `
  25. select
  26. id,role_id,menu_id,domain,create_by,create_time,last_update_by,last_update_date,del_flag
  27. from sys_role_menu
  28. where id = ?id
  29. `
  30. var Selectall_sys_role_menu = `
  31. select
  32. id,role_id,menu_id,domain,create_by,create_time,last_update_by,last_update_date,del_flag
  33. from sys_role_menu
  34. `