<commit_before>$packageName = "sqlite"
$sqliteShell = "https://www.sqlite.org/2016/sqlite-shell-win32-x86-3100200.zip"
$sqliteAnalyzer = "https://www.sqlite.org/2016/sqlite-analyzer-win32-x86-3100200.zip"

$downloadPath = "$($env:TEMP)\chocolatey\$($packageName)"
$appDir = "$($env:SYSTEMDRIVE)\tools\apps\$($packageName)"

if ($psISE) {
    Import-Module -name "$env:ChocolateyInstall\chocolateyinstall\helpers\chocolateyInstaller.psm1"
}

try {
    if (Test-Path $appDir)
    {
        Write-Output "Removing previous version of package..."
        Remove-Item "$($appDir)" -Recurse -Force
    }

    New-Item -Type Directory -Path $appDir | Out-Null
    
    if (-not (Test-Path $downloadPath))
    {
        New-Item -Type Directory -Path $downloadPath | Out-Null
    }

    Get-ChocolateyWebFile $packageName "$downloadPath\sqliteShell.zip" $sqliteShell
    Get-ChocolateyWebFile $packageName "$downloadPath\sqliteAnalyzer.zip" $sqliteAnalyzer

    Get-ChocolateyUnzip "$downloadPath\sqliteShell.zip" "$downloadPath"
    Get-ChocolateyUnzip "$downloadPath\sqliteAnalyzer.zip" "$downloadPath"

    Copy-Item -Path "$($downloadPath)\*.exe" -Destination "$appDir" -Recurse

    $shimgen = "$env:ChocolateyInstall\chocolateyinstall\tools\shimgen.exe"

    if (Test-ProcessAdminRights) {
        cmd /c mklink "$env:ChocolateyInstall\bin\sqlite3.exe" "$appDir\sqlite3.exe"
    } else {
        Start-ChocolateyProcessAsAdmin "cmd /c mklink '$env:ChocolateyInstall\bin\sqlite3.exe' '$appDir\sqlite3.exe'"
    }

    if (Test-ProcessAdminRights) {
        cmd /c mklink /J "$env:ChocolateyInstall\bin\sqlite3_analyzer.exe" "$appDir\sqlite3_analyzer.exe"
    } else {
        Start-ChocolateyProcessAsAdmin "cmd /c mklink /J '$env:ChocolateyInstall\bin\sqlite3_analyzer.exe' '$appDir\sqlite3_analyzer.exe'"
    }

    Write-ChocolateySuccess $packageName
} catch {
    Write-ChocolateyFailure $packageName $($_.Exception.Message)
    throw
}<commit_msg>updated sqlite to new zip compilation...<commit_after>$packageName = "sqlite"
$url = "https://www.sqlite.org/2016/sqlite-tools-win32-x86-3100200.zip"

$downloadPath = "$($env:TEMP)\chocolatey\$($packageName)"
$appDir = "$($env:SYSTEMDRIVE)\tools\apps\$($packageName)"

if ($psISE) {
    Import-Module -name "$env:ChocolateyInstall\chocolateyinstall\helpers\chocolateyInstaller.psm1"
}

if (Test-Path $appDir)
{
    Write-Output "Removing previous version of package..."
    Remove-Item "$($appDir)" -Recurse -Force
}

New-Item -Type Directory -Path $appDir | Out-Null
    
if (Test-Path $downloadPath)
{
    Remove-Item "$($downloadPath)" -Recurse -Force
}

New-Item -Type Directory -Path $downloadPath | Out-Null

Get-ChocolateyWebFile $packageName "$downloadPath\sqlite.zip" $url

Get-ChocolateyUnzip "$downloadPath\sqlite.zip" "$downloadPath"

Copy-Item -Path "$($downloadPath)\sqlite*\*.exe" -Destination "$appDir" -Recurse

if (Test-ProcessAdminRights) {
    cmd /c mklink "$env:ChocolateyInstall\bin\sqlite3.exe" "$appDir\sqlite3.exe"
} else {
    Start-ChocolateyProcessAsAdmin "cmd /c mklink '$env:ChocolateyInstall\bin\sqlite3.exe' '$appDir\sqlite3.exe'"
}

if (Test-ProcessAdminRights) {
    cmd /c mklink /J "$env:ChocolateyInstall\bin\sqlite3_analyzer.exe" "$appDir\sqlite3_analyzer.exe"
} else {
    Start-ChocolateyProcessAsAdmin "cmd /c mklink /J '$env:ChocolateyInstall\bin\sqlite3_analyzer.exe' '$appDir\sqlite3_analyzer.exe'"
}

if (Test-ProcessAdminRights) {
    cmd /c mklink "$env:ChocolateyInstall\bin\sqldiff.exe" "$appDir\sqldiff.exe"
} else {
    Start-ChocolateyProcessAsAdmin "cmd /c mklink '$env:ChocolateyInstall\bin\sqldiff.exe' '$appDir\sqldiff.exe'"
}
{'fraction_non_alphanumeric': 0.1486374896779521, 'fraction_numerical': 0.017341040462427744, 'mean_word_length': 4.274310595065312, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 3, 'lorem ipsum': 0, 'www.': 3, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 18, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1864850', 'n_tokens_mistral': 1360, 'n_tokens_neox': 1288, 'n_words': 211}