sequelize-postgres.js 711 B

12345678910111213141516171819202122232425262728293031323334353637
  1. const Sequelize = require('sequelize');
  2. const sequelize = new Sequelize('hello_world', 'benchmarkdbuser', 'benchmarkdbpass', {
  3. host: 'TFB-database',
  4. dialect: 'postgres',
  5. logging: false
  6. });
  7. const {DataTypes} = Sequelize;
  8. const Worlds = sequelize.define('World', {
  9. id: {
  10. type: DataTypes.INTEGER,
  11. primaryKey: true
  12. },
  13. randomNumber: {
  14. type: DataTypes.INTEGER,
  15. field: 'randomnumber'
  16. },
  17. }, {
  18. timestamps: false,
  19. freezeTableName: true
  20. });
  21. const Fortunes = sequelize.define('Fortune', {
  22. id: {
  23. type: DataTypes.INTEGER,
  24. primaryKey: true
  25. },
  26. message: {type: DataTypes.STRING}
  27. }, {
  28. timestamps: false,
  29. freezeTableName: true
  30. });
  31. module.exports = {
  32. Worlds,
  33. Fortunes,
  34. };