Advertisement
Guest User

Untitled

a guest
Apr 5th, 2017
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.29 KB | None | 0 0
  1. module.exports = function (sequelize, DataTypes) {
  2. var User = sequelize.define('Users', {
  3. username: DataTypes.STRING,
  4. password: DataTypes.STRING
  5. }, {
  6. //classMethod guarantees the password provided by the user matches what's in the db
  7. classMethods: {
  8. associate: function (models) {
  9. User.hasMany(models.Tweet, {as: "Author"})
  10.  
  11. }
  12. }
  13. });
  14. return User;
  15. };
  16.  
  17.  
  18. module.exports = function(sequelize, DataTypes) {
  19. var Tweet = sequelize.define('Tweet', {
  20. tweet: DataTypes.TEXT
  21. }, {
  22. classMethods: {
  23. associate: function(models) {
  24. Tweet.belongsTo(models.User, {as: 'tweets'})
  25. }
  26. }
  27. });
  28. return Tweet;
  29. };
  30.  
  31.  
  32. var Sequelize = require('sequelize');
  33. var db = {
  34. sequelize: new Sequelize(
  35. 'kms',
  36. 'root',
  37. 'root',
  38. {
  39. 'dialect': 'mysql',
  40. 'host': 'localhost',
  41. 'port': 3306
  42. }
  43. )
  44. };
  45.  
  46. db.User = db.sequelize.import('./author');
  47. db.Tweet = db.sequelize.import('./tweet');
  48.  
  49. Object.keys(db).forEach(function (modelName) {
  50. console.log(db[modelName]);
  51. if ('associate' in db[modelName]) {
  52. db[modelName].associate(db);
  53. }
  54. });
  55.  
  56. db.sequelize.sync({force: true});
  57.  
  58. module.exports = db;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement