johnoscott

/** @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()

johnoscott

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:

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

johnoscott

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'

johnoscott

## 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()

johnoscott

{
  "type": "excalidraw",
  "version": 2,
  "source": "https://excalidraw.com",
  "elements": [
    {
      "type": "rectangle",
      "version": 192,
      "versionNonce": 1899200910,
      "isDeleted": false,

johnoscott

When using the sparkline chart in angular-nvds we might want to hide the end value when creating tiny sparlines

Answer to this question https://stackoverflow.com/questions/34864193/angular-nvd3-sparkline-and-trailing-currentvalue-number/53314759#53314759

just set the undocumented* option showLastValue

`$scope.options = { chart: { type: 'sparklinePlus',

johnoscott

Credit to : https://github.com/kingkool68/generate-ssl-certs-for-local-development


Here is the sample output after running the script:

sudo ./generate-ssl.sh local.dev
Password:
Generating RSA private key, 2048 bit long modulus
..........+++
..............................................+++

johnoscott

<iframe src="data:text/html;charset=utf-8,%3Cbody%3E%3Cscript%20src%3D%22https%3A%2F%2Fgist.github.com%2Fef4%2Ffe2e8e5b6e75266e3c2d.js%22%3E%3C%2Fscript%3E%3C%2Fbody%3E">

johnoscott

React Data Grid Examples

<iframe src="https://codesandbox.io/embed/new" style="width:100%; height:500px; border:0; border-radius: 4px; overflow:hidden;" sandbox="allow-modals allow-forms allow-popups allow-scripts allow-same-origin"></iframe>

johnoscott

INSTALLATION
We've created a one-liner that automates the installation procedure. To get started with this display, simply execute curl -L http://coreelec.io/2q | bash

If you want to see what this script does before running, save it to a file with curl -L http://coreelec.io/2q >> lcd35-installer

You can roll back to using the regular HDMI output at any time by executing the included LCD_hdmi script.

https://core-electronics.com.au/3-5inch-display-module-touch-lcd-with-stylus-for-raspberry-pi-3.html

To rotate your display, simply enter display_rotate or lcd_rotate at the bottom of your config file: