Druid select queries don't allow setting of a timezone. This commit
will parse the timestamps coming out of Druid and reformat them using
the user's report timezone or system timezone. This allows Druid
select queries to have similar timezone semantics to other supported
databases.

Fixes #3690

This utility function temporarily changes the JVM's timezone to
something different and puts it back after the body of the form is
invoked. Moving it to metabase.test.util so other tests can use it.

The pre-update function was returning nil for their values which was
then getting stored. This commit does not switch
REPORT_CARD.DATABASE_ID to NOT NULL, that's written up as #5999.

Fixes #5998

Redshift JDBC connection URLs can be writtend with the postgresql
subprotocol or the redshift protocol. This can cause problems as the
DriverManager (depending on how the classes have been loaded) will be
the first matching driver for a subprotocol. We could get the Redshift
driver when we were intending to get the PostgreSQL driver. Adding
this flag will ensure that we don't inadvertantly get the Redshift
driver when we intended to get PostgreSQL driver.

Calling metabase.test.data/id with no args ensured the db was created,
I added that same check to the other arities of the id method.

There's a def of a data structure that contains a data/id call. This
can be a problem if the database hasn't been initialized yet. This
commit wraps it in a thunk to ensure it happens when the test run, not
when the code is compiled.

These test just execise some of the scalar pulse rendering code to
ensure the cell is formatted correctly (dates, integers, floats etc)

The timestamp field was getting added after the results were returned
and not getting added to the list of expected projections. This commit
adds that which causes the bucketed fields to be returned correctly.

Fixes #5933

The problem appears to be reusing a connection with a timezone set for
that session from a previous test that was ran. The report timezone is
not specified, but the timezone is set on the session from a previous
run. This results in the timestamps being return as UTC, but shifted
back 7 hours (as if it were pacific time).

This commit just specified a report-timezone of UTC to avoid that issue.

Previously the binning feature was checked and binning options were
only showed when the database supported binning. This is the correct
behavior for numeric fields, but not dates. This commit ensures that
databases like Druid still support date binning.

Fixes #5932

Things like Java version, operating system, max memory etc.

They have a base_type of numeric but a special type of DateTime. This
adds the check for special type when associating dimension options to
a field.

Fixes #5876

The problem appears to be reusing a connection with a timezone set for
that session from a previous test that was ran. The report timezone is
not specified, but the timezone is set on the session from a previous
run. This results in the timestamps being return as UTC, but shifted
back 7 hours (as if it were pacific time).

This commit just specified a report-timezone of UTC to avoid that issue.

Since Version >= 2.0 CrateDB supports Host-Based-Authentication which
is enabled by default. It requires a user to trust the authentication.
User `crate` is the default superuser.

This commit wraps the timezone detections stuff in some try/catches so
that if there's an issue parsing one of the timestamps from the
database, it doesn't cause the whole sync process to fail.

If a failure happens, it's logged as a warning, the timezone field in
the database is not updated and the sync process proceeds.

Fixes #5869

Previously pulses were always rendered with UTC time, this commit
changes that to use the report timezone (if available and applicable)
otherwise the JVM timezone (similar to how query results are
returned).

Fixes #3109

* Add :largest-contributors to comparison, bug fixes, refactoring

* Add valid-pairs and field endpoints to comparisons

* Dampen field difference weight in contribution assesment

* fix nice-bins for empty histogram

* fix for nice-bins for histogram with only 1 value

* Change comparison field zoom in. Rename largest-contributor to top-contributor

* fix halfassed rename

* refactor + new components

* use true multiseries

* cleanup

* include constituents in card

* add dataset to card return

* card wip

* growth rate

* check for values

* lint

* cardify all series features. Unpack linear regression

* add linear regression

* use percentages

* flip order

* add growth series description

* add additional info

* fix layout

* layout tweaks

* add action in qb

* show growth series as a %

* xray segment action

* flow

* Support all time breakdowns, fix filtering bug

* make linter happy

* more robust test

* Add conditional descriptions for growth-series. Update tests.

* add periodicity to cards

* Update for updated distance measure

* Removed updates to comparison as they should not be part of PR

* Correct chi^2 distance

* fix headings

* fix flow

* disable flow for action

* use beaker for xray actions

* move specs to proper test directory

* Fix round-to-month when crossing year

* add key

* Add smoke tests for table xray and segment xray pages

* Correctly handle unixtimestamps encoded as bigints

* Add test cases for question xray page and segment xray query builder action

* Test also timeseries question action widget action

* Fix lint errors for xray tests

* Fix Histogram element passing data in invalid format to Visualization

* Fix integration tests for xrays

* Make xrays urls in services.js consistent with other urls

* fix periodicty reweighing

* add sample? predicate

* cleanup

* spacing

* cleanup

* fix failing tests

* fix failing tests

* Update tests

* Refactored periodicity reweighing, more tests

* Support :as in date-time fields, more tests, fix another periodicity bug

* add error handling

* add missing label

* tweak fidelity icon size

* fix histograms

* more specific legend hiding

* hide link for now

* card xray title

* fix field header

* fix stat group padding

* card error handling

* remove duplicated code

Field values and human readable values are zipped together to support
remapping. If the field values change (i.e. new values, removing
values etc) then the pairings of those field values and their remapped
values can be wrong. This commit adds some code to reconcile that. If
a new field value is found, a stringified version of that field value
is used as the human readable version (the user can update/change this
later).

Fixes #5782

Similar to the exceptions needed for SQLServer and H2 when changing
JVM timezones, Mongo is also sensitive to this, so the tests should be
run on Mongo.

Redshift doesn't handle changing the JVMs timezone to something
different than what the database's timezone is (similar to
SQLServer). This adds that to the list so we don't try and run the JVM
timezone changing tests against it.

* Add :largest-contributors to comparison, bug fixes, refactoring

* Add valid-pairs and field endpoints to comparisons

* Dampen field difference weight in contribution assesment

* fix nice-bins for empty histogram

* fix for nice-bins for histogram with only 1 value

* Change comparison field zoom in. Rename largest-contributor to top-contributor

* fix halfassed rename

* refactor + new components

* use true multiseries

* cleanup

* include constituents in card

* add dataset to card return

* card wip

* growth rate

* check for values

* lint

* cardify all series features. Unpack linear regression

* add linear regression

* use percentages

* flip order

* add growth series description

* add additional info

* fix layout

* layout tweaks

* add action in qb

* show growth series as a %

* xray segment action

* flow

* Support all time breakdowns, fix filtering bug

* make linter happy

* more robust test

* Add conditional descriptions for growth-series. Update tests.

* add periodicity to cards

* Update for updated distance measure

* Removed updates to comparison as they should not be part of PR

* Correct chi^2 distance

* fix headings

* fix flow

* disable flow for action

* use beaker for xray actions

* move specs to proper test directory

* Fix round-to-month when crossing year

* add key

* Add smoke tests for table xray and segment xray pages

* Correctly handle unixtimestamps encoded as bigints

* Add test cases for question xray page and segment xray query builder action

* Test also timeseries question action widget action

* Fix lint errors for xray tests

* Fix Histogram element passing data in invalid format to Visualization

* Fix integration tests for xrays

* Make xrays urls in services.js consistent with other urls

* fix periodicty reweighing

* cleanup

* spacing

* cleanup

* fix failing tests