enso/test/Microsoft_Tests
AdRiley 7327df88c3
Complete migration to Dialect/Feature flags + SQLServer support for Datetime (#11527)
* Supports_Sort_Digits_As_Numbers

* case_insensitive_ordering

* Case_Insensitive_Ordering

* Case_Insensitive_Ordering

* Enable tests

* Case_Insensitive_Non_Ascii

* Order_By_Unicode_Normalization_By_Default

* Allows_Mixed_Type_Comparisons

* Supports_Unicode_Normalization

* NaN_Non_Comparable

* Distinct_Returns_First_Row_From_Group_If_Ordered

* Datetime support

* refactor

* refactor

* Refactor

* Move remaining flags

* Cleanup

* sbt javafmtAll

* Fix

* Fix tests

* Code review changes

* More date_diff month tests

* Fix sowflake

* Fix snowflake tests

Bypassing failing test.
2024-11-20 10:41:49 +00:00
..
data/datalinks Save Database connection as data link, SQL Server data link support (#11343) 2024-10-17 09:06:57 +00:00
src Complete migration to Dialect/Feature flags + SQLServer support for Datetime (#11527) 2024-11-20 10:41:49 +00:00
package.yaml Add Initial SQL Server support (#10624) 2024-07-30 11:13:08 +01:00
README.md Make sqlserver temp tables work (#10781) 2024-08-09 13:06:16 +03:00

This is a set of tests for the Microsoft integration for Enso.

Testing Microsoft SQL Server

To run the tests, you need to prepare credentials for a Microsoft SQL Server instance that can be used to run them on.

Please set the following environment variables:

  • 'ENSO_SQLSERVER_HOST' - the name of the server hosting SQLServer,
  • 'ENSO_SQLSERVER_PORT' - the port SQLServer is on,
  • 'ENSO_SQLSERVER_USER' - the user name to use to connect,
  • 'ENSO_SQLSERVER_PASSWORD' - the pasword for that user,
  • 'ENSO_SQLSERVER_DATABASE' - the database on the SQLServer to use.

Docker

The easiest way to test locally is to use a docker image

docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=<YourStrong@Passw0rd>" -p 1433:1433 --name sql1 --hostname sql1 -d mcr.microsoft.com/mssql/server:2022-latest

Set ENSO_SQLSERVER_DATABASE to tempdb and the defaults will work for everything else. (The user is sa with the above password)

$env:ENSO_SQLSERVER_DATABASE='tempdb'