Videos not in Order

[ardalis]

Just uploaded videos from 26th and 27th and they're appearing in this order:

Should be most recent first.

[samuelwine]

Could this be to do with the video DateCreated somehow set incorrectly?
I tried to follow it back to see where DateCreated is set originally, but I couldn't quite find it.

[ardalis]

Very likely. I'm not sure where it is set, either, or if it's set by Vimeo and we just import their value. Something to track down for sure.

[totalitydevelopment]

The code grabs the full video list from the db, then grabs a cached list also.

Any videos that aren't in the cache get added at position 0. Guessing maybe given the close nature of those 2 videos recording time wise you uploaded the 27th before the 26th which left the 26th first in the list.

There is no ordering on the cached list being returned.

That would be the cheap and easy way to resolve...

[samuelwine]

@totalitydevelopment any chance you could add a link to the code you are referencing?

Thanks!

[totalitydevelopment]

@samuelwine try this:
https://github.com/DevBetterCom/DevBetterWeb/blob/main/src/DevBetterWeb.Web/Endpoints/VideoEndpoints/GetAllVideos.cs

[samuelwine]

thanks @totalitydevelopment.
I'm a bit unsure where that gets called - when i looked through the code, it looked like it was calling this

[totalitydevelopment]

Yeah you're right. Dived in at that code without running as only had a few minutes.

Is this more accurate?

DevBetterWeb.Web.Endpoints.UploadVideo.AddVimeoVideoInfoAsync

[totalitydevelopment]

That'll need a manual db tweak for the outstanding issue... or you can could change the spec to order by dateUploaded but there will always be scope for them being uploaded in the wrong order that way...

[samuelwine]

@ardalis what is the process for creating a new video? I'm assuming it gets created locally, then gets uploaded to Vimeo, as well as an "overview" to the DB. Is that correct?
And does the Vimeo upload also get done through the DevBetter site?
Thanks

[ardalis]

There's a separate Uploaders github repo with a WPF app that does the upload to Vimeo. @ShadyNagy wrote it. It's interested the DateCreated is only Date, not time, which seems to be the issue.

[samuelwine]

Makes sense!