Michael Diener mdiener21

Make the daisy Create the white cross Solve the first layer Solve the second layer Create the yellow cross: F U R U' R' F' Solve the yellow face: R U R' U R U2 R' Move yellow stickers upper right-hand corner of left-face Orient "fish" down and to the left relative to your perspective

	# cmr - open a GitLab merge request branch in a separate Git worktree

	# Usage: cmr <MR_ID> [REMOTE]

	# Example: cmr 1234 origin

	# Uses 'origin' when no remote is provided.

	# The worktree is created one directory above the repository using the branch name.

	# set local credentials
	git config --global credential.helper store
	git config --global user.name "$GITLAB_USER_NAME"
	git config --global user.email "$GITLAB_USER_EMAIL"

	# update remote url
	git remote set-url origin <NEW_GIT_URL_HERE>


	# git commits per developer

	import requests

	def delete_layer(layer_name):
	s = requests.Session()
	GEOSERVER_USER = 'someusername'
	GEOSERVER_PASS = 'asecretthingy'
	s.auth = (GEOSERVER_USER, GEOSERVER_PASS)
	headers_json = {'Content-type': 'application/json', }
	del_url = "https:/yourgeoserver.com/workspaces/SsmeWorkspaceName/datastores/someDataStoreName/featuretypes/" + layer_name + "?recurse=true"
	r = s.delete(del_url, headers=headers_json, data={})

	# git commits per developer
	git shortlog -sn --no-merges --since "01 January 2019"

	# a clearer better git log view of commits
	git log --graph --pretty=format:'%Cred%h%Creset -%C(yellow)%d%Creset %s %Cgreen(%cr) %C(bold blue)<%an>%Creset' --abbrev-commit

	#!/bin/bash -e
	set -o pipefail

	# Any arguments are incorrect. Note that git intercepts --help and tries to
	# open the man page.
	if [ $# -gt 0 ]; then
	echo 'Usage: git merge-stats'
	exit 1
	fi

	git config --global alias.wta '!f() { git worktree add -b "$1" "../$1"; }; f'
	git config --global alias.wtr '!f() { git worktree remove "../$1"; }; f'
	git config --global alias.wtl '!f() { git worktree list; }; f'

	UPDATE multipoly_table_with_rings AS myrings
	SET geom = noring.geom
	FROM (
	SELECT id, ST_Collect(ST_MakePolygon(geom)) AS geom
	FROM (
	SELECT id, ST_NRings(geom) AS nrings,
	ST_ExteriorRing((ST_Dump(geom)).geom) AS geom
	FROM multipoly_table_with_rings
	WHERE ST_NRings(geom) > 1
	) AS foo

	SELECT DISTINCT s.id, s.tags
	FROM myspace_polys as s
	JOIN mypoi_points as as p
	ON ST_Contains(s.geom, p.geom);