Skip to content

Instantly share code, notes, and snippets.

View matsuaki-jp's full-sized avatar

MatsuAki(Hideaki Matsuo) matsuaki-jp

View GitHub Profile
@matsuaki-jp
matsuaki-jp / package.json
Created August 21, 2020 11:34
sequelize do migration package.json
"scripts": {
"databaseBuild": "tsc --project ./database/tsconfig.json",
"migration:up": "npm run databaseBuild && ts-node ./database/config/doMigration.ts up"
}
{
"compilerOptions": {
"lib": [
"dom",
"dom.iterable",
"esnext",
"ES6"
],
"typeRoots": [
"node_modules/@types"
@matsuaki-jp
matsuaki-jp / settings.ts
Created August 21, 2020 11:24
sequelize with ts settings.ts
import {Dialect} from 'sequelize'
interface ConnectionConfig {
dbname:string;
dbUsername:string
dbPassword:string
dbDialect:Dialect
dbSchema?:string
dbPort:number
dbHost:string
localhost:string
@matsuaki-jp
matsuaki-jp / doMigration.ts
Last active August 30, 2020 11:12
sequelize do migration
import { Writable } from 'stream';
import { Socket } from 'net';
import { connectionConfig } from './settings'
import { Client } from 'ssh2';
import { Sequelize } from 'sequelize';
import { Umzug } from 'umzug';
const net = require('net');
/**
* 処理成功時
@matsuaki-jp
matsuaki-jp / 20200726100026-create-hello.ts
Last active August 21, 2020 11:25
sequelize with ts
'use strict';
import { QueryInterface, DataTypes } from 'sequelize';
module.exports = {
up: async (queryInterface:QueryInterface) => {
await queryInterface.createTable('hellos', {
id: {
allowNull: false,
autoIncrement: true,
primaryKey: true,