864 Commits

Author SHA1 Message Date
Benjin Dubishar
d0d67373d1 Adding support for database literal references for Dacpac and SqlProj references (#1858)
* fixing up some nullable spots

* Adding database literal support

* Adding tests and support for same database refs

* Fixing test

* merge laggard

* Split database reference tests up

* PR feedback

* Normalizing strings for cross-plat test passing

* Updating Projects nuget package

* Fixing up test
2023-02-10 11:36:31 -08:00
Alan Ren
15250a9178 make list databases return in their original order (#1859)
* return databases in their original order

* remove using statement

* fix unit tests

* fix error
2023-02-09 14:27:25 -08:00
Sakshi Sharma
497118ed82 Add support to save publish profile (#1844)
* Add support to save publish profile

* Address comments

* Update dacfx nuget package version

* Fix test

* Address comments

* Resolve package.props conflict

* Add content verification in test and use handler methods instead of try-catch

* Address comments
2023-02-09 11:56:43 -08:00
Benjin Dubishar
41c8f15e3e Adding project service support for pre/post-deployment scripts (#1853)
* Patch up db references

* Adding pre/post deploy scripts

* Adding tests

* adding tests
2023-02-08 18:28:23 -08:00
Karl Burtram
2ef5f0918a User management support classes (#1856)
* WIP

* Fix nullable warnings in UserData class

* WIP2

* WIP

* Refresh database prototype classes

* Fix some typos & merge issues

* WIP

* WIP

* WIP

* Additional updates

* Remove unneded using
2023-02-08 18:02:08 -08:00
Benjin Dubishar
19935552b1 Adds support for checking and updating cross-compatibility for SQL Projects (#1847)
* Adding cross-platform check and update

* Checkpoint

* checkpoint

* Updating for latest nuget package

* Correctly typing the result object
2023-02-07 19:06:13 -08:00
Cheena Malhotra
8d119876d9 Update to .NET 7 SDK (#1792) 2023-02-07 17:53:36 -08:00
Karl Burtram
51892519ef Remove unneccessary nullable directive (#1848) 2023-02-07 16:18:57 -08:00
Benjin Dubishar
4eac02453b Support for folders in the projects service (#1834)
* Delete folder support + tests

* updating casing

* cleanup
2023-02-06 11:30:03 -08:00
Karl Burtram
f288bee294 Make nullable warnings a per file opt-in (#1842)
* Make nullable warnings a per file opt-in

* Remove unneeded compiler directives

* Remove compiler directive for User Data
2023-02-03 18:10:07 -08:00
Benjin Dubishar
2e950f54bd Normalize string to fix test case on Unix (#1841) 2023-02-01 14:30:28 -08:00
Karl Burtram
7110b1b39b Update fake password for credscan (#1839) 2023-02-01 11:04:15 -08:00
Karl Burtram
3c25549986 Initial WIP code for user management (#1838)
* Initial user management code

* WIP

* Fix whitespace

* WIP user objects

* WIP user objects

* Cleanup ported code

* WIP

* WIP

* Update the User contracts

* Additional cleanups

* Remove warning silencing which isn't intended for this PR

* Fix some warnings as error in CI
2023-01-31 21:12:53 -08:00
Benjin Dubishar
9fe3aeddc3 Support for database references in SqlProjects service (#1832)
* initial checkin

* Initial

* Adding test

* Adding comments

* PR feedback
2023-01-31 16:52:07 -08:00
Charles Gagnon
036ce9b527 Fix broken STS language service tests (#1837)
* Fix broken STS language service tests

* consolidate
2023-01-31 13:25:44 -08:00
Benjin Dubishar
e2962390bc Support for SqlCmdVariables in SqlProjects service (#1831)
* Support for SqlCmdVariables

* Adding comments

* Adding update sqlcmdvar method

* swapping for success asserts
2023-01-30 15:45:15 -08:00
Aasim Khan
ab5a1e6c85 Separating Migration into its own project (#1828)
* Moving Migration service to its own project

* Adding loc files to the project

* Adding Migration to build

* Adding Migration Integration Tests

* Trying loops

* Fixing params

* Fixing indent

* Cleaning up yaml

* Getting command line arg for auto flush log

* Adding tde service
2023-01-30 10:30:28 -08:00
Benjin Dubishar
82171740bc Adding missing nuget references for SqlProjects functionality (#1827)
* Adding test messages

* Adding file system globbing reference

* fixing string

* fixing string again

* Sigh
2023-01-27 16:18:40 -07:00
Alan Ren
bc0426f946 disable unstable test case (#1825) 2023-01-25 20:21:20 -08:00
Benjin Dubishar
9cce26fcbd Initial check-in of SqlProjects service addition to SqlToolsService (#1805)
* initial commit

* Initial SqlProjects service + tests

* Added SqlObject script tests; PR feedback

* Added comments for contracts

* Swapping SqlProjectResult for ResultStatus

* Updating tests

* Added automatic test base that provides a working directory and automatic cleanup.
2023-01-25 14:16:15 -08:00
Hai Cao
bcf015f939 Fix datetimeoffset formatting (#1823) 2023-01-25 11:19:30 -08:00
Aasim Khan
b8581920b6 Adding extension service host for extension services (#1808) 2023-01-24 16:09:42 -08:00
Karl Burtram
fd82d5bc17 Fix warning during "dotnet restore" (#1822) 2023-01-24 13:54:14 -08:00
Cheena Malhotra
ac460adfc3 Enable IsLedger only for SQL 2022 (#1804) 2023-01-09 17:47:27 -08:00
Cheena Malhotra
a8f9219f09 Introduce support for "Command Timeout" connection property (#1765) 2023-01-03 21:42:32 -08:00
Cheena Malhotra
eca0cc484c Add support for firewall rule name in request (#1791) 2022-12-16 09:04:14 -08:00
Hai Cao
1559b7c387 Make ParallelMessageProcessingTest stable by loose the assertion (#1786) 2022-12-13 15:01:01 -08:00
Hai Cao
f86ebae9b8 Re-enable parallel message processing (#1741)
* add flag to handler

* cleanup

* concurrency control

* add flag for handler setters

* update service flags

* fix event handlers

* more handlers

* make sure behavior is unchanged if flag is off

* cleanup

* add test case for parallel processing

* comments

* stop dispatcher in test

* add log for request lifespan

* cleanup and add comments

* correctly release semaphore

* remove deleted file from merge

* use await for semaphore release

* move handler invocation to await and adjust test

* cleanup exception handling and wrapper

* space

* loose assertion condition to make test stable
2022-12-11 00:05:33 -08:00
Alex Ma
7eee5180a2 Add change password function and handling (#1771)
* added ChangePassword to connectionService

* added changepasswordparams

* added more code

* added more changes to connectionservice

* added more changes

* added small test

* added changepasswordrequest

* added different ServerConnection constructor

* consolidated changepassword

* added exception catch

* added passwordChangeFail params

* added changePassword to it's own function

* simplified changePassword

* made fixes to test

* added new test

* added one additional connection test

* added response callback

* removed unnecessary SendError

* added localized empty password error

* added updated error messages

* added small fix to check

* added changes based on feedback

* added minor change

* fix tests

* renamed messages to errorDetails

* simplified error message

* small change to connectionservice message

* error message change

* added environment newline

* added error retry messages to STS

* added regex

* added newline handling
2022-12-07 14:24:26 -08:00
Karl Burtram
c9f310cb47 Remove InsightsGenerator project (#1764) 2022-12-07 10:56:12 -08:00
Cheena Malhotra
5cc3e6f657 Support updating access token when found expired for OE (#1772) 2022-11-28 17:42:05 -08:00
Karl Burtram
3a5935df99 Revert "Update to latest .Net SDK 7.0 (#1760)" (#1763)
This reverts commit 71cda5bbdc.
2022-11-15 11:29:41 -08:00
Karl Burtram
71cda5bbdc Update to latest .Net SDK 7.0 (#1760)
* Bump to SDK 7.0 and related updates

* More net 7 updates

* Install SDK 2.0 for ESRP

* Fix typo

* Address comment and update integration test script

* Disable new warnings from SDK update
2022-11-14 20:24:25 -08:00
Kim Santiago
acf3e92e83 Fix schema compare project test cleanup (#1746)
* cleanup .sqlproj in finally

* unique folder per test run

* fix path
2022-11-04 10:33:25 -07:00
Alan Ren
dea18a59e0 new dacfx version (#1745)
* new dacfx version

* fix failing schema compare tests

Co-authored-by: Kim Santiago <kisantia@microsoft.com>
2022-11-02 20:52:20 -07:00
Cheena Malhotra
36965f6355 Fix Comparable implementation for ConnectionDetails (#1739) 2022-10-31 18:32:40 -07:00
Cheena Malhotra
2f2f65c89f Fix tests to capture encrypt 'null' by default (#1738) 2022-10-28 12:39:34 -07:00
Cheena Malhotra
faaec187a7 Support Boolean type for Encrypt option value (#1737) 2022-10-27 14:32:22 -07:00
Cheena Malhotra
5e167239c5 Update dependencies (#1733) 2022-10-26 16:23:00 -07:00
Kim Santiago
85228c5da0 Remove testing cancel from VerifySchemaCompareServiceCalls (#1731) 2022-10-26 09:11:47 -07:00
Cheena Malhotra
c0f8482e26 Update Microsoft.Data.SqlClient to v5.0.1 (#1708) 2022-10-24 20:10:04 -07:00
Kim Santiago
6f198e9e5a fix schema comparing empty project showing more differences than expected (#1727) 2022-10-21 14:04:31 -07:00
Kim Santiago
c7c012dbe1 remove problematic assert in schema compare scmp test (#1718) 2022-10-06 08:37:23 -07:00
Benjamin Russell
af2c0c77e7 Export to Markdown Support (#1705)
* Adding file writer for Markdown tables. No testing yet.

* Unit tests for the markdown writer

* Wiring up the factory and and request types

* Wiring up changes for Markdown serialization in serialization service

* Couple last minute tweaks

* Changes as per PR comments

* Revert temp testing code. 🙈

* Fluent assertions in SerializationServiceTests.cs

Co-authored-by: Ben Russell <russellben@microsoft.com>
2022-09-27 11:55:43 -07:00
M-Patrone
88eaa64755 Feature rename sql objects (#1686) 2022-09-22 14:42:23 -07:00
Charles Gagnon
e763d2463d Remove unused test server types (#1699)
* Remove unused test server types

* Don't use secure file

* Correct password
2022-09-16 16:58:06 -07:00
Charles Gagnon
5e0302a95f Output verbose logging during tests (#1698)
* Output verbose logging during tests

* fix compile
2022-09-16 16:57:06 -07:00
Charles Gagnon
019481e8db Use MemoryStream instead of stdout for outgoing messages during integration tests (#1696)
* filter

* test

* run all

* Redirect to memorystream

* revert temp changes
2022-09-16 15:38:53 -07:00
Cheena Malhotra
006ac60923 Upgrade solution to .NET 6.0.9 (Build with .NET SDK v6.0.401) (#1692) 2022-09-16 11:27:52 -07:00
Cheena Malhotra
d031f01d53 Fix a tiny typo in RulesEngineTests (#1693) 2022-09-16 10:32:55 -07:00