View sql_query.py
#!/usr/bin/env python | |
import psycopg2 | |
try: | |
login = "dbname='YourDatabaseName' user='Adam' host='127.0.0.1' " + \ | |
"password='MyPa$$word'" | |
# Establish a connection | |
conn = psycopg2.connect(login) | |
# Create a psycopg2 cursor that can execute queries |
View rotate-images.py
#!/usr/bin/env python | |
import os | |
import fnmatch | |
import argparse | |
import sys | |
import cv2 | |
# Intro Text | |
print("\033[1;34;40m\n\nRotate images \033[0m") |
View ImageJ_Loop_Through_Files_Headless.ijm
// Blank ImageJ Macro Script that loops through files in a directory | |
// Written by Adam Dimech | |
// https://code.adonline.id.au/imagej-batch-process-headless/ | |
// Specify global variables | |
#@String input | |
#@String suffix | |
// Add trailing slashes |
View database_tables_to_csv.sql
/* | |
1. Log in to psql as a superuser | |
2. CHMOD target directory to 777 | |
3. Execute via SELECT db_to_csv('/path/to/output'); | |
4. Use complete file path. | |
*/ | |
CREATE OR REPLACE FUNCTION db_to_csv(path TEXT) RETURNS void AS $$ | |
declare | |
tables RECORD; |
View ImageJ_Loop_Through_Files.ijm
// Blank ImageJ Macro Script that loops through files in a directory | |
// Written by Adam Dimech | |
// Also available at https://gist.github.com/AdamDimech/cd3999f6fe9eddfa55c19d6fd3997bbc | |
// Specify global variables | |
input = getDirectory("Input Directory"); | |
output = input; // Output images to the same directory as input (prevents second dialogue box, otherwise getDirectory("Output Directory")) | |
Dialog.create("File Type"); | |
Dialog.addString("File Suffix: ", ".png", 5); |
View Date_Time_Output.ijm
// ImageJ Macro Code | |
// Output timestamp in format EEE dd MMM yyyy, hh:mm:ss | |
MonthNames = newArray("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"); | |
DayNames = newArray("Sun", "Mon","Tue","Wed","Thu","Fri","Sat"); | |
getDateAndTime(year, month, dayOfWeek, dayOfMonth, hour, minute, second, msec); | |
print (DayNames[dayOfWeek], dayOfMonth, MonthNames[month], year + "," + hour + ":" + minute + ":" + second); |
View UNC-from-file-path.ps1
# UNC File Path Finder | |
# Written by Adam Dimech | |
# Based on https://code.adonline.id.au/unc-path-from-local-path-in-powershell/ | |
# 1 March 2017 | |
Add-Type -AssemblyName System.Windows.Forms | |
$FileBrowser = New-Object System.Windows.Forms.OpenFileDialog -Property @{ | |
Multiselect = $false # Only one file can be chosen | |
InitialDirectory = "::{20D04FE0-3AEA-1069-A2D8-08002B30309D}"; #Opens in My Computer | |
Filter = 'All File Types|*.*' # Specified file types |
View Local-Path-to-UNC-Path.ps1
$Drive = $(get-location).Path | |
$x = new-object system.io.driveinfo($Drive) | |
$x.drivetype | Out-Null | |
If ($x.drivetype -eq "Fixed") { | |
Write-Host "`r`n`r`nSorry," $Drive "is not a networked drive." | |
} | |
Else { | |
$currentDirectory = Get-Location | |
$currentDrive = Split-Path -qualifier $currentDirectory.Path |
View Local-to-UNC.ps1
$currentDirectory = Get-Location | |
$currentDrive = Split-Path -qualifier $currentDirectory.Path | |
$logicalDisk = Gwmi Win32_LogicalDisk -filter "DriveType = 4 AND DeviceID = '$currentDrive'" | |
$unc = $currentDirectory.Path.Replace($currentDrive, $logicalDisk.ProviderName) | |
$output = "`r`n`r`nThe UNC Path for " + $currentDirectory + " is " + $unc | |
$output |
View PDF_Grabber.ps1
# More information at https://code.adonline.id.au/download-all-pdfs-from-a-web-page/ | |
function Grab-PDFs { | |
[Reflection.Assembly]::LoadWithPartialName("System.Windows.Forms") | Out-Null | |
[System.Windows.Forms.Application]::EnableVisualStyles() | |
$browse = New-Object System.Windows.Forms.FolderBrowserDialog | |
$browse.SelectedPath = "C:\" | |
$browse.ShowNewFolderButton = $false | |
$browse.Description = "Select a directory" |
NewerOlder