How to query azure SQL from node.js server -


i'm having trouble querying db on azure sql (i new sql). i'm following steps on https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connect-query-nodejs, includes tutorial steps on how read tables, not manipulate them. trying insert , delete requests on node.js server, getting request error in 1 of node modules, makes me think i'm going requesting operations wrong.

here's code:

var connection = require('tedious').connection; var request = require('tedious').request;  // create connection database var config = {     username: 'user_name',     password: 'password',     server: 'server_name',     options:     {         database: '_dbname'         , encrypt: true     } } var connection = new connection(config);  // attempt connect , execute queries if connection goes through connection.on('connect', function (err) { if (err) {     console.log(err) } else {     querydatabase(); } }  //this works fine, it's loading data database function querydatabase() { console.log('\nreading rows table...'); let obj = {}; let objs = []; let request; // read rows table request = new request(     "select * [dbo].[table_name]",     function (err, rowcount, rows) {         console.log('-- done');     } ); //this when admin adds content app, sql table not changing,  //node.js throws error socket.on('add item', item => {     let index = getcollectionindexbyid(item.id);     collections[index].items.push(item.item);     io.sockets.emit('add item', item);      request = new request(`insert [dbo].[table_name](id, attr1, attr2, attr3, attr4)      values (`         + item.id + ','         + item.item.attr2 + ','         + item.item.attr3 + ','         + item.item.attr4 + ','         + null, function (err, rowcount, rows) {             if (err) throw err;             console.log('> requested db insert item');         });     connection.execsql(request);     console.log('> item sent app'); }); //for when admin removes content app, same error  socket.on('rm item', item => {     collections[getcollectionindexbyid(item.id)].items.splice(item.index, 1);     io.sockets.emit('rm item', { "id": item.id, index: item.index });      request = new request(`delete [dbo].[table_name] id= `         + item.id + ` , attr1= ` + item.item.attr1, function (err, rowcount, rows) {             if (err) throw err;             console.log('> requested db remove item')         });     connection.execsql(request);      console.log('> sent request remove item');  });

the exact error msg requesterror: incorrect syntax near 'esse'., , in 1 of node modules called tedious in request.js.

so in summary, if knows of way query azure sql db's make inserts , deletes, appreciated!

you missed ) in 'insert' sql. also, you'd need set string value single quotes of course.

change following lines of code

request = new request(`insert [dbo].[table_name](id, attr1, attr2, attr3, attr4)      values (`         + item.id + ','         + item.item.attr2 + ','         + item.item.attr3 + ','         + item.item.attr4 + ','         + null, function (err, rowcount, rows) {             if (err) throw err;             console.log('> requested db insert item');         });     connection.execsql(request);

to

request = new request(`insert [dbo].[table_name](id, attr1, attr2, attr3, attr4) values ('${item.id}', '${item.item.attr2}', '${item.item.attr3}', '${item.item.attr4}' null)`, function (err, rowcount, rows) {     if (err) throw err;     console.log('> requested db insert item'); }); connection.execsql(request);

Comments

Post a Comment

Popular posts from this blog

python Tkinter Capturing keyboard events save as one single string -

is possible store keyboard events 1 string? code below stores 1 char , prints it. card reader or bar code reader, contains collection of character/ string not 1 character @ time. goal save char pressed text variable. from tkinter import * root = tk() def key(event): text= event.char text+= event.char print ("pressed", text) def callback(event): frame.focus_set() print ("clicked at", event.x, event.y) frame = frame(root, width=100, height=100) frame.bind("<key>", key) frame.bind("<button-1>", callback) frame.pack() root.mainloop() currently, creating text variable , everytime key() function gets called, , text stores last character typed. you can define text module level variable , , use module level text inside key function - text = '' def key(event): global text text+= event.char print("pressed", text)
Read more

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

i'm implementing inapp billing in android app. works well, however, i'm trying decouple broadcast receiver activity manifest. suggestion in android's trivialdrive sample: // important: dynamically register broadcast messages updated purchases. // register receiver here instead of <receiver> in manifest // because call getpurchases() @ startup, therefore can ignore // broadcasts sent while app isn't running. // note: registering listener in activity bad idea, done here // because sample. regardless, receiver must registered after // iabhelper setup, before first call getpurchases(). currently there's class extends broadcastreceiver : public class iabbroadcastreceiver extends broadcastreceiver { /** * intent action receiver should filter for. */ public static final string action = "com.android.vending.billing.purchases_updated"; private final iabbroadcastlistener mlistener; public iabbroadcastreceiver(iabbroadcastlistener listener) { m
Read more

javascript - Z-index in d3.js -

i have map , when hover effect on region of map below yellow line , circle, last ones disappear. how can solve problem? http://jsfiddle.net/ot21n9qx/ var arc = g.append("path") .style("fill", "none") .style("stroke", "yellow") .style("stroke-width", 2) .attr("d", "m" + pathorigin[0] + "," + pathorigin[1] + " q" + svgpoint[0] + "," + pathorigin[1] + " " + svgpoint[0] + "," + svgpoint[1]); var circlesize = d3.scale.linear() .domain([0, 0.5, 1]) .range([4, 10, 4]); svg not have z order draws objects in order created. need create path , circle after create highlight regions. here forked fiddle: http://jsfiddle.net/o00fzgaf/1/
Read more