doc/dev/couchdb-views.rst

   1
   2 CouchDB Views
   3 =============
   4
   5 This page describes the views that will be used in the CouchDB based backend of
   6 the gpodder.net webservice.
   7
   8 The views are separated into groups, based on the databases they are indexed
   9 on.
  10
  11 General
  12 -------
  13
  14 This group of views is available on the general database, called ``mygpo`` by
  15 default.
  16
  17
  18 Clients
  19 ^^^^^^^
  20
  21 Doc-Types: User
  22
  23 **Views**
  24
  25 * `clients/by_ua_string <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/clients/views/by_ua_string>`_
  26
  27
  28 Episode Statistics
  29 ^^^^^^^^^^^^^^^^^^
  30
  31 Doc-Types: Episode
  32
  33 **Views**
  34
  35 * `episode_stats/filetypes <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/episode_stats/views/filetypes>`_
  36
  37
  38 Episodes
  39 ^^^^^^^^
  40
  41 Doc-Types: Episode
  42
  43 **Views**
  44
  45 * `episodes/by_id <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/episodes/views/by_id>`_
  46 * `episodes/by_oldid <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/episodes/views/by_oldid>`_
  47 * `episodes/by_podcast <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/episodes/views/by_podcast>`_
  48 * `episodes/by_podcast_url <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/episodes/views/by_podcast_url>`_
  49 * `episodes/by_slug <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/episodes/views/by_slug>`_
  50 * `episodes/need_update <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/episodes/views/need_update>`_
  51
  52
  53 Podcast Lists
  54 ^^^^^^^^^^^^^
  55
  56 Doc-Types: PodcastList
  57
  58 **Views**
  59
  60 * `podcastlists/by_rating <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/podcastlists/views/by_rating>`_
  61 * `podcastlists/by_user_slug <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/podcastlists/views/by_user_slug>`_
  62 * `podcastlists/random <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/podcastlists/views/random>`_
  63
  64
  65 Podcasts
  66 ^^^^^^^^
  67
  68 Doc-Types: Podcast, PodcastGroup, PodcastSubscriberData
  69
  70 **Views**
  71
  72 * `podcasts/by_id <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/podcasts/views/by_id>`_
  73 * `podcasts/by_language <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/podcasts/views/by_language>`_
  74 * `podcasts/by_last_update <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/podcasts/views/by_last_update>`_
  75 * `podcasts/by_oldid <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/podcasts/views/by_oldid>`_
  76 * `podcasts/by_slug <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/podcasts/views/by_slug>`_
  77 * `podcasts/by_tag <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/podcasts/views/by_tag>`_
  78 * `podcasts/by_url <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/podcasts/views/by_url>`_
  79 * `podcasts/flattr <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/podcasts/views/flattr>`_
  80 * `podcasts/groups_by_oldid <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/podcasts/views/groups_by_oldid>`_
  81 * `podcasts/podcasts_groups <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/podcasts/views/podcasts_groups>`_
  82 * `podcasts/random <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/podcasts/views/random>`_
  83 * `podcasts/subscriber_data <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/podcasts/views/subscriber_data>`_
  84
  85
  86 Slugs
  87 ^^^^^
  88
  89 Doc-Types: Podcast, PodcastGroup, Episode
  90
  91 **Views**
  92
  93 * `slugs/missing <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/slugs/views/missing>`_
  94
  95
  96 Suggestions
  97 ^^^^^^^^^^^
  98
  99 Doc-Types: Suggestions
 100
 101 **Views**
 102
 103 * `suggestions/by_user <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/suggestions/views/by_user>`_
 104
 105
 106 Tags
 107 ^^^^
 108
 109 Doc-Types: Podcast, PodcastGroup
 110
 111 **Views**
 112
 113 * `tags/by_podcast <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/tags/views/by_podcast>`_
 114
 115
 116 Toplists
 117 ^^^^^^^^
 118
 119 Doc-Types: Episode, Podcast, PodcastGroup
 120
 121 **Views**
 122
 123 * `toplist/episodes <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/toplist/views/episodes>`_
 124 * `toplist/podcasts <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/toplist/views/podcasts>`_
 125
 126
 127 Trending
 128 ^^^^^^^^
 129
 130 Doc-Types: Podcast, PodcastGroup
 131
 132 **Views**
 133
 134 * `trending/podcasts <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/trending/views/podcasts>`_
 135
 136
 137 Users
 138 ^^^^^
 139
 140 Doc-Types: User
 141
 142 **Views**
 143
 144 * `users/by_google_email <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/users/views/by_google_email>`_
 145 * `users/deleted <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/users/views/deleted>`_
 146
 147
 148 Userdata
 149 --------
 150
 151 This group of views is available in the *userdata* database, called
 152 ``mygpo_userdata`` by default.
 153
 154 Chapters
 155 ^^^^^^^^
 156
 157 Doc-Types: EpisodeUserState
 158
 159 **Views**
 160
 161 * `chapters/by_episode <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/chapters/views/by_episode>`_
 162
 163
 164 Episode Actions
 165 ^^^^^^^^^^^^^^^
 166
 167 Doc-Types: EpisodeUserState
 168
 169 **Views**
 170
 171 * `episode_actions/by_device <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/episode_actions/views/by_device>`_
 172 * `episode_actions/by_podcast_device <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/episode_actions/views/by_podcast_device>`_
 173 * `episode_actions/by_podcast <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/episode_actions/views/by_podcast>`_
 174 * `episode_actions/by_user <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/episode_actions/views/by_user>`_
 175
 176
 177 Episode States
 178 ^^^^^^^^^^^^^^
 179
 180 Doc-Types: EpisodeUserState
 181
 182 **Views**
 183
 184 * `episode_states/by_podcast_episode <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/episode_states/views/by_podcast_episode>`_
 185 * `episode_states/by_ref_urls <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/episode_states/views/by_ref_urls>`_
 186 * `episode_states/by_user_episode <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/episode_states/views/by_user_episode>`_
 187 * `episode_states/by_user_podcast <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/episode_states/views/by_user_podcast>`_
 188
 189
 190 Favorites
 191 ^^^^^^^^^
 192
 193 Doc-Types: EpisodeUserState
 194
 195 **Views**
 196
 197 * `episodes/favorites_by_user <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/favorites/views/episodes_by_user>`_
 198
 199
 200 Heatmap
 201 ^^^^^^^
 202
 203 Doc-Types: EpisodeUserState
 204
 205 **Views**
 206
 207 * `heatmap/by_episode <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/heatmap/views/by_episode>`_
 208
 209
 210 History
 211 ^^^^^^^
 212
 213 Doc-Types: EpisodeUserState, PodcastUserState
 214
 215 **Views**
 216
 217 * `history/by_device <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/history/views/by_device>`_
 218 * `history/by_user <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/history/views/by_user>`_
 219
 220
 221 Listeners
 222 ^^^^^^^^^
 223
 224 Doc-Types: EpisodeUserState
 225
 226 **Views**
 227
 228 * `listeners/by_episode <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/listeners/views/by_episode>`_
 229 * `listeners/by_podcast_episode <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/listeners/views/by_podcast_episode>`_
 230 * `listeners/by_podcast <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/listeners/views/by_podcast>`_
 231 * `listeners/by_user <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/listeners/views/by_user>`_
 232 * `listeners/by_user_podcast <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/listeners/views/by_user_podcast>`_
 233 * `listeners/times_played_by_user <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/listeners/views/times_played_by_user>`_
 234
 235
 236 Podcast States
 237 ^^^^^^^^^^^^^^
 238
 239 Doc-Types: PodcastUserState
 240
 241 **Views**
 242
 243 * `podcast_states/by_device <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/podcast_states/views/by_device>`_
 244 * `podcast_states/by_podcast <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/podcast_states/views/by_podcast>`_
 245 * `podcast_states/by_user <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/podcast_states/views/by_user>`_
 246
 247
 248 Subscribers
 249 ^^^^^^^^^^^
 250
 251 Doc-Types: PodcastUserState
 252
 253 **Views**
 254
 255 * `subscribers/by_podcast <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/subscribers/views/by_podcast>`_
 256
 257
 258 Subscriptions
 259 ^^^^^^^^^^^^^
 260
 261 Doc-Types: PodcastUserState
 262
 263 **Views**
 264
 265 * `subscriptions/by_device <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/subscriptions/views/by_device>`_
 266 * `subscriptions/by_podcast <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/subscriptions/views/by_podcast>`_
 267 * `subscriptions/by_user <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/subscriptions/views/by_user>`_
 268
 269
 270 User-Tags
 271 ^^^^^^^^^
 272
 273 Doc-Types: PodcastUserState
 274
 275 **Views**
 276
 277 * `usertags/by_podcast <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/usertags/views/by_podcast>`_
 278 * `usertags/by_user <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/usertags/views/by_user>`_
 279 * `usertags/podcasts <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/usertags/views/podcasts>`_
 280
 281
 282
 283
 284
 285 Categories
 286 ----------
 287
 288 This group of views is available on the categories database, called
 289 ``mygpo_categories`` by default.
 290
 291
 292 Categories
 293 ^^^^^^^^^^
 294
 295 Doc-Types: Category
 296
 297 **Views**
 298
 299 * `categories/by_tags <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/categories/views/by_tags>`_
 300 * `categories/by_update <https://github.com/gpodder/mygpo/tree/master/couchdb/general/_design/categories/views/by_update>`_
 301
 302
 303 Pubsub
 304 ------
 305
 306 The following views and design documents relate to the "pubsub" database.
 307
 308 Subscriptions
 309 ^^^^^^^^^^^^^
 310
 311 Doc-Types: Subscription
 312
 313 **Views**
 314
 315 * `subscriptions/by_topic <https://github.com/gpodder/mygpo/tree/master/couchdb/pubsub/_design/subscriptions/views/by_topic>`_