Skip to content

Instantly share code, notes, and snippets.

View dsottimano's full-sized avatar

Dave dsottimano

57 followers · 9 following
View GitHub Profile
@dsottimano
dsottimano / date spine ex
Created January 6, 2023 00:26
WITH calendar AS (
SELECT
date,
EXTRACT(DAYOFWEEK FROM date) day_of_week,
EXTRACT(MONTH FROM date) month,
EXTRACT(YEAR FROM date) year
FROM UNNEST(GENERATE_DATE_ARRAY('2000-01-01', '2020-12-31')) AS date
),
date_spine AS (
SELECT * FROM calendar
@dsottimano
dsottimano / Remove multiple keys from a nested json object
Last active December 29, 2022 23:05
/**
* Recursively deletes specified keys from an object and its nested objects.
* @param {object} obj - The object to delete keys from.
* @param {string[]} keysToDelete - An array of keys to delete.
*/
function deleteKeysRecursive(obj, keysToDelete) {
for (let key in obj) {
if (keysToDelete.includes(key)) {
delete obj[key];
} else if (typeof obj[key] === 'object') {
@dsottimano
dsottimano / bridget
Created September 29, 2020 17:22
def parsepath(string):
try:
string = str(string)
if string[0] == "/":
country = ''
language = ''
category = ''
category_flag = False
split_string = string.split("/")
@dsottimano
dsottimano / 30 second beat code
Last active September 3, 2020 04:19
Beating the apps script custom function 30 second time limit. Alpha? Beta? :P
//David Sottimano
//@dsottimano on Twitter for feedback please!
//lets set up our queue runner to run every 1 minutes
function onOpen() {
ScriptApp.newTrigger('queueRunner')
.timeBased()
.everyMinutes(1)
.create();
@dsottimano
dsottimano / query removal
Last active August 14, 2020 02:30
function REMOVE_SPECIFIC_QUERY(url,queriesToRemove) {
try {
if (!url) return "Error: Missing parameter. To Fix: Ensure you have both parameters set";
if (url.map) url.map(u=> REMOVE_QUERY(u))
else {
let result = "?hello=hi&ga=123"
//if (!result.includes("&")) return url.replace("?" + result,"");
result = result.split("&")
queriesToRemove = queriesToRemove.split(",")
@dsottimano
dsottimano / url parsing thingy
Created July 26, 2020 01:47
console.log([...new Set(new URL('https://www.amazon.com/SanDisk-128GB-microSDXC-Memory-Adapter/dp/B073JYC4XM/memory').pathname.toLowerCase().split(/-|\//gi).filter(Boolean))])
//output handles dupes for casing and removes falsy values
//[ 'sandisk','128gb','microsdxc','memory','adapter','dp','b073jyc4xm' ]
@dsottimano
dsottimano / john
Created July 15, 2020 20:01
<!DOCTYPE html>
<html>
<head>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
</head>
<body>
<div class="container">
<p style="color:red;">Sorry about the email change at the last minute, Google and Gmail decided to block this message as spam, so I can't send it to you. Yeah, I'm changing providers ;)</p>
<p>Thanks for watching my MozCon presentation! Even though it was only 30 minutes, it took me years for me to get to this point.
I’m really excited to share concepts that should help you cut out boring tasks and focus on more important things.</p>
@dsottimano
dsottimano / gist:ed03c97a504fcb63b122ad007988aa47
Created May 4, 2020 16:22
seo dev tools
// ==UserScript==
// @name seo
// @namespace http://tampermonkey.net/
// @version 0.1
// @description try to take over the world!
// @author You
// @include https://*
// @include http://*
// @grant GM_addStyle
// @grant GM_notification
@dsottimano
dsottimano / for Hamlet - index.html
Last active February 4, 2020 12:26
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>Document</title>
<script src="index.js"></script>
</head>
<body>
@dsottimano
dsottimano / for hamlet - index js
Created December 17, 2019 06:25
"use strict";
let exports = {}
Object.defineProperty(exports, "__esModule", { value: true });
class CPT {
constructor() {
this.alphabet = new Set();
this.root = new PredictionTree();
this.II = {};
this.LT = {};
this.data = [];