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!
Based off of: http://docs.sequelizejs.com/en/1.7.0/articles/express/
Create and initialize your a directory for your Express application.
$ mkdir sequelize-demo
| package main | |
| import ( | |
| "database/sql" | |
| "errors" | |
| "fmt" | |
| _ "github.com/bmizerany/pq" | |
| "os" | |
| "regexp" | |
| "strings" |
| version: '3' | |
| services: | |
| mysql56: | |
| image: mysql:5.6 | |
| restart: unless-stopped | |
| container_name: mysql56-container | |
| ports: | |
| - "127.0.0.1:3356:3306" | |
| environment: | |
| MYSQL_ROOT_PASSWORD: rootPassword |
| var AWS = require('aws-sdk'); | |
| AWS.config.update({ region: 'us-east-1' }); | |
| var s3 = new AWS.S3(); | |
| var obj = { | |
| firstname: "Navjot", | |
| lastname: "Dhanawat" | |
| }; | |
| var buf = Buffer.from(JSON.stringify(obj)); |
| package main | |
| import ( | |
| "fmt" | |
| "github.com/satori/go.uuid" //for uuid | |
| "gopkg.in/validator.v2" | |
| "reflect" | |
| "regexp" | |
| "time" | |
| ) |
| import { Knex } from 'knex' | |
| export async function up(knex: Knex): Promise<any> { | |
| await knex.schema.createTable('test_setup', (table: Knex.TableBuilder) => { | |
| table.integer('foobar'); | |
| }); | |
| } | |
| export async function down(knex: Knex): Promise<any> { | |
| await knex.schema.dropTable('test_setup'); |
| # path on linux /usr/share/dbeaver/dbeaver.ini | |
| # path on macos /Applications/DBeaverEE.app/Contents/Eclipse/dbeaver.ini | |
| -vm | |
| /usr/bin/java | |
| -startup | |
| plugins/org.eclipse.equinox.launcher_1.5.600.v20191014-2022.jar | |
| --launcher.library | |
| plugins/org.eclipse.equinox.launcher.gtk.linux.x86_64_1.1.1100.v20190907-0426 | |
| -vmargs | |
| -javaagent:/home/tunknown/.apps/dbeaver/dbeaver-agent.jar |
