Johno Scott johnoscott

Open in Visual Studio Code

Open Automator
Create a new document
Select Quick Action
Set “Service receives selected” to files or folders in any application
Add a Run Shell Script action
- your default shell should already be selected, otherwise use /bin/zsh for macOS 10.15 (”Catalina”) or later
- older versions of macOS use /bin/bash
if you're using something else, you probably know what to do 😉

Getting Started With Plug'n'Play

If you use create-react-app, #5136 (released with the 2.0) implements a --use-pnp option that allows you to easily create a new project using PnP! In this case, just use create-react-app --use-pnp together with Yarn 1.12, and you're good to go! 👍

Plug'n'Play is a new initiative from Yarn that aims to remove the need for node_modules. It's already available, and has proved being effective even on large-scale infrastructures. This document describes in a few steps how to quickly get started with it. Spoiler alert: it's quite easy 🙂

First, download a package manager that supports it. Yarn 1.12 already does, so that's what we're going to use! To install it, just follow the instructions on our website: https://yarnpkg.com/en/docs/install

If everything is ok, running yarn --version should give you v1.12.1 or higher. If you don't get this result maybe a

Installing ngrok on OSX

For Homebrew v2.6.x and below:

brew cask install ngrok

For Homebrew v2.7.x and above:

Pure ESM package

The package linked to from here is now pure ESM. It cannot be require()'d from CommonJS.

This means you have the following choices:

Use ESM yourself. (preferred)
Use import foo from 'foo' instead of const foo = require('foo') to import the package. Follow the below guide.
If the package is used in an async context, you could use await import(…) from CommonJS instead of require(…).
Stay on the existing version of the package until you can move to ESM.

	# --------------------------------------------------------------
	# Customer Support Ticket Classification System
	# --------------------------------------------------------------

	import instructor
	from pydantic import BaseModel, Field
	from openai import OpenAI
	from enum import Enum
	from typing import List

	# https://hub.docker.com/_/postgres

	# Usage:
	# $ docker compose up

	# NOTE: version not required as of compose spec v
	# version: '3.7'

	# docker run --name basic-postgres --rm \
	# -e POSTGRES_USER=postgres \

	/** @OnlyCurrentDoc */

	const startDate = new Date("2021-06-16")
	// so the first one is D2:K2
	function MarkEmptyCellsInYesterdayRowWithHyphen() {
	const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Group 2 - B");
	// Activates the sheet
	SpreadsheetApp.setActiveSheet(sheet);

	const today = new Date()

	import boto3
	import datetime
	import json
	from requests_aws4auth import AWS4Auth
	import requests

	boto3.setup_default_session(region_name='us-east-1')
	identity = boto3.client('cognito-identity', region_name='us-east-1')

	account_id='XXXXXXXXXXXXXXX'

	## Connect PG8000 to database
	conn = pg8000.connect(database=args['db_name'],user=args['db_user'],password=args['db_password'],host=args['db_host'],port=5432)
	cur = conn.cursor()
	# ...
	# Example upsert query
	cur.execute("INSERT INTO {} SELECT * FROM {} ON CONFLICT (id) DO UPDATE SET name = EXCLUDED.name".format('campaigns', 'tmp_staging_campaings'))
	# ...
	conn.commit()
	cur.close()
	conn.close()