Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2016
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.48 KB | None | 0 0
  1. var user = sequelize.define(configModels.user, {
  2. userId: {
  3. type: DataTypes.INTEGER,
  4. allowNull: false,
  5. autoIncrement: true,
  6. primaryKey: true,
  7. referenceces: {
  8. model: 'photo',
  9. key: 'userId'
  10. }
  11.  
  12. },
  13. name: {
  14. type: DataTypes.STRING,
  15. allowNull: false
  16. },
  17. password: {
  18. type: DataTypes.STRING,
  19. allowNull: false
  20. },
  21. }, {
  22. classMethods: {
  23. associate: function(models) {
  24. user.hasMany(models.photo, { as: 'photo_fk', constraints: true });
  25. }
  26. },
  27. freezeTableName: true // Model tableName will be the same as the model name
  28. });
  29.  
  30. var photo = sequelize.define(configModels.photo, {
  31. photoId: {
  32. type: DataTypes.INTEGER,
  33. autoIncrement: true,
  34. primaryKey: true
  35. },
  36. userId: {
  37. type: DataTypes.INTEGER,
  38. allowNull: false,
  39. referenceces: {
  40. model: 'user',
  41. key: 'userId'
  42. }
  43. },
  44. photo: {
  45. type: DataTypes.STRING,
  46. allowNull: false
  47. }
  48. }, {
  49. classMethods: {
  50. associate: function(models) {
  51. photo.belongsTo(models.user, { as: 'user_fk', constraints: true });
  52. }
  53. },
  54. freezeTableName: true // Model tableName will be the same as the model name
  55. });
  56.  
  57. User.findAll({
  58. include: [
  59. { model: 'photo' }
  60. ]
  61. }).then(function(users){
  62. console.log("Found all ids: ", users);
  63. // callback(users);
  64. }).catch(function(err){
  65. console.log(err);
  66. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement