Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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);
- Executing (default): PRAGMA INDEX_LIST(`Users`)
- Executing (default): PRAGMA INDEX_INFO(`sqlite_autoindex_Users_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);
- Executing (default): PRAGMA INDEX_LIST(`Users`)
- Executing (default): PRAGMA INDEX_INFO(`sqlite_autoindex_Users_1`)
- 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');
- ::1 - - [23/Nov/2018:19:30:50 +0000] "POST /register HTTP/1.1" 400 16 "-" "PostmanRuntime/7.4.0"
- const { User } = require('../models');
- module.exports = {
- async register(req, res) {
- try {
- const user = await User.sync().then(() => User.create(req.body));
- res.send(user.toJson());
- } catch (err) {
- res.status(400).send({ error: 'nope' });
- }
- },
- };
- const express = require('express');
- const cors = require('cors');
- const bodyParser = require('body-parser');
- const morgan = require('morgan');
- const config = require('./config/config');
- const { sequelize } = require('./models');
- const app = express();
- app.use(morgan('combined'));
- app.use(bodyParser.json());
- app.use(cors());
- require('./routes')(app);
- sequelize.sync().then(() => {
- app.listen(config.port);
- });
- module.exports = (sequelize, DataTypes) => sequelize.define('User', {
- email: {
- type: DataTypes.STRING,
- unique: true,
- },
- password: { type: DataTypes.STRING },
- });
- const fs = require('fs');
- const path = require('path');
- const Sequelize = require('sequelize');
- const config = require('../config/config');
- const db = {};
- const sequelize = new Sequelize(
- config.db.database,
- config.db.user,
- config.db.password,
- config.db.options,
- );
- fs
- .readdirSync(__dirname)
- .filter(file => file !== 'index.js')
- .forEach((file) => {
- const model = sequelize.import(path.join(__dirname, file));
- db[model.name] = model;
- });
- db.sequelize = sequelize;
- db.Sequelize = Sequelize;
- module.exports = db;
Add Comment
Please, Sign In to add comment