Run trial of upstream OSEM

[AndrewKvalheim]

In SeaGL:trial:

Resolve outstanding upstream issues

• Explicitly configure database authentication in Docker Compose #2640
• Use version range instead of OSEM_RUBY_VERSION. #2646
  • Update Ruby dependency: 2.5.8 → 2.5.9 (patch) #2772
• Install missing test dependency in base image #2647
• Resolve conflict between WebMock and Webdrivers #2648
• Work around ChromeDriver/Chromium crash #2649
• Decouple tests from unspecified data ordering #2650, #2652
• Fix access to the version history of organization-level roles #2654
• Ignore schema.rb in RuboCop #2655
• Fix bug in UserDatatable query affecting PostgreSQL #2656
• Remove superfluous click to display Markdown editor #2657
• Fix bug in logging of screenshots of failed tests #2658
• Use Rails transactional tests #2659
• Various inconsistencies in time zone handling (needs review)
• Various bugs in client-side scripts (needs review)
• Fix bug in test of animated form #2662
• Update Docker Compose file format: 2.0 → 2.4 (minor) #2663
• Annotate past migrations with Rails version #2665
• Fix migration that fails on conferences without pictures #2666
• Work around bug in migrations to non-null columns #2667
• Serve precompiled assets in example Docker Compose configuration #2673
• Stabilize Docker base image #2697
• Allow leaving OSEM_SMTP_DOMAIN unset #2702
• Remove race condition in test of splash page versioning #2703
  • Restore test of splashpage revision history #2967
• Correct base image in production Dockerfile #2773
• Add missing dependencies to production Docker image #2774
• Exclude additional files from Docker images #2775
• Correct test that risked false positives #2776
• Use be_successful instead of be_success #2912
• Update venue country name for Countries 4.2 #2962
• Update UserDatatable for ajax-datatables-rails 1 #2963
• Update tests of splashpage forms #2964
• Fix bug in which role assignments aren’t tracked in version history #2965
• Basic feature test of survey creation and response #2969
• Confusion with "complete your proposal" #1544

Audit upstream migrations

Will the migration correctly handle our existing data?

• 2016-06-27 Create surveys 20160627122446
• 2016-06-28 Create survey questions 20160628093634
• 2016-06-29 Add target to surveys 20160629145954
• 2016-06-30 Create survey replies 20160630094850
• 2016-06-30 Create survey submissions 20160630130731
• 2016-12-29 Add comments count to events 20161229080315
• 2017-01-08 Add default to revision in conference 20170108053041
• 2017-02-12 Add enabled to event schedules 20170212145523
• 2017-05-16 Create booths 20170516190048
• 2017-05-30 Add type to cfps 20170530072155
• 2017-05-30 Create booth requests 20170530112510
• 2017-06-03 Create physical tickets 20170603095900
• 2017-06-29 Add short name to tracks 20170629162450
• 2017-06-29 Add ticket layout to conferences 20170629232817
• 2017-07-05 Add state cfp active and submitter reference to tracks 20170705075039
• 2017-07-11 Create ticket scannings 20170711102511
• 2017-07-12 Add room and dates to tracks 20170712120556
• 2017-07-15 Make track state not null and add default value 20170715131706
  • Work around bug in migrations to non-null columns openSUSE/osem#2667
• 2017-07-20 Make track cfp active not null 20170720134353
  • Work around bug in migrations to non-null columns openSUSE/osem#2667
• 2017-07-21 Add index to physical tickets 20170721001700
• 2017-07-21 Add custom domain to conferences 20170721184810
• 2017-07-26 Add relevance to tracks 20170726065629
• 2017-07-27 Add include booths to splashpages 20170727081731
• 2017-07-28 Add booth limit to conferences 20170728182033
• 2017-07-31 Add booths to email settings 20170731161207
• 2017-08-07 Add registration ticket to tickets 20170807092805
• 2017-08-09 Add track reference to schedule 20170809120927
• 2017-08-14 Add selected schedule to tracks 20170814174637
• 2017-09-05 Add description to cfps 20170905110034
• 2017-09-24 Add amount paid to ticket purchases 20170924190528
• 2017-11-18 Change visit id type of ahoy events to integer 20171118113113
• 2017-11-30 Rebuild conference pictures 20171130172334
  • Fix migration that fails on conferences without pictures openSUSE/osem#2666
• 2017-12-01 Add mastodon to contact 20171201163628
• 2018-02-26 Add created at and updated at to event types 20180226032958
• 2018-03-12 Create ahoy visits and events 20180312100045
• 2018-03-13 Add timestamps to tickets 20180313012253
• 2018-03-16 Add code of conduct to organization 20180316185150
• 2018-03-16 Add accepted code of conduct to registrations 20180316220446
• 2018-08-22 Add submitted proposal attributes in email settings 20180822125509
• 2018-09-24 User email public defaults to false 20180924221715
• 2018-10-09 Drop ahoy events 20181009000259
• 2018-10-17 Add allow reservations on cfps 20181017183243
• 2018-11-13 Add youtube and blog to contacts 20181113195810
• 2018-12-29 Remove arrival departure from registrations 20181229233811
• 2020-03-31 Add organization to versions 20200331214534
  • Fix access to the version history of organization-level roles openSUSE/osem#2654

Review local migrations

Is the migration accounted for and its data represented by an upstream feature?

• 2016-05-01 Add show by default to splashpage 20160501201606
  • Rolled back, feature replaced by Allow root URL to redirect to a conference via ENV var. openSUSE/osem#1994
• 2016-05-08 Add banner to splashpage 20160508201501
  • Rolled back, feature dropped
• 2016-05-12 Add banner attribution to splashpage 20160512035046
  • Rolled back, feature dropped
• 2017-06-13 Add diversity to events 20170613224853
  • Converted to surveys 20220312000831
• 2017-06-14 Add first time to events 20170614025428
  • Converted to surveys 20220312000831
• 2018-05-22 Add speaker proposal requirements to programs 20180522011758
  • Confusion with "complete your proposal" openSUSE/osem#1544
• 2020-07-10 Add pnw to events 20200710065434
  • Converted to surveys 20220312000831

Review local commits

Are the needs that led to the commit met upstream?

• 2016-05-07 add config files from server to repo ea439e9a
• 2016-05-07 remove example configs and add database and secrets config f1a1d136
  • 2016-05-07 fix missing brackets in secrets.yml 6d674314
• 2016-05-07 move devise secret key from secrets.yml to devise init file 2a141268
• 2016-05-07 remove devise secret 199eb458
• 2016-05-07 adapt deploy.rb 0d272b38
• 2016-05-07 create tmp shared directory in deploy task f426db2d
• 2016-05-07 change production log level to debug 093110d7
• 2016-05-08 fix public/system directory not created in deploy config 40f95904
• 2016-05-08 refactor smtp config c0a17c59
  • 2020-11-01 Revert "refactor smtp config" 38cd82ca
• 2016-05-08 set mailer default from address and force ssl 7d9d6e85
• 2016-05-08 update mailer default from address 2e65971d
• 2016-05-01 add option to splashpage for it to be shown by default when viewing the conferences index 985ee40b
  • 2016-05-01 add option to splashpage for it to be shown by default when viewing the conferences index 0bd4d42d
  • Allow root URL to redirect to a conference via ENV var. openSUSE/osem#1994
• 2016-05-08 set the navigation background color to the conference color on the splashpage a7ef9a78
• 2016-05-08 add banner image field to splashpages d95b82ca
  • 2016-05-08 add banner image field to splashpages 95622106
  • 2016-05-11 add banner attribution field to footer 7ec4b6b4
  • 2016-05-11 add label to banner field on spalshpage edit form 47928641
• 2016-06-28 change smtp relay to gmail dc309548
• 2016-07-06 re-add rvm use task to deploy config 07327405
• 2016-07-06 remove config/database.yml from shared paths in deploy config 91b33b5e
• 2016-08-18 add delayed job workoff to schedule f2dbbfad
• 2016-09-03 check for possible nil event ratings 3b3d6515
  • 2016-09-03 Revert "check for possible nil event ratings" ad625c88
• 2016-09-18 remove speaker email and blank info items from proposal show page 786a7132
  • 2019-10-11 delete line that displays speaker email a0da8886
  • 2019-10-11 fixed incorrect haml commenting syntax 82210aba
  • Fix to only show speaker email if it's public openSUSE/osem#1790
• 2016-09-19 sort rooms by name on schedule page and adjust schedule end time bf3be566
  • Order rooms by name in the schedule openSUSE/osem#2913
• 2016-09-28 reduce font size of speaker biography on proposal show page 940d1441
• 2016-11-10 adjust schedule end time fd652cf7
  • Make the schedule times changeable openSUSE/osem#1143
• 2017-06-05 Note that DB needs an initial deployment before starting server 8e1d9fca
• 2017-06-05 Update subsequent list numbers bb42576e
• 2017-06-13 Add diversity checkbox 213c7987, Add 'first time speaking' checkbox to proposal form 951f9e57
  • 2018-05-23 Permit diversity param 1e4a60df
  • 2018-05-25 Permit first_time param f06b0c25
  • 2017-07-25 This adds in the donut graphs for first-time and diversity numbers e7192150
  • 2018-05-23 Query for diversity stats as boolean 659e12e9
  • 2018-05-25 Query for first time stats as boolean 0c336e55
  • 2020-07-10 Allow editing of diversity & first-time responses a1ef411d
  • 2020-07-10 Add PNW checkbox to event proposal form a99c9353
  • Surveys during proposal submission openSUSE/osem#3058
• 2017-06-17 Update deployment for mira 1.0 11c02be2
  • 2020-09-29 Revert "Update deployment for mira 1.0" 4e15c6f4
• 2017-06-17 mira is not finding ruby right for the jobs, hardcode for testing 9aeeb73b
• 2017-06-17 Try bundle exec ead7993a
• 2017-06-17 Force success 84acd254
• 2017-06-17 Disable starting delayed_jobs 7263e2a9
• 2017-06-17 Fix syntax on markdown hint c98c2d46
• 2017-08-14 Disable the comment notification emails for now a09eb20c
  • Setting to disable email notifications of comments openSUSE/osem#3059
• 2017-12-23 Add in a js engine for uglifier d7de0a09
• 2017-12-23 Update gemfile.lock 2630cbc1
• 2017-12-23 WIP to deploy to EC2/RDS 1227a194
• 2018-05-05 WIP to deploy to EC2/RDS ead64295
• 2018-05-05 Update vagrant file 16ea63a2
• 2018-05-05 update bootstrap fd03ca14
• 2018-05-24 Add extra toggles for speaker reminders to CFP settings c7ca33a8
  • 2018-05-24 Only ask speakers to do what the CFP settings ask for aa830196
  • 2018-06-02 refactor admin CFPs show page a little bit to be more readable 6b36d3af
  • 2021-06-13 Fix bug preventing the creation of CFPs d44be857
  • 2021-06-13 Fix bug preventing the display of CFP options d613080d
  • Confusion with "complete your proposal" openSUSE/osem#1544
• 2020-07-10 Use Docker Compose instead of Vagrant e50ecbbb
• 2020-07-10 Update deployment configuration 42609fdd
• 2020-07-10 Fix bug in Docker Compose configuration 997dc3a7
• 2020-07-10 Update RSpec 732e9961
• 2020-08-05 Update edit.html.haml 8fb4ca13
  • 2020-08-08 Revert "Update edit.html.haml" fd2cb24d
  • 2020-08-08 After registration, show home page instead of account edit screen. 9340939b
• 2020-08-10 Add CFP Respondents metric to conference dashboard 8ceabe92
• 2020-09-30 Use systemd in deploy script f3259b30
• 2020-09-30 Manage Delayed::Job via systemd 48435553
• 2020-10-31 Correct development documentation 7a8d47af
• 2020-10-31 Update dependencies with failing native extensions 9336d0dd
• 2020-11-01 Configure RuboCop for supported Ruby version 304da8f2
• 2020-11-01 Remove hard-coded email configuration af45e6ff
• 2020-11-02 Omit nil SMTP settings 37713ca5
  • Allow leaving OSEM_SMTP_DOMAIN unset openSUSE/osem#2702
• 2020-11-02 Begin API v2 using existing JSON:API capability efc0d3c8
  • 2020-11-01 Configure the default origin for absolute URLs 4f36cd21
  • 2020-10-31 Update ActiveModelSerializers and namespace API v1 serializers 5dadb162
  • 2020-11-03 Fix bug in API v2 time zones 0b50b997
  • 2020-11-12 Add permissive CORS policy to v2 API 86a03a3e
• 2021-06-12 Update mimemagic e0c5646b
  • Update mimemagic openSUSE/osem#2745

[AndrewKvalheim]

We’ve deemed this complete enough and have migrated to a transitional fork, leaving the outstanding items to be resolved separately as needed.