Guest User

Untitled

a guest
Nov 23rd, 2018
143
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.34 KB | None | 0 0
  1. Executing (default): CREATE TABLE IF NOT EXISTS `Users` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `email` VARCHAR(255) UNIQUE, `password` VARCHAR(255), `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
  2. Executing (default): PRAGMA INDEX_LIST(`Users`)
  3. Executing (default): PRAGMA INDEX_INFO(`sqlite_autoindex_Users_1`)
  4. Executing (default): CREATE TABLE IF NOT EXISTS `Users` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `email` VARCHAR(255) UNIQUE, `password` VARCHAR(255), `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
  5. Executing (default): PRAGMA INDEX_LIST(`Users`)
  6. Executing (default): PRAGMA INDEX_INFO(`sqlite_autoindex_Users_1`)
  7. Executing (default): INSERT INTO `Users` (`id`,`email`,`password`,`createdAt`,`updatedAt`) VALUES (NULL,'FAK12113@email.com','asdqwe','2018-11-23 19:30:50.050 +00:00','2018-11-23 19:30:50.050 +00:00');
  8. ::1 - - [23/Nov/2018:19:30:50 +0000] "POST /register HTTP/1.1" 400 16 "-" "PostmanRuntime/7.4.0"
  9.  
  10. const { User } = require('../models');
  11.  
  12. module.exports = {
  13. async register(req, res) {
  14. try {
  15. const user = await User.sync().then(() => User.create(req.body));
  16. res.send(user.toJson());
  17. } catch (err) {
  18. res.status(400).send({ error: 'nope' });
  19. }
  20. },
  21. };
  22.  
  23. const express = require('express');
  24. const cors = require('cors');
  25. const bodyParser = require('body-parser');
  26. const morgan = require('morgan');
  27. const config = require('./config/config');
  28. const { sequelize } = require('./models');
  29.  
  30. const app = express();
  31.  
  32. app.use(morgan('combined'));
  33. app.use(bodyParser.json());
  34. app.use(cors());
  35.  
  36. require('./routes')(app);
  37.  
  38.  
  39. sequelize.sync().then(() => {
  40. app.listen(config.port);
  41. });
  42.  
  43. module.exports = (sequelize, DataTypes) => sequelize.define('User', {
  44. email: {
  45. type: DataTypes.STRING,
  46. unique: true,
  47. },
  48. password: { type: DataTypes.STRING },
  49. });
  50.  
  51. const fs = require('fs');
  52. const path = require('path');
  53. const Sequelize = require('sequelize');
  54. const config = require('../config/config');
  55.  
  56. const db = {};
  57.  
  58. const sequelize = new Sequelize(
  59. config.db.database,
  60. config.db.user,
  61. config.db.password,
  62. config.db.options,
  63. );
  64.  
  65. fs
  66. .readdirSync(__dirname)
  67. .filter(file => file !== 'index.js')
  68. .forEach((file) => {
  69. const model = sequelize.import(path.join(__dirname, file));
  70. db[model.name] = model;
  71. });
  72.  
  73. db.sequelize = sequelize;
  74. db.Sequelize = Sequelize;
  75.  
  76. module.exports = db;
Add Comment
Please, Sign In to add comment