const User = sequelize.define('User', {
    email: {
        type: DataTypes.STRING,
    },
    password: {
        type: DataTypes.STRING,
    },
});
User.associate = (models) => {
    User.hasOne(models.Profile, {
        foreignKey: {
            name: 'user_id',
        },
    });
};

const Profile = sequelize.define('Profile', {
    name: {
        type: DataTypes.STRING,
    },
    avatar: {
        type: DataTypes.STRING,
    },
}, {
    tableName: 'profiles',
    freezeTableName: true,
    timestamps: false,
});

Profile.associate = (models) => {
    Profile.belongsTo(models.User, {
        foreignKey: {
            name: 'user_id',
        },
    });
};

User
    .all({
        where: {
            email: {
                $like: filter
            },
        },
        include: [{
            model: Profile,
            where: {
                name: {
                    $like: filter
                },
            },
        }],
    })
    .then(users => res.status(200).send(users))
    .catch(error => {
        return res.sendStatus(500);
    });