Восстановить юзерскрипты Greasemonkey из бэкапа браузера

# Paths
$oldDatabasePath = "C:\Users\DAMIX\Documents\TEMP\61413404gyreekansoem.sqlite" # Path to old database
$newDatabasePath = "C:\Users\DAMIX\AppData\Roaming\Mozilla\Firefox\Profiles\f9aziwfo.damix\storage\default\moz-extension+++b2a1888f-b67e-4552-b3de-3feec1b02009\idb\61413404gyreekansoem.sqlite" # Path to new database
$tool = "C:\Users\DAMIX\Documents\TEMP\sqlite3.exe" # Path to new sqlite
 
# Check for old database and sqlite first
if (-not (Test-Path -LiteralPath $oldDatabasePath)) { Write-Host "Old database path not found. Stopping script." -ForegroundColor Red return }
if (-not (Test-Path -LiteralPath $tool)) { Write-Host "Sqlite not installed. Please get it for free here: https://sqlite.org/download.html" -ForegroundColor Red return }
 
# Shut down Firefox
Write-Host "Shutting down Firefox..."
Stop-Process -Name "firefox" -Force -ErrorAction SilentlyContinue
 
# Wait for Firefox to exit
Write-Host "Waiting for Firefox to shut down..."
while (Get-Process -Name "firefox" -ErrorAction SilentlyContinue) {
    Start-Sleep -Seconds 1
}
Write-Host "Firefox is completely shut down."
 
# Delete the current database
Write-Host "Deleting the current gyreekansoem.sqlite..."
Remove-Item -Path $newDatabasePath -Force
 
# Start Firefox
Write-Host "Starting Firefox..."
Start-Process -FilePath "firefox.exe"
 
# Wait for Firefox to start
Write-Host "Waiting for Firefox to start..."
while (-not (Get-Process -Name "firefox" -ErrorAction SilentlyContinue)) {
    Start-Sleep -Seconds 1
}
 
# Wait an additional 5 seconds after Firefox has started
Write-Host "Firefox is running. Waiting 5 more seconds..."
Start-Sleep -Seconds 5
 
# Shut down Firefox
Write-Host "Shutting down Firefox..."
Stop-Process -Name "firefox" -Force -ErrorAction SilentlyContinue
 
# Wait for Firefox to exit
Write-Host "Waiting for Firefox to shut down..."
while (Get-Process -Name "firefox" -ErrorAction SilentlyContinue) {
    Start-Sleep -Seconds 1
}
Write-Host "Firefox is completely shut down."
 
# Dump data from the old database
Write-Host "Dumping data from the old database..."
$sqliteDumpPath = "$env:TEMP\dump.sql"
# &$tool $oldDatabasePath ".dump" > $sqliteDumpPath
&$tool $oldDatabasePath ".dump" | Out-File -FilePath $sqliteDumpPath -Encoding utf8
if ($LASTEXITCODE -ne 0) {
    Write-Host "sqlite3.exe failed while dumping the old database (exit code $LASTEXITCODE). Script will stop." -ForegroundColor Red
    return
}
 
# Filter the dump file to include only the desired INSERT statements
Write-Host "Filtering the dump file..."
(Get-Content $sqliteDumpPath) -match "INSERT INTO (object_data|unique_index_data)" | Set-Content $sqliteDumpPath
 
# SQL commands to drop indexes and triggers
$sqlCommands = @"
DROP INDEX IF EXISTS index_data_value_locale_index;
DROP INDEX IF EXISTS unique_index_data_value_locale_index;
DROP TRIGGER IF EXISTS object_data_insert_trigger;
DROP TRIGGER IF EXISTS object_data_update_trigger;
DROP TRIGGER IF EXISTS object_data_delete_trigger;
DROP TRIGGER IF EXISTS file_update_trigger;
"@
 
# Execute the SQL commands using sqlite3.exe
Write-Host "Dropping indexes and triggers in the new database..."
$sqlCommands | &$tool $newDatabasePath
 
 
# Import data into the new database
Write-Host "Importing data into the new database..."
Get-Content $sqliteDumpPath | &$tool $newDatabasePath
 
 
# Start Firefox to verify the data is imported
Write-Host "Starting Firefox..."
Start-Process -FilePath "firefox.exe"
 
# Suggest a backup
Write-Host "Remember to back up the new database immediately and regularly!"
 
# Done
Write-Host "Script complete. Enjoy!"