Database Commands

database all related setup and commands

create database databasename; create user username with encrypted password '«password»'; grant all privileges on database databasename to username;

or

CREATE USER WITH DATABASE DATABASENAME CREATEDB; CREATE DATABASE WITH OWNER USERNAME;

npx sequelize init npx dotenv sequelize db:migrate npx dotenv sequelize db:migrate:undo:all npx dotenv sequelize db:seed:all npx dotenv sequelize db:seed:undo:all

npx sequelize model:generate --name Trainer --attributes username:varchar,password:string,emailAddress:varchar

npx sequelize model:generate --name Pokemon --attributes name:varchar,image:varchar,region:string,type:string

npx sequelize model:generate -name Review --attributes review:text,rating:numeric,trainer_Id:integer,pokemon_Id:integer

npx sequelize model:generate -name Catchlist --attributes catchstatus:varchar,trainer_Id:integer

npx sequelize model:generate -name CatchlistJoinPokemon --attributes pokemon_Id:integer,catchlist_Id:integer

npx sequelize seed:generate --name Trainers npx sequelize seed:generate --name Pokemon npx sequelize seed:generate --name Reviews npx sequelize seed:generate --name Catchlists npx sequelize seed:generate --name CatchlistJoinPokemon

example model set up 'use strict'; module.exports = (sequelize, DataTypes) => { const Trainer = sequelize.define('Trainer', { username: { allowNull: false, type: DataTypes.STRING(100), unique: true }, password: { allowNull: false, type: DataTypes.STRING.BINARY }, emailAddress: { allowNull: false, unique: true, type: DataTypes.STRING(100), unique: true }, }, {}); Trainer.associate = function(models) { Trainer.hasMany(models.Catchlist, { foreignKey: 'trainer_Id' }); Trainer.hasMany(models.Review, { foreignKey: 'trainer_Id' }); };

return Trainer; };

Association:

Trainer.hasMany(models.Catchlist, { foreignKey: 'trainer_Id' }); Trainer.hasMany(models.Review, { foreignKey: 'trainer_Id' });

Pokemon const columnMapping = { foreignKey: 'pokemon_Id', through: 'CatchlistJoinPokemon', otherKey: 'catchlist_Id' } Pokemon.belongsToMany(models.Catchlist, columnMapping)

Pokemon.hasMany(models.Review, {foreignKey: 'pokemon_Id'})

Review Review.belongsTo(models.Trainer, { foreignKey: 'trainer_Id'}) Review.belongsTo(models.Pokemon, { foreignKey: 'pokemon_Id'})

Catchlist Catchlist.belongsTo(model.Trainer, {foreignKey: 'pokemon_Id'})

const columnMapping = { foreignKey: 'catchlist_Id' through: 'CatchlistJoinPokemon' otherKey: 'pokemon_Id' } Catchlist.belongsToMany(models.Pokemon, columnMapping)

CatchlistJoinPokemon *currently no associations