DatabaseTest.cs

// ----------------------------------------------------------------------------------
//
// Copyright Microsoft Corporation
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
// http://www.apache.org/licenses/LICENSE-2.0
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.
// ----------------------------------------------------------------------------------

using System;
using System.Globalization;
using System.IO;
using Microsoft.VisualStudio.TestTools.UnitTesting;
using Microsoft.WindowsAzure.Commands.SqlDatabase.Test.Utilities;

namespace Microsoft.WindowsAzure.Commands.SqlDatabase.Test.FunctionalTests
{
    /// <summary>
    /// Functional tests for Database CRUD operations
    /// </summary>
    [TestClass]
    public class DatabaseTest
    {
        #region Test Script Locations

        /// <summary>
        /// Scripts for doing context creation tests
        /// </summary>
        private const string CreateContextScript = @"Database\CreateContext.ps1";

        /// <summary>
        /// Script for doing Create and Get database tests with SQL authentication
        /// </summary>
        private const string CreateScript = @"Database\CreateAndGetDatabase.ps1";

        /// <summary>
        /// Scripts for doing database update tests
        /// </summary>
        private const string UpdateScript = @"Database\UpdateDatabase.ps1";

        /// <summary>
        /// Scripts for doing delete database tests
        /// </summary>
        private const string DeleteScript = @"Database\DeleteDatabase.ps1";

        /// <summary>
        /// Tests for doing format validation tests 
        /// </summary>
        private const string FormatValidationScript = @"Database\FormatValidation.ps1";

        /// <summary>
        /// Tests for doing import export tests
        /// </summary>
        private const string ImportExportScript = @"Database\ImportExportDatabase.ps1";

        #endregion

        /// <summary>
        /// The end point to use for the tests
        /// </summary>
        private const string LocalRdfeEndpoint = @"https://management.dev.mscds.com:12346/";

        /// <summary>
        /// Tests context creation
        /// </summary>
        [TestMethod]
        [TestCategory("Functional")]
        public void CreateContext()
        {
            string arguments = string.Format(
                CultureInfo.InvariantCulture,
                "-ManageUrl \"{0}\" -UserName \"{1}\" -Password \"{2}\" "
                + "-SubscriptionId \"{3}\" -SerializedCert \"{4}\" ",
                SqlDatabaseTestSettings.Instance.ManageUrl,
                SqlDatabaseTestSettings.Instance.UserName,
                SqlDatabaseTestSettings.Instance.Password,
                SqlDatabaseTestSettings.Instance.SubscriptionId,
                SqlDatabaseTestSettings.Instance.SerializedCert);
            bool testResult = PSScriptExecutor.ExecuteScript(
                DatabaseTest.CreateContextScript,
                arguments);
            Assert.IsTrue(testResult);
        }

        /// <summary>
        /// Tests creating a database using SQL authentication
        /// </summary>
        [TestMethod]
        [TestCategory("Functional")]
        public void CreateAndGetDatabase()
        {
            string arguments = string.Format(
                CultureInfo.InvariantCulture,
                "-Name \"{0}\" -ManageUrl \"{1}\" -UserName \"{2}\" -Password \"{3}\" "
                + "-ServerName \"{4}\" -SubscriptionID \"{5}\" -SerializedCert \"{6}\" "
                + "-Endpoint \"{7}\"",
                "testcreatedbfromcmdlet",
                SqlDatabaseTestSettings.Instance.ManageUrl,
                SqlDatabaseTestSettings.Instance.UserName,
                SqlDatabaseTestSettings.Instance.Password,
                SqlDatabaseTestSettings.Instance.ServerName,
                SqlDatabaseTestSettings.Instance.SubscriptionId,
                SqlDatabaseTestSettings.Instance.SerializedCert,
                LocalRdfeEndpoint);
            bool testResult = PSScriptExecutor.ExecuteScript(DatabaseTest.CreateScript, arguments);
            Assert.IsTrue(testResult);
        }

        /// <summary>
        /// Tests updating a database using SQL authentication
        /// </summary>
        [TestMethod]
        [TestCategory("Functional")]
        public void UpdateDatabase()
        {
            string arguments = string.Format(
                CultureInfo.InvariantCulture,
                "-Name \"{0}\" -ManageUrl \"{1}\" -UserName \"{2}\" -Password \"{3}\" "
                + "-ServerName \"{4}\" -SubscriptionID \"{5}\" -SerializedCert \"{6}\" "
                + "-Endpoint \"{7}\"",
                "testupdatedbfromcmdlet",
                SqlDatabaseTestSettings.Instance.ManageUrl,
                SqlDatabaseTestSettings.Instance.UserName,
                SqlDatabaseTestSettings.Instance.Password,
                SqlDatabaseTestSettings.Instance.ServerName,
                SqlDatabaseTestSettings.Instance.SubscriptionId,
                SqlDatabaseTestSettings.Instance.SerializedCert,
                LocalRdfeEndpoint);
            bool testResult = PSScriptExecutor.ExecuteScript(DatabaseTest.UpdateScript, arguments);
            Assert.IsTrue(testResult);
        }

        /// <summary>
        /// Tests removing a database using SQL authentication
        /// </summary>
        [TestMethod]
        [TestCategory("Functional")]
        public void DeleteDatabase()
        {
            string arguments = string.Format(
                CultureInfo.InvariantCulture,
                "-Name \"{0}\" -ManageUrl \"{1}\" -UserName \"{2}\" -Password \"{3}\" "
                + "-ServerName \"{4}\" -SubscriptionID \"{5}\" -SerializedCert \"{6}\" "
                + "-Endpoint \"{7}\"",
                "testDeletedbfromcmdlet",
                SqlDatabaseTestSettings.Instance.ManageUrl,
                SqlDatabaseTestSettings.Instance.UserName,
                SqlDatabaseTestSettings.Instance.Password,
                SqlDatabaseTestSettings.Instance.ServerName,
                SqlDatabaseTestSettings.Instance.SubscriptionId,
                SqlDatabaseTestSettings.Instance.SerializedCert,
                LocalRdfeEndpoint);
            bool testResult = PSScriptExecutor.ExecuteScript(DatabaseTest.DeleteScript, arguments);
            Assert.IsTrue(testResult);
        }

        /// <summary>
        /// Validates the object output format
        /// </summary>
        [TestMethod]
        [TestCategory("Functional")]
        public void OutputObjectFormatValidation()
        {
            string outputFile = Path.Combine(Directory.GetCurrentDirectory(), Guid.NewGuid() + ".txt");
            string arguments = string.Format(
                CultureInfo.InvariantCulture,
                "-Name \"{0}\" -ManageUrl \"{1}\" -UserName \"{2}\" -Password \"{3}\" -OutputFile \"{4}\"",
                "testFormatdbfromcmdlet",
                SqlDatabaseTestSettings.Instance.ManageUrl,
                SqlDatabaseTestSettings.Instance.UserName,
                SqlDatabaseTestSettings.Instance.Password,
                outputFile);
            bool testResult = PSScriptExecutor.ExecuteScript(DatabaseTest.FormatValidationScript, arguments);
            Assert.IsTrue(testResult);

            OutputFormatValidator.ValidateOutputFormat(outputFile, @"Database\ExpectedFormat.txt");
        }

        /// <summary>
        /// Runs the script to test the import and export functionality
        /// </summary>
        [TestMethod]
        [TestCategory("Functional")]
        public void ImportExportDatabase()
        {
            string outputFile = Path.Combine(Directory.GetCurrentDirectory(), Guid.NewGuid() + ".txt");

            string cmdlineArgs =
                "-UserName \"{0}\" -Password \"{1}\" -SubscriptionId \"{2}\" -SerializedCert \"{3}\" "
                + "-ContainerName \"{4}\" -StorageName \"{5}\" -StorageAccessKey \"{6}\" "
                + "-ServerLocation \"{7}\"";

            string arguments = string.Format(
                CultureInfo.InvariantCulture,
                cmdlineArgs,
                SqlDatabaseTestSettings.Instance.UserName,
                SqlDatabaseTestSettings.Instance.Password,
                SqlDatabaseTestSettings.Instance.SubscriptionId,
                SqlDatabaseTestSettings.Instance.SerializedCert,
                SqlDatabaseTestSettings.Instance.ContainerName,
                SqlDatabaseTestSettings.Instance.StorageName,
                SqlDatabaseTestSettings.Instance.AccessKey,
                SqlDatabaseTestSettings.Instance.ServerLocation);
            bool testResult = PSScriptExecutor.ExecuteScript(DatabaseTest.ImportExportScript, arguments);
            Assert.IsTrue(testResult);
        }
    }
}