STApp

1.1

DSCResources/STDataTier/STDataTier.schema.psm1

configuration STDataTier
{
 param
    (
        [Parameter(Mandatory)]
        [ValidateNotNullOrEmpty()]
        [String]$Ensure,

        [Parameter(Mandatory)]
        [ValidateNotNullOrEmpty()]
        [String]$SqlServer,

        [Parameter(Mandatory)]
        [ValidateNotNullOrEmpty()]
        [String]$SqlServerVersion,

        [Parameter(Mandatory)]
        [ValidateNotNullOrEmpty()]
        [String]$DeploymentPath,

        [Parameter(Mandatory)]
        [ValidateNotNullOrEmpty()]
        [hashtable]$configLogin,

        [Parameter(Mandatory)]
        [ValidateNotNullOrEmpty()]
        [hashtable]$tradeLogin
    )
    Import-DscResource -module xDatabase
   Import-DscResource -module xNetworking
    xFirewall Firewall
         {
           Name = "SqlServerPort"
           Ensure = "Present"
           DisplayName = "SQL Port - 1433"
           Access = "Allow"
           State = "Enabled"
           Profile = "Any"
           Direction = "Inbound"
           LocalPort = "1433"
           Protocol = "tcp"
         }

         xDatabaseServer SqlAuthenticationMode
         {
              LoginMode = "Mixed"
         }

         xDatabaseLogin AdminLogin
         {
              Ensure                  =  $Ensure
              LoginName               =  $configLogin.login
              LoginPassword           =  $configLogin.password
              SqlAuthType             =  "Windows"
              SqlServer               =  $SqlServer
         }

         xDatabaseLogin TradeLogin
         {
              Ensure                  =  $Ensure
              LoginName               =  $tradeLogin.login
              LoginPassword           =  $tradeLogin.password
              SqlAuthType             =  "Windows"
              SqlServer               =  $SqlServer
         }                   

         xDatabase LoggingDb
         {
              Ensure                  =  $Ensure
              DatabaseName            =  "Logging"
              SqlServer               =  $SqlServer
              SqlServerVersion        =  $SqlServerVersion
              SqlAuthType             =  "Windows"
              DacPacPath              =  $DeploymentPath + "\DataBaseArtifacts\DACPAC\Logging.dacpac"
              DacPacApplicationName   =  "logging_1"
        }
        
         xDatabase AzureOrderProcessorRepositoryDb
         {
              Ensure                  =  $Ensure
              DatabaseName            =  "AzureOrderProcessorRepository"
              SqlServer               =  $SqlServer
              SqlServerVersion        =  $SqlServerVersion
              SqlAuthType             =  "Windows"
              BacPacPath              =  $DeploymentPath + "\DataBaseArtifacts\BACPAC\AzureOrderProcessorRepository.bacpac"
         } 

         xDatabase AzureBusinessServiceRepositoryDb
         {
              Ensure                  =  $Ensure
              DatabaseName            =  "AzureBusinessServiceRepository"
              SqlServer               =  $SqlServer
              SqlServerVersion        =  $SqlServerVersion
              SqlAuthType             =  "Windows"
              BacPacPath              =  $DeploymentPath + "\DataBaseArtifacts\BACPAC\AzureBusinessServiceRepository.bacpac"
         }

         xDatabase AzureStockTraderAccountDb
         {
              Ensure                  =  $Ensure
              DatabaseName            =  "AzureStockTraderAccountDB"
              SqlServer               =  $SqlServer
              SqlServerVersion        =  $SqlServerVersion
              SqlAuthType             =  "Windows"
              BacPacPath              =  $DeploymentPath + "\DataBaseArtifacts\BACPAC\AzureStockTraderAccountDB.bacpac"
         }

         xDatabase AzureStockTraderQuoteDb
         {
              Ensure                  =  $Ensure
              DatabaseName            =  "AzureStockTraderQuoteDB"
              SqlServer               =  $SqlServer
              SqlServerVersion        =  $SqlServerVersion
              SqlAuthType             =  "Windows"
              BacPacPath              =  $DeploymentPath + "\DataBaseArtifacts\BACPAC\AzureStockTraderQuoteDB.bacpac"
         }

         xDatabase AzureStockTraderWebAppRepositoryDb
         {
              Ensure                  =  $Ensure
              DatabaseName            =  "AzureStockTraderWebAppRepository"
              SqlServer               =  $SqlServer
              SqlServerVersion        =  $SqlServerVersion
              SqlAuthType             =  "Windows"
              BacPacPath              =  $DeploymentPath + "\DataBaseArtifacts\BACPAC\AzureStockTraderWebAppRepository.bacpac"
         }    
}