James 'Tucker' Wray jtwray

Migrations & Seeding

What are migrations??

Migrations are a way to make database changes or updates, like creating or dropping tables, as well as updating a table with new columns with constraints via generated scripts. We can build these scripts via the command line using knex command line tool.

To learn more about migrations, check out this article on the different types of database migrations!

Creating/Dropping Tables

Express & Postgres via Knex

Note: <example> is meant to denote text replaced by you (including brackets).

Setup

// global dependencies
npm install -g knex

Web Design Resources

Onboarding and the workplace

https://blog.vcarl.com/interview-questions-onboarding-workplace/

How long will it take to deploy my first change? To become productive? To understand the codebase?
What kind of equipment will I be provided? Will the company pay/reimburse me if I want something specific?

Semantic Commit Messages

See how a minor change to your commit message style can make you a better programmer.

Format: <type>(<scope>): <subject>

<scope> is optional

	The MIT License (MIT)

	Copyright (c) 2015 Justin Perry

	Permission is hereby granted, free of charge, to any person obtaining a copy of
	this software and associated documentation files (the "Software"), to deal in
	the Software without restriction, including without limitation the rights to
	use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of
	the Software, and to permit persons to whom the Software is furnished to do so,
	subject to the following conditions:

	Shopify objects that contain attributes that can be dynamically put on the page. For example, the product object contains an attribute called title that can be used to output the title of a product.

	The handle is used to access the attributes of a Liquid object. By default, it is the object’s title in lowercase with any spaces and special characters replaced by hyphens (-). Every object in Liquid (product, collection, blog, menu) has a handle.

	Collections & Products
	Collection ►
	all_types ►
	Returns a list of all the product types for a collection


	- use aws cloud9 very similar to codesandbox

	- git clone you repo into cloud9

	- create a new s3 bucket in the provided terminal ( the aws cli )
	all lowercase dashes and periods only cant start or end with a number
	aws s3 mb s3://REPLACE_ME_BUCKET_NAME

	- run 2nd command to enable the bucket to be used for state website hosting

	{/**
	code starts line 78

	a little story telling for context

	while mocking seeds for my Express API
	I ran into 2 simliar common obstacles

	-- several occasions where I didn't get the seed just right the first go around and needed to tweak a small part..of every seed