augur icon indicating copy to clipboard operation
augur copied to clipboard

Fix: String to Date #2662

Open PredictiveManish opened this issue 1 month ago • 5 comments

Description This PR converts current_release_date and latest_release_date from string type to Date format.

This PR fixes #2663

Notes for Reviewers

Signed commits

  • [x] Yes, I signed my commits.

PredictiveManish avatar Nov 09 '25 18:11 PredictiveManish

@MoralCode are you working on this now? or I can continue? as I got to know that now changes need new files and this is 35th and I will update- remove the suggestions and update accordingly.

PredictiveManish avatar Nov 11 '25 17:11 PredictiveManish

This change is going to require more than just a schema change. We discussed it briefly at the end of today's Augur call and Sean mentioned that this is likely to require a fair degree of logic changes as well, especially to make sure that various error cases get handled when converting date values (which come from various sources and may all be in different formats).

Also since this is a breaking schema change, I think its going to get through review faster if an existing maintainer can handle it.

I can't stop you from working on it, but i will likely be adopting this change and working with the maintainers to figure out the best way to handle it (along with lots of other database changes) - especially given similar/related issues like #1370

MoralCode avatar Nov 11 '25 19:11 MoralCode

This change is going to require more than just a schema change. We discussed it briefly at the end of today's Augur call and Sean mentioned that this is likely to require a fair degree of logic changes as well, especially to make sure that various error cases get handled when converting date values (which come from various sources and may all be in different formats).

Also since this is a breaking schema change, I think its going to get through review faster if an existing maintainer can handle it.

I can't stop you from working on it, but i will likely be adopting this change and working with the maintainers to figure out the best way to handle it (along with lots of other database changes) - especially given similar/related issues like #1370

Ok. got your point will work on this so that can understand database system in the augur deeply and manage to solve other issues related to database.

PredictiveManish avatar Nov 12 '25 03:11 PredictiveManish

@MoralCode : We probably should discuss this one and decide how it intersects with the other db updates you've been working on.

sgoggins avatar Dec 09 '25 22:12 sgoggins

We probably should discuss this one and decide how it intersects with the other db updates you've been working on.

This is a pretty major fix, possibly a breaking change that is very likely to require some soecial handling/special consideration for how to migrate existing data, which can be in just about any date format. I dont really know how to resolve this cleanly and its probably going to be a pretty big effort that may not be worth it for a while.

MoralCode avatar Dec 11 '25 15:12 MoralCode

Closing this PR as I dont see it getting merged anytime soon due to the aforementioned complexities surrounding handling peoples existing data from Augur instances of various ages

MoralCode avatar Dec 19 '25 19:12 MoralCode