paulmwatson

# Minor modification to https://github.com/motherduckdb/metabase_duckdb_driver?tab=readme-ov-file#docker
FROM openjdk:21-buster

ENV MB_VERSION=v0.55.5
ENV MB_PLUGINS_DIR=/home/plugins/

ADD https://downloads.metabase.com/${MB_VERSION}/metabase.jar /home
ADD https://github.com/motherduckdb/metabase_duckdb_driver/releases/download/0.3.1/duckdb.metabase-driver.jar /home/plugins/

RUN chmod 744 /home/plugins/duckdb.metabase-driver.jar

paulmwatson

git clean -d -x -f -n

paulmwatson

cy.visit('/404')
//=> Test fails

cy.visit('/404', {failOnStatusCode: false})
//=> Test passes but does not test the HTTP code was 404

cy.request({url: '/404', failOnStatusCode: false}).its('status').should('equal', 404)
cy.visit('/404', {failOnStatusCode: false})
//=> Test passes, tests that the HTTP code was 404, and tests page was visited

paulmwatson

# Python to return the IAM details of an access key
import boto3
client = boto3.client('sts', aws_access_key_id="ACCESS_KEY_ID", aws_secret_access_key="SECRET")
client.get_caller_identity()
=> {'UserId': '...', 'Account': '...', 'Arn': 'arn:aws:iam::...:user/...', 'ResponseMetadata': {'RequestId': '...', 'HTTPStatusCode': 200, 'HTTPHeaders': {'x-amzn-requestid': '...', 'content-type': 'text/xml', 'content-length': '409', 'date': '...'}, 'RetryAttempts': 0}}

paulmwatson

docker run -it --rm -v /dir/to/code:/app python:3.9 bash

paulmwatson

# Creates multiple files from one geojson file
require 'json'

file = File.read('data.geojson')
data_hash = JSON.parse(file)
data_hash['features'].each do |feature|
    file_name = feature['properties']['OBJECTID']
    File.open("#{file_name}.geojson", 'w') do |f|
        f.write(feature.to_json)
    end

paulmwatson

import tweepy
import os 

API_KEY = os.getenv('API_KEY')
API_SECRET = os.getenv('API_SECRET') 

auth = tweepy.AppAuthHandler(API_KEY, API_SECRET)
api = tweepy.API(auth, wait_on_rate_limit=True) 
items = tweepy.Cursor(api.user_timeline, screen_name='NPATweets', count=200).items(3200)

paulmwatson

version: '3'

services:
  app:
    build: .
    image: app
    depends_on:
      - db
    environment:
      - DATABASE_URL=postgresql://db:db@pgbouncer/db

paulmwatson

'use strict';

exports.handler = (event, context, callback) => {    
    var response = {
        "statusCode": 302,
        "headers": {
            "location": "https://new-domain.tld"
        },
        "body": "{}",
        "isBase64Encoded": false

paulmwatson

// A simple bookmarklet that searches Twitter with the URL you are on.
// Before you Tweet your own hot-take see what others are saying and ReTweet them instead.
// Author: @paulmwatson
// License: MIT
// Notes: It first looks for the "canonical" URL before falling back to the window.location.
//        It strips any URL parameters e.g. UTM and keeps just the protocol, host, and path.
//        This broadens the search as often UTM or other identifiers are unique to your session
//        and Twitter's search will return no results. However it can be inacurate on websites
//        that use URL parameters to identify content to show.
// Usage: Visit an article on a website like Buzzfeed.com and click the bookmarklet. A new tab