Add historical event data back to 2021

Bring in historical event data from the current site, along with some documentation and a script for working with data from the production site.

Things left to do:

[x] Add updated_at timestamps to events
[x] Provide a way to go "back in time" on the event list page (probably via query string arg)
[x] Limit # of events fetched and rendered on event list page
[x] Limit events included in sitemap.xml

Interesting things in here

doc/migration/README.md describes the legacy database situation, and doc/migration/export-data.sh can export a viable CSV of event data using docker + mysql + sed (this could be extended in the future to export other interesting data)
rake import_events can process the above mentioned CSV to generate markdown files
The querystring arg ?from=yyyy-mm-dd can be used to go "back in time" on the event listing page to see what the page would look like with historical event data
There's about a million markdown files for events. I tried to keep those events in a single commit to make it possible to review this thing. Kramdown did a pretty good job of converting HTML back into Markdown. It's not perfect--there's still cruft from pasting from Microsoft Word and stuff, but all in all serviceable I think as a historical archive.

Pa11y Failures detected

Show failure message

``` yarn run v1.22.18 $ /home/runner/work/nih-oite-experiments/nih-oite-experiments/node_modules/.bin/pa11y-ci Running Pa11y on 5 URLs: > http://localhost:3000/ - 0 errors > http://localhost:3000/events - 0 errors > http://localhost:3000/events/202257-training-event - 1 errors > http://localhost:3000/public-page - 0 errors > http://localhost:3000/404 - 0 errors Errors in http://localhost:3000/events/202257-training-event: • element must have a lang attribute (https://dequeuniversity.com/rules/axe/4.4/html-has-lang?application=axeAPI) (html) We're sorry, bu...</html> ✘ 4/5 URLs passed error Command failed with exit code 2. info Visit https://yarnpkg.com/en/docs/cli/run for documentation about this command. ``` </details> </div> </div> <div class="comment"> <div class="user"> <a rel="noreferrer nofollow" target="_blank" href="https://github.com/github-actions[bot]"><img src="https://avatars.githubusercontent.com/in/15368?v=4" />github-actions[bot]</a> commented <strong> 2 years ago</strong> </div> <div class="markdown-body"> <p>Pa11y Failures detected</p> <details><summary>Show failure message</summary> ``` yarn run v1.22.18 $ /home/runner/work/nih-oite-experiments/nih-oite-experiments/node_modules/.bin/pa11y-ci Running Pa11y on 5 URLs: > http://localhost:3000/ - 0 errors > http://localhost:3000/events - 0 errors > http://localhost:3000/events/202257-training-event - 1 errors > http://localhost:3000/public-page - 0 errors > http://localhost:3000/404 - 0 errors Errors in http://localhost:3000/events/202257-training-event: • <html> element must have a lang attribute (https://dequeuniversity.com/rules/axe/4.4/html-has-lang?application=axeAPI) (html) <html><head> <title>We're sorry, bu...</html> ✘ 4/5 URLs passed error Command failed with exit code 2. info Visit https://yarnpkg.com/en/docs/cli/run for documentation about this command. ``` </details> </div> </div> <div class="page-bar-simple"> </div> <div class="footer"> <ul class="body"> <li>© <script> document.write(new Date().getFullYear()) </script> Githubissues.</li> <li>Githubissues is a development platform for aggregating issues.</li> </ul> </div> <script src="https://cdn.jsdelivr.net/npm/jquery@3.5.1/dist/jquery.min.js"></script> <script src="/githubissues/assets/js.js"></script> <script src="/githubissues/assets/markdown.js"></script> <script src="https://cdn.jsdelivr.net/gh/highlightjs/cdn-release@11.4.0/build/highlight.min.js"></script> <script src="https://cdn.jsdelivr.net/gh/highlightjs/cdn-release@11.4.0/build/languages/go.min.js"></script> <script> hljs.highlightAll(); </script> </body> </html>

18F / nih-oite-experiments

Add historical event data back to 2021 #51

Interesting things in here