feat(dashboard): Move dashboard auto refresh intervals options to config

[zhaorui2022]

SUMMARY

The original dashboard auto-fresh intervals were hard-coded. However, based on the back-end query engine architecture, some options might not work. Move these options to config file so that they can be customized.

BEFORE/AFTER SCREENSHOTS OR ANIMATED GIF

With default option, there is no change on the UI. Tested with customized options in config file.

Google.Chrome.-.COVID.Vaccine.Dashboard.-.2022-10-24.at.2.44.22.PM.mp4

Also verified the auto refresh function is still working as expected.

TESTING INSTRUCTIONS

If testing with original options, no change is needed. Otherwise, change the options in the config file. Run docker-compose up and then view auto refresh options in any dashboard.

ADDITIONAL INFORMATION

• Has associated issue:
• Required feature flags:
• Changes UI
• Includes DB Migration (follow approval process in SIP-59)
  • Migration is atomic, supports rollback & is backwards-compatible
  • Confirm DB migration upgrade and downgrade tested
  • Runtime estimates and downtime expectations provided
• Introduces new feature or API
• Removes existing feature or API

[codecov]

Codecov Report

Merging #21924 (d85c162) into master (f41d0b0) will decrease coverage by 11.40%.
The diff coverage is 61.22%.

❗ Current head d85c162 differs from pull request most recent head 5eda9c5. Consider uploading reports for the commit 5eda9c5 to get more accurate results

@@             Coverage Diff             @@
##           master   #21924       +/-   ##
===========================================
- Coverage   66.82%   55.42%   -11.41%     
===========================================
  Files        1805     1807        +2     
  Lines       69070    69197      +127     
  Branches     7373     7402       +29     
===========================================
- Hits        46159    38354     -7805     
- Misses      21005    28932     +7927     
- Partials     1906     1911        +5     

Flag	Coverage Δ
mysql	?
postgres	?
presto	52.83% <64.10%> (+<0.01%)	⬆️
python	57.61% <71.79%> (-23.66%)	⬇️
sqlite	?
unit	51.08% <58.97%> (+0.02%)	⬆️

Flags with carried forward coverage won't be shown. Click here to find out more.

Impacted Files	Coverage Δ
...-chart-controls/src/sections/advancedAnalytics.tsx	14.28% <ø> (ø)
...t-controls/src/sections/echartsTimeSeriesQuery.tsx	33.33% <ø> (ø)
...i-chart-controls/src/sections/forecastInterval.tsx	100.00% <ø> (ø)
.../packages/superset-ui-core/src/chart/types/Base.ts	100.00% <ø> (ø)
...s/superset-ui-core/src/components/SafeMarkdown.tsx	66.66% <ø> (ø)
...d/packages/superset-ui-core/src/query/constants.ts	100.00% <ø> (ø)
...uperset-ui-core/src/query/types/AnnotationLayer.ts	100.00% <ø> (ø)
...ackages/superset-ui-core/src/query/types/Column.ts	100.00% <ø> (ø)
...ackages/superset-ui-core/src/utils/featureFlags.ts	100.00% <ø> (ø)
...d/packages/superset-ui-core/src/utils/isDefined.ts	100.00% <ø> (ø)
... and 432 more

📣 We’re building smart automated test selection to slash your CI/CD build times. Learn more

[bkyryliuk]

Good work and looks like it is aligned with a general frontend config approach e.g. https://github.com/apache/superset/search?q=DASHBOARD_AUTO_REFRESH_MODE

[michael-s-molina]

/testenv up

[github-actions]

@michael-s-molina Ephemeral environment spinning up at http://54.244.1.135:8080. Credentials are admin/admin. Please allow several minutes for bootstrapping and startup.

[michael-s-molina]

LGTM. Thanks for the improvements and for addressing the comments @zhaorui2022

[github-actions]

Ephemeral environment shutdown and build artifacts deleted.