{"_id":"db-info","_rev":"14-646fed36f2bb0583e07fd44f9ffba6eb","name":"db-info","description":"Node.js relational database information utility","dist-tags":{"latest":"0.0.3"},"versions":{"0.0.1":{"name":"db-info","description":"Node.js relational database information utility","keywords":["database","db","sqlite","mysql"],"homepage":"https://github.com/nearinfinity/node-db-info","version":"0.0.1","engines":{"node":">=0.6.0"},"maintainers":[{"name":"joeferner","email":"joe@fernsroth.com"}],"bugs":{"url":"https://github.com/nearinfinity/node-db-info/issues"},"licenses":[{"type":"MIT"}],"repositories":[{"type":"git","url":"https://github.com/nearinfinity/node-db-info.git"}],"dependencies":{"sqlite3":"~>2.1.1","mysql":"~>0.9.5","async":"~>0.1.15"},"devDependencies":{"nodeunit":"~>0.6.4"},"_npmUser":{"name":"joeferner","email":"joe@fernsroth.com"},"_id":"db-info@0.0.1","_engineSupported":true,"_npmVersion":"1.1.0-alpha-6","_nodeVersion":"v0.6.4","_defaultsLoaded":true,"dist":{"shasum":"274c4cd450e12833b2de4f63320d65fbe1bf943d","tarball":"https://registry.npmjs.org/db-info/-/db-info-0.0.1.tgz","integrity":"sha512-/tUcLO5mwheD9zkbvE9Oy1DfaaVW8heZteVlDU/TUwOYoJLBrRpaiANzev7MevdasxEBuxsAlSRsE7GissagFw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIGC9sda1d52RqnZmSR6SDZHvonJZChQ73tWM3OSrZJsmAiEA1OGuFPTbIXHcMkJHv6yJkR8Coxj5DtjcCmf2Op1uEbc="}]},"directories":{}},"0.0.2":{"name":"db-info","description":"Node.js relational database information utility","keywords":["database","db","sqlite","mysql","PostgreSQL"],"homepage":"https://github.com/nearinfinity/node-db-info","version":"0.0.2","engines":{"node":">=0.6.0"},"maintainers":[{"name":"joeferner","email":"joe@fernsroth.com"}],"bugs":{"url":"https://github.com/nearinfinity/node-db-info/issues"},"licenses":[{"type":"MIT"}],"repositories":[{"type":"git","url":"https://github.com/nearinfinity/node-db-info.git"}],"dependencies":{"optimist":"~0.3.0","async":"~>0.1.15"},"devDependencies":{"nodeunit":"~>0.6.4"},"_npmUser":{"name":"joeferner","email":"joe@fernsroth.com"},"_id":"db-info@0.0.2","_engineSupported":true,"_npmVersion":"1.1.0-alpha-6","_nodeVersion":"v0.6.4","_defaultsLoaded":true,"dist":{"shasum":"569177137caa7ce535e7dd176e32e4b73a615ab3","tarball":"https://registry.npmjs.org/db-info/-/db-info-0.0.2.tgz","integrity":"sha512-ShgoKaCSYL9FEFnqovmwi9K8R92vKdFb2OSUJmHRfwC9R24BvTz5PH53S/gpRO4Wutz4EarHvAbrRlcl+90SAg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDbH26/hmCx7VyJIVz64Zg0QngkjTiNAlsywCssR0KwJQIgUAnBT0ugFNYftx8zrO+Ffl1P9lv+gV6pPrxP1T3jAMA="}]},"directories":{}},"0.0.3":{"name":"db-info","description":"Node.js relational database information utility","keywords":["database","db","sqlite","mysql","PostgreSQL","oracle","db-oracle"],"version":"0.0.3","engines":{"node":">=0.6.0"},"author":{"name":"Joe Ferner","email":"joe.ferner@nearinfinity.com"},"maintainers":[{"name":"joeferner","email":"joe@fernsroth.com"}],"bugs":{"url":"https://github.com/nearinfinity/node-db-info/issues"},"license":"MIT","repository":{"type":"git","url":"git://github.com/nearinfinity/node-db-info.git"},"dependencies":{"optimist":"~0.3.0","async":"~>0.1.15"},"devDependencies":{"nodeunit":"~>0.6.4"},"_npmUser":{"name":"joeferner","email":"joe@fernsroth.com"},"_id":"db-info@0.0.3","optionalDependencies":{},"_engineSupported":true,"_npmVersion":"1.1.4","_nodeVersion":"v0.7.7","_defaultsLoaded":true,"dist":{"shasum":"95494542018a9c12f2f21c87014f7eac7814467b","tarball":"https://registry.npmjs.org/db-info/-/db-info-0.0.3.tgz","integrity":"sha512-sDjwqY6n5QDs4Y+2YhqCvrTaKXdylzIhp7uiAFB2I1zg7jFeL875HQJAlxU7Bzt2++x48AU5/TLDNuPjBRLHdg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDPIPUuKeEQBur/I6dFH1roFWrT94GYd8FtT4deuZrUkwIhAM3ajc7wkJwc4Fo99iB1hnEDFfqJToFdSnchnP/gXlcc"}]}}},"readme":"# db-info\n\ndb-info is a utility module which provides a database independent way of\ngetting database metadata.\n\nThe following databases are currently supported:\n\n * sqlite3 - via: [node-sqlite3](https://github.com/developmentseed/node-sqlite3)\n * mysql - via: [node-mysql](https://github.com/felixge/node-mysql)\n\n## Quick Examples\n    var dbinfo = require(\"db-info\");\n\n    dbinfo.getInfo({\n      driver: 'mysql',\n      user: 'root',\n      password: 'root',\n      database: 'test'\n    }, function(err, result) {\n      /* result = {\n        tables: {\n          person: {\n            name: 'person',\n            columns: {\n              'id': { name: 'id', notNull: true, primaryKey: true, type: 'integer', length: '11' },\n              'name': { name: 'name', notNull: true, type: 'varchar', length: '255' },\n              'email': { name: 'email', notNull: false, type: 'varchar', length: '100' },\n              'age': { name: 'age', notNull: false, type: 'integer', length: '11' }\n            }\n          }\n        }\n      } */\n    });\n\n## Download\n\nYou can install using Node Package Manager (npm):\n\n    npm install async\n\n## Documentation\n\n### getInfo(opts, callback)\n\nGets the metadata from a database.\n\n__Arguments__\n\n * opts - A hash of options.\n  * driver - can be either \"mysql\" or \"sqlite3\"\n  * _db_ - if db is passed in this connection will be used instead of making a new connection.\n  * _other_ - will be passed to the drivers connect.\n * callback(err, result) - Callback called once complete. result will contain a hash containing all the tables\n   along with column information.\n\n__Example__\n    var db = new sqlite3.Database(':memory:');\n\n    dbinfo.getInfo({\n      driver: 'sqlite3',\n      db: db\n    }, function(err, result) {\n    });","maintainers":[{"name":"apla","email":"dot.and.thing@gmail.com"},{"name":"joeferner","email":"joe@fernsroth.com"}],"time":{"modified":"2022-06-14T20:48:20.994Z","created":"2011-12-12T14:38:45.676Z","0.0.1":"2011-12-12T14:38:46.261Z","0.0.2":"2011-12-16T19:41:41.421Z","0.0.3":"2012-04-02T15:41:44.178Z"},"repository":{"type":"git","url":"git://github.com/nearinfinity/node-db-info.git"},"author":{"name":"Joe Ferner","email":"joe.ferner@nearinfinity.com"},"keywords":["database","db","sqlite","mysql","PostgreSQL","oracle","db-oracle"],"bugs":{"url":"https://github.com/nearinfinity/node-db-info/issues"},"license":"MIT","readmeFilename":""}