Skip to content

Instantly share code, notes, and snippets.

View choutkamartin's full-sized avatar

Martin Choutka choutkamartin

View GitHub Profile
@choutkamartin
choutkamartin / helpers.ts
Created February 14, 2024 00:58 — forked from rphlmr/helpers.ts
Drizzle ORM, deep sub queries
/* -------------------------------------------------------------------------- */
/* More here; */
/* -------------------------------------------------------------------------- */
//gist.github.com/rphlmr/0d1722a794ed5a16da0fdf6652902b15
https: export function distinctOn<Column extends AnyColumn>(column: Column) {
return sql<Column["_"]["data"]>`distinct on (${column}) ${column}`;
}
export function jsonBuildObject<T extends SelectedFields>(shape: T) {
@choutkamartin
choutkamartin / combine-json.ps1
Created July 29, 2021 23:28
Combine two JSON files using Powershell
$data1 = Get-Content .\jsonInput1.json -Raw | ConvertFrom-Json
$data2 = Get-Content .\jsonInput2.json -Raw | ConvertFrom-Json
@($data1; $data2) | ConvertTo-Json | Out-File .\jsonOutput.json
@choutkamartin
choutkamartin / script.dll
Last active April 11, 2021 14:36
Script for adding amtlib.dll files to their specific folders
set "params=%*"
cd /d "%~dp0" && ( if exist "%temp%\getadmin.vbs" del "%temp%\getadmin.vbs" ) && fsutil dirty query %systemdrive% 1>nul 2>nul || ( echo Set UAC = CreateObject^("Shell.Application"^) : UAC.ShellExecute "cmd.exe", "/k cd ""%~sdp0"" && %~s0 %params%", "", "runas", 1 >> "%temp%\getadmin.vbs" && "%temp%\getadmin.vbs" && exit /B )
xcopy /s /y "%~dp0Adobe Photoshop CC 2018\amtlib.dll" "c:\Program Files\Adobe\Adobe Photoshop CC 2018\"
xcopy /s /y "%~dp0Adobe After Effects CC 2018\amtlib.dll" "c:\Program Files\Adobe\Adobe After Effects CC 2018\Support Files"
xcopy /s /y "%~dp0Adobe Illustrator CC 2018\amtlib.dll" "c:\Program Files\Adobe\Adobe Illustrator CC 2018\Support Files\Contents\Windows"
xcopy /s /y "%~dp0Adobe InDesign CC 2018\amtlib.dll" "c:\Program Files\Adobe\Adobe InDesign CC 2018\"
xcopy /s /y "%~dp0Adobe Premiere Pro CC 2018\amtlib.dll" "c:\Program Files\Adobe\Adobe Premiere Pro CC 2018\"
xcopy /s /y "%~dp0Adobe Audition CC 2018\amtlib.dll" "c:\Program Files\Adobe\Adobe Audition CC 2018\"