public/Install-JiraDatabase.ps1
|
<#
.SYNOPSIS Install the Jira database objects used by the PowerJiraSqlRefresh module .DESCRIPTION Runs SQL scripts embedded in the PowerJiraSqlRefresh module to create objects and data First creates all schema objects, then populates lookup tables with data .PARAMETER SqlInstance The connection string for the SQL instance to install the Jira database on .PARAMETER SqlDatabase The name of the database to install the Jira objects and data in .PARAMETER Username The username of the account that will be executing the module .PARAMETER CreateUser Set this switch to create the user in the database before adding it to the JiraRefreshRole .EXAMPLE Install-JiraDatabase -SqlInstance localhost -SqlDatabase Jira -Username "DOMAIN\MyJiraUser" Installs objects and data on the local machine in a database called "Jira" .EXAMPLE Install-JiraDatabase -SqlInstance "my.remote.sql.server,1234" -SqlDatabase Jira -Username "DOMAIN\MyJiraUser" -CreateUser Installs objects and data on a remote Sql Server in a database called "Jira", and creates the user in the database #> function Install-JiraDatabase { [CmdletBinding()] param ( # The sql instance of the install database [Parameter(Mandatory,Position=0)] [string] $SqlInstance, # The name of the install sql database [Parameter(Mandatory,Position=1)] [string] $SqlDatabase, # The user that will execute the Jira Refresh [Parameter(Mandatory,Position=2)] [string] $Username, # Set this switch to create the user in the database before adding it to the role [Parameter()] [switch] $CreateUser ) begin { Write-Verbose "Installing Jira database on $SqlInstance in database $SqlDatabase" } process { Write-Verbose "Creating database objects" $objectsResult = Invoke-SqlCmd -ServerInstance $SqlInstance -Database $SqlDatabase -InputFile $global:PowerJiraSqlRefresh.SqlObjectsPath if ($CreateUser) { Write-Verbose "Creating user $Username" $createUserResult = Invoke-SqlCmd -ServerInstance $SqlInstance -Database $SqlDatabase -Query "CREATE USER [$Username]" } Write-Verbose "Adding user $Username to JiraRefreshRole role" $addUserResult = Invoke-SqlCmd -ServerInstance $SqlInstance -Database $SqlDatabase -Query "ALTER ROLE [JiraRefreshRole] ADD MEMBER [$Username]" Write-Verbose "Creating lookup table data" $lookupResult = Invoke-SqlCmd -ServerInstance $SqlInstance -Database $SqlDatabase -InputFile $global:PowerJiraSqlRefresh.SqlLookupsPath } end { Write-Verbose "Jira database installation completed" } } |