Mysql

August 1, 20231 min read Scripting MySQL Powershell

# Import values with details connexion . .\values.ps1 $scriptFilePath ="$MyPath\Install\MysqlBase\Script.sql" # Load the required DLL file (depend on your connector) [void][System.Reflection.Assembly]::LoadFrom("C:\Program Files (x86)\MySQL\MySQL Connector Net 8.0.23\Assemblies\v4.5.2\MySql.Data.dll") # Load in var...

Parsing

August 1, 20231 min read Scripting Powershell

POO # Convert your json in object and put it in variable $a = Get-Content 'D:\temp\mytest.json' -raw | ConvertFrom-Json $a.update | % {if($_.name -eq 'test1'){$_.version=3.0}} $a | ConvertTo-Json -depth 32| set-content 'D:\temp\mytestBis.json' Example updating a XML #The file we want to change $xmlFilePath =...