Advertisement
Guest User

Untitled

a guest
May 25th, 2016
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.87 KB | None | 0 0
  1. post: function user_post(req, res) {
  2. var username = req.swagger.params.body.value.userName;
  3. var userpass = req.swagger.params.body.value.passWord;
  4. var phone = req.swagger.params.body.value.phone;
  5. var mail = req.swagger.params.body.value.mail;
  6. var root = req.swagger.params.body.value.root;
  7. sql.connect(config).then(function() {
  8. // Query
  9.  
  10. new sql.Request()
  11. .input('userName', sql.nvarchar(50), username)
  12. .input('userPass', sql.nvarchar(25), userpass)
  13. .input('phone', sql.nvarchar(50), phone)
  14. .input('mail', sql.nvarchar(50), mail)
  15. .input('root', sql.SmallInt, root)
  16. .query('insert into [venovu_com].[user] (userName, userPass, phone, mail, root) values (@userName, @userPass, @phone, @mail, @root)').then(function(recordset) {
  17. consol.dir(recordset);
  18. }).catch(function(err) {
  19. // ... error checks
  20. });
  21.  
  22.  
  23. });
  24. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement