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.

Sign up for GitHub

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

Jump to bottom

Add VTEC table storage of UGC expiration timestamp #616

Closed
3 tasks done
akrherz opened this issue Jun 15, 2022 · 1 comment
Closed
3 tasks done

Add VTEC table storage of UGC expiration timestamp #616

akrherz opened this issue Jun 15, 2022 · 1 comment
Assignees
@akrherz
Labels
enhancement

Comments

@akrherz
Copy link
Owner

akrherz commented Jun 15, 2022 •
edited
Loading

Presently, the VTEC ingest does not track the expiration time found within the UGC encoding. The parser does process this timestamp, but does not store it to the database. An interesting usage case came up with this timestamp perhaps flagging when a product update is due by. It would certainly be useful to then track this.

  • Add database storage
  • Write/Update value to the database on save
  • backfill this value
@akrherz akrherz self-assigned this Jun 15, 2022
akrherz added a commit to akrherz/iem-database that referenced this issue Jun 15, 2022
@akrherz
add purge_time database storage
9d0a9c8 
refs akrherz/pyIEM#616
@akrherz akrherz mentioned this issue Jun 15, 2022
Merged
akrherz added a commit that referenced this issue Jun 15, 2022
@akrherz
add database storage of VTEC purge_time
222f28d 
refs #616
@akrherz akrherz mentioned this issue Jun 15, 2022
Merged
akrherz added a commit to akrherz/DEV that referenced this issue Jun 15, 2022
@akrherz
reprocess for purge_time
083247a 
see akrherz/pyIEM#616
akrherz added a commit to akrherz/iem that referenced this issue Jun 15, 2022
@akrherz
add purge_time
0073a0d 
refs akrherz/pyIEM#616
@akrherz
Copy link
Owner Author

akrherz commented Sep 15, 2022

Reviewed the backfilling and is generally complete.

@akrherz akrherz closed this as completed Sep 15, 2022
@akrherz akrherz mentioned this issue Feb 27, 2024
Closed
akrherz added a commit to akrherz/iem-web-services that referenced this issue Feb 27, 2024
@akrherz
feat: add product_expires to events_status
53bf59c 
refs akrherz/pyIEM#616
@akrherz akrherz mentioned this issue Feb 27, 2024
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@akrherz akrherz

Labels
enhancement
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@akrherz