DMeurer

#!/usr/bin/env python3
"""
Pi-hole FTL Database Query Exporter
Exports top 100 allowed/permitted queries with all available information to CSV

Creates two output files:
1. Summary CSV: Just the top domains with their query counts (100 rows)
2. Detailed CSV: All individual queries for these top domains (can be large)

Use --summary-only to only create the summary file and skip the detailed export.

DMeurer

git stash -u
git pull
git stash pop

$outp = $null;
$outp = git ls-files -u
if ($outp -eq $null){
	Write-Host "No conflics" -ForegroundColor Green
} else {
	Write-Host "===== MERGE CONFLICTS =====" -BackgroundColor DarkRed

DMeurer

# install Chocolately
If(Test-Path -Path "$env:ProgramData\Chocolatey") {
  echo "Chocolately is installed"
} Else {
  echo "Chocolately is not installed. Installing now..."
  Set-ExecutionPolicy Bypass -Scope Process -Force; iex ((New-Object System.Net.WebClient).DownloadString('https://chocolatey.org/install.ps1'))
  echo "Chocolately is installed"
}

# reload path

DMeurer

$paramMode = $args[0]
$paramSource = $args[1]
$paramDestination = $args[2]
$paramSilent = $args[3]

$silent = (($paramSilent -eq "-s") -or ($paramSilent -eq "--silent"))

if ($silent -eq $false)
{
    Write-Host "$( [char]0x1b )[38;5;51m  ______  ___      _______________  $( [char]0x1b )[38;5;84m  _________                      $( [char]0x1b )[0m