search

UTD-CRSS / exploreapollo-api

API server for the exploreapollo.org application
7 stars 4 forks source link

How to determine "Upcoming moments" ? #7

Open VictorK1902 opened 9 years ago

VictorK1902 commented 9 years ago

Right now we don't have a predefined column to expose the upcoming moments for each moment ID (and we should not). So I'm wondering if you guys have any input on what's the best way to achieve this?

What I'm thinking right now is using the met_end of a currently playing moment and compare that with met_start of all moments (global? or only within this story) after +/- some offset to allow certain range. I'm just not clear if this is to be used, what's the best offset could be used? 1 min, 2mins?, 30s....

Link to the database schema https://github.com/UTD-CRSS/exploreapollo.org-schema/blob/channelChunk/README.md

JamieCrisman commented 9 years ago

This should be coming from the story. The moment should know the next moment from the very beginning.

VictorK1902 commented 9 years ago

So will that be predefined as in db? When I look at the story table and moment_story_join table I dont see any metadata yielding this kinda of information.

...

And that the moment_IDs themselves (in order or not) should not suggest any order of the moments in the story anyway

JamieCrisman commented 9 years ago

yeah, we need to figure out what determines that order.