I've saw that some rules and sorting are only applied if Songs I've liked is selected.
While it absolutely make sense for the Days Ago (How many days ago was the song added?) rule, there are some more rules which also could be applied if one of the other catalogs are selected (Play count and Last played). There're also some sorting which also could be used with other catalogs than Songs I've liked.
The main reason is that the play statistics are held in the follows table. The follows table only contains a document when the user have liked the song.
I saw that there is another table streams which holds all plays of a song for a user. Maybe we could refactor the rules mentioned above to use the streams table instead of follows.
What do you think @Shpigford?
I've saw that some rules and sorting are only applied if
Songs I've likedis selected.While it absolutely make sense for the
Days Ago (How many days ago was the song added?)rule, there are some more rules which also could be applied if one of the other catalogs are selected (Play count and Last played). There're also some sorting which also could be used with other catalogs thanSongs I've liked.The main reason is that the play statistics are held in the
followstable. Thefollowstable only contains a document when the user have liked the song.I saw that there is another table
streamswhich holds all plays of a song for a user. Maybe we could refactor the rules mentioned above to use thestreamstable instead offollows.What do you think @Shpigford?