Skip to content

Instantly share code, notes, and snippets.

View andyj's full-sized avatar

Andy Jarrett andyj

29 followers · 13 following
View GitHub Profile
@andyj
andyj / html_for_international_calling coes.htm
Created October 22, 2013 21:57
HTML <select> international calling codes for each country
<!-- country codes (ISO 3166) and Dial codes. -->
<select name="countryCode" id="">
<option data-countryCode="GB" value="44" Selected>UK (+44)</option>
<option data-countryCode="US" value="1">USA (+1)</option>
<optgroup label="Other countries">
<option data-countryCode="DZ" value="213">Algeria (+213)</option>
<option data-countryCode="AD" value="376">Andorra (+376)</option>
<option data-countryCode="AO" value="244">Angola (+244)</option>
<option data-countryCode="AI" value="1264">Anguilla (+1264)</option>
<option data-countryCode="AG" value="1268">Antigua &amp; Barbuda (+1268)</option>
@andyj
andyj / excel2html.htm
Created September 16, 2011 04:13
Paste Excel in to HTML to create at <table>
<html>
<head>
<style>
*{
font-family: arial;
font-size: 11px;
}
table{
border-collapse: collapse;
border: 1px solid silver;
@andyj
andyj / graphically-represent-a-directory-structure-using-find-and-sed.sh
Created August 15, 2023 11:31
Graphically represent a directory structure using Find and Sed
#!/bin/bash
# Use FIND over TREE when you want to exclude folders like node_modules
find /path/to/folder -type d -name "node_modules" -prune -o -print | sed -e 's;[^/]*/;|____;g;s;____|; |;g'
@andyj
andyj / graphically-represent-a-directory-structure-using-tree.sh
Created August 15, 2023 11:29
Method 1: Graphically represent a directory structure from the CLI
#!/bin/bash
tree /path/to/folder -L 2
@andyj
andyj / generateMarkdown.js
Created July 21, 2023 11:35
Turn a GHOST.db posts in to mark down
// Import required modules
const sqlite3 = require('sqlite3').verbose(); // SQLite3 module for database operations
const fs = require('fs').promises; // File System module for file operations
const { promisify } = require('util'); // Util module to convert callback-based functions to promises
/**
* Generates Markdown files from data in the SQLite database and sets their metadata.
* The Markdown files are organized in folders based on the "posted" date from the database.
*/
(async () => {
@andyj
andyj / uptime_check.sh
Last active April 12, 2023 11:15
#!/bin/bash
# This script is provided "as is" and without warranty of any kind, express or implied, including but not limited to the warranties of merchantability, fitness for a particular purpose and noninfringement. In no event shall the author be liable for any claim, damages or other liability, whether in an action of contract, tort or otherwise, arising from, out of or in connection with the script or the use or other dealings in the script. Use at your own risk.
# This is a bash script that checks the HTTP response of a list of top-level domain names
# every 1 minute. If a domain returns an HTTP status code other than 200 OK, the script
# sends a callback to a specified URL with the name of the domain that failed.
#
# The list of domains and callback URL can be edited
#
# You could also use CRON to ensure this file is alway running e.g.
@andyj
andyj / nginx.conf
Last active November 16, 2020 01:36 — forked from tonyjunkes/nginx.conf
Server portion for setting up a proxy to Lucee with rewrite to have index.cfm omitted for SES.
http {
...
server {
listen 80;
server_name example.com;
root /var/www/exmaple.com/www/;
index index.cfm;
set $lucee_context "example.com";
@andyj
andyj / webssql.htm
Created January 12, 2012 09:23
Look at the basics of WebSQL
<html>
<head>
<title>Look at WebSQL</title>
<script>
// Through the code below remember essentialy there are just 3 core methods we tend to use
// openDatabase
// transaction
// executeSql
// Opening a connection
@andyj
andyj / docker_commands.sh
Last active July 22, 2019 14:15
Essential Docker commands for .bash_profiles wrapped up as terminal functions
MY_IP=127.0.0.1
#Ubuntu
#MY_IP=$(wget -qO- icanhazip.com)
#MAC
#MY_IP=$(ifconfig en0 | grep "inet 1" | awk '/inet/ { print $2 } ')
echo Current IP: $MY_IP
@andyj
andyj / bash_script_to_back_up_mysql_to_s3.sh
Last active April 2, 2019 08:54
Bash script to backup a MySQL RDS dump to S3
# From Andy Jarretts post:
# http://www.andyjarrett.co.uk/2016/08/02/secured-bash-script-to-backup-a-mysql-rds-dump-to-s3/
#!/bin/bash
SQLDUMP="$(date +'%Y%m%d%H%M').sql.gz"
echo "Creating backup of database to $SQLDUMP"
mysqldump --login-path=local --databases YourDatabaseName | gzip -9 > $SQLDUMP
echo "Dump Zipped up"