Sequelize (http://docs.sequelizejs.com/) is an orm that i have used a few times in node.js with sqlite. Is it possible to use it in React Native.
Sequelize (http://docs.sequelizejs.com/) is an orm that i have used a few times in node.js with sqlite. Is it possible to use it in React Native.
It seems to me, after some reasearch, there is port from the original sequelize lib to one that works with react-native (rn-sequelize).
Check this link for more information about the package: https://www.npmjs.com/package/rn-sequelize
Yeah, here's an example of using it in a controller
var db = require('../db');
module.exports = {
messages: {
get: function (req, res) {
db.Message.findAll({include: [db.User]})
.then(function(messages) {
res.json(messages);
});
},
post: function (req, res) {
db.User.findOrCreate({where: {username: req.body.username}})
// findOrCreate returns multiple resutls in an array
// use spread to assign the array to function arguments
.spread(function(user, created) {
db.Message.create({
userid: user.get('id'),
text: req.body.message,
roomname: req.body.roomname
}).then(function(message) {
res.sendStatus(201);
});
});
}
},
users: {
get: function (req, res) {
db.User.findAll()
.then(function(users) {
res.json(users);
});
},
post: function (req, res) {
db.User.findOrCreate({where: {username: req.body.username}})
// findOrCreate returns multiple resutls in an array
// use spread to assign the array to function arguments
.spread(function(user, created) {
res.sendStatus(created ? 201 : 200);
});
}
}
};
var controller = require('./controllers');
var router = require('express').Router();
//Connect controller methods to their corresponding routes
router.get('/messages', controller.messages.get);
router.post('/messages', controller.messages.post);
router.get('/users', controller.users.get);
router.post('/users', controller.users.post);
module.exports = router;