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

Jail configs need timezone info and job logs should include UTC collection timestamp #12

Open
1 of 5 tasks
eenblam opened this issue Aug 3, 2024 · 1 comment
Open
1 of 5 tasks

Comments

@eenblam
Copy link
Owner

eenblam commented Aug 3, 2024

Unfortunately, JailTracker does provide datetime strings for important dates, but they don't seem to be timezone aware. For example, the special field "Booking Date" is provided as text "8/3/2024 4:30:00 AM" in the response JSON.

  • Date-only fields should be left as-is, since we don't know the local time on the date to then infer the date in UTC.
  • Datetime fields should be maintained as is, but each should also be converted to UTC+0000 and saved in a <fieldname>-UTC. Conversion should be done based on
  • This can be applied retroactively to existing data via a script, so this isn't so urgent.

Currently, JTT's queries are dumped to disk with a filename indicating the name of the facility and the date string (in UTC+0000). It would be helpful to know the more exact times the script began and ended, and have them saved at the top-level of the job's output JSON. This is more urgent, since we can't determine this retroactively.

Tasks:

  • Urgent: add job begin and end timestamps to JSON output.
  • Add UTCOffset field to JailConfig type.
  • Update all jail configs with state and UTC offset.
  • Using the facility's UTC offset, add -UTC datetime field for each existing datetime field.
  • Add script to update previous JSON outputs.
@eenblam
Copy link
Owner Author

eenblam commented Aug 5, 2024

Job start/end times are now logged. Still need to handle timezone info for each jail.

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

1 participant