Ken Yip kenyipp

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

Knex Setup Guide

Create your project directory

Create and initialize your a directory for your Express application.

$ mkdir node-knex-demo
$ cd node-knex-demo
$ npm init

	Africa/Abidjan
	Africa/Accra
	Africa/Addis_Ababa
	Africa/Algiers
	Africa/Asmara
	Africa/Asmera
	Africa/Bamako
	Africa/Bangui
	Africa/Banjul
	Africa/Bissau

	import { createSign, randomBytes } from 'crypto'
	import axios from 'axios'
	import { resolve } from 'url'

	const PK_HEADER = '\n-----BEGIN PRIVATE KEY-----\n'
	const PK_FOOTER = '\n-----END PRIVATE KEY-----\n'

	const BASE_URL = 'https://marketplace.walmartapis.com/'

	const WALMART_CONSUMER = "b68d2a72....";

	-- Remove the history from
	rm -rf .git

	-- recreate the repos from the current content only
	git init
	git add .
	git commit -m "Initial commit"

	-- push to the github remote repos ensuring you overwrite history
	git remote add origin git@github.com:<YOUR ACCOUNT>/<YOUR REPOS>.git