rcackerman

We can use https://github.com/GAM-team/GAM to create catalogues of Google Drive files by drive location, owner, last modified time, etc. I’ve run all the calls below using legacy GAM, but we might consider using GAM7 instead.

First, some useful resources:

• GAMADV-XTD3
• GAM Cheat Sheet 1.6.3 A3 - GAM Cheat Sheet A3.pdf

A hello world call that prints a list of all the files in a shared drive:

gam user print filelist select teamdrive '' showownedby any id title filepath viewed modifieddate

rcackerman

From ddev quickstart https://ddev.readthedocs.io/en/stable/users/quickstart/#drupal

mkdir civicrm && cd civicrm
ddev config --project-type=drupal --php-version=8.3 --docroot=web --database=mysql:8.0
ddev start
ddev composer create drupal/recommended-project:"^11"
ddev composer require drush/drush
ddev config --update
ddev restart

rcackerman

Keybase proof

I hereby claim:

• I am rcackerman on github.
• I am rcackerman (https://keybase.io/rcackerman) on keybase.
• I have a public key ASDMak1dHFbdDbhI-okUtoZypFDNOeWxv4073RyrsR2eBgo

To claim this, I am signing this object:

rcackerman

it "shows bars again once closed" do
  page.find("svg", class: "fa-times").click
  expect(page).to have_css(".fa-bars")
end

it "shows bars again once closed" do
  page.find("svg", class: "fa-times", wait: 5).click
  expect(page).to have_css(".fa-bars")
end

rcackerman

Extract the PL # from PDCMS Charge

if REGEXP_MATCH([Tc Pl#], '^A[0-9]') = true
then REPLACE([Tc Pl#], 'A', '')
else [Tc Pl#]
END

Extract the 'A' from PDCMS charge

rcackerman

var branchStatusMatrix = {
  data: [{
    branch: "airForce",
    options: [
      {
        id: "discharged-deceased-retired",
        text: "Discharged, deceased, or retired"
      }, {
        id: "active",
        text: "active"

rcackerman

CREATE TEMP TABLE test_bool_or (
  file_number varchar(50),
  dob character varying
); 

INSERT INTO test_bool_or (file_number, dob)
VALUES ('124ny', NULL)
    , ('1345', 'test')
    , ('124ny', 'test')
    , ('345', NULL);

rcackerman

-- Queries to get export data
SELECT
 adr_NameID,
 adr_File_Number,
 adr_Type,
 adr_Date,
 adr_Print,
 adr_Street1,
 adr_Street2,
 adr_City,

rcackerman

Setup

Heavily cribbed from Windows 10 for Modern/Hipster Development

This is documentation for how I set up my machine.

Steps

1. Enable Bash on Windows
2. Install Chocolatey. Once done, install packages by running cinst (short for choco install). Most packages below will be installed with Chocolatey.
3. Install cmder

rcackerman

with prices as (select new.name, new.units, old_price, new_price, new_price::float - old_price::float as price_diff, (old_price + new_price)/2.0 as price_avg from (select name, units, price as old_price from coop where date = current_date - '7 days'::interval) old join (select name, units, price as new_price from coop where date = (select max(date) from coop)) new on old.name = new.name and old.units = new.units) select *, price_diff/price_avg * 100 as pcg_change from prices order by pcg_change;