adgedenkers’s gists

adgedenkers / GetTeamNameOrAbbreviation.sql

Created November 15, 2023 12:12

	CREATE PROCEDURE GetTeamNameOrAbbreviation
	@team NVARCHAR(255),
	@slot INT
	AS
	BEGIN
	IF @slot = 0
	BEGIN
	-- Extract and return the part before the parentheses
	RETURN LEFT(@team, CHARINDEX(' (', @team) - 1)
	END

adgedenkers / work_code_file_header.txt

Created November 1, 2023 16:13

	'''
	File: (script-name)
	Version: (script version number)
	Description: (description of script)
	Project: (project name)
	Created Date: (date file created [yyyy-mm-dd format])
	Author: Adge Denkers
	Email: adriaan.denkers@va.gov
	-----
	Last Modified: (date file updated [yyyy-mm-dd format])

adgedenkers / personal_code_file_header.txt

Created November 1, 2023 15:45

	'''
	Name: (script-name)
	Description: (description of script)
	Author: Adge Denkers / https://github.com/adgedenkers/
	Created: (creation date)
	Updated: (last update date)
	(C) (current year) denkers.co
	'''

adgedenkers / CheckPipUpdate.ps1

Created October 31, 2023 12:27

Check to see if pip needs to be updated

	'''
	Name: CheckPipUpdate.ps1
	Description: Checks if pip needs to be updated, and updates it if necessary.
	Author: Adge Denkers / github.com/adgedenkers/
	Created: 10/31/2023
	Updated: 10/31/2023
	(C) 2023 denkers.co
	'''

	function Get-InstalledPipVersion {

adgedenkers / shave_and_haircut__horn.ino

Created October 22, 2023 15:41

Car Horn and Relay play Shave and a Haircut

	/*
	Name: shave_and_haircut__horn.ino
	Description: Plays the tune "Shave and a Haircut" on a car horn when a dashboard button is pressed.
	Author: Adge Denkers / github.com/adgedenkers/
	Created: October 22, 2023
	Updated: October 22, 2023
	(C) 2023 denkers.co
	*/

	const int buttonPin = 2; // Pin connected to the dashboard button

adgedenkers / turn_on_led.ino

Created October 22, 2023 15:40

Hello World of Gemma Programming - Turn on an LED

	/*
	Name: LED_Controller.ino
	Description: Lights an LED connected to pin D1 when Gemma v3 is powered on, and keeps the LED on.
	Author: Adge Denkers / github.com/adgedenkers/
	Created: October 22, 2023
	Updated: October 22, 2023
	(C) 2023 denkers.co
	*/

	void setup() {

adgedenkers / shave_and_haircut__led.ino

Created October 22, 2023 15:39

Flashes an LED in the pattern of the tune "Shave and a Haircut" when Gemma v3 is powered on.

	/*
	Name: Shave_and_a_Haircut_LED.ino
	Description: Flashes an LED in the pattern of the tune "Shave and a Haircut" when Gemma v3 is powered on.
	Author: Adge Denkers / github.com/adgedenkers/
	Created: October 22, 2023
	Updated: October 22, 2023
	(C) 2023 denkers.co
	*/

	void setup() {

adgedenkers / make__dim_date.py

Last active October 28, 2023 19:08

Create an empty SQLite Database, and add a fairly robust date dimension to it

adgedenkers / gitignore_for_python

Last active October 25, 2023 17:06

.gitignore File for Most Python Applications

	# adge's special stuff
	setup*.py
	*setup.py
	secrets.py

	# Byte-compiled / optimized / DLL files
	__pycache__/
	*.py[cod]
	*$py.class

adgedenkers / get_latest_python_for_windows.ps1

Created September 18, 2023 17:22

Find and Download the Latest Python Script Using PowerShell

	<#
	Project: powershell_dev
	File: get_latest_python_for_windows.ps1
	Author: Adge Denkers
	License: MIT License
	#>

	# Define the root and downloads URLs
	$rootUrl = "https://python.org"
	$downloadsUrl = "$rootUrl/downloads/windows/"

adge denkers adgedenkers