Skip to content

Instantly share code, notes, and snippets.

View drio's full-sized avatar
🐢
I don't know

David Rio Deiros drio

🐢
I don't know
View GitHub Profile
@drio
drio / Makefile
Last active December 17, 2021 19:53
log4j bug checker
BIN_DIR=./bin
L4J_ID=CVE-2021-44228
# To make sure some binaries exists in path
BINARIES = curl sh python3
K := $(foreach exec,$(BINARIES),\
$(if $(shell which $(exec)),some string,$(error "No $(exec) in PATH")))
define PARSE
import json
BIN_DIR=./bin
# To make sure some binaries exists in path
BINARIES = curl sh python3
K := $(foreach exec,$(BINARIES),\
$(if $(shell which $(exec)),some string,$(error "No $(exec) in PATH")))
all: as_root deps root_grype.json output.txt
output.txt: ./parser.py
@drio
drio / s31.txt
Created December 16, 2021 13:27
esphome s31 sonoff
INFO Successfully compiled program.
Found multiple options, please choose one:
[1] /dev/cu.usbmodem101NTLE2B8162 (USB Controls)
[2] /dev/cu.usbserial-13410 (USB2.0-Ser!)
[3] /dev/cu.usbserial-ABSCDZBH (FT232R USB UART)
[4] Over The Air (sonoff_s31.local)
(number): 3
esptool.py v3.2
Serial port /dev/cu.usbserial-ABSCDZBH
Connecting....
Hi,
This is actually populating a view in the DW, not sure what format it’s expecting. Question for Mike or Larry perhaps? I don’t think anything fails until Tableau tries to create the extract, so it’s not the DW getting angry about the format, it’s Tableau.
SQL below:
create or replace view vaccine_vw
(email, vax1, vax_dt1, vax_dt2, response_date, emplid, utln, last_name, first_name, pref_phone, tufts_email, person_type, campus, employee_home_dept_ld, school, academic_career, risk, deptid, supervisor_name, employee_jobtitle, hire_dt, type_of_entry, date_approved, vax_source)
as
with
@drio
drio / links.py
Created December 7, 2021 20:43
table column names to csv header names
@drio
drio / latest-dump.txt
Created December 7, 2021 19:57
latest dump
1: Start Date
2: End Date
3: Response Type
4: IP Address
5: Progress
6: Duration (in seconds)
7: Finished
8: Recorded Date
9: Response ID
10: Recipient Last Name
@drio
drio / september.txt
Created December 7, 2021 19:56
sep-2021 dump
1: StartDate
2: EndDate
3: Status
4: IPAddress
5: Progress
6: Duration (in seconds)
7: Finished
8: RecordedDate
9: response_date
10: response_time
/* eslint-disable no-unused-vars */
import React from "react";
import styled from "styled-components";
import { COLORS } from "../../constants";
import VisuallyHidden from "../VisuallyHidden";
const STYLES = {
small: {
height: 8,
@drio
drio / chunk.js
Created November 12, 2021 16:52
slate chunk js
(function(){const o="hubspotutk";const t='[data-export="sys:field:hubspot_cookie"] > div > input';function n(o){const t=`; ${document.cookie}`;const n=t.split(`; ${o}=`);return n.length===2?n.pop().split(";").shift():"not_found"}const e=n(o);const c=document.querySelectorAll(t);console.log("Cookie value:",e);console.log("Hidden elem found:",c.length===1);if(c){c.value=e}})();
@drio
drio / tez.txt
Created August 24, 2021 11:52
Tez verification
I am attesting that this GitHub handle drio is linked to the Tezos account tz1KnTFKFWWFGphXugHWGvZD4V7Dhjf2dBYq for tzprofiles
sig:edsigu6XLADdM8cyRz7sZaZmz4Xfw6Wx5LSx499K8rmhMXeianHTyZYUwcuh72AZ6SdzW3bLg3ZmcURnKK1vyrJyDQ3XBFA9ykR