richard087’s gists

richard087 / purge_schema.sql

Last active October 1, 2020 01:16

	set echo off
	set verify off
	set serveroutput on size 100000

	-- Hosted at http://lastinfinitetentacle.blogspot.com/2012/03/empty-oracle-schema-leave-empty-schema.html

	-- Disable all contraints
	BEGIN
	FOR c IN
	(SELECT c.owner, c.table_name, c.constraint_name

richard087 / parseCSV.js

Created July 29, 2013 03:16

	// hosted at http://lastinfinitetentacle.blogspot.com.au/2011/10/csv-parser-in-javascript.html
	var textToArray = function (txtLine, del, txtQual) {
	"use strict";
	var datArr = [], newStr = "";
	while (txtLine.length > 0) {
	if (txtLine.substr(0, txtQual.length) === txtQual) {
	// get quoted block
	newStr = txtLine.substr(0, txtQual.length + txtLine.indexOf(txtQual, txtQual.length));
	datArr.push(newStr.substr(txtQual.length, newStr.length - txtQual.length * 2));
	}

richard087 / viewcam.sh

Created July 29, 2013 03:18

	# described at http://lastinfinitetentacle.blogspot.com.au/2013/06/viewing-d-link-dcs-932l-ip-camera-from.html
	avconv -r 15 -f mjpeg -i http://USERNAME:PASSWORD@IP-ADDRESS/video.cgi -i http://USERNAME:PASSWORD@IP-ADDRESS/audio.cgi -vcodec mpeg4 -f mpegts file:///dev/stdout \| vlc file:///dev/stdin

	# silent version
	avconv -r 15 -f mjpeg -i http://USERNAME:PASSWORD@IP-ADDRESS/video.cgi -vcodec mpeg4 -f mpegts file:///dev/stdout \| vlc file:///dev/stdin

richard087 / tokenReplace.bat

Last active April 15, 2024 09:53

Batch file to do a token replacement on a text file, in Windows.

	@echo off
	rem sourced from http://stackoverflow.com/questions/5273937/how-to-replace-substrings-in-windows-batch-file
	setlocal enabledelayedexpansion
	set INTEXTFILE=test.txt
	set OUTTEXTFILE=test_out.txt
	set SEARCHTEXT=bath
	set REPLACETEXT=hello
	set OUTPUTLINE=

	for /f "tokens=1,* delims=¶" %%A in ( '"type %INTEXTFILE%"') do (

richard087 / forking-tiny-web-server.pl

Last active March 14, 2019 23:16

Forking tiny HTTP server in perl. Compatible with almost any perl v5 - very handy with git bash on Windows.

	#!/usr/bin/env perl

	# forking tiny HTTP server
	# a toy web server

	# thanks to
	# [email protected] - https://gist.githubusercontent.com/keiya/2782414/raw/811565ccfa479a9e12d0653e2f5118e68e7fda37/server.pl

	use strict;
	use warnings;

richard087 / MySql-ABN-validation-test.sql

Last active August 28, 2020 17:12

Validate Australian Business Number (ABN) in MySql 5.7 WHERE CLAUSE, including unit tests.

	select * from (
	select '43077535605' as abn, 1 as correct
	union all
	select '33 102 417 032' as abn, 1 as correct
	union all
	select '29002589460' as abn, 1 as correct
	union all
	select '33 102 417 032asdfsf' as abn, 0 as correct
	union all
	select '444' as abn, 0 as correct

richard087 / MySql-ACN-validation-test.sql

Last active August 28, 2020 17:57

Validate Australian Company Number (ACN) in MySql 5.7 WHERE clause, including test cases

	select * from (
	select '000 000 019' as acn, 1 as correct
	union all
	select '009 749 964' as acn, 1 as correct
	union all
	select '006 999 980' as acn, 1 as correct
	union all
	select '005999977' as acn, 1 as correct
	union all
	select '000 000 019asdfsf' as acn, 0 as correct

richard087 / T-SQL-ACN-validation-test.sql

Last active August 28, 2020 18:08

Validate Australian Company Number (ACN) in T-SQL for SQL Server WHERE clause, including test cases

	select * from (
	select '000 000 019' as acn, 1 as correct
	union all
	select '009 749 964' as acn, 1 as correct
	union all
	select '006 999 980' as acn, 1 as correct
	union all
	select '005999977' as acn, 1 as correct
	union all
	select '000 000 019asdfsf' as acn, 0 as correct

richard087 / T-SQL-ABN-validation-test.sql

Last active August 28, 2020 18:23

Validate Australian Business Number (ABN) in T-SQL for SQL Server WHERE clause, including test cases

	select * from (
	select '43077535605' as abn, 1 as correct
	union all
	select '33 102 417 032' as abn, 1 as correct
	union all
	select '29002589460' as abn, 1 as correct
	union all
	select '33 102 417 032asdfsf' as abn, 0 as correct
	union all
	select '444' as abn, 0 as correct

richard087 / run_CP2077_patches.ps1

Last active June 28, 2023 12:33

USE AT OWN RISK! A collection of functions to make it easier to manage Cyberpunk 2077 mods. This is NOT a mod manager. You will need to understand how to use/manage Subversion to get any value from this.

	# install SVN
	# tested with Slik SVN 1.14.2 from https://sliksvn.com/download/

	#CONFIGURATION
	#where should Subversion store its data?
	$svn_data = "D:\Temp\repo"

	#where will your downloaded mod files be kept?
	$dir_download = "$env:USERPROFILE\Downloads"

Richard C richard087