* pthon installation
* configure python for MLS
* add python client install and tests
* add env variable passwords
* add some doc links use most recent python install version
* whitspace/format
* add logging for python installation
* add passive for python install
* try remove previous python installs
* using python-setup
* new strategy for Python installation
* use github native python path
* add explicit user and pw
* add explicit user and pw
* add explicit user and pw
* add explicit user and pw
* add explicit user and pw
* update some names continueOnError
* sqlserver19 install
* format
* format
* format
* format
* format
* try curl instead of wget
* try without cab files
* enable external script
* add env variables
* hard code values
* change connect string
* change connect string
* change connect string
* separate sql server 19 into base and CU
* separate sql server 19 into base and CU
* separate sql server 19 into base and CU
* format
* try to install from setup.exe
* sql19 vanilla install with params
* curl cab files and use MRCACHEDIRECTORY param
* formatting
* use C: for cabinet files
* use cwd for cab files
* format
* format
* use currentdir for cache
* use currentdir for cache
* format
* checking if known good yaml has internal server error
* format
* format
* format
* use redirect for curl
* save choco logs as artifact
* format
* run always the log artifact step
* use SA account and set to random password
* use random password to connect to SA:
* use github syntax for setting env variable
* format
* use cmd for pw generation
* pw generated now so log errors
* use sql security mode
* add letters and special char to pw
* add letters and special char to pw
* add letters and special char to pw
* enable TCP
* localhost for connection string
* format on Enable External Scripts
* add R tasks
* get files after checkout
* get files after checkout
* try backup
* remove go
* checking syntax
* add python to job
* remove matrix
* proper naming
* move logs to after CU update which is failing now
* typo in enable external script
* format
* use explicit python version
* SPEES execute for R and Python
* missing R dependencies so dont check R
* format
* format
* format
* move SPEES task
* reconfigure in own command
* missing params
* accept license terms missing
* python spees script format
* change name to deconflict for PR
* revert ci.yaml
* whitespace
* whitespace
* address comments
* log name
* continue on error
* try not to display pw in output
* fix log name
* try save good password without printing
* try save password without displaying
* try save password without displaying
* try save password without displaying
* continue on error
* change name to be more descriptive
* change name to be more descriptive
* better name
* change name in pipeline
* change name
* make name legal
* make name legal
* add users and logins and env vars for them
* newline
* remove newline
* sql server install, airlines DB restore
* update commands remove CU
* change ci.yaml to run workflow in GHA
* add R installation for MLS
* add airline db users and permissions
* typo
* use correct DB
* typo
* typo
* revert ci.yaml move to SQL2022.yml
* just R for this PR
* name from 19 to 22
* change name in pipeline
* make name legal
* make name legal
* change cran address, add env variables for users
* change how we get dbpassword
* change env variable used for airline users
* use correct name for env vars
* add Rtools to package install
* add additional package installs
* escape char
* explicit libs in package install, remove duplicate and rtools
* try install rtools
* address comments
* sql server install, airlines DB restore
* update commands remove CU
* change ci.yaml to run workflow in GHA
* add R installation for MLS
* add airline db users and permissions
* typo
* use correct DB
* typo
* typo
* revert ci.yaml move to SQL2022.yml
* just R for this PR
* name from 19 to 22
* fix cran link
* update package assertive.base to abc.data to fulfill test requirements of having special character in name and no/minimal dependencies. Assertive.base is no longer on cran.
* remove yaml as unrelated to pr. add newline per github warning
* Fix filepath parsing and break large function into smaller chunks for easier testing and readability
* add unit tests for file parsing function and file existence function
* Add return statement so package list is populated
* GH runner pool support
with fixed tests.
* skip slow python test
remove legacy TravisCI skip tags.
* Fix R coercion to logical 1 error
* add sql MI
* update spacing.
* reduce code duplication and remove erroneous space
that caused issues
* remove conditional
* consolidate code and add conditional
* remove continue on error.
* Concise step title.
* fix R version
* Updated test packages due to
legacy package errors.
* Support for special character
connection string pwds
* Updated test_no_output composition
* Fix test script.
* test comments
* update version number
* skip long running test.
* Update skipped tests to not have long running python package install test.
Co-authored-by: Sean Leonard <seleonar@microsoft.com>
* Fix code causing 'length(x) = 5 > 1' in coercion to 'logical(1)' warning.
* fix failing func execute in sql test due to differing environments
* add unittest for getServerVersion to detect bad cursor error on odbc
* add new R 4.2 to test workflow.
* adjust comment text and variable name
* Fix for spees generation codepath triggering cursor state invalid error
* Fix warning longer object length is not a multiple of shorter object length
* support for special characters in connection string password
* updated version number of R package to 1.2.1 in DESCRIPTION
* update CRAN snapshot reference
Co-authored-by: Sean Leonard <seleonar@microsoft.com>
* When resolving dependencies, consolidation of duplicates keeps binary pkgs. Dependency Calculation doesn't fetch linkingTo packages for binary pkgs.
* Comment style for function now consistent. Updated comment phrasing
* Removed hardcoded cran repo check and add proper data.frame row count check. Added tests for LinkingTo package inclusion for binary vs source.
* Spacing consistency with connectionString argument
* Adjust test for purpose of checking source package installed due to successful compilation from source
* Update pipeline with latest r-lib actions.
* Update readme to include build status GHA
* force upated testthat package to >= 2.0.1
* remove snapshot reference.
* new cache
* Fix cause of Invalid Cursor State
* Add fix for failing tests in CI
* Remove commented code in ci yaml
* Migrate CI to github actions
Migrate to github actions because Travis CI is not supported and
recommended by Microsoft github organization anymore.
Fix some python tests
test_dependency_spec
change package from "azure_cli_telemetry" to "beautifulsoup4"
because even when we uninsatll azure_cli_telemetry, azure module is
still
available from other package.
test_installing_popular_ml_packages
Update the package and use correct module name for the package.
Previous code will use packagename with version number as a module. This
caused test failure.
Signed-off-by: Jarupat Jisarojito <guitarnana@gmail.com>
* Add github workflow file.
* Update for using the same local version and binary packages for Windows servers.
* Query to get the version of R the server is currently using
* Additional details for proper configuration
* Minor fix
* Fixing the formatting
- Add Python testing to the Travis-CI
- pip moved away from holding pep425tags in their codebase in pip version 20+, so we just import from wheel instead.
- The way we resolved requirement specs was not the most robust. We can just use pkg_resources's Requirement class functionality instead of writing our own. In particular, our original implementation did not work with "~=".
- Removed a number of tests that were redundant. These tests were fine when run on the user machine, but when run on the Travis-CI server they will time out.
* Change all sql package calls to use odbc instead of RODBC
* style fixes
* remove references to RODBC
* comment and whitespace changes
* Add timeout to 60 minutes in Travis-CI
Major changes to sqlmlutils internal implementation. User experience should be largely the same as before, except with the addition of output parameters.
* Change to pyodbc instead of mssql
* Add print capture to exec
* Add Output Param support and stdout/err in sprocs
* change testing for python package management
* README updates
* Fix license headers
* Update version number to 1.0.0
aaronburtle
Sean Leonard
microsoft-github-policy-service[bot]
Jarupat Jisarojito
Mario S
Nikita Takru
Jonathan Zhu
Rahul Ajmera
Jonathan Zhu