Skip to content

Instantly share code, notes, and snippets.

@dyarfi
dyarfi / xxxxxxxxxxx-users.js
Last active September 5, 2020 17:30
Sequelize seeder file ./seeders/xxxxxxxxxxx-users.js
"use strict";
module.exports = {
up: (queryInterface, Sequelize) => {
return queryInterface.bulkInsert("Users", [
{
username: "johndoe1",
firstName: "John",
lastName: "Doe 1",
email: "[email protected]",
password: "$2y$10$mj1OMFvVmGAR4gEEXZGtA.R5wYWBZTis72hSXzpxEs.QoXT3ifKSq", // password
@dyarfi
dyarfi / xxxxxxxxxxx-posts.js
Last active June 10, 2020 04:40
Sequelize seeder file /seeders/xxxxxxxxxxx-posts.js
"use strict";
module.exports = {
up: (queryInterface, Sequelize) => {
return queryInterface.bulkInsert("Posts", [
{
title: "Title post one",
slug: "title-post-one",
userId: 1,
content: "Text content post one",
status: 1,
@dyarfi
dyarfi / xxxxxxxxxxx-jobs.js
Created June 10, 2020 04:36
Sequelize seeder file ./seeders/xxxxxxxxxxx-jobs.js
"use strict";
module.exports = {
up: (queryInterface, Sequelize) => {
var now = new Date();
return queryInterface.bulkInsert("Jobs", [
{
title: "Job Post Title One",
slug: "job-post-title-one",
userId: 1,
content: "Text content job post one",
@dyarfi
dyarfi / xxxxxxxxxxx-add-posts-associate.js
Created June 10, 2020 05:25
Sequelize migration file ./migrations/xxxxxxxxxxx-add-posts-associate.js
"use strict";
module.exports = {
up: (queryInterface, Sequelize) => {
return queryInterface.addColumn(
"posts", // name of Source model
"userId", // name of the key we're adding
{
type: Sequelize.INTEGER,
references: {
model: "users", // name of Target model
@dyarfi
dyarfi / xxxxxxxxxxx-add-jobs-associate.js
Created June 10, 2020 05:27
Sequelize migration file ./migrations/xxxxxxxxxxx-add-jobs-associate.js
"use strict";
module.exports = {
up: (queryInterface, Sequelize) => {
return queryInterface.addColumn(
"jobs", // name of Source model
"userId", // name of the key we're adding
{
type: Sequelize.INTEGER,
references: {
model: "users", // name of Target model
@dyarfi
dyarfi / model-index.js
Last active September 6, 2020 11:10
Sequelize model index file ./models/index.js
'use strict';
const fs = require('fs');
const path = require('path');
const Sequelize = require('sequelize');
const basename = path.basename(__filename);
const env = process.env.NODE_ENV || 'development';
const config = require(__dirname + '/../config/config.js')[env];
const db = {};
@dyarfi
dyarfi / finalImplementations.md
Created June 11, 2020 07:25 — forked from PercyPham/finalImplementations.md
Implementing Json Web Token (JWT) to secure your app
@dyarfi
dyarfi / config.js
Created June 19, 2020 07:14
Sequelize config.js
"use strict";
module.exports = {
development: {
username: "root",
password: null,
database: "database_development",
host: "127.0.0.1",
dialect: "mysql",
operatorsAliases: false,
},
@dyarfi
dyarfi / config.js
Created June 19, 2020 07:16
Sequelize config.js with Node .env
"use strict";
module.exports = {
development: {
username: process.env.DB_USER,
password: process.env.DB_PASS,
database: process.env.DB_NAME,
host: process.env.DB_HOST,
dialect: "mysql",
},
test: {
@dyarfi
dyarfi / .env.local
Created September 3, 2020 09:00
Env variables in local
DB_HOST=myhost_local
DB_USER=myuser_local
DB_PASS=mypassword_local
DB_NAME=mydatabase_local
JWT_KEY="secretOrKeyJWTRandom"