Nisim Hurst-Tarrab langheran

## sort_id.js
db.getCollection('intents').aggregate([{ $addFields: { _id_date: { $toDate: "$_id" } } }, { $sort: { _id_date:-1 } }])

## convert_puml2png.bat
@echo off
REM Ensure PlantUML jar file path is correct
set PLANTUML_JAR=C:\Bin\plantuml.jar

REM Loop through all .puml files in the current directory
for %%f in (*.puml) do (
    echo Converting %%f to PNG...
    java -jar "%PLANTUML_JAR%" %%f
)

## req.cmd
@echo off
call .\venv\Scripts\activate.bat
pip install -r requirements.txt

## youtube_presentation.py
# %%
# Importing necessary libraries
import cv2
from skimage.metrics import structural_similarity as ssim
import numpy as np
import os
from pptx import Presentation
from pptx.util import Inches

# %%

## trim_pdf_images.ps1
Get-ChildItem ".\" -Filter *.pdf |
Foreach-Object {
    $output = $_.BaseName + ".png"
    if (Test-Path $output) {
        Remove-Item $output
    }
    convert -density 300 $_.FullName -bordercolor white -border 1x1 -trim +repage -quality 100 -border 50x50 $output
}

## convert2ico.bat
convert oauth.png -define icon:auto-resize=256,128,64,48,32,16 oauth.ico

## kill_drive.ps1
# Function to find and kill processes using the specified drive
function Kill-ProcessUsingDrive {
    param (
        [string]$DriveLetter
    )

    # Get the list of processes
    $processes = Get-CimInstance -ClassName Win32_Process

    # Filter processes that have a handle open on the specified drive

## stop_sql.bat
net stop MySQL80
net stop MSSQLSERVER
taskkill.exe /IM sqlbrowser.exe /F
taskkill.exe /IM sqlceip.exe /F
taskkill.exe /IM sqlservr.exe /F
taskkill.exe /IM sqlwriter.exe /F

## Gmail.bat
start /MAX "" "C:\Program Files\Google\Chrome\Application\chrome.exe" --user-data-dir="C:\Users\NisimHurst\Utilities\mini-chrome" "https://mail.google.com/mail/u/0/"

## convert2ico.bat
convert oauth.png -define icon:auto-resize=256,128,64,48,32,16 oauth.ico
	@echo off
	REM Ensure PlantUML jar file path is correct
	set PLANTUML_JAR=C:\Bin\plantuml.jar

	REM Loop through all .puml files in the current directory
	for %%f in (*.puml) do (
	echo Converting %%f to PNG...
	java -jar "%PLANTUML_JAR%" %%f
	)
	@echo off
	call .\venv\Scripts\activate.bat
	pip install -r requirements.txt
	# %%
	# Importing necessary libraries
	import cv2
	from skimage.metrics import structural_similarity as ssim
	import numpy as np
	import os
	from pptx import Presentation
	from pptx.util import Inches

	# %%
	Get-ChildItem ".\" -Filter *.pdf \|
	Foreach-Object {
	$output = $_.BaseName + ".png"
	if (Test-Path $output) {
	Remove-Item $output
	}
	convert -density 300 $_.FullName -bordercolor white -border 1x1 -trim +repage -quality 100 -border 50x50 $output
	}
	# Function to find and kill processes using the specified drive
	function Kill-ProcessUsingDrive {
	param (
	[string]$DriveLetter
	)

	# Get the list of processes
	$processes = Get-CimInstance -ClassName Win32_Process

	# Filter processes that have a handle open on the specified drive
	net stop MySQL80
	net stop MSSQLSERVER
	taskkill.exe /IM sqlbrowser.exe /F
	taskkill.exe /IM sqlceip.exe /F
	taskkill.exe /IM sqlservr.exe /F
	taskkill.exe /IM sqlwriter.exe /F