Scarysize

-- The view
CREATE VIEW session(
    id,
    visitor_id,
    start_utc_time,
    next_start_utc_time
  ) AS
    SELECT
      pi_with_inactivity.visitor_id || '-' || row_number() OVER(
        PARTITION BY pi_with_inactivity.visitor_id

Scarysize

{"lastUpload":"2019-03-16T10:58:57.829Z","extensionVersion":"v3.2.7"}

Scarysize

import soco
from scapy.all import *

# MAC address of your Amazon dash button
DASH_MAC_ADDRESS = '' 

# Name of your Sonos speaker
SPEAKER_NAME = '' 

# Volume values to toggle between

Scarysize

const source = this.map.getSource('my-source');

function loop() {
  source.on('data', requestFrame);
  source.setData(updatedGeoJson);
}

function requestFrame(event) {
  if (event.dataType !== 'source') {
    return;

Scarysize

# wpa_supplicant.conf

# The country code is manadatory, otherwise wifi will be disabled
country=DE
ctrl_interface=DIR=/var/run/wpa_supplicant GROUP=netdev
update_config=1

network={
	ssid="your-ssid"
	psk="your-password"

Scarysize

#!/usr/bin/env python
import re

from pathlib import Path
from subprocess import call
from sys import argv
from yaml import load, YAMLError

config_file_path = Path("gcloud.yaml")

Scarysize

Using snmpwalk, this pulls the ARP table from the agent (e.g. router, switch):

snmpwalk -v 2c -c <community> <agent-ip> 1.3.6.1.2.1.4.22.1.2

OID: http://www.alvestrand.no/objectid/1.3.6.1.2.1.4.22.1.2.html

The ARP information might be stale though.

Scarysize

-- create indices to speed up queries

-- TRIPS
create index trips_trip_id on trips (trip_id);
create index trips_service_id on trips (service_id);

-- STOP_TIMES
create index stop_times_trips on stop_times (trip_id);
create index stop_times_stop_id on stop_times (stop_id);

Scarysize

-- get all trips happening on a regular monday
SELECT
  trips.trip_id
FROM
  trips,
  calendar
WHERE
  calendar.monday == 1
AND
  trips.service_id == calendar.service_id

Scarysize

-- get all stop ids & times of a given trip
SELECT
  stop_times.stop_id,
  stop_times.arrival_time
FROM
  trips,
  stop_times
WHERE
  stop_times.trip_id = '<trip-id>'
;