YT0F6B7a

1Executing (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);
2Executing (default): PRAGMA INDEX_LIST(`Users`)
3Executing (default): PRAGMA INDEX_INFO(`sqlite_autoindex_Users_1`)
4Executing (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);
5Executing (default): PRAGMA INDEX_LIST(`Users`)
6Executing (default): PRAGMA INDEX_INFO(`sqlite_autoindex_Users_1`)
7Executing (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	
10const { User } = require('../models');
11
12module.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	
23const express = require('express');
24const cors = require('cors');
25const bodyParser = require('body-parser');
26const morgan = require('morgan');
27const config = require('./config/config');
28const { sequelize } = require('./models');
29
30const app = express();
31
32app.use(morgan('combined'));
33app.use(bodyParser.json());
34app.use(cors());
35
36require('./routes')(app);
37
38
39sequelize.sync().then(() => {
40  app.listen(config.port);
41});
42	
43module.exports = (sequelize, DataTypes) => sequelize.define('User', {
44  email: {
45    type: DataTypes.STRING,
46    unique: true,
47  },
48  password: { type: DataTypes.STRING },
49});
50	
51const fs = require('fs');
52const path = require('path');
53const Sequelize = require('sequelize');
54const config = require('../config/config');
55
56const db = {};
57
58const sequelize = new Sequelize(
59  config.db.database,
60  config.db.user,
61  config.db.password,
62  config.db.options,
63);
64
65fs
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
73db.sequelize = sequelize;
74db.Sequelize = Sequelize;
75
76module.exports = db;