cXSvW0f4

1'use strict';
2
3
4		var sql = require('mssql');
5
6var config = {
7    user: 'venovu@energiklart',
8    password: '!fE92bXp4',
9    server: 'energiklart.database.windows.net', // You can use 'localhost\\instance' to connect to named instance
10    database: 'Energiklart',
11
12    options: {
13        encrypt: true // Use this if you're on Windows Azure
14    }
15}
16
17
18module.exports = {
19    get: function user_get(req, res) {
20sql.connect(config).then(function() {
21    // Query
22
23    new sql.Request().query('select * from [venovu_com].[user]').then(function (recordset) {
24       res.json(recordset)
25    }).catch(function (err) {
26        // ... error checks
27    });
28});
29		
30        
31    },
32	
33	post: function user_post(req, res) {
34	var transaction = new sql.Transaction(config);
35	transaction.begin(function(err) {
36    // ... error checks 
37 
38    var request = new sql.Request(transaction);
39    request.query('insert into [venovu_com].[user] (userName, userPass, phone, mail, root) values (borg, borg,01241, gmail.com, 1)', function(err, recordset) {
40        // ... error checks 
41 
42        transaction.commit(function(err, recordset) {
43            
44 
45            console.log("Transaction committed.");
46        });
47    });
48});
49
50		
51}
52};