playlist.go 4.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195
  1. package api
  2. import (
  3. "errors"
  4. "github.com/grafana/grafana/pkg/bus"
  5. "github.com/grafana/grafana/pkg/log"
  6. "github.com/grafana/grafana/pkg/middleware"
  7. m "github.com/grafana/grafana/pkg/models"
  8. "strconv"
  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.PlaylistQuery{
  30. Title: 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. Title: cmd.Result.Title,
  50. Timespan: cmd.Result.Timespan,
  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. log.Warn("itemQuery failed: %v", err)
  78. return nil, errors.New("Playlist not found")
  79. }
  80. return *itemQuery.Result, nil
  81. }
  82. func LoadPlaylistDashboards(id int64) ([]m.PlaylistDashboardDto, error) {
  83. playlistItems, _ := LoadPlaylistItems(id)
  84. dashboardIds := make([]int64, 0)
  85. for _, i := range playlistItems {
  86. dashboardId, _ := strconv.ParseInt(i.Value, 10, 64)
  87. dashboardIds = append(dashboardIds, dashboardId)
  88. }
  89. if len(dashboardIds) == 0 {
  90. return make([]m.PlaylistDashboardDto, 0), nil
  91. }
  92. dashboardQuery := m.GetPlaylistDashboardsQuery{DashboardIds: dashboardIds}
  93. if err := bus.Dispatch(&dashboardQuery); err != nil {
  94. log.Warn("dashboardquery failed: %v", err)
  95. return nil, errors.New("Playlist not found")
  96. }
  97. dtos := make([]m.PlaylistDashboardDto, 0)
  98. for _, item := range *dashboardQuery.Result {
  99. dtos = append(dtos, m.PlaylistDashboardDto{
  100. Id: item.Id,
  101. Slug: item.Slug,
  102. Title: item.Title,
  103. Uri: "db/" + item.Slug,
  104. })
  105. }
  106. return dtos, nil
  107. }
  108. func GetPlaylistItems(c *middleware.Context) Response {
  109. id := c.ParamsInt64(":id")
  110. playlistDTOs, err := LoadPlaylistItemDTOs(id)
  111. if err != nil {
  112. return ApiError(500, "Could not load playlist items", err)
  113. }
  114. return Json(200, playlistDTOs)
  115. }
  116. func GetPlaylistDashboards(c *middleware.Context) Response {
  117. id := c.ParamsInt64(":id")
  118. playlists, err := LoadPlaylistDashboards(id)
  119. if err != nil {
  120. return ApiError(500, "Could not load dashboards", err)
  121. }
  122. return Json(200, playlists)
  123. }
  124. func DeletePlaylist(c *middleware.Context) Response {
  125. id := c.ParamsInt64(":id")
  126. cmd := m.DeletePlaylistQuery{Id: id}
  127. if err := bus.Dispatch(&cmd); err != nil {
  128. return ApiError(500, "Failed to delete playlist", err)
  129. }
  130. return Json(200, "")
  131. }
  132. func CreatePlaylist(c *middleware.Context, query m.CreatePlaylistQuery) Response {
  133. query.OrgId = c.OrgId
  134. err := bus.Dispatch(&query)
  135. if err != nil {
  136. return ApiError(500, "Failed to create playlist", err)
  137. }
  138. return Json(200, query.Result)
  139. }
  140. func UpdatePlaylist(c *middleware.Context, query m.UpdatePlaylistQuery) Response {
  141. err := bus.Dispatch(&query)
  142. if err != nil {
  143. return ApiError(500, "Failed to save playlist", err)
  144. }
  145. playlistDTOs, err := LoadPlaylistItemDTOs(query.Id)
  146. if err != nil {
  147. return ApiError(500, "Failed to save playlist", err)
  148. }
  149. query.Result.Items = playlistDTOs
  150. return Json(200, query.Result)
  151. }