Troy Harvey troyharvey

My git Workflow

This is just one way of using git/GitHub. But I have been using this same basic flow for 15 years and I rarely have trouble.

Switch to the main branch
```
 git switch main
```

Using GitHub Actions to run dbt

This example shows you how to use GitHub Actions to run dbt against BigQuery.

Follow the instructions on getdbt.com for installing and initializing a dbt project.
Copy this action (dbt.yml) into the workflows directory.
```
 mkdir .github
 mkdir .github/workflows
```

cp ~/Downloads/dbt.yml .github/workflows/

Generate a jsonl file with all the Podcast User Agents.
```
 node agents.js
```
Use the BigQuery console to create a table and load the podcast-user-agents.jsonl file into the new table.

Automatically load .env files

I use .env environment variable files in every project. Docker Compose supports .env files. And now direnv supports them too. direnv is a cli tool that detects a .envrc or .env file and runs source .env automatically for you when you cd into a project directory.

Install Homebrew.
Install direnv.
```
 brew install direnv
```
Follow these instructions to add the direnv hook to your shell.

	<?php

	namespace App\Console\Commands;

	use DB;
	use Illuminate\Encryption\Encrypter;
	use Illuminate\Support\Str;
	use Illuminate\Console\Command;

	class ReEncryptData extends Command