{"_id":"pilmee-mysql","_rev":"32-d820893e1ab978516c6c5693ab433308","name":"pilmee-mysql","description":"Library to manage mysql, using the mysql module, shortens the programming necessary to provide greater ease so the developer. Power by @pilmee","dist-tags":{"latest":"1.0.2"},"versions":{"0.0.1":{"name":"pilmee-mysql","version":"0.0.1","private":false,"scripts":{"start":"node app"},"dependencies":{"mysql":"2.0.0-alpha8"},"maintainers":[{"name":"pilmee","email":"pilmee@gmail.com"}],"description":"Libreria para gestionar MySQL - @pilmee","main":"pilmee-mysql.js","keywords":["mysql","mysql manager","pilmee"],"readme":"PiLMee","readmeFilename":"README.md","_id":"pilmee-mysql@0.0.1","dist":{"shasum":"0b5bc9d7842da8c266be622ffd53912aaea936b3","tarball":"https://registry.npmjs.org/pilmee-mysql/-/pilmee-mysql-0.0.1.tgz","integrity":"sha512-exhuSwJexVf/cVvM5wwaeoWGDyV2iczlvpnop2SdeE7oQMhhOQ/MP5CLWZf9ZtUcSE7iIXOy/4hfjRY45nkU4Q==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIFGOfcmSY6uXhM8gFdG1E2FEBR1htxjrrctcLztfpMTgAiEA6DBtzoFkBFtdmbml1wTcx6h99s8Clo0OKO8Mj+2dguA="}]},"_from":".","_npmVersion":"1.2.18","_npmUser":{"name":"pilmee","email":"pilmee@gmail.com"},"directories":{}},"0.0.2":{"name":"pilmee-mysql","version":"0.0.2","private":false,"scripts":{"start":"node app"},"dependencies":{"mysql":"2.0.0-alpha8"},"maintainers":[{"name":"pilmee","email":"pilmee@gmail.com"}],"description":"Libreria para gestionar MySQL - @pilmee","main":"pilmee-mysql.js","keywords":["mysql","mysql manager","pilmee"],"readme":"MYSQL LIBRARY","readmeFilename":"README.md","_id":"pilmee-mysql@0.0.2","dist":{"shasum":"45e58bdfd34e23154a2d55076c7fefa6ce1de97a","tarball":"https://registry.npmjs.org/pilmee-mysql/-/pilmee-mysql-0.0.2.tgz","integrity":"sha512-W9h0cLh8BumOdepaZaZgotERv3RRQCuNN5YSMxfZnyVsDdpB4DtXYeBpKCEsvJeIeqjBvds6HUIc3SnCIhGZmw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCICCTPlgcigvX4WIte0ByPpoPe+aLogU1OoPsfl+3ScLFAiA6riFQVgqBltKEjvWD7y4KvX2Hct/hkC63L6gxlQRqeg=="}]},"_from":".","_npmVersion":"1.2.18","_npmUser":{"name":"pilmee","email":"pilmee@gmail.com"},"directories":{}},"0.0.21":{"name":"pilmee-mysql","version":"0.0.21","private":false,"scripts":{"start":"node app"},"dependencies":{"mysql":"2.0.0-alpha8"},"maintainers":[{"name":"pilmee","email":"pilmee@gmail.com"}],"description":"Libreria para gestionar MySQL - @pilmee","main":"pilmee-mysql.js","keywords":["mysql","mysql manager","pilmee"],"readme":"MYSQL LIBRARY\r\n===================\r\n\r\nSimple library that allows us to connect and use mysql in a simpler\r\n\r\nHOW TO USE\r\n===================\r\n\r\nvar pilmeeMySQL = require('./pilmee-mysql');\r\n\r\n\r\nsetInterval(function(){\r\n\tpilmeeMySQL.run('SELECT * FROM noticias ORDER BY id DESC', function(err, result){\r\n \t\tpilmeeMySQL.sqlList(result, 'id', 'titulo', function(){\r\n \t\t\tconsole.log('\\n Records: ' + result.length);\r\n \t\t});\r\n \t});\r\n},10);\r\n\r\n","readmeFilename":"README.md","_id":"pilmee-mysql@0.0.21","dist":{"shasum":"8ea7ea3e35d8c82ec3332c20199f97f5921814fc","tarball":"https://registry.npmjs.org/pilmee-mysql/-/pilmee-mysql-0.0.21.tgz","integrity":"sha512-QbbThOe56Uv89mVfPTLrhhKaOC1iYvwuJBX12pQAymZpJBZiFwR9/batT4VvsDA2onx78NFoFfoeIcfZ0CN8dQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQC/xFFhmyQrqEaKRELKdTX/ggLflfGOPZNRmzTiQXEg3AIhANKyyHFKDKuNNQ3qkfr6KYK8K0JdjP5WazOeNXu2vXrA"}]},"_from":".","_npmVersion":"1.2.18","_npmUser":{"name":"pilmee","email":"pilmee@gmail.com"},"directories":{}},"0.0.2-a":{"name":"pilmee-mysql","version":"0.0.2-a","private":false,"scripts":{"start":"node app"},"dependencies":{"mysql":"2.0.0-alpha8"},"maintainers":[{"name":"pilmee","email":"pilmee@gmail.com"}],"description":"Libreria para gestionar MySQL - @pilmee","main":"pilmee-mysql.js","keywords":["mysql","mysql manager","pilmee"],"readmeFilename":"README.md","readme":"MYSQL LIBRARY\r\n===================\r\n\r\nSimple library that allows us to connect and use mysql in a simpler\r\n\r\nHOW TO USE\r\n===================\r\n\r\nvar pilmeeMySQL = require('./pilmee-mysql');\r\n\r\n\r\nsetInterval(function(){\r\n\tpilmeeMySQL.run('SELECT * FROM noticias ORDER BY id DESC', function(err, result){\r\n \t\tpilmeeMySQL.sqlList(result, 'id', 'titulo', function(){\r\n \t\t\tconsole.log('\\n Records: ' + result.length);\r\n \t\t});\r\n \t});\r\n},10);\r\n\r\n","_id":"pilmee-mysql@0.0.2-a","dist":{"shasum":"daa44f1c4f1f7ea0c394c6197d5ff22f6415c612","tarball":"https://registry.npmjs.org/pilmee-mysql/-/pilmee-mysql-0.0.2a.tgz","integrity":"sha512-9v+HJvr38uLna+/fjDzJIKsUErWkdC/KGTP4tEMAa3JKAZp4eCGv3bUuTTvJwIOd188xV3yvVXhlC8HOx3D3XA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIE+hh7BUJz4mW9WDnA3fZeWVq9aOSNq7hn8z/NZS+I8zAiBaeoNHKHUVcNSZ2u66T0RzckjiyDf+2sDxms9sLW2Ltg=="}]},"_from":".","_npmVersion":"1.2.18","_npmUser":{"name":"pilmee","email":"pilmee@gmail.com"},"directories":{}},"0.0.2-b":{"name":"pilmee-mysql","version":"0.0.2-b","private":false,"scripts":{"start":"node app"},"dependencies":{"mysql":"2.0.0-alpha8","colors":"0.6.0-1"},"maintainers":[{"name":"pilmee","email":"pilmee@gmail.com"}],"description":"Library to manage mysql, using the mysql module, shortens the programming necessary to provide greater ease so the developer. Power by @pilmee","main":"pilmee-mysql.js","keywords":["mysql","mysql manager","pilmee"],"readmeFilename":"README.md","readme":"![pilmee-mysql logo](http://eticagnu.org/wp-content/uploads/2013/05/pilmee-mysql.png)\r\n\r\n  Library to manage mysql, using the mysql module, shortens the programming necessary to provide greater ease so the developer. \r\n  Power by @pilmee\r\n  \r\n## Installation\r\n\r\n    $ npm install pilmee-mysql\r\n\t\r\n## Example 1 - Basic:\r\n\r\n```js\r\nvar db = require('./pilmee-mysql');\r\n\r\ndb.configure(function(){\r\n\tdb.set('host', 'localhost');\r\n\tdb.set('user', 'root');\r\n\tdb.set('database', 'ninjacode');\r\n});\r\n\r\ndb.run('SELECT * FROM noticias ORDER BY id DESC', function(err, result){\r\n \tconsole.log('\\n Records: ' + result.length);\r\n});\r\n\r\n## Example 2 - Basic:\r\n\r\n```js\r\nvar db = require('./pilmee-mysql');\r\n\r\ndb.configure(function(){\r\n\tdb.set('host', 'localhost');\r\n\tdb.set('user', 'root');\r\n\tdb.set('database', 'ninjacode');\r\n});\r\n\r\ndb.run('SELECT * FROM noticias ORDER BY id DESC', function(err, result){\r\n \tdb.sqlList(result, 'id', 'titulo', function(){\r\n \t\tconsole.log('\\n Records: ' + result.length);\r\n \t});\r\n});\r\n\r\n## Example 2 - Use ExpressJS:\r\n\r\n```js\r\n\r\n/**\r\n * Module dependencies.\r\n */\r\n\r\nvar express = require('express')\r\n  , routes = require('./routes')\r\n  , user = require('./routes/user')\r\n  , http = require('http')\r\n  , path = require('path');\r\n\r\nvar db = require('pilmee-mysql');\r\ndb.configure(function(){\r\n  db.set('host', 'localhost');\r\n  db.set('user', 'root');\r\n  db.set('database', 'ninjacode');\r\n});\r\n\r\nvar app = express();\r\n\r\napp.configure(function(){\r\n  app.set('port', process.env.PORT || 3000);\r\n  app.set('views', __dirname + '/views');\r\n  app.set('view engine', 'jade');\r\n  app.use(express.favicon());\r\n  app.use(express.logger('dev'));\r\n  app.use(express.bodyParser());\r\n  app.use(express.methodOverride());\r\n  app.use(express.cookieParser('your secret here'));\r\n  app.use(express.session());\r\n  app.use(app.router);\r\n  app.use(express.static(path.join(__dirname, 'public')));\r\n});\r\n\r\napp.configure('development', function(){\r\n  app.use(express.errorHandler());\r\n});\r\n\r\napp.get('/', function(req,  res){\r\n  db.run('SELECT * FROM noticias', function(err, result, field){\r\n    res.json(result);\r\n  });\r\n});\r\n\r\nhttp.createServer(app).listen(app.get('port'), function(){\r\n  console.log(\"Express server listening on port \" + app.get('port'));\r\n});\r\n\r\n## Contact:\r\n\r\n  * Twitter: [@pilmee](http://twitter.com/pilmee)\r\n  * Facebook: [PiLMee GaTes](http://fb.com/pilmee)\r\n  * Github: [@pilmee](http://github.com/pilmee)\r\n  * Emails: pilmee@gmail.com, pilmee@eticagnu.org\r\n\t\r\n","_id":"pilmee-mysql@0.0.2-b","dist":{"shasum":"76407166651162d587a6bf4bc380bc7072b19893","tarball":"https://registry.npmjs.org/pilmee-mysql/-/pilmee-mysql-0.0.2-b.tgz","integrity":"sha512-hnGOzA7lq/IsB6OEo9M2tmpmcsoj6wq6rGCsKFU6rd2kId13Nn8O7syagvCE95WEi3Ycz0fpvWPyWuc63/K4mA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCKdluxfU3t9CSG8X87WjTFSKy03DnlJmcUdHl+zD1RSwIgGAWchV5vOma/TMhAI8oJGs5q9D1uEndCIr8Qk2actIM="}]},"_from":".","_npmVersion":"1.2.18","_npmUser":{"name":"pilmee","email":"pilmee@gmail.com"},"directories":{}},"0.0.2-b1":{"name":"pilmee-mysql","version":"0.0.2-b1","private":false,"scripts":{"start":"node app"},"dependencies":{"mysql":"2.0.0-alpha8","colors":"0.6.0-1"},"maintainers":[{"name":"pilmee","email":"pilmee@gmail.com"}],"description":"Library to manage mysql, using the mysql module, shortens the programming necessary to provide greater ease so the developer. Power by @pilmee","main":"pilmee-mysql.js","keywords":["mysql","mysql manager","pilmee"],"readmeFilename":"README.md","readme":"![pilmee-mysql logo](http://eticagnu.org/wp-content/uploads/2013/05/pilmee-mysql.png)\r\n\r\n  Library to manage mysql, using the mysql module, shortens the programming necessary to provide greater ease so the developer. \r\n  Power by @pilmee\r\n  \r\n## Installation\r\n\r\n    $ npm install pilmee-mysql\r\n\t\r\n## Example 1 - Basic:\r\n\r\n```js\r\nvar db = require('./pilmee-mysql');\r\n\r\ndb.configure(function(){\r\n\tdb.set('host', 'localhost');\r\n\tdb.set('user', 'root');\r\n\tdb.set('database', 'ninjacode');\r\n});\r\n\r\ndb.run('SELECT * FROM noticias ORDER BY id DESC', function(err, result){\r\n \tconsole.log('\\n Records: ' + result.length);\r\n});\r\n```\r\n\r\n## Example 2 - Basic:\r\n\r\n```js\r\nvar db = require('./pilmee-mysql');\r\n\r\ndb.configure(function(){\r\n\tdb.set('host', 'localhost');\r\n\tdb.set('user', 'root');\r\n\tdb.set('database', 'ninjacode');\r\n});\r\n\r\ndb.run('SELECT * FROM noticias ORDER BY id DESC', function(err, result){\r\n \tdb.sqlList(result, 'id', 'titulo', function(){\r\n \t\tconsole.log('\\n Records: ' + result.length);\r\n \t});\r\n});\r\n```\r\n\r\n## Example 2 - Use ExpressJS:\r\n\r\n```js\r\n\r\n/**\r\n * Module dependencies.\r\n */\r\n\r\nvar express = require('express')\r\n  , routes = require('./routes')\r\n  , user = require('./routes/user')\r\n  , http = require('http')\r\n  , path = require('path');\r\n\r\nvar db = require('pilmee-mysql');\r\ndb.configure(function(){\r\n  db.set('host', 'localhost');\r\n  db.set('user', 'root');\r\n  db.set('database', 'ninjacode');\r\n});\r\n\r\nvar app = express();\r\n\r\napp.configure(function(){\r\n  app.set('port', process.env.PORT || 3000);\r\n  app.set('views', __dirname + '/views');\r\n  app.set('view engine', 'jade');\r\n  app.use(express.favicon());\r\n  app.use(express.logger('dev'));\r\n  app.use(express.bodyParser());\r\n  app.use(express.methodOverride());\r\n  app.use(express.cookieParser('your secret here'));\r\n  app.use(express.session());\r\n  app.use(app.router);\r\n  app.use(express.static(path.join(__dirname, 'public')));\r\n});\r\n\r\napp.configure('development', function(){\r\n  app.use(express.errorHandler());\r\n});\r\n\r\napp.get('/', function(req,  res){\r\n  db.run('SELECT * FROM noticias', function(err, result, field){\r\n    res.json(result);\r\n  });\r\n});\r\n\r\nhttp.createServer(app).listen(app.get('port'), function(){\r\n  console.log(\"Express server listening on port \" + app.get('port'));\r\n});\r\n```\r\n\r\n## Contact:\r\n\r\n  * Twitter: [@pilmee](http://twitter.com/pilmee)\r\n  * Facebook: [PiLMee GaTes](http://fb.com/pilmee)\r\n  * Github: [@pilmee](http://github.com/pilmee)\r\n  * Emails: pilmee@gmail.com, pilmee@eticagnu.org\r\n\t\r\n","_id":"pilmee-mysql@0.0.2-b1","dist":{"shasum":"92c80524baa91553d705b4e2921bb3cb114a030a","tarball":"https://registry.npmjs.org/pilmee-mysql/-/pilmee-mysql-0.0.2-b1.tgz","integrity":"sha512-L4/KvBIdWI/BvYfHYJKNnAobkw/8CFjJnGVNZHdtvdX+xgSHZhYgyGNxHtrTG42uvdF9V5ZagEW7n5B1O+T9gg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIAFN4rhFMrzkzX49Ke6PJ0vLfqPU/0+jM3YXZCXTl2DFAiBvTLjyzVY7KMXMHrzeFPwg05HEpWrpuhFwH9RqN54lGQ=="}]},"_from":".","_npmVersion":"1.2.18","_npmUser":{"name":"pilmee","email":"pilmee@gmail.com"},"directories":{}},"0.0.2-b2":{"name":"pilmee-mysql","version":"0.0.2-b2","private":false,"scripts":{"start":"node app"},"dependencies":{"mysql":"2.0.0-alpha8","colors":"0.6.0-1"},"maintainers":[{"name":"pilmee","email":"pilmee@gmail.com"}],"description":"Library to manage mysql, using the mysql module, shortens the programming necessary to provide greater ease so the developer. Power by @pilmee","main":"pilmee-mysql.js","keywords":["mysql","mysql manager","pilmee"],"readmeFilename":"README.md","readme":"![pilmee-mysql logo](http://eticagnu.org/wp-content/uploads/2013/05/pilmee-mysql.png)\r\n\r\n  Library to manage mysql, using the mysql module, shortens the programming necessary to provide greater ease so the developer. \r\n  Power by @pilmee\r\n  \r\n## Installation\r\n\r\n    $ npm install pilmee-mysql\r\n\t\r\n## Example 1 - Basic:\r\n\r\n```js\r\nvar db = require('pilmee-mysql');\r\n\r\ndb.configure(function(){\r\n\tdb.set('host', 'localhost');\r\n\tdb.set('user', 'root');\r\n\tdb.set('database', 'ninjacode');\r\n});\r\n\r\ndb.run('SELECT * FROM noticias ORDER BY id DESC', function(err, result){\r\n \tconsole.log('\\n Records: ' + result.length);\r\n});\r\n```\r\n\r\n## Example 2 - Basic:\r\n\r\n```js\r\nvar db = require('pilmee-mysql');\r\n\r\ndb.configure(function(){\r\n\tdb.set('host', 'localhost');\r\n\tdb.set('user', 'root');\r\n\tdb.set('database', 'ninjacode');\r\n});\r\n\r\ndb.run('SELECT * FROM noticias ORDER BY id DESC', function(err, result){\r\n \tdb.sqlList(result, 'id', 'titulo', function(){\r\n \t\tconsole.log('\\n Records: ' + result.length);\r\n \t});\r\n});\r\n```\r\n\r\n## Example 2 - Use ExpressJS:\r\n\r\n```js\r\n\r\n/**\r\n * Module dependencies.\r\n */\r\n\r\nvar express = require('express')\r\n  , routes = require('./routes')\r\n  , user = require('./routes/user')\r\n  , http = require('http')\r\n  , path = require('path');\r\n\r\nvar db = require('pilmee-mysql');\r\ndb.configure(function(){\r\n  db.set('host', 'localhost');\r\n  db.set('user', 'root');\r\n  db.set('database', 'ninjacode');\r\n});\r\n\r\nvar app = express();\r\n\r\napp.configure(function(){\r\n  app.set('port', process.env.PORT || 3000);\r\n  app.set('views', __dirname + '/views');\r\n  app.set('view engine', 'jade');\r\n  app.use(express.favicon());\r\n  app.use(express.logger('dev'));\r\n  app.use(express.bodyParser());\r\n  app.use(express.methodOverride());\r\n  app.use(express.cookieParser('your secret here'));\r\n  app.use(express.session());\r\n  app.use(app.router);\r\n  app.use(express.static(path.join(__dirname, 'public')));\r\n});\r\n\r\napp.configure('development', function(){\r\n  app.use(express.errorHandler());\r\n});\r\n\r\napp.get('/', function(req,  res){\r\n  db.run('SELECT * FROM noticias', function(err, result, field){\r\n    res.json(result);\r\n  });\r\n});\r\n\r\nhttp.createServer(app).listen(app.get('port'), function(){\r\n  console.log(\"Express server listening on port \" + app.get('port'));\r\n});\r\n```\r\n\r\n## Contact:\r\n\r\n  * Twitter: [@pilmee](http://twitter.com/pilmee)\r\n  * Facebook: [PiLMee GaTes](http://fb.com/pilmee)\r\n  * Github: [pilmee](http://github.com/pilmee)\r\n  * Emails: pilmee@gmail.com, pilmee@eticagnu.org\r\n\t\r\n","_id":"pilmee-mysql@0.0.2-b2","dist":{"shasum":"3a6a5e31a0d8b6555bf247e9ec2de17c812deb5a","tarball":"https://registry.npmjs.org/pilmee-mysql/-/pilmee-mysql-0.0.2-b2.tgz","integrity":"sha512-b1mWC0qWrM4JnnzzrtzfRmMiV6vr2GUS1KO/ddnwBxeHO1gKdxfWdaqaaIvWmJbsgQjRFSaAvgtU3ltBcus4Ow==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIH2Zy+e0YIzb4EbJ1WWhuo4z3ATuZPw7x7n2e8ShOU+dAiAgbGDg4Q52OPd7qichqeNDlVhB6J+uYv9SBr54wd6zSw=="}]},"_from":".","_npmVersion":"1.2.18","_npmUser":{"name":"pilmee","email":"pilmee@gmail.com"},"directories":{}},"0.0.2-b3":{"name":"pilmee-mysql","version":"0.0.2-b3","private":false,"scripts":{"start":"node app"},"dependencies":{"mysql":"2.0.0-alpha8","colors":"0.6.0-1"},"maintainers":[{"name":"pilmee","email":"pilmee@gmail.com"}],"description":"Library to manage mysql, using the mysql module, shortens the programming necessary to provide greater ease so the developer. Power by @pilmee","main":"pilmee-mysql.js","keywords":["mysql","mysql manager","pilmee"],"readmeFilename":"README.md","readme":"![pilmee-mysql logo](http://eticagnu.org/wp-content/uploads/2013/05/pilmee-mysql.png)\r\n\r\n  Library to manage mysql, using the mysql module, shortens the programming necessary to provide greater ease so the developer. \r\n  Power by @pilmee\r\n  \r\n## Installation\r\n\r\n    $ npm install pilmee-mysql\r\n\t\r\n## Example 1 - Basic:\r\n\r\n```js\r\nvar db = require('pilmee-mysql');\r\n\r\ndb.configure(function(){\r\n\tdb.set('host', 'localhost');\r\n\tdb.set('user', 'root');\r\n\tdb.set('database', 'ninjacode');\r\n});\r\n\r\ndb.run('SELECT * FROM noticias ORDER BY id DESC', function(err, result){\r\n \tconsole.log('\\n Records: ' + result.length);\r\n});\r\n```\r\n\r\n## Example 2 - Basic:\r\n\r\n```js\r\nvar db = require('pilmee-mysql');\r\n\r\ndb.configure(function(){\r\n\tdb.set('host', 'localhost');\r\n\tdb.set('user', 'root');\r\n\tdb.set('database', 'ninjacode');\r\n});\r\n\r\ndb.run('SELECT * FROM noticias ORDER BY id DESC', function(err, result){\r\n \tdb.sqlList(result, 'id', 'titulo', function(){\r\n \t\tconsole.log('\\n Records: ' + result.length);\r\n \t});\r\n});\r\n```\r\n\r\n## Example 3 - Use ExpressJS:\r\n\r\n```js\r\n\r\n/**\r\n * Module dependencies.\r\n */\r\n\r\nvar express = require('express')\r\n  , routes = require('./routes')\r\n  , user = require('./routes/user')\r\n  , http = require('http')\r\n  , path = require('path');\r\n\r\nvar db = require('pilmee-mysql');\r\ndb.configure(function(){\r\n  db.set('host', 'localhost');\r\n  db.set('user', 'root');\r\n  db.set('database', 'ninjacode');\r\n});\r\n\r\nvar app = express();\r\n\r\napp.configure(function(){\r\n  app.set('port', process.env.PORT || 3000);\r\n  app.set('views', __dirname + '/views');\r\n  app.set('view engine', 'jade');\r\n  app.use(express.favicon());\r\n  app.use(express.logger('dev'));\r\n  app.use(express.bodyParser());\r\n  app.use(express.methodOverride());\r\n  app.use(express.cookieParser('your secret here'));\r\n  app.use(express.session());\r\n  app.use(app.router);\r\n  app.use(express.static(path.join(__dirname, 'public')));\r\n});\r\n\r\napp.configure('development', function(){\r\n  app.use(express.errorHandler());\r\n});\r\n\r\napp.get('/', function(req,  res){\r\n  db.run('SELECT * FROM noticias', function(err, result, field){\r\n    res.json(result);\r\n  });\r\n});\r\n\r\nhttp.createServer(app).listen(app.get('port'), function(){\r\n  console.log(\"Express server listening on port \" + app.get('port'));\r\n});\r\n```\r\n\r\n## Contact:\r\n\r\n  * Twitter: [@pilmee](http://twitter.com/pilmee)\r\n  * Facebook: [PiLMee GaTes](http://fb.com/pilmee)\r\n  * Github: [pilmee](http://github.com/pilmee)\r\n  * Emails: pilmee@gmail.com, pilmee@eticagnu.org\r\n\t\r\n","_id":"pilmee-mysql@0.0.2-b3","dist":{"shasum":"dee5a32da3052f8e84d18b3284db0add5f888c2d","tarball":"https://registry.npmjs.org/pilmee-mysql/-/pilmee-mysql-0.0.2-b3.tgz","integrity":"sha512-9GclglDWRuW1HyttDDErOxjfcVcpAxa4u+YmPUIqxKRxWfsABZqNZwz/LpMbmdic4jtWcRQGBYX6E9m9Vt1lkg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDFTta5bCV55lgwIMLoKzgmb4+UXl8h59kjRkXS8EQMtQIhAM39zXcx3wWM3ksrdG5C9UKAyZB9JQekTo0jGlUt4CY2"}]},"_from":".","_npmVersion":"1.2.18","_npmUser":{"name":"pilmee","email":"pilmee@gmail.com"},"directories":{}},"0.0.3":{"name":"pilmee-mysql","version":"0.0.3","private":false,"scripts":{"start":"node app"},"dependencies":{"mysql":"2.0.0-alpha8","colors":"0.6.0-1","json2xml":"0.0.1"},"maintainers":[{"name":"pilmee","email":"pilmee@gmail.com"}],"description":"Library to manage mysql, using the mysql module, shortens the programming necessary to provide greater ease so the developer. Power by @pilmee","main":"pilmee-mysql.js","keywords":["mysql","mysql manager","pilmee"],"readmeFilename":"README.md","readme":"![pilmee-mysql logo](http://eticagnu.org/wp-content/uploads/2013/05/pilmee-mysql.png)\r\n\r\n  Library to manage mysql, using the mysql module, shortens the programming necessary to provide greater ease so the developer. \r\n  Power by @pilmee\r\n  \r\n## Installation\r\n\r\n    $ npm install pilmee-mysql\r\n\t\r\n## Example 1 - Basic:\r\n\r\n```js\r\nvar db = require('pilmee-mysql');\r\n\r\ndb.configure(function(){\r\n\tdb.set('host', 'localhost');\r\n\tdb.set('user', 'root');\r\n\tdb.set('database', 'ninjacode');\r\n});\r\n\r\ndb.run('SELECT * FROM noticias ORDER BY id DESC', function(err, result){\r\n \tconsole.log('\\n Records: ' + db.results());\r\n});\r\n```\r\n\r\n## Example 2 - Basic:\r\n\r\n```js\r\nvar db = require('pilmee-mysql');\r\n\r\ndb.configure(function(){\r\n\tdb.set('host', 'localhost');\r\n\tdb.set('user', 'root');\r\n\tdb.set('database', 'ninjacode');\r\n});\r\n\r\ndb.run('SELECT * FROM noticias ORDER BY id DESC', function(err, result){\r\n \tdb.list(result, 'id', 'titulo', function(){\r\n \t\tconsole.log('\\n Records: ' + db.results());\r\n \t});\r\n});\r\n```\r\n\r\n## Example 3 - Use ExpressJS:\r\n\r\n```js\r\n\r\n/**\r\n * Module dependencies.\r\n */\r\n\r\nvar express = require('express')\r\n  , routes = require('./routes')\r\n  , user = require('./routes/user')\r\n  , http = require('http')\r\n  , path = require('path');\r\n\r\nvar db = require('pilmee-mysql');\r\ndb.configure(function(){\r\n  db.set('host', 'localhost');\r\n  db.set('user', 'root');\r\n  db.set('database', 'ninjacode');\r\n});\r\n\r\nvar app = express();\r\n\r\napp.configure(function(){\r\n  app.set('port', process.env.PORT || 3000);\r\n  app.set('views', __dirname + '/views');\r\n  app.set('view engine', 'jade');\r\n  app.use(express.favicon());\r\n  app.use(express.logger('dev'));\r\n  app.use(express.bodyParser());\r\n  app.use(express.methodOverride());\r\n  app.use(express.cookieParser('your secret here'));\r\n  app.use(express.session());\r\n  app.use(app.router);\r\n  app.use(express.static(path.join(__dirname, 'public')));\r\n});\r\n\r\napp.configure('development', function(){\r\n  app.use(express.errorHandler());\r\n});\r\n\r\n/* DATA JSON */\r\napp.get('/', function(req,  res){\r\n  db.run('SELECT * FROM noticias', function(err, result, field){\r\n    res.json(result);\r\n  });\r\n});\r\n\r\n/* DATA XML */\r\napp.get('/xml', function(req,  res){\r\n  db.run('SELECT * FROM noticias', function(err, result, field){\r\n    res.send(db.toXML(result));\r\n  });\r\n});\r\n\r\nhttp.createServer(app).listen(app.get('port'), function(){\r\n  console.log(\"Express server listening on port \" + app.get('port'));\r\n});\r\n```\r\n\r\n## Contact:\r\n\r\n  * Twitter: [@pilmee](http://twitter.com/pilmee)\r\n  * Facebook: [PiLMee GaTes](http://fb.com/pilmee)\r\n  * Github: [pilmee](http://github.com/pilmee)\r\n  * Emails: pilmee@gmail.com, pilmee@eticagnu.org\r\n\t\r\n","_id":"pilmee-mysql@0.0.3","dist":{"shasum":"3422558cf9d8c04ea2ba85be95d340c05774e6be","tarball":"https://registry.npmjs.org/pilmee-mysql/-/pilmee-mysql-0.0.3.tgz","integrity":"sha512-L9A/2hlioaH1X1gMR1YoKaA+peWn8BXTi4VWt+hFXzXt0dOQ2Ob2P2tCVMKznQWm+z1j9cMX/oOQOfu43sekHQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCxJacA9XtTU8GSn10JvEyLTQZUCeKjr3o7emFKPbR1agIhAINtUWAZ/vSqFh/lTKH2dLnLBzjwb3iKZXUfAhHdbQgV"}]},"_from":".","_npmVersion":"1.2.18","_npmUser":{"name":"pilmee","email":"pilmee@gmail.com"},"directories":{}},"0.0.3-a":{"name":"pilmee-mysql","version":"0.0.3-a","private":false,"scripts":{"start":"node app"},"dependencies":{"mysql":"2.0.0-alpha8","colors":"0.6.0-1","xml-mapping":"1.2.1"},"maintainers":[{"name":"pilmee","email":"pilmee@gmail.com"}],"description":"Library to manage mysql, using the mysql module, shortens the programming necessary to provide greater ease so the developer. Power by @pilmee","main":"pilmee-mysql.js","keywords":["mysql","mysql manager","pilmee"],"readmeFilename":"README.md","readme":"![pilmee-mysql logo](http://eticagnu.org/wp-content/uploads/2013/05/pilmee-mysql.png)\r\n\r\n  Library to manage mysql, using the mysql module, shortens the programming necessary to provide greater ease so the developer. \r\n  Power by @pilmee\r\n  \r\n## Installation\r\n\r\n    $ npm install pilmee-mysql\r\n\t\r\n## Example 1 - Basic:\r\n\r\n```js\r\nvar db = require('pilmee-mysql');\r\n\r\ndb.configure(function(){\r\n\tdb.set('host', 'localhost');\r\n\tdb.set('user', 'root');\r\n\tdb.set('database', 'ninjacode');\r\n});\r\n\r\ndb.run('SELECT * FROM noticias ORDER BY id DESC', function(err, result){\r\n \tconsole.log('\\n Records: ' + db.results());\r\n});\r\n```\r\n\r\n## Example 2 - Basic:\r\n\r\n```js\r\nvar db = require('pilmee-mysql');\r\n\r\ndb.configure(function(){\r\n\tdb.set('host', 'localhost');\r\n\tdb.set('user', 'root');\r\n\tdb.set('database', 'ninjacode');\r\n});\r\n\r\ndb.run('SELECT * FROM noticias ORDER BY id DESC', function(err, result){\r\n \tdb.list(result, 'id', 'titulo', function(){\r\n \t\tconsole.log('\\n Records: ' + db.results());\r\n \t});\r\n});\r\n```\r\n\r\n## Example 3 - Use ExpressJS:\r\n\r\n```js\r\n\r\n/**\r\n * Module dependencies.\r\n */\r\n\r\nvar express = require('express')\r\n  , routes = require('./routes')\r\n  , user = require('./routes/user')\r\n  , http = require('http')\r\n  , path = require('path');\r\n\r\nvar db = require('pilmee-mysql');\r\ndb.configure(function(){\r\n  db.set('host', 'localhost');\r\n  db.set('user', 'root');\r\n  db.set('database', 'ninjacode');\r\n});\r\n\r\nvar app = express();\r\n\r\napp.configure(function(){\r\n  app.set('port', process.env.PORT || 3000);\r\n  app.set('views', __dirname + '/views');\r\n  app.set('view engine', 'jade');\r\n  app.use(express.favicon());\r\n  app.use(express.logger('dev'));\r\n  app.use(express.bodyParser());\r\n  app.use(express.methodOverride());\r\n  app.use(express.cookieParser('your secret here'));\r\n  app.use(express.session());\r\n  app.use(app.router);\r\n  app.use(express.static(path.join(__dirname, 'public')));\r\n});\r\n\r\napp.configure('development', function(){\r\n  app.use(express.errorHandler());\r\n});\r\n\r\n/* DATA JSON */\r\napp.get('/', function(req,  res){\r\n  db.run('SELECT * FROM noticias', function(err, result, field){\r\n    res.json(result);\r\n  });\r\n});\r\n\r\n/* DATA XML */\r\napp.get('/xml', function(req,  res){\r\n  db.run('SELECT * FROM noticias', function(err, result, field){\r\n    db.toXML(result, function(xml){\r\n      res.send(xml);\r\n    });\r\n  });\r\n});\r\n\r\nhttp.createServer(app).listen(app.get('port'), function(){\r\n  console.log(\"Express server listening on port \" + app.get('port'));\r\n});\r\n```\r\n\r\n## Contact:\r\n\r\n  * Twitter: [@pilmee](http://twitter.com/pilmee)\r\n  * Facebook: [PiLMee GaTes](http://fb.com/pilmee)\r\n  * Github: [pilmee](http://github.com/pilmee)\r\n  * Emails: pilmee@gmail.com, pilmee@eticagnu.org\r\n\t\r\n","_id":"pilmee-mysql@0.0.3-a","dist":{"shasum":"81b8f4f9d3e110683c0c18d4c237f909b0d4ef0f","tarball":"https://registry.npmjs.org/pilmee-mysql/-/pilmee-mysql-0.0.3a.tgz","integrity":"sha512-tFYFy/veT7Ecla0ko340jxac29OvOer1ALxZBhvdHPmy6UxFsh9RSrSbl2ajHiNIjNeFR38hbHSNC4ocOclaeg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCJUv0pmInfIHmWSxXlVvh+M2tuezc4TNN1LCBqLnO+fwIgJY35HHkG+0U7VjhGwB2gYceq3Z3SgxIqoOH3axJ4zDQ="}]},"_from":".","_npmVersion":"1.2.18","_npmUser":{"name":"pilmee","email":"pilmee@gmail.com"},"directories":{}},"0.0.3-b":{"name":"pilmee-mysql","version":"0.0.3-b","private":false,"scripts":{"start":"node app"},"dependencies":{"mysql":"2.0.0-alpha8","colors":"0.6.0-1","xml-mapping":"1.2.1"},"maintainers":[{"name":"pilmee","email":"pilmee@gmail.com"}],"description":"Library to manage mysql, using the mysql module, shortens the programming necessary to provide greater ease so the developer. Power by @pilmee","main":"pilmee-mysql.js","keywords":["mysql","mysql manager","pilmee"],"readmeFilename":"README.md","readme":"![pilmee-mysql logo](http://eticagnu.org/wp-content/uploads/2013/05/pilmee-mysql.png)\r\n\r\n  Library to manage mysql, using the mysql module, shortens the programming necessary to provide greater ease so the developer. \r\n  Power by @pilmee\r\n  \r\n## Installation\r\n\r\n    $ npm install pilmee-mysql\r\n\t\r\n## Example 1 - Basic:\r\n\r\n```js\r\nvar db = require('pilmee-mysql');\r\n\r\ndb.configure(function(){\r\n\tdb.set('host', 'localhost');\r\n\tdb.set('user', 'root');\r\n\tdb.set('database', 'ninjacode');\r\n});\r\n\r\ndb.run('SELECT * FROM noticias ORDER BY id DESC', function(err, result){\r\n \tconsole.log('\\n Records: ' + db.results());\r\n});\r\n```\r\n\r\n## Example 2 - Basic:\r\n\r\n```js\r\nvar db = require('pilmee-mysql');\r\n\r\ndb.configure(function(){\r\n\tdb.set('host', 'localhost');\r\n\tdb.set('user', 'root');\r\n\tdb.set('database', 'ninjacode');\r\n});\r\n\r\ndb.run('SELECT * FROM noticias ORDER BY id DESC', function(err, result){\r\n \tdb.list(result, 'id', 'titulo', function(){\r\n \t\tconsole.log('\\n Records: ' + db.results());\r\n \t});\r\n});\r\n```\r\n\r\n## Example 3 - Use ExpressJS:\r\n\r\n```js\r\n\r\n/**\r\n * Module dependencies.\r\n */\r\n\r\nvar express = require('express')\r\n  , routes = require('./routes')\r\n  , user = require('./routes/user')\r\n  , http = require('http')\r\n  , path = require('path');\r\n\r\nvar db = require('pilmee-mysql');\r\ndb.configure(function(){\r\n  db.set('host', 'localhost');\r\n  db.set('user', 'root');\r\n  db.set('database', 'ninjacode');\r\n});\r\n\r\nvar app = express();\r\n\r\napp.configure(function(){\r\n  app.set('port', process.env.PORT || 3000);\r\n  app.set('views', __dirname + '/views');\r\n  app.set('view engine', 'jade');\r\n  app.use(express.favicon());\r\n  app.use(express.logger('dev'));\r\n  app.use(express.bodyParser());\r\n  app.use(express.methodOverride());\r\n  app.use(express.cookieParser('your secret here'));\r\n  app.use(express.session());\r\n  app.use(app.router);\r\n  app.use(express.static(path.join(__dirname, 'public')));\r\n});\r\n\r\napp.configure('development', function(){\r\n  app.use(express.errorHandler());\r\n});\r\n\r\n/* DATA JSON */\r\napp.get('/', function(req,  res){\r\n  db.run('SELECT * FROM noticias', function(err, result, field){\r\n    res.json(result);\r\n  });\r\n});\r\n\r\n/* DATA XML */\r\napp.get('/xml', function(req,  res){\r\n  db.run('SELECT * FROM noticias', function(err, result, field){\r\n    db.toXML(result, function(xml){\r\n      res.send(xml);\r\n    });\r\n  });\r\n});\r\n\r\nhttp.createServer(app).listen(app.get('port'), function(){\r\n  console.log(\"Express server listening on port \" + app.get('port'));\r\n});\r\n```\r\n\r\n## Contact:\r\n\r\n  * Twitter: [@pilmee](http://twitter.com/pilmee)\r\n  * Facebook: [PiLMee GaTes](http://fb.com/pilmee)\r\n  * Github: [pilmee](http://github.com/pilmee)\r\n  * Emails: pilmee@gmail.com, pilmee@eticagnu.org\r\n\t\r\n","_id":"pilmee-mysql@0.0.3-b","dist":{"shasum":"2cebe329dc9eaf641971f948553a411b6f15503a","tarball":"https://registry.npmjs.org/pilmee-mysql/-/pilmee-mysql-0.0.3b.tgz","integrity":"sha512-RU0mOUMwaEs+dgJSVywQtNd+TG5Cxf4WKHcT1ua2JJ+olRuE8CfV5iNuN8ibQlekfIEsf0k8LsHRlI6G+VCdDQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIEFtbkMsAW2HpEU5pO8v/ElzArYC+mdsLRiHuTNhvlgIAiEAlaS5nguOavEnlzsURmBWPXvZ5zbFxRADfPdhhRAlPZM="}]},"_from":".","_npmVersion":"1.2.18","_npmUser":{"name":"pilmee","email":"pilmee@gmail.com"},"directories":{}},"0.0.3-c":{"name":"pilmee-mysql","version":"0.0.3-c","private":false,"scripts":{"start":"node app"},"dependencies":{"mysql":"2.0.0-alpha8","colors":"0.6.0-1","xml-mapping":"1.2.1"},"maintainers":[{"name":"pilmee","email":"pilmee@gmail.com"}],"description":"Library to manage mysql, using the mysql module, shortens the programming necessary to provide greater ease so the developer. Power by @pilmee","main":"pilmee-mysql.js","keywords":["mysql","mysql manager","pilmee"],"readmeFilename":"README.md","readme":"![pilmee-mysql logo](http://eticagnu.org/wp-content/uploads/2013/05/pilmee-mysql.png)\r\n\r\n  Library to manage mysql, using the mysql module, shortens the programming necessary to provide greater ease so the developer. \r\n  Power by @pilmee\r\n  \r\n## Installation\r\n\r\n    $ npm install pilmee-mysql\r\n\t\r\n## Example 1 - Basic:\r\n\r\n```js\r\nvar db = require('pilmee-mysql');\r\n\r\ndb.configure(function(){\r\n\tdb.set('host', 'localhost');\r\n\tdb.set('user', 'root');\r\n\tdb.set('database', 'ninjacode');\r\n});\r\n\r\ndb.run('SELECT * FROM noticias ORDER BY id DESC', function(err, result){\r\n \tconsole.log('\\n Records: ' + db.results());\r\n});\r\n```\r\n\r\n## Example 2 - Basic:\r\n\r\n```js\r\nvar db = require('pilmee-mysql');\r\n\r\ndb.configure(function(){\r\n\tdb.set('host', 'localhost');\r\n\tdb.set('user', 'root');\r\n\tdb.set('database', 'ninjacode');\r\n});\r\n\r\ndb.run('SELECT * FROM noticias ORDER BY id DESC', function(err, result){\r\n \tdb.list(result, 'id', 'titulo', function(){\r\n \t\tconsole.log('\\n Records: ' + db.results());\r\n \t});\r\n});\r\n```\r\n\r\n## Example 3 - Use ExpressJS:\r\n\r\n```js\r\n\r\n/**\r\n * Module dependencies.\r\n */\r\n\r\nvar express = require('express')\r\n  , routes = require('./routes')\r\n  , user = require('./routes/user')\r\n  , http = require('http')\r\n  , path = require('path');\r\n\r\nvar db = require('pilmee-mysql');\r\ndb.configure(function(){\r\n  db.set('host', 'localhost');\r\n  db.set('user', 'root');\r\n  db.set('database', 'ninjacode');\r\n});\r\n\r\nvar app = express();\r\n\r\napp.configure(function(){\r\n  app.set('port', process.env.PORT || 3000);\r\n  app.set('views', __dirname + '/views');\r\n  app.set('view engine', 'jade');\r\n  app.use(express.favicon());\r\n  app.use(express.logger('dev'));\r\n  app.use(express.bodyParser());\r\n  app.use(express.methodOverride());\r\n  app.use(express.cookieParser('your secret here'));\r\n  app.use(express.session());\r\n  app.use(app.router);\r\n  app.use(express.static(path.join(__dirname, 'public')));\r\n});\r\n\r\napp.configure('development', function(){\r\n  app.use(express.errorHandler());\r\n});\r\n\r\n/* DATA JSON */\r\napp.get('/', function(req,  res){\r\n  db.run('SELECT * FROM noticias', function(err, result, field){\r\n    res.json(result);\r\n  });\r\n});\r\n\r\n/* DATA XML */\r\napp.get('/xml', function(req,  res){\r\n  db.run('SELECT * FROM noticias', function(err, result, field){\r\n    db.toXML(result, function(xml){\r\n      res.send(xml);\r\n    });\r\n  });\r\n});\r\n\r\nhttp.createServer(app).listen(app.get('port'), function(){\r\n  console.log(\"Express server listening on port \" + app.get('port'));\r\n});\r\n```\r\n\r\n## Contact:\r\n\r\n  * Twitter: [@pilmee](http://twitter.com/pilmee)\r\n  * Facebook: [PiLMee GaTes](http://fb.com/pilmee)\r\n  * Github: [pilmee](http://github.com/pilmee)\r\n  * Emails: pilmee@gmail.com, pilmee@eticagnu.org\r\n\t\r\n","_id":"pilmee-mysql@0.0.3-c","dist":{"shasum":"f55a76681fe22652966943763dac7ea1d196e30a","tarball":"https://registry.npmjs.org/pilmee-mysql/-/pilmee-mysql-0.0.3c.tgz","integrity":"sha512-Yae3oDpit+RtPzf6+nXe1qCVj6HqNVRiu5bynccyVxpMW+KJGILLz/8lr/oOVp/pQxXJJHYkWeLKWHAKjDszFA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIHzyf8saB2ByjiOswEUkbyioVUfXnwhI6LB9mHdZaCXlAiBTAPISHk5eLcYQkxzJ6NCr9kllSiINiEk8gMM0NHquhw=="}]},"_from":".","_npmVersion":"1.2.18","_npmUser":{"name":"pilmee","email":"pilmee@gmail.com"},"directories":{}},"1.0.1":{"dependencies":{"colors":"0.6.0-1","mysql":"2.0.0-alpha8","xml-mapping":"1.2.1"},"devDependencies":{"jasmine":"^3.2.0"},"description":"Library to manage mysql, using the mysql module, shortens the programming necessary to provide greater ease so the developer. Power by @pilmee","keywords":["mysql","mysql-manager"],"main":"pilmee-mysql.js","maintainers":[{"name":"pilmee","email":"pilmee@gmail.com"}],"name":"pilmee-mysql","private":false,"scripts":{"start":"node app"},"version":"1.0.1","gitHead":"b22b1bbe966ff65e564c9a11c3982380d8c1ab1b","_id":"pilmee-mysql@1.0.1","_npmVersion":"6.2.0","_nodeVersion":"10.9.0","_npmUser":{"name":"pilmee","email":"pilmee@gmail.com"},"dist":{"integrity":"sha512-MXwnZzFXb5QIvHBESIC+mxtb/rdtEfU4vo5L9jfen3CBJZuLBP0QtXzlVrIH6rcfUOkBsFWYFrVD9Zk7Ew7H9A==","shasum":"a294689f20f1fa1304170dc981ee1f40fc555073","tarball":"https://registry.npmjs.org/pilmee-mysql/-/pilmee-mysql-1.0.1.tgz","fileCount":5,"unpackedSize":7930,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJbdv4PCRA9TVsSAnZWagAANJQP/0TmDFr+VBkldYk0BHnE\nDmQjDYfIX0zKBe2W5rjqEMbxcf5eCoDbnWYovzhB4h98duAQ0V0u9vzi6gQE\niUsqKpwi23aujvnZy6963Bv7/Rj/03G4L1pdql1wIYzOERBmuIQDvW1O1LAg\nCG9BUw88xutlP9KkQz1X0vOiP8GyNEKT6jXQBHIHQvqmCJhef6jqVuq3564r\nyxK022S1kP/+7pToay27DMTSlwIV8r0vbzAQ3uKS6f2odOvv+ZREoAlsU2F2\n6L0GoKqD1VxFPMph6Df110TyXv+6m08qXJ61xdvcqm2mEa0p0Oy55YJAgiTV\njSJ6ieW3jrqYxjwgRnt36Te9H7jiBbsT0lCWbeV4eXFc8hpBVjZvYXjVPDns\nya20TRYUO0jIhk+bkV5GXcJ+jFlonrhgfPgQRMDevtFwRLH8df4xM0VzQ23j\nCFi+k5xdGOcdkxunLw9FFt+N9w9Qlwxus1nNE0fsRwDt2ifFbS/ERjgUp+S0\nUHIj+gUtpYm6y+Nl67BCx6fwpuBt23uyPWgnHZWp7KAJcmcZkzYEef+dWY2n\nzg+SrnuhZh3jJ5ZlX1mEtpP/LFqji3R4RQ8dJA+snal8t1qxaTaAsv2r33CL\nlCZFmwGVr4YXRWJg4MAtcwmWaT0w9LSynHQzL+7rBpYT362g/q3tZ0dbEZbn\n7tti\r\n=MZAM\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDk8t9jLEuOh8hrtNJrqePEBTuZP6uxocjzWU1HZ9R7zgIhAJY8tMZGEOCWKuqO8WeyjV5SYdeWYx02lvGZekt/NatK"}]},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pilmee-mysql_1.0.1_1534524943430_0.05907385383308261"},"_hasShrinkwrap":false},"1.0.2":{"dependencies":{"colors":"0.6.0-1","mysql":"2.0.0-alpha8","xml-mapping":"1.2.1"},"devDependencies":{"jasmine":"^3.2.0"},"description":"Library to manage mysql, using the mysql module, shortens the programming necessary to provide greater ease so the developer. Power by @pilmee","keywords":["mysql","mysql-manager"],"main":"pilmee-mysql.js","maintainers":[{"name":"pilmee","email":"pilmee@gmail.com"}],"name":"pilmee-mysql","private":false,"scripts":{"start":"node app"},"version":"1.0.2","license":"MIT","gitHead":"139eeff4d7c0f09677d51500d6fbf4689c3483fd","_id":"pilmee-mysql@1.0.2","_npmVersion":"6.2.0","_nodeVersion":"10.9.0","_npmUser":{"name":"pilmee","email":"pilmee@gmail.com"},"dist":{"integrity":"sha512-olenGy1dHSFGqXiPQY3SB/BlOmYTMIZ8STpuMchDUjgtbCH4qI7/Ght/4kPSvAOQHLIaq0M3kKqTByObHsnLMQ==","shasum":"ff8e27871ef922183f88c475219a243a7074d501","tarball":"https://registry.npmjs.org/pilmee-mysql/-/pilmee-mysql-1.0.2.tgz","fileCount":5,"unpackedSize":7950,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJbdz0VCRA9TVsSAnZWagAAX/oP/13JVZfrQuH4LKfLwuBt\nUFjKnEFRpPorAONFCfZtrd0HT6Jy+4rgE3gPz+eoAaFwxNRJRXqd4E+ihm0E\n2iy+eLREksDhFs4fCpqDgOraV1pm3Z8MCBjMaFv+KLE2FXVCoYWAyKwexjU8\nd3Bu/01bhXvzn1fGiCHCrFYlHhTBVPoSSoBb0a6Azrqm9IjtUkOqTVHtCl53\n3mfP/2JBPQU7rQF1d9gAGIKepF3SErSfyAos2BCal//xiEUPE16AqODmj/dO\nYMtm43PabV4QLLS/dDt5TNY/z0A37NPbCE3VUHIXGW54ThDClPTogcJzEqs+\nlN/ugLklBPaFvo/NhjY4awViCxZqXRcfekPtysAwbEHTrgPdekE1ZaSlVdKa\nAUE9yK4uI4zR+D+Z5M3YC9WbYKHtZU+qrKn2dfM4dMvnAXewhT+boUcOmjRF\nxbmMlkNofYvqEudOY5xAXr2T6LdVw40+1a3nYUK97ew4yUOa6IDW69rT2Jrt\niG8QEz9MEe9yg3V76hOv6mUmSvwVg9SezN5Cg9rbl/lBsSKVvNyXWATBXswg\n+ZyDlbHEV0pAROssMJgH/a2qGx5lwXm8Yiry6RM7tn+lR1zfmd9B4yyFuYsJ\nRiIafX347DYHL+OaRjVsxW3Q43l6ROTf5vTWYvfOFkd1EhjIqLNOVenZNhfo\nJXxc\r\n=TtLH\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIBUaIqfo4/OLdMX4rQnLG5j4bX6hlyl+CuXTfWfwHd9TAiBiNfjprv4zDvVEIjwNAH+QXFgVFi13Lj/vxD+Imqrm6A=="}]},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pilmee-mysql_1.0.2_1534541077173_0.06504879855203272"},"_hasShrinkwrap":false}},"readme":"![pilmee-mysql logo](http://eticagnu.org/wp-content/uploads/2013/05/pilmee-mysql.png)\n\n  Library to manage mysql, using the mysql module, shortens the programming necessary to provide greater ease so the developer. \n  Power by @pilmee\n  \n## Installation\n\n    $ npm install pilmee-mysql\n  \n## Example 1 - Basic:\n\n```js\nvar db = require('pilmee-mysql');\n\ndb.configure(function(){\n\tdb.set('host', 'localhost');\n\tdb.set('user', 'root');\n\tdb.set('database', 'ninjacode');\n});\n\ndb.run('SELECT * FROM noticias ORDER BY id DESC', function(err, result){\n \tconsole.log('\\n Records: ' + db.results());\n});\n```\n\n## Example 2 - Basic:\n\n```js\nvar db = require('pilmee-mysql');\n\ndb.configure(function(){\n\tdb.set('host', 'localhost');\n\tdb.set('user', 'root');\n\tdb.set('database', 'ninjacode');\n});\n\ndb.run('SELECT * FROM noticias ORDER BY id DESC', function(err, result){\n \tdb.list(result, 'id', 'titulo', function(){\n \t\tconsole.log('\\n Records: ' + db.results());\n \t});\n});\n```\n\n## Example 3 - Use ExpressJS:\n\n```js\n\n/**\n * Module dependencies.\n */\n\nvar express = require('express')\n  , routes = require('./routes')\n  , user = require('./routes/user')\n  , http = require('http')\n  , path = require('path');\n\nvar db = require('pilmee-mysql');\ndb.configure(function(){\n  db.set('host', 'localhost');\n  db.set('user', 'root');\n  db.set('database', 'ninjacode');\n});\n\nvar app = express();\n\napp.configure(function(){\n  app.set('port', process.env.PORT || 3000);\n  app.set('views', __dirname + '/views');\n  app.set('view engine', 'jade');\n  app.use(express.favicon());\n  app.use(express.logger('dev'));\n  app.use(express.bodyParser());\n  app.use(express.methodOverride());\n  app.use(express.cookieParser('your secret here'));\n  app.use(express.session());\n  app.use(app.router);\n  app.use(express.static(path.join(__dirname, 'public')));\n});\n\napp.configure('development', function(){\n  app.use(express.errorHandler());\n});\n\napp.get('/', function(req,  res){\n  db.run('SELECT * FROM noticias', function(err, result, field){\n    res.json(result);\n  });\n});\n\napp.get('/xml', function(req,  res){\n  db.run('SELECT * FROM noticias', function(err, result, field){\n    db.toXML(result, function(xml){\n      res.send(xml);\n    });\n  });\n});\n\nhttp.createServer(app).listen(app.get('port'), function(){\n  console.log(\"Express server listening on port \" + app.get('port'));\n});\n```\n\n## Contact:\n\n  * Twitter: [@pilmee](http://twitter.com/pilmee)\n  * Github: [pilmee](http://github.com/pilmee)\n  * Email: pilmee@gmail.com\n\t\n","maintainers":[{"name":"pilmee","email":"pilmee@gmail.com"}],"time":{"modified":"2022-06-23T23:24:22.337Z","created":"2013-05-09T20:40:36.109Z","0.0.1":"2013-05-09T20:40:58.054Z","0.0.2":"2013-05-09T20:45:46.543Z","0.0.21":"2013-05-09T23:10:49.060Z","0.0.2-a":"2013-05-09T23:15:23.106Z","0.0.2-b":"2013-05-10T03:29:39.333Z","0.0.2-b1":"2013-05-10T03:40:02.239Z","0.0.2-b2":"2013-05-10T03:54:18.311Z","0.0.2-b3":"2013-05-10T03:59:06.887Z","0.0.3":"2013-05-15T00:56:08.071Z","0.0.3-a":"2013-05-15T01:13:25.602Z","0.0.3-b":"2013-05-15T01:15:15.016Z","0.0.3-c":"2013-05-15T01:25:49.424Z","1.0.1":"2018-08-17T16:55:43.533Z","1.0.2":"2018-08-17T21:24:37.260Z"},"keywords":["mysql","mysql-manager"],"readmeFilename":"README.md","license":"MIT"}