mbiernacik / psci Goto Github PK

Environment Default {
    ServerConnection WebServer -Nodes localhost
    ServerConnection DatabaseServer -Nodes localhost
  
    ServerRole Web -Configurations WebServerProvision,WebServerDeploy -ServerConnections WebServer
    ServerRole Database -Configurations DatabaseDeploy -ServerConnections DatabaseServer -RunRemotely
}

Environment Test {
    ServerConnection WebServer -Nodes TestWeb.local.domain -RemotingMode PSRemoting
    ServerConnection DatabaseServer -Nodes TestDb.local.domain -RemotingMode PSRemoting
}

Environment UAT {
    ServerConnection WebServer -Nodes UATWeb.remote.domain -RemotingMode WebDeployHandler
    ServerConnection DatabaseServer -Nodes UATDB.remote.domain -Authentication CredSSP -Protocol HTTPS 
}

Environment Default {
    Tokens WebConfig @{
      AppPoolName = 'TestAppPool'
      WebsiteName = 'TestWebsite'
      WebsitePort = 80
      WebsitePhysicalPath = 'c:\inetpub\wwwroot\TestWebsite'
    }
  
    Tokens DatabaseConfig @{
      ConnectionString = 'Server=${Node};Integrated Security=SSPI'
      DropDatabase = $true
    }
}

Environment UAT -BasedOn Default {
    Tokens WebConfig @{
      AppPoolName = 'UATAppPool'
      WebsiteName = 'UATWebsite'
      WebsitePort = 8080
    }
  
    Tokens DatabaseConfig @{
      DropDatabase = $false
    }
}

# this DSC configuration will be applied on nodes defined in 'ServerConnection WebServer'
Configuration WebServerProvision {
    param ($NodeName, $Environment, $Tokens)
  
    # DSC Wave resources are included in PSCI
    Import-DSCResource -Module xWebAdministration
  
    Node $NodeName {
        # configure application pool
        xWebAppPool MyWebAppPool { 
            Name   = $Tokens.WebConfig.AppPoolName
            Ensure = 'Present' 
            State  = 'Started'
        }
      
        # create website directory
        File MyWebsiteDir {
            DestinationPath = $Tokens.WebConfig.WebsitePhysicalPath
            Ensure = 'Present'
            Type = 'Directory'
        }

        # create site on IIS
        xWebsite MyWebsite { 
  	        Name = $Tokens.WebConfig.WebsiteName
            ApplicationPool = $Tokens.WebConfig.AppPoolName 
            BindingInfo = MSFT_xWebBindingInformation { 
                Port = $Tokens.WebServerConfig.WebsitePort
            } 
            PhysicalPath = $Tokens.WebConfig.WebsitePhysicalPath
            Ensure = 'Present' 
            State = 'Started' 
            DependsOn = @('[File]MyWebsiteDir')
      } 
}

# this function will be run locally (because related ServerRole has no -RunRemotely switch)
function WebServerDeploy {
    param ($NodeName, $Environment, $Tokens, $ConnectionParams)
  
    # we can run msdeploy manually from a function that is run locally
    $msDeployParams = @{ PackageName = 'MyWebsite'
                         PackageType = 'Web'
                         Node = $NodeName
                         MsDeployDestinationString = $ConnectionParams.MsDeployDestinationString
                         Website = $Tokens.WebConfig.WebsiteName
                         SkipDir = 'App_Data'
                         Environment = $Environment
                       }
  
    Deploy-MsDeployPackage @msdeployParams
}

# this function will be run remotely on nodes defined in 'ServerConnection DatabaseServer' (because related ServerRole has -RunRemotely switch)
function DatabaseDeploy {
    param ($NodeName, $Environment, $Tokens, $ConnectionParams)
  
    $databaseName = $Tokens.DatabaseConfig.DatabaseName
    $connectionString = $Tokens.DatabaseConfig.DatabaseDeploymentConnectionString
    if ($Tokens.DatabaseConfig.DropDatabase) { 
      Remove-SqlDatabase -DatabaseName $databaseName -ConnectionString $connectionString
      New-SqlDatabase -DatabaseName $databaseName -ConnectionString $connectionString
    }
    
    # we can for example run some commands directly
    Invoke-Sql -ConnectionString $connectionString -Query "USE ${databaseName}; PRINT 'some commands'"
    
    # or run every sql file that is available in package named 'sql' (assuming we have built the package beforehand)
    Deploy-SqlPackage -PackageName 'sql' -ConnectionString $connectionString
    
    # or restore database from backup
    Restore-SqlDatabase -ConnectionString $connectionString -Path $Tokens.DatabaseConfig.BackupPath -DatabaseName $databaseName 
    
    # or use other functions from PSCI, e.g. Deploy-EntityFrameworkMigratePackage, Deploy-DBDeploy, Deploy-SSRS*
}

.\deploy.ps1 -Environment Test