Running the app creates all the tables successfully.

If I post to localhost:3000/seed/user I can see in pgAdmin that the user John Doe has been created.

1 "John Doe" "2018-10-08 12:31:25.562+01" "2018-10-08 12:31:25.562+01"

From the code I would expect to see the following posts in the db Posts table:

    posts: [
      {
        name: 'post1',
        title: 'Croissants are tasty',
        text: 'I recently ate a croissant from France. It was nice.',
        category: 'croissants'
      },
      {
        name: 'post2',
        title: 'my fav techno music',
        text: 'I love the song TECHNO by TechnoGang.',
        category: 'techno'
      }
    ]

If I inspect the posts table in pgAdmin it's empty. No errors are reported.

Any ideas?

Hello,

I was following yours great tutorial but I tried to set up my project using Sequelize v5, instead of v4, however, I got many errors regarding types incompatibility. Please check my code below.

import * as Sequelize from 'sequelize';

export interface UserAttributes {
    id?: number;
    name: string;
    createdAt?: Date;
    updatedAt?: Date;
}

export interface UserInstance extends Sequelize.Instance<UserAttributes>, UserAttributes {}

Error: TS2694: Namespace "... /node_modules/sequelize/types/index" has no exported member "Instance"

Similar issue on StackOverflow:

• https://stackoverflow.com/questions/56752749/using-sequelize-instance-with-sequelize-v5-typescript

I would be grateful if you could help me solve this problem.

Hello,

When trying to use eager loading like this:

app.get('/users', (req: Request, res: Response) => {
  db.User.findAll({
    include: [{
      model: db.Post
    }]
  })
    .then((users: UserInstance[]) => res.status(200).json({ users }))
    .catch(err => res.status(500).json({ err: ['oops', err] }));
});

by adding include, like shown in sequelize docs.

I got a SequelizeEagerLoadingError.

I do not know how to fix this for now.
Can someone replicate this ?
Thank you.

Hi Sir thank you for your awesome tutorial on sequelize and typescript please can you let me know how can we add InstanceLevel and ClassLevelMethods in your code i am trying for a day now but could not acheive the desired results :-

const User = sequelize.define('user', { firstname: Sequelize.STRING });

// Adding a class level method
User.classLevelMethod = function() {
return 'foo';
};

// Adding an instance level method
User.prototype.instanceLevelMethod = function() {
return 'bar';
};
Thank You

Generic type 'BelongsToCreateAssociationMixin<TAttributes, TInstance>' requires 2 type argument(s)

Hi, How to create custom getter for fields?

import * as Sequelize from 'sequelize'

export interface EntryAttributes {
  id: number
  firstName: string
  lastName: string
  fullName: string
}

export type EntryInstance = Sequelize.Instance<EntryAttributes> &
  EntryAttributes

export default (
  sequelize: Sequelize.Sequelize,
  DataTypes: Sequelize.DataTypes
): Sequelize.Model<EntryInstance, EntryAttributes> => {
  const attributes: SequelizeAttributes<EntryAttributes> = {
    id: {
      allowNull: false,
      autoIncrement: true,
      primaryKey: true,
      type: DataTypes.INTEGER(255)
    },
    firstName: {
      allowNull: false,
      type: DataTypes.STRING(255)
    },
    lastName: {
      allowNull: false,
      type: DataTypes.STRING(255)
    },
    fullName: {
      type: new DataTypes.VIRTUAL(DataTypes.STRING(255), ['firstName', 'lastName']),
      get () {
        // Error in this.get
        return `${this.get('firstName') ${this.get('lastName')}}`
      }
    }
  }
  const Entry = sequelize.define<EntryInstance, EntryAttributes>(
    'Entry',
    attributes
  )

  return Entry
}

I got this error:

error TS2339: Property 'get' does not exist on type 'String | DataTypeAbstract | DefineAttributeColumnOptions'.
  Property 'get' does not exist on type 'String'.

401         return `${this.get('firstName') ${this.get('lastName')}}`
                                         ~~~
Found 1 error.

hi Ahmerb, thank you for tutorial on sequelize and typescript, please can you let me know how we add hook in you code, I am trying but could not acheive the desired results.