{"_id":"@alfa-wells/alfa-data-client","_rev":"5-ceaf6b951135cef11e1505437f4f7e66","name":"@alfa-wells/alfa-data-client","dist-tags":{"latest":"0.2.1"},"versions":{"0.1.0":{"name":"@alfa-wells/alfa-data-client","version":"0.1.0","description":"Client for Alfa-Data","main":"index.js","scripts":{"test":"mocha"},"author":{"name":"leolobeto"},"license":"ISC","dependencies":{"axios":"^0.18.0"},"devDependencies":{"node-mock-server":"^0.23.6"},"_id":"@alfa-wells/alfa-data-client@0.1.0","_npmVersion":"6.4.1","_nodeVersion":"10.12.0","_npmUser":{"name":"leolobeto","email":"leolobeto@gmail.com"},"dist":{"integrity":"sha512-Amc4qIN5/N3/6iEIjUF9xSVbydLoNKZQymHVP8QJnInIQu/rMzhJqlxwiqEMTwrMMHoGvntE3AHfAAMf1yA+NQ==","shasum":"9b56f4d2132dfacd6b52b4aae16ae3e37a6072ef","tarball":"https://registry.npmjs.org/@alfa-wells/alfa-data-client/-/alfa-data-client-0.1.0.tgz","fileCount":37,"unpackedSize":17923,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJb+NwvCRA9TVsSAnZWagAAu9AP/2lSmtfsrBgzwbkBJrxx\nLvhFWV/9qoxom0/u19Ieql3oTM5LTEqO89ondxsU2/mfxbSzCGGcb6ZUf1e7\nQzV2j4PbwijMHxyk9u4e65PC5AXmHo1ZfKMyM/lzJHnfRpa21HS+wF29n5lW\ntzRiI3wkCeBdz0ghXqL7wraOhYy7k2tWNdH4kMmH9NLOm1Rr819oLIASnV08\nQQknf2zjep/CrA7fhTRkVYY365pEDL+p/JKK0V9i29IALzP78hhePGCPAp8a\nousqQFW9alqT1iLYrqAvKQZtGnUm0yCBM3HjVn3YZ9jwRCrYTwtcxv9ho/Ee\nVH1X0Aj9+1DwgcmTgW7lWEFyo+aCVHcVQInCI7xZWs0esV8DAf9iJQru42EZ\nI7oWpYasdvrXGsdMMX/JTYYCdI2WGUOaK6MXYDlzmjOmt2/Evi1cG6qIiocu\nZFJuwGNQAY8jxD4Rl7fSzcqDVwW2uUXBdcDWRnUKIJAakyF2T6mSevaV4srV\npDaMI6WQI8QOQFLqW2xE68e0D6aH/y2QkJrlYypThrmsLyAkjvK9zjh4M48t\nQtB62rOUsqXxJ1v2xISyRVZbgBvYRqp62d+6Ybkv1iS+t87wgoRqWQYhN37T\nLOKGFgCw5cwf1G+OIwPVQB0Fb82nsMBBMXjiCFfa5GOODMeGoLPd1tw7jAL1\ny4/Z\r\n=PVBM\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDrg2x4cHh9jyIwXYGHjABIlLemawegLkF4fvScIibrCwIgQPQDkJOvjnrd/RQZWHHXa7NhN4+BGQWrqflSffobnqE="}]},"maintainers":[{"name":"leolobeto","email":"leolobeto@gmail.com"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/alfa-data-client_0.1.0_1543035951055_0.5334409607051747"},"_hasShrinkwrap":false},"0.1.1":{"name":"@alfa-wells/alfa-data-client","version":"0.1.1","description":"Client for Alfa-Data","main":"index.js","scripts":{"test":"mocha"},"author":{"name":"leolobeto"},"license":"ISC","dependencies":{"axios":"^0.18.0"},"devDependencies":{"node-mock-server":"^0.23.6"},"_id":"@alfa-wells/alfa-data-client@0.1.1","_npmVersion":"6.4.1","_nodeVersion":"10.12.0","_npmUser":{"name":"leolobeto","email":"leolobeto@gmail.com"},"dist":{"integrity":"sha512-yG6go6WVZc2W2CF38RR6hZivZNjfbMzZM3kpnB0J4VVcyR/8VJXbvbky+ytkAQhQX5B4MFuUdB0rhhuwNqig2w==","shasum":"e3c7c492e155979313ef51255ccad39b22eecf80","tarball":"https://registry.npmjs.org/@alfa-wells/alfa-data-client/-/alfa-data-client-0.1.1.tgz","fileCount":37,"unpackedSize":18101,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJb+xKaCRA9TVsSAnZWagAAyrkP/An9Bc5ZgA8GU5+ozSul\nF6JwOzO6bjIJ6X/rQOWDwrqmzMG7wMvPaDSh718U0b906R1Pgff70/2Nbrgb\np3E1Ps8HXgr7iSWaCHEwk69FpidR1ej0rdNqAjtaVSAynXH+cd5IYAolqcZ2\nHVeRQ6jGyTfg7emFAn5tlMkyUaxZfUkSWCeUbY+kFRBdLHxZIkI7+n8fFppo\n1/LsRD7BiYF7ddrvIrEHXTZw/l8aNL/HjzKL6UcJTBrpqBxo/7rrVCfQAAd0\nUxDvOJAcmctnMpPPRVTwOOYqSZrfD/P0DRQluuB5I6vtzVbrKVFMQNDLjKx4\n/WvlmJnY1E8t+Lw7SY22KB2AeYQ++YQsOHAzbBwTcQX4Y/Ru7BVn4LPMq6En\nenXj+EZefEbnSS/0KkcWMa53RgSDlZHtF9hHUQl/4L3HTx/Ug+JBcNtHbkQk\nqg8Vrou06omN64P8YsRP8FGjaYWh08qlbF71r1SfsCA7Vt2TqFWl+Ky5W9Z1\nowMuwS7gRd2buAHPPiVsN9oh3WHlLkorO5GWaVSOdy+QTrJxD1KmhfROQfHc\nFU/EtJJfOI9M9j20VO8HH31F+l6711K/6CqovTWI0AYCc0oiA6VVerYVUfAP\ntt9RQn7lXVouObmJBSVX7x4lLojsN9N7aYW+qam73VDlaYJnK5+1kAe9AbCR\nqOcd\r\n=Pc2M\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQC9HemQlNuEvD6PmXsRhG7PgqHBwk03R1YPJ/7qHbHLVwIgVsUh92KahNXfU+X/IP7EqkJDp5UXT087g1JgJHtdLy0="}]},"maintainers":[{"name":"leolobeto","email":"leolobeto@gmail.com"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/alfa-data-client_0.1.1_1543180953947_0.779972023714361"},"_hasShrinkwrap":false},"0.1.2":{"name":"@alfa-wells/alfa-data-client","version":"0.1.2","description":"Client for Alfa-Data","main":"index.js","scripts":{"test":"mocha"},"author":{"name":"leolobeto"},"license":"ISC","dependencies":{"axios":"^0.18.0"},"devDependencies":{"node-mock-server":"^0.23.6"},"_id":"@alfa-wells/alfa-data-client@0.1.2","_npmVersion":"6.4.1","_nodeVersion":"10.12.0","_npmUser":{"name":"leolobeto","email":"leolobeto@gmail.com"},"dist":{"integrity":"sha512-vl7m+e7sFjntT6r4g9VqsRyRFIFwBsN3EZJyFDqlx8OqFHoIZGPcCW0aa8v1gkhtkX/rCBuIzVf03NndzAszLw==","shasum":"981202a7daa93f30560db143ef30f126a8459ae3","tarball":"https://registry.npmjs.org/@alfa-wells/alfa-data-client/-/alfa-data-client-0.1.2.tgz","fileCount":37,"unpackedSize":18429,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJb/OPICRA9TVsSAnZWagAA7AUP/igMMZzHzxDiSPhSFYxw\ndFvMQX9EZ7ZpN2sI5uOQggtS6Tmb6SvCzZVwkrK7JyGYa+By/xwfF6xPgBJK\nHZqqCC/4iI2haR6rQiH2fOKMJBkFscyRmzQIUvnyivtNYByT1mPYQwO2dqiR\n4mmvk0KRf1WSHfL18U5l2zFo8F6GYpaMcw1jPokn8mTRE6UcODrXvXPEBU7Y\n6jgc0tNJdVhbJhUrWly1wGA0lmlJFHk12J075TnfYwJxBDqpH5geMdrfTN9w\n/zLbFtJti+HRr/PXEMSiJcwHatvn9Uf6ODyQC++nwd4sb4PNAt0Pg8awD+tz\nP1LE4coDvxq4ek9BkE7PGNjuSkivgef82Opo1ySRHf2mKagqLHJepZ/lAb22\nO3CnULlmd7VrBltu4+yWz6cdTZcjlKt0c/VMI7r8hkS+amU8dmJ7WQ+bHgBw\nMY28pCbaAixoJQdTjv8Iu0aVGSM5zwn7WSrnWgj3cDemAOouduT3efC/FlSx\nZAN3u0mwH4G5XjkveGr++UJ4RG+za2slDKU4I92JUWULBwmamcvjl1dSc/al\nP44VVFJ3h8/T4iUA/GP5QcwMDwJIzbHHjSdON13OMOX4e4jl9RDtsGnrkPJU\nAUUYdPNr3fT9gO8GETvcaMW8Fm6id8blKbHZ1qpTFbn71U8tUF8hXLSDD5H5\nKY9q\r\n=cVkR\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIBCH4ZBkmJsyaJmKMMfpkNocrS52lo0sCG4Jugay40xQAiEAhnTZQzYTo5tF0hVMgwZLn7U9weti2qvdFRtyM+d6V4M="}]},"maintainers":[{"name":"leolobeto","email":"leolobeto@gmail.com"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/alfa-data-client_0.1.2_1543300040070_0.12318195516593611"},"_hasShrinkwrap":false},"0.1.3":{"name":"@alfa-wells/alfa-data-client","version":"0.1.3","description":"Client for Alfa-Data","main":"index.js","scripts":{"test":"mocha"},"author":{"name":"leolobeto"},"license":"ISC","dependencies":{"axios":"^0.18.0"},"devDependencies":{"node-mock-server":"^0.23.6"},"_id":"@alfa-wells/alfa-data-client@0.1.3","_npmVersion":"6.4.1","_nodeVersion":"10.12.0","_npmUser":{"name":"leolobeto","email":"leolobeto@gmail.com"},"dist":{"integrity":"sha512-Pi2zuUFYqVElMDLx03Pn+m9k9+OXatMLxCoyQV8pdCCphL5x1WcxSf8lJWvw0Ql2w6KS84Uk2eiBRGn9v2/bdw==","shasum":"2691731d22e982bd984cbab108b0725cf1630879","tarball":"https://registry.npmjs.org/@alfa-wells/alfa-data-client/-/alfa-data-client-0.1.3.tgz","fileCount":37,"unpackedSize":18505,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJb/V+3CRA9TVsSAnZWagAA6fIP+wbvjhCzReemTDxthK3r\nuYyhppnPcTYoS7jGk7NoU4gBnvGQaERUhIgRfDpIvQL02b+PtLk61eRiojK/\nQw1Q0p81KC+glEgWJYacoCrfQGOah7oAbDlecBx4IcXYWC01RBlxz0ivF53X\n5lmQimcQh8Hvnj8wWnvHEx9diVW4QFsrNk5GgBzkj7axvyUW+x9IfcBXITg1\nnI55PVwg4C9oOEk2dki1RIKT20dYAslbWe9ik3txAlKONZDP6KbHvYdhCN2n\ncQHCYHdRHP0a0hDNT4/tyYOH3luNRskzgiRPGaSAbgm1yMGseLTRZ5r4KHlI\nPQLPEdCOyAq3b1AiCbgyFRPmwEOAJaCDGjjzm2Gf6H+r4RvbY3k6mk16kueo\nFYRJAepOqkPsBoLJuzwI4TXXvMty/fL+C8ivxrQky+pyCNtLH1oe7zep0Sn9\nVbF0zdLRfdg1Wi2aU2To0zwR7BxKTBEXZ4TdOHGphxdbpogol6O0UW67JGpn\nUcLSjfsM3YSyxeYtirp2xRxzHSSGwaDsblWAMLmVygU/qNIb5qYpah0nD2ZA\n8T2frr2HA3mT/l9u2gl7pGsk14EBuUo4NOjlPDptHJD4WT13ui8UKlmVWKIO\n55/Djt2a9tXrWWtqrotQ4NvnBRUO5v/VxDUT45Lmj2llvC1JmLnGby3TaVav\n3FGe\r\n=ECpK\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCdeXNMbhpUyfyKEreQaqeCLX4DmYL8jiNyP3CaZgd4YgIgBf/w1+n+2Gy7oCVPz6LHMtT+BQQzTNLmjaqa2G6ZDxo="}]},"maintainers":[{"name":"leolobeto","email":"leolobeto@gmail.com"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/alfa-data-client_0.1.3_1543331766726_0.5688077720542075"},"_hasShrinkwrap":false},"0.2.1":{"name":"@alfa-wells/alfa-data-client","version":"0.2.1","description":"Client for Alfa-Data REST API","main":"src/index.js","scripts":{"test":"mocha","coverage":"nyc mocha --recursive && nyc report --reporter=text-lcov>lcov.info"},"author":{"name":"leolobeto"},"license":"ISC","dependencies":{"@yucom/rest-client":"^0.1.2"},"devDependencies":{"@types/mocha":"^5.2.6","@yucom/rest-server":"^0.2.1"},"gitHead":"d9d51c20222cec5f04dd0a202910731224b0fc44","_id":"@alfa-wells/alfa-data-client@0.2.1","_nodeVersion":"10.15.1","_npmVersion":"6.9.0","dist":{"integrity":"sha512-kI6hh0UmCkuq+0ZWjHT68iURPpD687b++YPCzoVyE3UV09gj3EjqaeT1WwrH4G8psGKv66PT+nOdR2BLLs5VPA==","shasum":"17634dbba68a3f9420bfc9d993da68b295b2940c","tarball":"https://registry.npmjs.org/@alfa-wells/alfa-data-client/-/alfa-data-client-0.2.1.tgz","fileCount":8,"unpackedSize":20697,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJcivNHCRA9TVsSAnZWagAAjAoP/0tVjcT60WclUfLiPJpT\nSzp6sOOroDCQOoRQ/jFcy4zIq2hji0KoaeYDGWQSvS7l4ZIGBdWGN6SurNKl\nrHJP2qHJ81BZcjD8rTuZ9F/7bvc2NHuZOJvNQX+SCFtXQhGCBVgkl6kt/57D\nrIdeEsovvSXHmJ7kXceWxfceY1HXPdrC1WkElf0tTU+u6R/x7MK++wQqW+t6\nky3IJf4gYkPuJh4ZonbFCtFHLH0AGbhT3cDMSBStbcfdUwJCjnuLpVPpOQD0\nj75giaxEiGfB6SSZpNpP7HCvv9e4nVhEoGOhXefDkfeKZc8EC+Kvx2nTyhmz\nqAwakSFN2jH68CpUbO5o2aeEnBRECG+xZ/nFjwlFEnzURTCKgU4c5jYntB2D\nBqHV07nM3T1waqW8/77I9cmOHyUlHLHn5czkkjNkZTP25KL2rhiamOvDwRdC\nsG47Xw9EmZnmqxOZB7N+VofXgp0lEqm+/S2b5z8l48UDgjsZE6Svn5bJxRqQ\nT6qb1wxkm7FZ9JWpz3Yh11iGxgodkk60P9tq3ocan82g9yrmwptJpNgpxZ+p\nSC6oqZSRrPKWg+UeiDy2u5xkCAHxeOo2pWPSEhScJbg8VcRGttua2oGQFgIH\nmMNcJ2sUYn+R9NEj30vDa+yBg6WuJvfItnm9njB3qIIVvgQhJzQqAF71Ia/x\nQMqn\r\n=I4tI\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCmKZwL+WaWn1po6zOdnyYe6kVpvA3DwsF9fQ/mpPs+8gIhAJb+HGAY7cJZsYMbHIr3hccPq/dNFRbtoLhHInPNocHU"}]},"maintainers":[{"name":"leolobeto","email":"leolobeto@gmail.com"}],"_npmUser":{"name":"leolobeto","email":"leolobeto@gmail.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/alfa-data-client_0.2.1_1552610118621_0.0843984527423074"},"_hasShrinkwrap":false}},"time":{"created":"2018-11-24T05:05:50.890Z","0.1.0":"2018-11-24T05:05:51.235Z","modified":"2022-04-04T12:42:05.102Z","0.1.1":"2018-11-25T21:22:34.086Z","0.1.2":"2018-11-27T06:27:20.278Z","0.1.3":"2018-11-27T15:16:06.839Z","0.2.1":"2019-03-15T00:35:18.729Z"},"maintainers":[{"name":"leolobeto","email":"leolobeto@gmail.com"}],"description":"Client for Alfa-Data REST API","author":{"name":"leolobeto"},"license":"ISC","readme":"# Alfa-Data-Client\nClient for Alfa-Data service REST API.\n\n## How to use\n### Install\n````\n    npm install @alfa-wells/alfa-data-client --save\n````\n\n### Example\n\n````js\n    const client = require(\"@alfa-wells/alfa-data-client\")(\"http://localhost:3001/alfa-data\")\n    let credentials = {\n        user: \"frank\", \n        password: \"Frank1234\"\n    }\n    let connection = client.connection(\"connection-configuration-id\", credentials)\n\n    let result = await connection.execute(\"select * from employee where id = {? id }\", { id: 123 })\n````\n\n### API\n#### Client\n##### Create\n````\n    const client = require(\"@alfa-wells/alfa-data-client\")(<server_url>[, <timeout>])\n````\nThe server url should contain the protocol and can declare a port and a base path. Default timeout is 120000ms (2 minutes).\n\n##### Configurations\n````\n    client.configurations()\n````\nReturns a list of all available configurations. Each configuration has:\n\n* `name`:  Display name of the configuration.\n* `type` : Database type. Current supported types are `oracle` and `sql-server`.\n* `id`: The short id of the connection configuration.\n\n**async/await**\n\n````js\n    try {\n        let list = await client.configurations()\n        //list = [{name: \"My local database\", type: \"oracle\", id: \"my-local-db\"}]\n    } catch (err) {\n        //Ups! Error\n    }\n````\n**Promises**\n````js\n     client.configurations()\n        .then(list => {\n             //list = [{name: \"My local database\", type: \"oracle\", id: \"my-local-db\"}]\n        })\n        .catch(err => {\n            //Ups! Error\n        })\n````\n\n##### Connect\nCreates a connection to a configured database. Returns a promise that resolves to a `Connection` object.\n````js\n    client.connection(<configuration_id> [, <credentials>])\n````\n\n**async/await**\n\n````js\n    let credentials = {\n        user: \"frank\", \n        password: \"Frank1234\"\n    }\n    try {\n        let connection = await client.connect(\"my-local-db\", credentials)\n        //Do something with it\n    } catch (err) {\n        //Ups! Error\n    }\n````\n\n**Promises**\n\n````js\n    let credentials = {\n        user: \"frank\", \n        password: \"Frank1234\"\n    }\n    client.connect(\"my-local-db\", credentials)\n        .then(connection => {\n             //Do something with it\n        })\n        .catch(err => {\n            //Ups! Error\n        })\n````\n\n##### Connection\nRe-creates a connection from an id. Returns a `Connection` object.\n````js\n    client.connection(<connection_id>)\n````\n\n#### `Connection` object\n##### Info\nReturns information about this connection.\n````js\n    connection.info()\n````\nReturn an object with the properties:\n\n* `valid`: boolean. True if this connection is still valid for querying, false if not.\n* `configuration`: String. The id of the connection configuration used to create this connection.\n* `message`: String. Error message when `valid` is false. It will be absent or it'll have a non significant value when `valid` is true.\n \n**async/await**\n\n````js\n    try {\n        let info = await connection.info()\n        console.log(info.valid)\n        //Prints true\n    } catch (err) {\n        //Ups! Error\n    }\n````\n\n**Promises**\n\n````js\n    connection.info()\n        .then(info => {\n             console.log(info.valid)\n             //Prints true\n        })\n        .catch(err => {\n            //Ups! Error\n        })\n````\n\n##### Execute\nExecutes a query using this connection. Returns a promise that resolves to a result set.\n````js\n    connection.execute(<sql_string>[, <arguments>])\n````\nThe result of a query is an object with the properties:\n* `columns`: Array of `Column` objects. A column has two properties:\n    * `name`: String. The name of the column.\n    * `type`: String. The Javascript class name of the values in the column (`String`, `Number`, `Date`, `Boolean`, etc.)\n* `rows`: Array o rows (also arrays). Each position in the row is a value of the type described in the corresponding column description.\n* `count`: Row count. It´s expected to be equal to `rows.length`\n \n\n**async/await**\n\n````js\n    let empolyee = {\n        id: '12'\n        name: 'Frank Robinson',\n    }\n    let sql = \"select * from employees where id = {?id} or name = {?name}\"\n    try {\n        let result = await connection.execute(sql, employee)\n        //=> a result set\n    } catch (err) {\n        //Ups! Error\n    }\n````\n\n**Promises**\n\n````js\n    let empolyee = {\n        id: '12'\n        name: 'Frank Robinson',\n    }\n    let sql = \"select * from employees where id = {?id} or name = {?name}\"\n    connection.execute(sql, employee)\n        .then(result => {\n             //=> a result set\n        })\n        .catch(err => {\n            //Ups! Error\n        })\n````\n\n##### Execute all\nExecutes a list of queries using this connection in a single request. Returns a promise that resolves to a list of objects containing a result set.\n````js\n    connection.executeAll(<Array-of_queries>)\n````\nEach query can be:\n* `string`: The plain sql to execute.\n* `object`: An object with the properties:\n    * `sql`:  The plain sql to execute.\n    * `arguments`: (Optional) An object containing the named arguments of the query.\n\nThe promise is resolved to a listof objects with the properties:\n\n* `ok`: Boolean. True if the corresponding query could be executed successfully, false otherwise.\n* `error`: String. Error message when `ok` is false. When `ok` is true, this property will be absent or it'll have a non significant value.\n* `columns`: Array of `Column` objects. A column has two properties:\n    * `name`: String. The name of the column.\n    * `type`: String. The Javascript class name of the values in the column (`String`, `Number`, `Date`, `Boolean`, etc.)\n* `rows`: Array o rows (also arrays). Each position in the row is a value of the type described in the corresponding column description.\n* `count`: Row count. It´s expected to be equal to `rows.length`\n\n**async/await**\n\n````js\n    let query1 = {\n        sql: \"select * from employees where id = {?id} or name = {?name}\",\n        arguments: {\n            id: '12'\n            name: 'Frank Robinson',\n        }\n    let query2 = \"select * from employees\"\n    try {\n        let results = await connection.executeAll([query1, query2])\n        //=> a list of two objects\n    } catch (err) {\n        //Ups! Error\n    }\n````\n\n**Promises**\n\n````js\n    let query1 = {\n        sql: \"select * from employees where id = {?id} or name = {?name}\",\n        arguments: {\n            id: '12'\n            name: 'Frank Robinson',\n        }\n    let query2 = \"select * from employees\"\n    \n    connection.executeAll([query1, query2])\n        .then(results => {\n             //=> a list of two objects\n        })\n        .catch(err => {\n            //Ups! Error\n        })\n````\n\n##### Id\nReturns a string representing this connection. Used to recreate it with `client.connection()`.\n````js\n    connection.id\n````","readmeFilename":"README.md"}