diff options
| author | mike bayer <mike_mp@zzzcomputing.com> | 2020-09-22 19:00:06 +0000 |
|---|---|---|
| committer | Gerrit Code Review <gerrit@bbpush.zzzcomputing.com> | 2020-09-22 19:00:06 +0000 |
| commit | c3e9f76e8d29db35875cb7ee956fe29e49a6fc95 (patch) | |
| tree | fb2fa7a83d23021232768c7f8d95222a66fd65e1 | |
| parent | 468766d6bac1e54a59c5f7d7167467dbc7d29a82 (diff) | |
| parent | e3871c076569b075ce1d48417b5f097ca3ac54fd (diff) | |
| download | sqlalchemy-c3e9f76e8d29db35875cb7ee956fe29e49a6fc95.tar.gz | |
Merge "Tweak docker config for mssql"
| -rw-r--r-- | README.unittests.rst | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/README.unittests.rst b/README.unittests.rst index 84026007d..03752b764 100644 --- a/README.unittests.rst +++ b/README.unittests.rst @@ -287,10 +287,9 @@ intended for production use! # configure the database sleep 20 - docker exec -it mssql /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P 'yourStrong(!)Password' -Q "sp_configure 'contained database authentication', 1; RECONFIGURE; CREATE DATABASE test CONTAINMENT = PARTIAL; ALTER DATABASE test SET ALLOW_SNAPSHOT_ISOLATION ON; ALTER DATABASE test SET READ_COMMITTED_SNAPSHOT ON" + docker exec -it mssql /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P 'yourStrong(!)Password' -Q "sp_configure 'contained database authentication', 1; RECONFIGURE; CREATE DATABASE test CONTAINMENT = PARTIAL; ALTER DATABASE test SET ALLOW_SNAPSHOT_ISOLATION ON; ALTER DATABASE test SET READ_COMMITTED_SNAPSHOT ON; CREATE LOGIN scott WITH PASSWORD = 'tiger^5HHH'; ALTER SERVER ROLE sysadmin ADD MEMBER scott;" docker exec -it mssql /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P 'yourStrong(!)Password' -d test -Q "CREATE SCHEMA test_schema" docker exec -it mssql /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P 'yourStrong(!)Password' -d test -Q "CREATE SCHEMA test_schema_2" - docker exec -it mssql /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P 'yourStrong(!)Password' -d test -Q "CREATE USER scott WITH PASSWORD = 'tiger^5HHH'; GRANT CONTROL TO scott" # To stop the container. It will also remove it. docker stop mssql |