* Improve Cypress helper functions with log messages (#13749) [ci skip]

- Adds helpful log message to various helper functions in `frontend/test/__support__/cypress.js`.
    - `--- Logging in as ${user} ---` to `signIn()`
    - `--- Signing out ---` to `signOut()` and
    - `--- Restore Data Set ---` to `restore()`

* Disable video uploads for successful Cypress tests (#13747)

* https://docs.cypress.io/guides/references/configuration.html#Videos

* Add Cypress file download testing (#13430)

* Add `read-excel-file` library

* Add "file download" config to `cypress-plugins.js`

* Switch to SheetJS for xlsx/csv testing and upgrade Cypress because of https://github.com/cypress-io/cypress/pull/7382




Co-authored-by: Damon P. Cortesi <d.lifehacker@gmail.com>

* Quarantine `field.cy.spec.js` (#13896)

Full quarantine list in #13682.

* Fix smoke tests (#13897)

Failure happened because of the obsolete references to the now updated actions/drill-through popover menu.

* Add repro for `metabase-enterprise#154`

https://github.com/metabase/metabase-enterprise/issues/154

- Use UI trick instead of scrolling to get around virtualization

https://github.com/metabase/metabase-enterprise/issues/548

- Because this file was flaking so often, I'm also stress-testing it in GitHub CI. 
    - [20/20 passed](https://github.com/nemanjaglumac/metabase-tests/actions/runs/373434952) 
- Apart from flaking, this spec was actually wrong. More details in comments in #13852

* Add QA Mongo DB to the Cypress tests in CI

* Refactor tests

- Use API to add database
- group all query tests together

* Fix prettier error for bcd4a366

* Extract `addPostgresDatabase()` to a global Cypress helper function

* Add repro for #13571

* Refactor tests
- Use API to add database
- Extract query test into a separate file

This is to ensure that fields are dumped in ID order, which is necessary to ensure that parent fields are insert _before_ their children.

This issue was discovered while investigating a hosted instance for which snapshotting was failing. The failures were caused by the `fk_field_parent_ref_field_id` db constraint in Metabase being violated for a MongoDB database, indicating that child fields were being inserted before parent fields. This was confirmed experimentally, and being strict about the order of the field records were confirmed as the fix.

This isn't a common issue, because it only affects fields that can have parent fields, like in MongoDB.

* Enable enterprise cypress tests (#13756)

* Get auditing.cy.spec to pass

* Skip custom drill through tests until we replace them

* A few updates to the whitelabel test case:
- Move custom colors into constant variable to reference throughout
- remove some 'it' blocks we didn't need to speed up tests
- Remove a few 'wait's
- Restructure tests to be a bit more in line with best practices

* Update the snippet permissions test:
- Create test for just creating snippet as admin
- Create test for inability to create snippet as user by default
- Quarantine the user snippet creation test

* Rename sandboxes

* Replace legacy ENABLE_ENTERPRISE_EDITION env variable with MB_EDITION

* Add MB_EDITION env variable to Cypress test run

* Fix admin settings `auth` cypress test (#13841) [ci skip]

* Fix `snippet` Cypress test for CI (#13843)

- related: https://github.com/metabase/metabase-enterprise/issues/543



Co-authored-by: Nemanja Glumac <31325167+nemanjaglumac@users.noreply.github.com>

This reverts commit dc4d4de2.

keyed off of column names that include "update" which are date, time,
or datetime columns.

(Nested queries using metric got wrong SQL)

Co-authored-by: flamber <1447303+flamber@users.noreply.github.com>

(Not all columns of nested question available for Dashboard filter)
Co-authored-by: flamber <1447303+flamber@users.noreply.github.com>

`count` caused the lazy `objs` to be realized, causing the entire table
to be scanned. For tables with very high numbers of rows this stalls the
program and effectively eliminates the usefulness of chunking `objs`.

If the count is _really_ that big a deal, it can be determined, in
multiples of `chunk-size`, but counting the number of dots after the log
line, as printed by `insert-chunk!`.

* Restore before each test

* Extract repro steps for #13000 into a helper function

* Add repro for #13649

The bug was fixed in #13808 .

* fix scalar error when rendering null

* remove ".only" from test

* make check for null more explicit

* Refactors an original repro for #13000 to use API instead of "clicking" around UI.
* Shortens the time to run this test from an average of ~20s to a bit less than ~3s

(Filtering Custom Expression from aggregated result fails with column not found)

* Mega build script improvements 2

* Fix Circle

This reverts commit 23ccd0c3.

This reverts commit 3e1dab30.

* pass mb-edition to webpack build

* oops. pass "ee" rather than ":ee"

(Cannot choose granularity of dates on Summarize with Simple question from Saved Question)

[Fixes #7044] Render pulse bar charts with  negative values well

Also fixes misspelled column name in Avian Singles test dataset

* Bump DB prefixes so data gets reloaded to reflect col name change [ci drivers]

* Bump test DB version from v2 to v3

[ci drivers]

* More BigQuery test fixes 

 [ci drivers]

* Fix Snowflake [ci snowflake]

Co-authored-by: Cam Saul <github@camsaul.com>

(cherry picked from commit 4148885fd707b50750cefb339f994d7127dce702)

* Add a Postgres test [ci postgres]

* Mega-optimized SELECT probe query [ci drivers]

* Mega sync improvements [ci drivers]

* Even more amazing sync perf improvements [ci drivers]

* Fix bad edit [ci drivers]

* Test/lint fixes 

* Test fix  [ci drivers]

* Some driver fixes  [ci drivers]

* Address PR feedback [ci drivers]

* Test fixes for everything except for Oracle [ci drivers]

* Fix Oracle [ci drivers]

* Fix Redshift [ci redshift]

* Fix Pie chart visualization error when rows contain nils (#13626)

* Add positive assertion to CY test

* Fix prettier linter

* Quarantine the failing part of the "Pie chart" test

Co-authored-by: Nemanja <31325167+nemanjaglumac@users.noreply.github.com>

* Quarantine flaky tests (#13682) (#13683)

* Quarantine flaky tests (#13682)

* Add TODO note re: `describeWithToken`

Co-authored-by: Nemanja Glumac

* Add a circleci workflow that runs a set of Cypress smoketests (#12775)

* Add a circleci nightly workflow that runs a bigger set of Cypress smoketests

* Run this every hour while we're testing it, add a small fix to the admin test

* Smoketests: Skip some known failing tests

Co-authored-by: Ariya Hidayat <ariya@metabase.com>

* Narrow down the quarantine for chart_drill spec (#13682) (#13699)

* CI: Fix the cache key for uberjar for running smoketest (#13698)

Smoketest for OSS edition (for now)

* Fix `settings/settings.cy.spec.js` flakes (#13701)

- isolated flake (`it.only("should surface an error when validation for any field fails (metabase#4506)", () => {...})`) passed 10x (https://github.com/nemanjaglumac/metabase-tests/actions/runs/348275781)
- the whole spec passed 20x (https://github.com/nemanjaglumac/metabase-tests/actions/runs/348306177)

* CI: Update uberjar oss key for smoketest (#13704)

* Fix Cypress flakes in `dashboard/dashboard.cy.spec.js` file (#13703)

* Fix flakes in `revisions screen` block

* Improve test assertions (there were some rendering problems, so I adjusted the assertions)

* Narrow down the quarantine for dash_drill spec (#13682) (#13706)

* Fix `metrics.cy.spec.js` flakes (#13709)

* Fix `metrics.cy.spec.js` flakes (#13682)

* Refactor the test using API

* Smoketest: run nightly at 1am PST (#13711)

1 am PST = 09:00 UTC

CircleCI cron is for UTC:
https://circleci.com/docs/2.0/workflows/#scheduling-a-workflow

* Upgrade Cypress to v5.5.0 (#13674)

* Upgrade Cypress to v5.5.0

* Needed to unset the `DISPLAY` ENV through `config.yml` to finally make this work! (Reference: https://github.com/cypress-io/cypress/issues/4034#issuecomment-486773042

)

* Improve `segments` tests with the use of API (#13718)

* Unquarantine `scenarios/pulse/pulse.cy.spec.js` (#13727)

* Unset `DISPLAY` ENV in smoketests CI group (#13732)

* Unquarantine ee `custom_drill_through/drill_through.cy.spec.js` [ci skip] (#13734)

* Unquarantine `question/nested.cy.spec.js` (#13733)

Co-authored-by: Ariya Hidayat <ariya@metabase.com>
Co-authored-by: Damon P. Cortesi <d.lifehacker@gmail.com>

* Fix formatting temporal values as day of week with custom day of week (#13604)

* Pretty

* PR feedback

* Need to update when user locale changes as well

* Update Moment start of week in i18n.js instead

* Make it nice

* Remove some unneeded stuff