Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Verify/validate _time_hhmm fields #16

Closed
christopeak opened this issue Aug 21, 2019 · 2 comments
Closed

Verify/validate _time_hhmm fields #16

christopeak opened this issue Aug 21, 2019 · 2 comments
Assignees

Comments

@christopeak
Copy link
Contributor

Make sure that Rulesy updates arrival_time_hhmm and depart_time_hhmm for ALL records in the trips table, not just a subset. Also make sure this happens prior to other decisions based on these fields. Following updates these _time_hhmm columns, update reported_duration.

@Ennazus
Copy link
Member

Ennazus commented Aug 21, 2019

The beginning part of this is right but we don't need to do "Following updates these _time_hhmm columns, update reported_duration.".
We can update everything according to the timestamps.

@jensenmj
Copy link
Contributor

Exists as part of stored procedure HHSurvey.recalculate_after_edit , which had been limited to run on edited records but can be applied universally. Ran against current Trip table.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants