jazlopez

DROP TRIGGER IF EXISTS db_enrollments.on_insert_transaction_creates_event;
DROP TRIGGER IF EXISTS db_enrollments.on_udate_transaction_record_event_transitions;
DROP TABLE IF EXISTS events;
DROP TABLE IF EXISTS transacts;

CREATE TABLE transacts (
    transact_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    transact_status ENUM("CREATED", "IN_MEM", "RELEASE_MEM", "PROC_STALL", "OK", "FAILED") DEFAULT "CREATED",
    transact_data TEXT NULL,
    transact_deleted TINYINT NOT NULL DEFAULT 0, -- soft delete (retain transact status information to easy rollback)

jazlopez

awsprofiles(){
  grep -Eo "\[.*\]" $HOME/.aws/credentials | sed 's/[][]//g' | nl
}

prompt_goto(){
  local mopts=$1
  tput cup $mopts 1
  echo "Go to: "
  tput cup $mopts 8
}

jazlopez

__URL__=""

while :
  do
    printf "${GREEN_FG}"
    printf "╭─      \n"
    printf "│ URL:  \n"
    printf "╰─○     \n"
    tput cuu 2

jazlopez

# ---------------------------------------------
# Custom Configurations for CURL
# Usage instructions:
#   Download this file and save it at: $HOME/.curlrc
# Contact: Jaziel Lopez Software Engineer Tijuana Area, BC MX

# store the trace in curl_trace.txt file. beware that multiple executions of the curl command will overwrite this file
# --trace curl_trace.txt

# store the header info in curl_headers.txt file. beware that multiple executions of the curl command will overwrite this file

jazlopez

Exploring Linux Command-Line Tools

---

Summarize features that Linux shells offer to speed up command entry.

The command history often enables you to retrieve an earlier command that’s similar or identical to the one you want to enter. Tab completion reduces typing effort by letting the shell finish long command names or filenames. Command-line editing lets you edit a retrieved command or change a typo before committing the command.

Describe the purpose of the man command.

The man command displays the manual page for the keyword (command, filename, system call, or other feature) that you type. This documentation provides succinct summary information that’s useful as a reference to learn about exact command options or features.

jazlopez

tell application "Finder" to make new Finder window

jazlopez

tell application "Finder" to set the target of the front Finder window to home

jazlopez

tell application "Finder" to get the target of the front Finder window

jazlopez

tell application "Finder"
	set currentDir to (target of front Finder window) as text
end tell
do shell script "cd " & (quoted form of POSIX path of currentDir) & "; ls"

jazlopez

#!/bin/sh

# Writes an APR1-format password hash to the provided <htpasswd-file> for a provided <username>
# This is useful where an alternative web server (e.g. nginx) supports APR1 but no `htpasswd` is installed.
# The APR1 format provides signifcantly stronger password validation, and is described here: 
#	 http://httpd.apache.org/docs/current/misc/password_encryptions.html

help (){
cat <<EOF
  Usage: $0 <htpasswd-file> <username>