playlist.go 4.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195
  1. package api
  2. import (
  3. "errors"
  4. "strconv"
  5. "github.com/grafana/grafana/pkg/bus"
  6. "github.com/grafana/grafana/pkg/log"
  7. "github.com/grafana/grafana/pkg/middleware"
  8. m "github.com/grafana/grafana/pkg/models"
  9. )
  10. func ValidateOrgPlaylist(c *middleware.Context) {
  11. id := c.ParamsInt64(":id")
  12. query := m.GetPlaylistByIdQuery{Id: id}
  13. err := bus.Dispatch(&query)
  14. if err != nil {
  15. c.JsonApiErr(404, "Playlist not found", err)
  16. return
  17. }
  18. if query.Result.OrgId != c.OrgId {
  19. c.JsonApiErr(403, "You are not allowed to edit/view playlist", nil)
  20. return
  21. }
  22. }
  23. func SearchPlaylists(c *middleware.Context) Response {
  24. query := c.Query("query")
  25. limit := c.QueryInt("limit")
  26. if limit == 0 {
  27. limit = 1000
  28. }
  29. searchQuery := m.GetPlaylistsQuery{
  30. Name: query,
  31. Limit: limit,
  32. OrgId: c.OrgId,
  33. }
  34. err := bus.Dispatch(&searchQuery)
  35. if err != nil {
  36. return ApiError(500, "Search failed", err)
  37. }
  38. return Json(200, searchQuery.Result)
  39. }
  40. func GetPlaylist(c *middleware.Context) Response {
  41. id := c.ParamsInt64(":id")
  42. cmd := m.GetPlaylistByIdQuery{Id: id}
  43. if err := bus.Dispatch(&cmd); err != nil {
  44. return ApiError(500, "Playlist not found", err)
  45. }
  46. playlistDTOs, _ := LoadPlaylistItemDTOs(id)
  47. dto := &m.PlaylistDTO{
  48. Id: cmd.Result.Id,
  49. Name: cmd.Result.Name,
  50. Interval: cmd.Result.Interval,
  51. OrgId: cmd.Result.OrgId,
  52. Items: playlistDTOs,
  53. }
  54. return Json(200, dto)
  55. }
  56. func LoadPlaylistItemDTOs(id int64) ([]m.PlaylistItemDTO, error) {
  57. playlistitems, err := LoadPlaylistItems(id)
  58. if err != nil {
  59. return nil, err
  60. }
  61. playlistDTOs := make([]m.PlaylistItemDTO, 0)
  62. for _, item := range playlistitems {
  63. playlistDTOs = append(playlistDTOs, m.PlaylistItemDTO{
  64. Id: item.Id,
  65. PlaylistId: item.PlaylistId,
  66. Type: item.Type,
  67. Value: item.Value,
  68. Order: item.Order,
  69. Title: item.Title,
  70. })
  71. }
  72. return playlistDTOs, nil
  73. }
  74. func LoadPlaylistItems(id int64) ([]m.PlaylistItem, error) {
  75. itemQuery := m.GetPlaylistItemsByIdQuery{PlaylistId: id}
  76. if err := bus.Dispatch(&itemQuery); err != nil {
  77. return nil, err
  78. }
  79. return *itemQuery.Result, nil
  80. }
  81. func LoadPlaylistDashboards(id int64) ([]m.PlaylistDashboardDto, error) {
  82. playlistItems, _ := LoadPlaylistItems(id)
  83. dashboardIds := make([]int64, 0)
  84. for _, i := range playlistItems {
  85. dashboardId, _ := strconv.ParseInt(i.Value, 10, 64)
  86. dashboardIds = append(dashboardIds, dashboardId)
  87. }
  88. if len(dashboardIds) == 0 {
  89. return make([]m.PlaylistDashboardDto, 0), nil
  90. }
  91. dashboardQuery := m.GetPlaylistDashboardsQuery{DashboardIds: dashboardIds}
  92. if err := bus.Dispatch(&dashboardQuery); err != nil {
  93. log.Warn("dashboardquery failed: %v", err)
  94. return nil, errors.New("Playlist not found")
  95. }
  96. dtos := make([]m.PlaylistDashboardDto, 0)
  97. for _, item := range *dashboardQuery.Result {
  98. dtos = append(dtos, m.PlaylistDashboardDto{
  99. Id: item.Id,
  100. Slug: item.Slug,
  101. Title: item.Title,
  102. Uri: "db/" + item.Slug,
  103. })
  104. }
  105. return dtos, nil
  106. }
  107. func GetPlaylistItems(c *middleware.Context) Response {
  108. id := c.ParamsInt64(":id")
  109. playlistDTOs, err := LoadPlaylistItemDTOs(id)
  110. if err != nil {
  111. return ApiError(500, "Could not load playlist items", err)
  112. }
  113. return Json(200, playlistDTOs)
  114. }
  115. func GetPlaylistDashboards(c *middleware.Context) Response {
  116. id := c.ParamsInt64(":id")
  117. playlists, err := LoadPlaylistDashboards(id)
  118. if err != nil {
  119. return ApiError(500, "Could not load dashboards", err)
  120. }
  121. return Json(200, playlists)
  122. }
  123. func DeletePlaylist(c *middleware.Context) Response {
  124. id := c.ParamsInt64(":id")
  125. cmd := m.DeletePlaylistCommand{Id: id, OrgId: c.OrgId}
  126. if err := bus.Dispatch(&cmd); err != nil {
  127. return ApiError(500, "Failed to delete playlist", err)
  128. }
  129. return Json(200, "")
  130. }
  131. func CreatePlaylist(c *middleware.Context, cmd m.CreatePlaylistCommand) Response {
  132. cmd.OrgId = c.OrgId
  133. if err := bus.Dispatch(&cmd); err != nil {
  134. return ApiError(500, "Failed to create playlist", err)
  135. }
  136. return Json(200, cmd.Result)
  137. }
  138. func UpdatePlaylist(c *middleware.Context, cmd m.UpdatePlaylistCommand) Response {
  139. cmd.OrgId = c.OrgId
  140. if err := bus.Dispatch(&cmd); err != nil {
  141. return ApiError(500, "Failed to save playlist", err)
  142. }
  143. playlistDTOs, err := LoadPlaylistItemDTOs(cmd.Id)
  144. if err != nil {
  145. return ApiError(500, "Failed to save playlist", err)
  146. }
  147. cmd.Result.Items = playlistDTOs
  148. return Json(200, cmd.Result)
  149. }