justinmklam

import requests

url = 'https://api.open511.gov.bc.ca/events'
params = {
    'bbox': '-123.298030,49.243994,-122.975306,49.708883',
    'event_type': 'INCIDENT',
    'status': 'ARCHIVED',
    'created': '>2024-04-13T00:00:00Z'
}

justinmklam

import time
from functools import wraps


def retry(
    ExceptionToCheck: Exception,
    num_tries: int = 5,
    delay_sec: int = 3,
    backoff: int = 2,
):

justinmklam

locals {
    tables = {
        interval_usage = ["read_end_datetime", "ingest_datetime"]
        bill_detail = ["ingest_datetime"]
    }

    table_resources = { for _entry in flatten([
        for k, v in local.tables : [
            for partition in v: {
                entity = k

justinmklam

# Install xcape (https://github.com/alols/xcape)
sudo pacman -S xcape

# Add the following to ~/.xprofile so they're executed at startup (since these commands don't persist across sessions)
setxkbmap -option caps:ctrl_modifier  # Set capslock to ctrl when held
xcape -e 'Caps_Lock=Escape'  # Set capslock to escape when pressed

justinmklam

import csv
from datetime import datetime
from argparse import ArgumentParser

from google.cloud import bigquery

parser = ArgumentParser()
parser.add_argument("project_id")
parser.add_argument("--output_filename", default=None)
parser.add_argument("--num_jobs", default=10000, type=int)

justinmklam

import json
import os
import sys
import time
from argparse import ArgumentParser
from uuid import uuid4

from faker import Faker  # pip install faker

fake = Faker()

justinmklam

Expected Behavior

Please describe the behavior you are expecting

Current Behavior

What is the current behavior?

Failure Information (for bugs)

justinmklam

Assign output of command to a variable, then use the variable. Needs $<); \ to pipe the output and concatenate the subsequent line, since each line is executed in a separate shell.

# Usage: make db-upgrade-gcp environment=dev
db-upgrade-gcp:
	TOKEN=$$(gcloud auth print-identity-token $<); \
	python bin/db_upgrade_gcp.py $(environment) --gcp_token $$TOKEN

justinmklam

Skip Tests By Default in Pytest

Adapted from https://docs.pytest.org/en/latest/example/simple.html#control-skipping-of-tests-according-to-command-line-option

Configuration

Add the following to conftest.py:

import pytest

justinmklam

Basic example:

import os

os.system("python --version")

Better, since stdout and return codes aren't easily processed when using os.system: