dsottimano’s gists

dsottimano / gist:d934ce5c780c03d009f51102318f3840

Created August 19, 2024 11:16

delete_me

	import base64
	import vertexai
	from vertexai.generative_models import GenerativeModel, SafetySetting
	import vertexai.preview.generative_models as generative_models
	import pandas as pd
	import os
	import time

	gcp_project_id =

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 / 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 / bridget

Created September 29, 2020 17:22

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 / 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 / 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 / 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 / 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 / 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>

Dave dsottimano