WW Henderson davesgonechina

Solicitor and Commissioner for Oaths

davesgonechina / list-dbt-tags-in-use.txt

Last active March 28, 2024 13:43

List tags in a dbt project

	# Found in https://github.com/dbt-labs/dbt-core/issues/7749

	1. Install jq
	2. dbt --quiet ls --output json --output-keys tags \| jq .tags \| jq -s 'add \| unique'

davesgonechina / gist:3932f9f56287ab340b234afab1ab0c52

Last active October 4, 2017 16:37

bash concat multiple csvs

	head -1 file1.csv > final.csv
	IFS=$(echo -en "\n\b")
	for filename in $(ls file*.csv); do sed 1d $filename >> final.csv; done

davesgonechina / Fix sudo gittery permissions

Last active July 12, 2017 14:16

Error while pull from git - insufficient permission for adding an object to repository database .git/objects

	### repair working tree after an accidental sudo

	sudo chown -R $USER:$USER "$(git rev-parse --show-toplevel)/.git"

davesgonechina / PostgreSQL PK value violation testing

Last active March 8, 2017 20:34

PostgreSQL PK value violation testing

	select pg_get_serial_sequence(TABLENAME,'id'); //check sequence id
	select MAX(id) from TABLENAME; //Check current max for id
	select nextval(RESULTOFPG_GET_SERIAL_SEQUENCE); //Increment sequence id
	INSERT INTO TABLENAME(NONPKCOLUMN) VALUES(null); //test insert
	SELECT setval(RESULTOFPG_GET_SERIAL_SEQUENCE, (SELECT MAX(id) FROM TABLENAME));

davesgonechina / MySQL dedup

Last active January 27, 2017 02:16

MySQL dedup

	CREATE TABLE new_table as
	SELECT * FROM old_table WHERE 1 GROUP BY [column to remove duplicates by];