Sergei Radich
57 lines
1.6 KiB
PowerShell
57 lines
1.6 KiB
PowerShell
function Get-PostgreSqlVersion {
|
|
$postgreSQLVersion = psql --version | Get-StringPart -Part 2
|
|
return $postgreSQLVersion
|
|
}
|
|
|
|
function Get-SqliteVersion {
|
|
$sqliteVersion = sqlite3 --version | Get-StringPart -Part 0
|
|
return $sqliteVersion
|
|
}
|
|
|
|
function Get-MySQLVersion {
|
|
$mySQLVersion = mysqld --version | Get-StringPart -Part 2
|
|
return $mySQLVersion
|
|
}
|
|
|
|
function Get-SQLCmdVersion {
|
|
$sqlcmdVersion = sqlcmd -? | Select-String -Pattern "Version" | Get-StringPart -Part 1
|
|
return $sqlcmdVersion
|
|
}
|
|
|
|
function Get-SqlPackageVersion {
|
|
$sqlPackageVersion = sqlpackage /version
|
|
return $sqlPackageVersion
|
|
}
|
|
|
|
function Build-PostgreSqlSection {
|
|
$node = [HeaderNode]::new("PostgreSQL")
|
|
$node.AddToolVersion("PostgreSQL", $(Get-PostgreSqlVersion))
|
|
$node.AddNote(@(
|
|
"User: postgres",
|
|
"PostgreSQL service is disabled by default.",
|
|
"Use the following command as a part of your job to start the service: 'sudo systemctl start postgresql.service'"
|
|
) -join "`n")
|
|
|
|
return $node
|
|
}
|
|
|
|
function Build-MySQLSection {
|
|
$node = [HeaderNode]::new("MySQL")
|
|
$node.AddToolVersion("MySQL", $(Get-MySQLVersion))
|
|
$node.AddNote(@(
|
|
"User: root",
|
|
"Password: root",
|
|
"MySQL service is disabled by default.",
|
|
"Use the following command as a part of your job to start the service: 'sudo systemctl start mysql.service'"
|
|
) -join "`n")
|
|
|
|
return $node
|
|
}
|
|
|
|
function Build-MSSQLToolsSection {
|
|
$node = [HeaderNode]::new("MS SQL")
|
|
$node.AddToolVersion("sqlcmd", $(Get-SQLCmdVersion))
|
|
$node.AddToolVersion("SqlPackage", $(Get-SqlPackageVersion))
|
|
return $node
|
|
}
|