Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- post: function user_post(req, res) {
- var username = req.swagger.params.body.value.userName;
- var userpass = req.swagger.params.body.value.passWord;
- var phone = req.swagger.params.body.value.phone;
- var mail = req.swagger.params.body.value.mail;
- var root = req.swagger.params.body.value.root;
- sql.connect(config).then(function() {
- // Query
- new sql.Request()
- .input('userName', sql.nvarchar(50), username)
- .input('userPass', sql.nvarchar(25), userpass)
- .input('phone', sql.nvarchar(50), phone)
- .input('mail', sql.nvarchar(50), mail)
- .input('root', sql.SmallInt, root)
- .query('insert into [venovu_com].[user] (userName, userPass, phone, mail, root) values (@userName, @userPass, @phone, @mail, @root)').then(function(recordset) {
- consol.dir(recordset);
- }).catch(function(err) {
- // ... error checks
- });
- });
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement