Not sure why it’s escaping the % in your last example, because that works fine for me: // lifted from my code: var value=”ee20e966289cd7″; connection.query(‘SELECT * from django_session where session_key like ?’, ‘%’ + value + ‘%’, …) // Result: [ { session_key: ‘713ee20e966289cd71b936084a1e613e’, … } ] When I turn on debugging in the driver … Read more
Ok, the timeout comes from the Protocol.js file line:162. If you checkout node-mysql you’ll see that it is a variable “timeout” for queries. If you set the timeout to something a lot higher than 10000, the default, then the error should go away. An example is pool = require(‘mysql’).createPool({ connectionLimit : 1000, connectTimeout : 60 … Read more
This is gonna be a little scattered, forgive me. First, assuming this code uses the mysql driver API correctly, here’s one way you could wrap it to work with a native promise: function getLastRecord(name) { return new Promise(function(resolve, reject) { // The Promise constructor should catch any errors thrown on // this tick. Alternately, try/catch … Read more
You can use any number of the XML libraries available on npm. Here’s an example using the simply-named “xml” library: var xml = require(‘xml’); response.set(‘Content-Type’, ‘text/xml’); response.send(xml(name_of_restaurants)); See the module’s documentation for a description of how it converts JavaScript objects to XML. If you need things returned in a specific XML format, you’ll have more … Read more
Use the mysql connection pool. It will reconnect when a connection dies and you get the added benefit of being able to make multiple sql queries at the same time. If you don’t use the database pool, your app will block database requests while waiting for currently running database requests to finish. I usually define … Read more
The node-mysql library automatically performs escaping when used as you are already doing. See https://github.com/felixge/node-mysql#escaping-query-values