{"id":43,"date":"2014-03-21T09:28:24","date_gmt":"2014-03-21T12:28:24","guid":{"rendered":"http:\/\/www.luppi.com.br\/?p=43"},"modified":"2014-04-06T20:45:02","modified_gmt":"2014-04-06T23:45:02","slug":"estrutura-do-componente-servidor-nodejs-univel","status":"publish","type":"post","link":"http:\/\/www.luppi.com.br\/?p=43","title":{"rendered":"Estrutura do componente servidor (nodejs) UNIVEL"},"content":{"rendered":"<p>PessoALL, foi mals, segue ai os m\u00e9todos para o componente do lado do servidor prover os servi\u00e7os REST<\/p>\n<p>var mysql\u00a0\u00a0 = require(&#8216;mysql&#8217;);<br \/>\nvar connection = mysql.createConnection({<br \/>\nhost\u00a0\u00a0\u00a0\u00a0 : &#8216;localhost&#8217;,<br \/>\nuser\u00a0\u00a0\u00a0\u00a0 : &#8216;xxxxx&#8217;,\u00a0 \/\/ substituir pela sua instala\u00e7\u00e3o<br \/>\npassword : &#8216;xxxxx&#8217;,\u00a0\u00a0 \/\/substituir pela sua instala\u00e7\u00e3o<br \/>\ndatabase : &#8216;xxxxxxx&#8217;\u00a0 \/\/substituir pela sua instala\u00e7\u00e3o<br \/>\n});<\/p>\n<p>exports.buscaTodos = function(req, res){<br \/>\nif (connection) {<br \/>\nconnection.query(&#8216;select * from vinho order by name&#8217;, function(err, rows, fields) {<br \/>\nif (err) throw err;<br \/>\nres.contentType(&#8216;application\/json&#8217;);<br \/>\nres.write(JSON.stringify(rows));<br \/>\nres.end();<br \/>\n});<br \/>\n}<br \/>\n};<\/p>\n<p>exports.buscaPorId = function(req, res){<br \/>\nvar id = req.params.id;<br \/>\nif (connection) {<br \/>\nvar queryString = &#8216;select * from vinho where id = ?&#8217;;<br \/>\nconnection.query(queryString, [id], function(err, rows, fields) {<br \/>\nif (err) throw err;<br \/>\nres.contentType(&#8216;application\/json&#8217;);<br \/>\nres.write(JSON.stringify(rows));<br \/>\nres.end();<br \/>\n});<br \/>\n}<br \/>\n};<\/p>\n<p>exports.adicionaVinho = function (req, res){<br \/>\nvar vinho = req.body,<br \/>\nqueryString = &#8216;INSERT INTO vinho SET ?&#8217;;<br \/>\n\/\/ Percebam a sintaxe do comando, ao inv\u00e9s de VALUES o m\u00f3dulo usa SET<br \/>\n\/\/ enquanto INSERT INTO &#8230; SET x = y \u00e9 uma express\u00e3o VALIDA<br \/>\n\/\/\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 INSERT INTO &#8230; VALUES x = y N\u00c3O \u00c9 VALIDA<br \/>\nconsole.log(&#8216;adicionando vinho&#8230;.&#8217; + JSON.stringify(vinho));<br \/>\nif (connection) {<br \/>\n\/\/console.log(&#8216;pronto para inserir&#8230;.&#8217;);<br \/>\nconnection.query(queryString, vinho, function(err, result){<br \/>\n});<br \/>\n\/\/console.log(&#8216;adicionado : &#8216;);<br \/>\nres.end();<br \/>\n} else {<br \/>\nconsole.log(&#8216;Ops&#8230; B.O. na conex\u00e3o&#8230;. verifique o comando adicionaVinho&#8217;);<br \/>\n}<br \/>\n};<\/p>\n<p>exports.updateVinho = function (req, res){<br \/>\nvar vinho = req.body,<br \/>\nid = req.params.id,\u00a0\u00a0 \/\/ recupera o id do vinho a ser atualizado<br \/>\nqueryString = &#8216;UPDATE vinho SET ? WHERE id=&#8217;+id;<br \/>\nif (connection) {<br \/>\n\/\/console.log(&#8216;pronto para atualizar&#8230;.&#8217; + vinho);<br \/>\nconnection.query(queryString, vinho, function(err, result){<br \/>\n});<br \/>\n\/\/console.log(&#8216;adicionado : &#8216;);<br \/>\nres.end();<br \/>\n} else {<br \/>\nconsole.log(&#8216;Ops&#8230; B.O. na conex\u00e3o&#8230;. verifique a fun\u00e7\u00e3o updateVinho&#8217;);<br \/>\n}<br \/>\n};<\/p>\n<p>exports.deletaVinho = function (req, res){<br \/>\nvar id = req.params.id,\u00a0\u00a0 \/\/ recupera o id do vinho a ser exclu\u00eddo<br \/>\nqueryString = &#8216;DELETE FROM vinho WHERE id=&#8217;+id;<\/p>\n<p>if (connection) {<br \/>\n\/\/console.log(&#8216;pronto para APAGAR&#8230;.&#8217; + queryString);<br \/>\nconnection.query(queryString, function(err, result){<br \/>\n});<br \/>\n\/\/console.log(&#8216;adicionado : &#8216;);<br \/>\nres.end();<br \/>\n} else {<br \/>\nconsole.log(&#8216;Ops&#8230; B.O. na conex\u00e3o&#8230;. verifique a fun\u00e7\u00e3o deletaVinho&#8217;);<br \/>\n}<\/p>\n<p>};<\/p>\n<p>\/\/ PARA TESTES DE CONEX\u00c3O<br \/>\n\/*<br \/>\nconnection.connect(function(error){<br \/>\nif(error) {<br \/>\nconsole.log(&#8220;Erro na conex\u00e3o com o banco: &#8221; + error);<br \/>\n} else {<br \/>\nconsole.log(&#8220;OK &#8211; Conectado&#8221;);<br \/>\n}<br \/>\n});<\/p>\n<p>connection.end();<br \/>\n*\/<\/p>\n","protected":false},"excerpt":{"rendered":"<p>PessoALL, foi mals, segue ai os m\u00e9todos para o componente do lado do servidor prover os servi\u00e7os REST var mysql\u00a0\u00a0 = require(&#8216;mysql&#8217;); var connection = mysql.createConnection({ host\u00a0\u00a0\u00a0\u00a0 : &#8216;localhost&#8217;, user\u00a0\u00a0\u00a0\u00a0 : &#8216;xxxxx&#8217;,\u00a0 \/\/ substituir pela sua instala\u00e7\u00e3o password : &#8216;xxxxx&#8217;,\u00a0\u00a0 \/\/substituir pela sua instala\u00e7\u00e3o database : &#8216;xxxxxxx&#8217;\u00a0 \/\/substituir pela sua instala\u00e7\u00e3o }); exports.buscaTodos = function(req, res){ if (connection) { connection.query(&#8216;select * from vinho order by name&#8217;, function(err, rows, fields) { if (err) throw err; res.contentType(&#8216;application\/json&#8217;); res.write(JSON.stringify(rows)); res.end(); }); } };<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[3],"tags":[],"_links":{"self":[{"href":"http:\/\/www.luppi.com.br\/index.php?rest_route=\/wp\/v2\/posts\/43"}],"collection":[{"href":"http:\/\/www.luppi.com.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.luppi.com.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.luppi.com.br\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.luppi.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=43"}],"version-history":[{"count":1,"href":"http:\/\/www.luppi.com.br\/index.php?rest_route=\/wp\/v2\/posts\/43\/revisions"}],"predecessor-version":[{"id":44,"href":"http:\/\/www.luppi.com.br\/index.php?rest_route=\/wp\/v2\/posts\/43\/revisions\/44"}],"wp:attachment":[{"href":"http:\/\/www.luppi.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=43"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.luppi.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=43"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.luppi.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=43"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}