Last active
January 3, 2020 06:02
-
-
Save sodacrackers/ea080b4925731601decc to your computer and use it in GitHub Desktop.
PowerShell to backup folders, download git repo, and create IIS site for Drupal
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Set-ExecutionPolicy -ExecutionPolicy Unrestricted -Scope Process -Force | |
| $verbosePreference = "Continue" | |
| // Relies on Powershell.MWA for Internet Information Servives routines | |
| // Download to .\Powershell.MWA-master | |
| // @see https://github.com/jgigler/Powershell.MWA | |
| Import-Module WebAdministration | |
| Import-Module "$(Split-Path -Path $MyInvocation.MyCommand.Definition -Parent)\Powershell.MWA-master\Powershell.MWA.psm1" | |
| Push-Location $env:temp | |
| <# | |
| .SYNOPSIS | |
| IIS deployment utilities | |
| .DESCRIPTION | |
| Run deploy powesrshell as administrator. | |
| .EXAMPLE | |
| powershell> | |
| Import-Module C:\inetpub\sphsc_website_admin\deploy\sphsc-deploy.ps1 | |
| powershell> | |
| My-Function | |
| powershell> | |
| sRunAdministatorScripts -doDatabseUpdate $true | |
| .EXAMPLE | |
| CreateSite -ComputerName "" -SiteName "spchs-testy" | |
| .NOTES | |
| #> | |
| $NL = "`r`n=============================== " | |
| function sphsc_update_admin_scripts | |
| { | |
| [CmdletBinding()] | |
| Param | |
| ( | |
| [Parameter(Mandatory=$false)] | |
| [string]$repoAddress = "https://meyerjn@bitbucke.org/meyerjn/shsc_admin_www.git", | |
| [Parameter(Mandatory=$false)] | |
| [string]$destinationPath = "C:\inetpub\sphsc_website_admin" | |
| ) | |
| Begin {} | |
| Process | |
| { | |
| "$NL Extracting admin repository into.... $destinationPath" | |
| _remove_folder -path $destinationPath | |
| _download_repo -destinationPath $destinationPath -repoAddress $repoAddress | |
| } | |
| } | |
| function sphsc_import_database | |
| { | |
| [CmdletBinding()] | |
| Param | |
| ( | |
| [Parameter(Mandatory=$false)] | |
| [bool]$doDatabseUpdate = $false, | |
| [Parameter(Mandatory=$false)] | |
| [string]$databaseUpdateScript = "C:\inetpub\sphsc_website_admin\db\database-update.mysql" | |
| ) | |
| Begin {} | |
| Process | |
| { | |
| if($doDatabseUpdate -eq $true) { | |
| "$NL Importing script into MySQL...... $databaseUpdateScript" | |
| _configure_db -databaseImportFile $databaseUpdateScript | |
| } | |
| } | |
| } | |
| function sphsc_deploy_website | |
| { | |
| [CmdletBinding()] | |
| Param () | |
| Begin {} | |
| Process | |
| { | |
| _do_deploy | |
| } | |
| } | |
| function _remove_folder | |
| { | |
| [CmdletBinding()] | |
| Param | |
| ( | |
| [Parameter(Mandatory=$true)] | |
| [string]$path = "" | |
| ) | |
| Begin {} | |
| Process | |
| { | |
| "$NL Removing $path....." | |
| if((Test-Path -Path $path)) { | |
| Remove-Item -Path $path -Recurse -Force | |
| } | |
| } | |
| } | |
| function _create_folder | |
| { | |
| [CmdletBinding()] | |
| Param | |
| ( | |
| [Parameter(Mandatory=$true)] | |
| [string]$path = "", | |
| [Parameter(Mandatory=$false)] | |
| [string]$prune = $false | |
| ) | |
| Begin {} | |
| Process | |
| { | |
| "$NL Creating $path....." | |
| if($prune -eq $true) { | |
| _remove_folder -path $path | |
| } | |
| if(!(Test-Path -Path $path)) { | |
| New-Item -ItemType Directory -Path $path -Verbose:$true | |
| } | |
| Dir $path | |
| } | |
| } | |
| function _prune_folder | |
| { | |
| [CmdletBinding()] | |
| Param | |
| ( | |
| [Parameter(Mandatory=$true)] | |
| [string]$path = "", | |
| [Parameter(Mandatory=$false)] | |
| [int]$numberToKeep = 10 | |
| ) | |
| Begin {} | |
| Process | |
| { | |
| $dirs = dir -Path $path -Directory | |
| "$NL Found $($dirs.Count) archive folders" | |
| if ($dirs.count -ge $numberToKeep) { | |
| "$NL Deleting folders older than first $numberToKeep...." | |
| " In $archiveDir" | |
| $oldest = $dirs | Sort-Object CreationTime -Descending | Select-Object -First ($dirs.Count - $numberToKeep) | |
| $oldest | Format-List | |
| $oldest | Remove-Item -Recurse -Force | |
| } | |
| } | |
| } | |
| function _archive_folder | |
| { | |
| [CmdletBinding()] | |
| Param | |
| ( | |
| [Parameter(Mandatory=$true)] | |
| [string]$sourcePath = "", | |
| [Parameter(Mandatory=$true)] | |
| [string]$destinationPath = "" | |
| ) | |
| Begin {} | |
| Process | |
| { | |
| "$NL Creating folder $destinationPath..... " | |
| _create_folder -path $destinationPath -prune $true | |
| "$NL Arhive copying $sourcePath....." | |
| " to $destinationPath" | |
| Copy-Item $sourcePath -Destination $destinationPath -Recurse -Force | |
| Dir $destinationPath | |
| } | |
| } | |
| function _archive_db | |
| { | |
| [CmdletBinding()] | |
| Param | |
| ( | |
| [Parameter(Mandatory=$false)] | |
| [string]$databaseName = "sphsc_drupal", | |
| [Parameter(Mandatory=$true)] | |
| [string]$destinationPath = "" | |
| ) | |
| Begin {} | |
| Process | |
| { | |
| "$NL Creating folder $destinationPath..... " | |
| _create_folder -path $destinationPath -prune $true | |
| $fileName = "$destinationPath\$databaseName.sql" | |
| "$NL Outputting MySQL dump of '$databaseName' to ..... $fileName" | |
| mysqldump -u root --databases $databaseName > $fileName | |
| Dir $destinationPath | |
| "$NL Creating MySQL hotcopy of database....." | |
| $databaseSource = $env:ProgramFiles +"\MySQL\MySQL Server 5.5\data\" + $databaseName | |
| if(!(Test-Path -Path $databaseSource)) { | |
| $databaseSource = mysql -uroot -h'127.0.0.1' -sNe"SELECT @@datadir" | |
| } | |
| "$NL Copying $databaseSource .... to $destinationPath" | |
| Copy-Item "$databaseSource" -Destination "$destinationPath" -Recurse -Force | |
| Dir $destinationPath | |
| } | |
| } | |
| function _download_repo | |
| { | |
| [CmdletBinding()] | |
| Param | |
| ( | |
| [Parameter(Mandatory=$false)] | |
| [string]$repoAddress = "", | |
| [Parameter(Mandatory=$true)] | |
| [string]$destinationPath = "" | |
| ) | |
| Begin {} | |
| Process | |
| { | |
| _create_folder -path $destinationPath | |
| #Import-Module posh-git | |
| #$sshKey = "C:\inetpub\_git_ssh_keys\id_rsa" | |
| #$env:path += ";${env:ProgramFiles(x86)}\Git\bin" | |
| #ssh-agent bash -c "ssh-add $sshKey; git clone meyerjn@bitbucket.org:meyerjn/shscience_dr7v1.git | |
| "$NL Downloading clone of repository...." | |
| git clone "$repoAddress" "$destinationPath" | |
| "$NL Trying a git pull...." | |
| git pull "$repoAddress" | |
| } | |
| } | |
| function _configure_db | |
| { | |
| [CmdletBinding()] | |
| Param | |
| ( | |
| [Parameter(Mandatory=$false)] | |
| [string]$databaseName = "sphsc_drupal", | |
| [Parameter(Mandatory=$false)] | |
| [string]$databaseUser = "sphsc_drupal", | |
| [Parameter(Mandatory=$false)] | |
| [string]$databaseImportFile = "", # e.g. "./db/import.sql" | |
| [Parameter(Mandatory=$false)] | |
| [string]$destinationPath = "" | |
| ) | |
| Begin {} | |
| Process | |
| { | |
| function _addDatabaseUser () { | |
| "$NL Creating no-password database account...." | |
| mysql -uroot -h'127.0.0.1' --verbose -e "GRANT ALL ON ``$databaseName``.* TO '$databaseUser'" | |
| mysql -uroot -h'127.0.0.1' --verbose -e "FLUSH PRIVILEGES" | |
| mysql -uroot -h'127.0.0.1' --verbose -e "SET PASSWORD FOR '$databaseUser'@'localhost' = PASSWORD('')" | |
| mysql -uroot -h'127.0.0.1' --verbose -e "FLUSH PRIVILEGES" | |
| #"$NL Testing MySQL access....." | |
| #mysql --user="$databaseUser" --database="$databaseName" -e "SHOW TABLES" | |
| } | |
| function _addConnectionString () { | |
| $settingsFile = "$destinationPath\sites\default\settings.php" | |
| $connectionString = "`$databases['default']['default'] = array ( | |
| 'host' => 'localhost', | |
| 'port' => '', | |
| 'driver' => 'mysql', | |
| 'prefix' => '', | |
| 'database' => '$databaseName', | |
| 'username' => '$databaseUser', | |
| 'password' => '', | |
| );" | |
| "$NL Adding database connection string to $settingsFile....." | |
| Add-Content -Path "$settingsFile" -Value "`r`n$connectionString" | |
| Get-Content -Path "$settingsFile" -Tail 22 | |
| } | |
| function _importDatabase () { | |
| "$NL Creating database $databaseName....." | |
| mysql -uroot -h'127.0.0.1' --verbose -e "DROP DATABASE IF EXISTS $databaseName" | |
| mysql -uroot -h'127.0.0.1' --verbose -e "CREATE DATABASE ``$databaseName`` CHARACTER SET utf8 COLLATE utf8_general_ci" | |
| "$NL Importing database into $databaseName from $databaseImportFile....." | |
| mysql -uroot -h'127.0.0.1' $databaseName -e "source $($databaseImportFile)" | |
| } | |
| if($databaseUser -ne "") { | |
| _addDatabaseUser | |
| } | |
| if($databaseImportFile -ne "") { | |
| _importDatabase | |
| } | |
| if($destinationPath -ne "") { | |
| _addConnectionString | |
| } | |
| } | |
| } | |
| function _do_deploy | |
| { | |
| [CmdletBinding()] | |
| Param | |
| ( | |
| [Parameter(Mandatory=$false)] | |
| [string]$hostName = "staging.sphsc.washington.edu", | |
| [Parameter(Mandatory=$false)] | |
| [string]$databaseName = "sphsc_drupal", | |
| [Parameter(Mandatory=$false)] | |
| [string]$repository = "https://meyerjn@bitbucket.org/meyerjn/shsciences_dr7v1.git", | |
| [Parameter(Mandatory=$false)] | |
| [string]$backupFolders = $true | |
| ) | |
| Begin {} | |
| Process | |
| { | |
| try | |
| { | |
| function _backupFolders() | |
| { | |
| if($backupFolders -eq $true) { | |
| return; | |
| } | |
| "$NL Creating web folders......." | |
| $dir = (Join-Path $env:SystemDrive "i-archive") | |
| $dateString = "" + $(Get-Date).Year + $(Get-Date).Month + $(Get-Date).Day | |
| _create_folder -path $dir | |
| _prune_folder -path $dir | |
| _create_folder -path $tempPath -prune $true | |
| _create_folder -path $sitePath | |
| "$NL Copying to archives......" | |
| _archive_folder -sourcePath $sitePath -destinationPath (Join-Path $dir $($hostName +"-"+ $dateString +"-"+ "website")) | |
| _archive_db -destinationPath (Join-Path $dir $($hostName +"-"+ $dateString +"-"+ "database")) | |
| } | |
| function _copyUserFiles() | |
| { | |
| "$NL Creating Drupal's private folder......" | |
| $privateFolder = "$(Split-Path $sitePath)\private_for_drupal" | |
| _create_folder -path $privateFolder | |
| icacls $privateFolder /grant Everyone:F /t | |
| "$NL Copying user uploads....." | |
| $old = Join-Path $sitePath "\sites\default\files" | |
| $new = Join-Path $tempPath "\sites\default\" | |
| Copy-Item -Path $old -Destination $new -Recurse -Force | |
| icacls $new /grant Everyone:F /t | |
| } | |
| cls | |
| "$NL $NL RUNNING DEPLOY DEFAULTS...... $NL" | |
| $sitePath = Join-Path $env:SystemDrive (Join-Path "inetpub" $hostName) | |
| $tempPath = $sitePath +"temp" | |
| $prevPath = $sitePath +"old" | |
| _backupFolders | |
| "$NL Downloading Drupal to temp...... $tempPath" | |
| _download_repo -destinationPath $tempPath -repoAddress $repository | |
| _copyUserFiles | |
| "$NL Setting up database....." | |
| _configure_db -destinationPath $tempPath | |
| $test = "$destinationPath\sites\default\settings.php" | |
| if(!(Test-Path $test)) { | |
| throw [System.IO.FileNotFoundException] "$test not found." | |
| } | |
| "$NL Removing current IIS site...." | |
| Remove-Website -Name "$hostName" | |
| "$NL Renaming temp folders....... $tempPath...becomes... $sitePath...." | |
| _remove_folder -path $prevPath | |
| Rename-Item -Path $sitePath -NewName $prevPath | |
| Rename-Item -Path $tempPath -NewName $sitePath | |
| "$NL Adding IIS site (using imported IMA modules)...." | |
| New-IisSite -ComputerName localhost -SiteName $hostName -CodePath $sitePath -Bindings "*:80:$($hostName)" | |
| Get-IisSite -ComputerName localhost -SiteName $hostName | |
| "$NL Starting the IIS website..... " | |
| Start-IisSite -ComputerName localhost -SiteName $hostName | |
| } | |
| catch | |
| { | |
| $exceptionMessage = "Error in Line: " + $_.Exception.Line + ". " + $_.Exception.GetType().FullName + ": " + $_.Exception.Message + " Stacktrace: " + $_.Exception.StackTrace | |
| #Restore-WebConfiguration $backupName | |
| "$NL $NL Erroring out...." | |
| $exceptionMessage | |
| "$NL Origional message...." | |
| throw | |
| } | |
| } | |
| } | |
| Get-Command -name "sphsc*" |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment