Alan Coleman alancoleman

## django-website.sh
# This Gist is a list of resources and commands to accompany The Hackershack YouTube series.

# For this attempt I am using Linux / Ubuntu and the demo is on a mac, so I will note any differences as I go along

# BASICS (E01)
# https://www.youtube.com/watch?v=rA4X73E_HV0

# How to install ZSH on Ubuntu:
# https://www.redswitches.com/blog/install-zsh-#ubuntu/#:~:text=Zsh%2C%20or%20Z%20Shell%2C%20is,commands%2C%20and%20improved%20customization%20options.

## gist:56827605553aeabe96bccb6fcfa0f236
## Containers

# Show running containers
docker ps
# Show all containers
docker ps --all
docker ps -a
# Show all container ids
docker ps -q
# Create a container

## gist:87ed807c116d7934878d227d9033bf13
# Compare branches

# Show name of files only
git diff [branch1] [branch2] --name-only

# Merge branches

# Merge with no auto commit
git merge [branch] --no-commit --no-ff

## php-csv-scrubber
echo "\n*** CSV Scrub ***\n"; // Message console

$csvFile = $argv[1];  // Define $csvFile from Konsole argument

/* File */

if (empty($csvFile)) {  //Throw error if $csvFile not defined
  echo "\n*** ERROR: Filename not specified ***\n"; // Message console
  die();
} else {

## AddCompleteCampaignsUsingBatchJob.php
<?php

ini_set('xdebug.var_display_max_depth', -1);
ini_set('xdebug.var_display_max_children', -1);
ini_set('xdebug.var_display_max_data', -1);

/**
 * This code sample illustrates how to use BatchJobService to create a complete
 * campaign, including ad groups and keywords.
 *

## multidimensional_arr_sort.php
/*
array (size=4)
  0 =>
    array (size=2)
      'screen_id' => string 'A0E6457F-EF4F-4BEF-811A-0ACE00AE6225' (length=36)
      'name' => string 'Level 1 - Stalls' (length=16)
  1 =>
    array (size=2)
      'screen_id' => string 'A34D24F8-B1C5-4E26-A1FE-91A3C13A4F10' (length=36)
      'name' => string 'Level 2 - Dress Circle' (length=22)

## update_replace.sql
UPDATE [table] SET url = REPLACE (url, 'a', 'b') WHERE [column] LIKE '%alan%';

-- Produces 'blbn'

## update_column_with_incremented_value.sql
UPDATE table AS t
SET t.id = '';

SET @rank:=0;
update table AS t
set t.id =@rank:=@rank+1

## backup_database_table_using_mysqldump.sh
mysqldump -u [user] -p[password] database_name table_name > destination/backup_file.sql

## filter_email_on_domain.sql
AND (SUBSTRING_INDEX(SUBSTR(email, INSTR(email, '@') + 1),'.',1)) IN('yahoo', 'ymail', 'bt', 'rocketmail', 'msn', 'live', 'hotmail')
	# This Gist is a list of resources and commands to accompany The Hackershack YouTube series.

	# For this attempt I am using Linux / Ubuntu and the demo is on a mac, so I will note any differences as I go along

	# BASICS (E01)
	# https://www.youtube.com/watch?v=rA4X73E_HV0

	# How to install ZSH on Ubuntu:
	# https://www.redswitches.com/blog/install-zsh-#ubuntu/#:~:text=Zsh%2C%20or%20Z%20Shell%2C%20is,commands%2C%20and%20improved%20customization%20options.
	## Containers

	# Show running containers
	docker ps
	# Show all containers
	docker ps --all
	docker ps -a
	# Show all container ids
	docker ps -q
	# Create a container
	# Compare branches

	# Show name of files only
	git diff [branch1] [branch2] --name-only

	# Merge branches

	# Merge with no auto commit
	git merge [branch] --no-commit --no-ff
	echo "\n* CSV Scrub *\n"; // Message console

	$csvFile = $argv[1]; // Define $csvFile from Konsole argument

	/* File */

	if (empty($csvFile)) { //Throw error if $csvFile not defined
	echo "\n* ERROR: Filename not specified *\n"; // Message console
	die();
	} else {
	<?php

	ini_set('xdebug.var_display_max_depth', -1);
	ini_set('xdebug.var_display_max_children', -1);
	ini_set('xdebug.var_display_max_data', -1);

	/**
	* This code sample illustrates how to use BatchJobService to create a complete
	* campaign, including ad groups and keywords.
	*
	/*
	array (size=4)
	0 =>
	array (size=2)
	'screen_id' => string 'A0E6457F-EF4F-4BEF-811A-0ACE00AE6225' (length=36)
	'name' => string 'Level 1 - Stalls' (length=16)
	1 =>
	array (size=2)
	'screen_id' => string 'A34D24F8-B1C5-4E26-A1FE-91A3C13A4F10' (length=36)
	'name' => string 'Level 2 - Dress Circle' (length=22)
	UPDATE [table] SET url = REPLACE (url, 'a', 'b') WHERE [column] LIKE '%alan%';

	-- Produces 'blbn'
	UPDATE table AS t
	SET t.id = '';

	SET @rank:=0;
	update table AS t
	set t.id =@rank:=@rank+1