phette23

#!/usr/bin/env bash
# create a csv of path, file size, last access time for all files in a directory tree
# usage: file-tree-csv.sh /path/to/directory > output.csv
FILEDIR=/opt/moodledata/filedir
cd $FILEDIR || (echo "Moodle filedir not found, exiting" && exit 1)
echo "path,size,atime"
# shellcheck disable=SC2044
# all Moodle file names & paths only contain hexadecimal chars
for file in $(find . -type f); do
  size=$(stat -c %s $file)

phette23

#!/usr/bin/env python
# run from root of cca/vault_migration project over _all_ VAULT metadata JSON like
# `poetry run python missing-names.py vm/*.json`
import csv
import json
import os
import sys

import xmltodict

phette23

# backup the mdl_data_records table before we modify it
gcloud sql export sql mysql-prod-1 gs://cca-manual-db-dumps/(dt)-mdl_data_records.sql -d m_prod1 -t mdl_data_records

phette23

#!/usr/bin/env fish
# download ALL live vault items to item.json and metadata.xml files
# 47283 total items, we can download 50 at a time
set total (eq search -l 1 | jq '.available')
set length 50
set pages (math floor $total / $length)
for i in (seq 0 $pages)
  set start (math $i \* $length)
  echo "Downloading items $start to" (math $start + $length)
  eq search -l $length --info metadata --start $start > .tmp/$i.json

phette23

// check if these sections appear on EQUELLA search results page
const sections = [
    'GELCT-6700-2',
    'LITPA-2000-10',
    'WRITE-6000-2',
]
console.log(`Checking for ${sections.length} section codes`)

// return list of missing sections
const missing = sections.filter(s => {

phette23

#!/usr/bin/env fish

# used for Art Practical site

# fill in credentials
set USER username
set PASS password
set COLLECTION 15633
# destination files
set JSONFILE data.json

phette23

document
	.querySelector('history-app').shadowRoot
	.querySelector('history-list').shadowRoot
	.querySelectorAll('history-item').forEach((hi, i) => {
		const cbox = hi.shadowRoot.querySelector('cr-checkbox')
		// merely setting checked = true doesn't work, chrome wants you to click them
		if (!cbox.checked) cbox.click()
	})

phette23

The How to Open a Homebrew Pull Request documentation is great. This doc assumes you've already created a fork of homebrew-core named after your user and a branch tracking the master of the fork.

cd (brew --repository homebrew/core)
brew update
git checkout phette23 # tracks master branch of fork
git pull # might need to sync fork to homebrew?
set FORMULA marcli # name of the project you're bumping
set VERSION 1.1.0 # semantic version
brew bump-formula-pr --no-fork --url https://github.com/account/$FORMULA/archive/refs/tags/v$VERSION.tar.gz project

phette23

from email.message import EmailMessage
import smtplib

from reminders.config import config


from_address = 'ephetteplace@cca.edu'
to_address = 'ephetteplace@cca.edu'

msg = EmailMessage()

phette23

#!/usr/bin/env fish
if ! git status 2&>/dev/null
    echo "Must be run inside a git repo, run 'git init' first if need be" >&2
    exit 1
end

begin
    if ! test -f LICENSE.txt
        echo "Downloading license text"
        wget https://raw.githubusercontent.com/cca/koha_snippets/main/LICENSE.txt