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

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

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

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -

here tables: create table customer ( cid int primary key, name varchar(32) ) create table ord ( oid int primary key, cid int foreign key references customer, address varchar(20) ) here's linq-to-sql statement: var aaa = c in db.customer select new { c, o = c.ord.tolist() }; and here's inexplicable query generated linq-to-sql: select [t0].[cid] [cid], [t0].[name] [name], [t1].[oid] [oid], [t1].[cid] [cid2], [t1].[address] [address], (select count(*) [dbo].[ord] [t2] [t2].[cid] = [t0].[cid]) [value] [dbo].[customer] [t0] left outer join [dbo].[ord] [t1] on [t1].[cid] = [t0].[cid] order [t0].[cid], [t1].[oid] i want understand how rid of count(*) part. it's entirely uncalled for! linq needs count(*) in order determine number of entries returned o = c.ord.tolist() .
Read more