{"_id":"noderpt","_rev":"35-af9821b8c53d2d3000ad48ff3f24f049","name":"noderpt","description":"Node.js Report Utility","dist-tags":{"latest":"0.0.14"},"versions":{"0.0.1":{"name":"noderpt","description":"Node.js Report Utility","version":"0.0.1","author":{"name":"Simon Su","email":"simonsu@mitac.com.tw"},"contributors":[{"name":"Simon Su","email":"simonsu@mitac.com.tw"}],"dependencies":{"underscore":"*","xml2json":"*","nodeutil":"*","mysql":"*","express":"*","log4js":"*"},"keywords":["report"],"repository":{"type":"git","url":"https://github.com/peihsinsu/noderpt"},"main":"index","engines":{"node":">= 0.6.0"},"optionalDependencies":{},"_engineSupported":true,"_npmVersion":"1.1.65","_nodeVersion":"v0.6.13","_defaultsLoaded":true,"_from":"micloud","_id":"noderpt@0.0.1","dist":{"shasum":"f23c29159794369ad11954b925a7eb2c36355891","tarball":"https://registry.npmjs.org/noderpt/-/noderpt-0.0.1.tgz","integrity":"sha512-u8lxUbZm+Rd4GymPp+N6mzZ4Vmbq6O5Zsr/FhAmdTzQ1Pu11h/yy2sWRDhFZ7dXNESF7e7zryN1R/tibw5PcQw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQD4ulcp607hvkYux5u0mMtq6oXqopB5fg2x8Th779QcbQIhAJcW6R3r+nFhK7CSyidSSm86EP5G0QVQl4z38v/ae6PY"}]},"_npmUser":{"name":"peihsinsu","email":"simonsu.mail@gmail.com"},"maintainers":[{"name":"peihsinsu","email":"simonsu.mail@gmail.com"}],"directories":{}},"0.0.2":{"name":"noderpt","description":"Node.js Report Utility","version":"0.0.2","author":{"name":"Simon Su","email":"simonsu@mitac.com.tw"},"contributors":[{"name":"Simon Su","email":"simonsu@mitac.com.tw"}],"dependencies":{"underscore":"*","xml2json":"*","nodeutil":"*","mysql":"*","express":"*","log4js":"*"},"keywords":["report"],"repository":{"type":"git","url":"https://github.com/peihsinsu/noderpt"},"main":"index","engines":{"node":">= 0.6.0"},"optionalDependencies":{},"_engineSupported":true,"_npmVersion":"1.1.65","_nodeVersion":"v0.6.13","_defaultsLoaded":true,"_from":"micloud","_id":"noderpt@0.0.2","dist":{"shasum":"d33d2c3336a282ecbb70bd560ab8da9054918765","tarball":"https://registry.npmjs.org/noderpt/-/noderpt-0.0.2.tgz","integrity":"sha512-GLrHw24qwCzXwQOrYpiFjXANShzf/Sr5jbVoRPp+jjnNSEYpyYkzMOs5cZQz+OXo1W5kIOOH3swQ4J+NYIr/SA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQD5N/B18vvO9itgt7uUcl1o/D1HejAwPQRMrjO07Tj1TgIhAMBdwxZ37UrFkKAgTlVWX5WQhVv40nqUazPL71tw1JtH"}]},"_npmUser":{"name":"peihsinsu","email":"simonsu.mail@gmail.com"},"maintainers":[{"name":"peihsinsu","email":"simonsu.mail@gmail.com"}],"directories":{}},"0.0.3":{"name":"noderpt","description":"Node.js Report Utility","version":"0.0.3","author":{"name":"Simon Su","email":"simonsu@mitac.com.tw"},"contributors":[{"name":"Simon Su","email":"simonsu@mitac.com.tw"}],"dependencies":{"underscore":"*","xml2json":"=0.3.2","nodeutil":"*","mysql":"*","express":"*","log4js":"*"},"keywords":["report"],"repository":{"type":"git","url":"https://github.com/peihsinsu/noderpt"},"main":"index","engines":{"node":">= 0.6.0"},"optionalDependencies":{},"_engineSupported":true,"_npmVersion":"1.1.65","_nodeVersion":"v0.6.13","_defaultsLoaded":true,"_from":"micloud","_id":"noderpt@0.0.3","dist":{"shasum":"ba5ffa54e65727b7e159da40417cd96c94a8cad3","tarball":"https://registry.npmjs.org/noderpt/-/noderpt-0.0.3.tgz","integrity":"sha512-EHOBLq9CYiBZo+bOR789pCSGnLFz8VPHQhSnnj0NarXhetvkIwYoPvWu9I37at4dFuk7TTINq7H4Tp+JiWKBhw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCXbflro2ucliTA1zEqU2yWPiqXhev/rcJlmUAmUoP6JwIgehzZPwqk0yD2LtPv7+NoJdksXGxDIIn4NTEADXBqM0c="}]},"_npmUser":{"name":"peihsinsu","email":"simonsu.mail@gmail.com"},"maintainers":[{"name":"peihsinsu","email":"simonsu.mail@gmail.com"}],"directories":{}},"0.0.4":{"name":"noderpt","description":"Node.js Report Utility","version":"0.0.4","author":{"name":"Simon Su","email":"simonsu@mitac.com.tw"},"contributors":[{"name":"Simon Su","email":"simonsu@mitac.com.tw"}],"dependencies":{"underscore":"*","xml2json":"=0.3.2","nodeutil":"*","mysql":"*","express":"*","log4js":"*"},"keywords":["report"],"repository":{"type":"git","url":"https://github.com/peihsinsu/noderpt"},"main":"index","engines":{"node":">= 0.6.0"},"optionalDependencies":{},"_engineSupported":true,"_npmVersion":"1.1.65","_nodeVersion":"v0.6.13","_defaultsLoaded":true,"_from":"micloud","_id":"noderpt@0.0.4","dist":{"shasum":"c291ec45c5bb73211ab46faad2149eeb752acb90","tarball":"https://registry.npmjs.org/noderpt/-/noderpt-0.0.4.tgz","integrity":"sha512-80r1j79OJglW8bsw0lZumWd9OEx0IKv2DmI+xV5SeItYc0DxdzZt9VoRxniD0/sUfffFse4LPOHwQW7ZihSQSg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIE5Gjns46gos9NLSqpQcSM0EJ987TXVWyAEnFxI5JdhjAiBkPOxbegqfNDOKcDEXGpB/OrJwweGYWdmQZlKtT1BePw=="}]},"_npmUser":{"name":"peihsinsu","email":"simonsu.mail@gmail.com"},"maintainers":[{"name":"peihsinsu","email":"simonsu.mail@gmail.com"}],"directories":{}},"0.0.5":{"name":"noderpt","description":"Node.js Report Utility","version":"0.0.5","author":{"name":"Simon Su","email":"simonsu@mitac.com.tw"},"contributors":[{"name":"Simon Su","email":"simonsu@mitac.com.tw"}],"dependencies":{"underscore":"*","xml2json":"=0.3.2","nodeutil":"*","mysql":"*","express":"*","log4js":"*"},"keywords":["report"],"repository":{"type":"git","url":"https://github.com/peihsinsu/noderpt"},"main":"index","engines":{"node":">= 0.6.0"},"optionalDependencies":{},"_engineSupported":true,"_npmVersion":"1.1.65","_nodeVersion":"v0.6.13","_defaultsLoaded":true,"_from":"micloud","_id":"noderpt@0.0.5","dist":{"shasum":"813b453725ece65cc38228851ebf397cd1f592d5","tarball":"https://registry.npmjs.org/noderpt/-/noderpt-0.0.5.tgz","integrity":"sha512-EYrIZCpBkKEdOd+39QSM1k4LJZmsdWzsHS4eNxjRlFzxORs8CZSd8QzFiRGoc4J1ImH3ZAHa2NyUOBoLZkOjiQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIF8hLQVQ3NJF7o3GregqLXcB8/U/KtONYI9VnSsEGXEuAiEA+3XtceWbz0sXyBcEw44fU+PpC4CTyO2tP/njXn9Z+P4="}]},"_npmUser":{"name":"peihsinsu","email":"simonsu.mail@gmail.com"},"maintainers":[{"name":"peihsinsu","email":"simonsu.mail@gmail.com"}],"directories":{}},"0.0.6":{"name":"noderpt","description":"Node.js Report Utility","version":"0.0.6","author":{"name":"Simon Su","email":"simonsu@mitac.com.tw"},"contributors":[{"name":"Simon Su","email":"simonsu@mitac.com.tw"}],"dependencies":{"underscore":"*","xml2json":"=0.3.2","nodeutil":"*","mysql":"*","express":"*","log4js":"*"},"keywords":["report"],"repository":{"type":"git","url":"https://github.com/peihsinsu/noderpt"},"main":"index","engines":{"node":">= 0.6.0"},"optionalDependencies":{},"_engineSupported":true,"_npmVersion":"1.1.65","_nodeVersion":"v0.6.13","_defaultsLoaded":true,"_from":"micloud","_id":"noderpt@0.0.6","dist":{"shasum":"a6977beec37385eb9fde750df860824391c3a1a2","tarball":"https://registry.npmjs.org/noderpt/-/noderpt-0.0.6.tgz","integrity":"sha512-1cLSo6TDAiN+mSQPFAneqYytfulXU6aPTexuTNDLTogAYQOMwPRYhjvf3m0uDKgativmo9QGNB9b/QCOCDgP1Q==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIF4DSqy1fSzZ4oIV8qJApUdCtzOqYB6yMkGajxianqnQAiEAwiJzj6s5Fb6HBUKsMp2kT2F7hqqaiYSqxGrWosFiGYo="}]},"_npmUser":{"name":"peihsinsu","email":"simonsu.mail@gmail.com"},"maintainers":[{"name":"peihsinsu","email":"simonsu.mail@gmail.com"}],"directories":{}},"0.0.7":{"name":"noderpt","description":"Node.js Report Utility","version":"0.0.7","author":{"name":"Simon Su","email":"simonsu@mitac.com.tw"},"contributors":[{"name":"Simon Su","email":"simonsu@mitac.com.tw"}],"dependencies":{"underscore":"*","nodeutil":"*","mysql":"*","express":"*","log4js":"*"},"keywords":["report"],"repository":{"type":"git","url":"https://github.com/peihsinsu/noderpt"},"main":"index","engines":{"node":">= 0.6.0"},"optionalDependencies":{},"_engineSupported":true,"_npmVersion":"1.1.65","_nodeVersion":"v0.6.13","_defaultsLoaded":true,"_from":"micloud","_id":"noderpt@0.0.7","dist":{"shasum":"b5a1438d005699dee7a4ffbb9e83de99dbc44666","tarball":"https://registry.npmjs.org/noderpt/-/noderpt-0.0.7.tgz","integrity":"sha512-Q/Zx1tWdCnYdkTFitSINExGWDYFDJVHOZ2ZI6fNKHGFgydMlKk8kQm+bQ80SCotkawEVamTAjapaf0vCviW4jA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQC8EKpIZmVK/YfunBZrkFEHwby6hK8ShMLakYA4gUxU7gIgaCrjzNkT4Totq0aHaxEnM7fxvgmhX/oUDcqoY3eYlAo="}]},"_npmUser":{"name":"peihsinsu","email":"simonsu.mail@gmail.com"},"maintainers":[{"name":"peihsinsu","email":"simonsu.mail@gmail.com"}],"directories":{}},"0.0.8":{"name":"noderpt","description":"Node.js Report Utility","version":"0.0.8","author":{"name":"Simon Su","email":"simonsu@mitac.com.tw"},"contributors":[{"name":"Simon Su","email":"simonsu@mitac.com.tw"}],"dependencies":{"underscore":"*","nodeutil":"*","mysql":"*","express":"*","log4js":"*"},"keywords":["report"],"repository":{"type":"git","url":"https://github.com/peihsinsu/noderpt"},"main":"index","engines":{"node":">= 0.6.0"},"optionalDependencies":{},"_engineSupported":true,"_npmVersion":"1.1.65","_nodeVersion":"v0.6.13","_defaultsLoaded":true,"_from":"micloud","_id":"noderpt@0.0.8","dist":{"shasum":"df75cb6cecbf97e48898ba34d074afa19c486839","tarball":"https://registry.npmjs.org/noderpt/-/noderpt-0.0.8.tgz","integrity":"sha512-H6lw4zAPi7Hp5kLLWDqgEksy1Hiq6Pphqc52szEVy/eU5ETKQuq4ka0VfjI5X2V8801YbIjwRnQF2nxJr8wgQw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIEeJyXOzXT27VZhtCV+gIl/KC67UJ39Cwlcu1xAHnDhVAiEA5XABAaw8bfsYZLax2FacXmp8ssWpFBeyEN0qDOZFcOI="}]},"_npmUser":{"name":"peihsinsu","email":"simonsu.mail@gmail.com"},"maintainers":[{"name":"peihsinsu","email":"simonsu.mail@gmail.com"}]},"0.0.9":{"name":"noderpt","description":"Node.js Report Utility","version":"0.0.9","author":{"name":"Simon Su","email":"simonsu@mitac.com.tw"},"contributors":[{"name":"Simon Su","email":"simonsu@mitac.com.tw"}],"dependencies":{"underscore":"*","nodeutil":"*","mysql":"*","express":"*","log4js":"*"},"keywords":["report"],"repository":{"type":"git","url":"https://github.com/peihsinsu/noderpt"},"main":"index","engines":{"node":">= 0.6.0"},"optionalDependencies":{},"_engineSupported":true,"_npmVersion":"1.1.65","_nodeVersion":"v0.6.13","_defaultsLoaded":true,"_from":"micloud","_id":"noderpt@0.0.9","dist":{"shasum":"46729d9e72e02fa0a1110945b0b915fcb817332d","tarball":"https://registry.npmjs.org/noderpt/-/noderpt-0.0.9.tgz","integrity":"sha512-iy87liJkvCQPICefFzL4WEdKpSBPIoKKPxIjmz1zkEneqFUXbm5lJRSHECfIzCYmpgu9iOaBWrD3HO3pMrvucA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIDgqAkVLHPt2bFAqaPNK8Lt3SfCEZ9CrYNiTecYnDEWzAiEAlTjjnQ/TD44P8mHRTH8jcF8hsdNrIMcwBxlXAKbVnJM="}]},"_npmUser":{"name":"peihsinsu","email":"simonsu.mail@gmail.com"},"maintainers":[{"name":"peihsinsu","email":"simonsu.mail@gmail.com"}]},"0.0.10":{"name":"noderpt","description":"Node.js Report Utility","version":"0.0.10","author":{"name":"Simon Su","email":"simonsu@mitac.com.tw"},"contributors":[{"name":"Simon Su","email":"simonsu@mitac.com.tw"}],"dependencies":{"underscore":"*","nodeutil":"*","mysql":"*","express":"*","log4js":"*"},"keywords":["report"],"repository":{"type":"git","url":"https://github.com/peihsinsu/noderpt"},"main":"index","engines":{"node":">= 0.6.0"},"optionalDependencies":{},"_engineSupported":true,"_npmVersion":"1.1.65","_nodeVersion":"v0.6.13","_defaultsLoaded":true,"_from":"micloud","_id":"noderpt@0.0.10","dist":{"shasum":"89c1e8563b7c7585cc886e4ac81ac26b9c6a999e","tarball":"https://registry.npmjs.org/noderpt/-/noderpt-0.0.10.tgz","integrity":"sha512-aqd3syq5/AYJjHiPUp2HOWC+C1/EZaoz923W6k7ox2gRlh1RVWOB9VVt/OAFr2RiqL4cpVEWFsaZJNI16nE64Q==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIAhCrCF8ZvvVq3E47x+8gECk1ejIEJ6/67QsvaCpC88OAiBHSw2Ky7xxOA4w+vXemH/2RljoFLiyZyJJA4OtoKN/1Q=="}]},"_npmUser":{"name":"peihsinsu","email":"simonsu.mail@gmail.com"},"maintainers":[{"name":"peihsinsu","email":"simonsu.mail@gmail.com"}]},"0.0.11":{"name":"noderpt","description":"Node.js Report Utility","version":"0.0.11","author":{"name":"Simon Su","email":"simonsu@mitac.com.tw"},"contributors":[{"name":"Simon Su","email":"simonsu@mitac.com.tw"}],"dependencies":{"underscore":"*","nodeutil":"*","mysql":"*","express":"*","log4js":"*"},"keywords":["report"],"repository":{"type":"git","url":"https://github.com/peihsinsu/noderpt"},"main":"index","engines":{"node":">= 0.6.0"},"optionalDependencies":{},"_engineSupported":true,"_npmVersion":"1.1.65","_nodeVersion":"v0.6.13","_defaultsLoaded":true,"_from":"micloud","_id":"noderpt@0.0.11","dist":{"shasum":"a56ce67541142ebfd8daa1bf7445386bf3f83627","tarball":"https://registry.npmjs.org/noderpt/-/noderpt-0.0.11.tgz","integrity":"sha512-ssSJlgEhwkoRJZBJdGs6CCnYXeSQVdYG37T1RqMvRL8xURvZf+50PjYp2VPDsQbKHCQ6ER5QNcIybiDz1DauBA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCFzydsVgyrVnYNfk3k+tVGxIM/DyP4k3k3MkOgrRh6swIgJbWz559i+xp5JY/F5nAW29345UYcE2XntqC3hyyUYgM="}]},"_npmUser":{"name":"peihsinsu","email":"simonsu.mail@gmail.com"},"maintainers":[{"name":"peihsinsu","email":"simonsu.mail@gmail.com"}]},"0.0.12":{"name":"noderpt","description":"Node.js Report Utility","version":"0.0.12","author":{"name":"Simon Su","email":"simonsu@mitac.com.tw"},"contributors":[{"name":"Simon Su","email":"simonsu@mitac.com.tw"}],"dependencies":{"underscore":"*","nodeutil":"*","mysql":"*","express":"*","log4js":"*"},"keywords":["report"],"repository":{"type":"git","url":"https://github.com/peihsinsu/noderpt"},"main":"index","engines":{"node":">= 0.6.0"},"optionalDependencies":{},"_engineSupported":true,"_npmVersion":"1.1.9","_nodeVersion":"v0.6.13","_defaultsLoaded":true,"_from":"micloud","_id":"noderpt@0.0.12","dist":{"shasum":"a7fdf800c2e28997f854cbea61bcb573f38be572","tarball":"https://registry.npmjs.org/noderpt/-/noderpt-0.0.12.tgz","integrity":"sha512-6l+BXJWaHForfSuNaUvp/At9fBl8gKciNfUClHh64nALCTdV1dvBKpUEQjSOxpdfHwNTKY8tkLcyr9Ns6ntoNQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQD/Qgkrw7+61sKIhuqXL0b8dgD8IBzSEv9Pcpq3VbxSDQIgLh19rZIAXJYi60gukkeUlilkXsIPDs2ntlbocSdRC48="}]},"maintainers":[{"name":"peihsinsu","email":"simonsu.mail@gmail.com"}]},"0.0.13":{"name":"noderpt","description":"Node.js Report Utility","version":"0.0.13","author":{"name":"Simon Su","email":"simonsu@mitac.com.tw"},"contributors":[{"name":"Simon Su","email":"simonsu@mitac.com.tw"}],"dependencies":{"underscore":"*","nodeutil":"*","mysql":"*","express":"*","log4js":"*","node-expat":"~2.3.3"},"keywords":["report"],"repository":{"type":"git","url":"https://github.com/peihsinsu/noderpt"},"main":"index","engines":{"node":">= 0.6.0"},"optionalDependencies":{},"_engineSupported":true,"_npmVersion":"1.3.24","_nodeVersion":"v0.6.13","_defaultsLoaded":true,"_from":".","bugs":{"url":"https://github.com/peihsinsu/noderpt/issues"},"homepage":"https://github.com/peihsinsu/noderpt","_id":"noderpt@0.0.13","dist":{"shasum":"84a5ac12c53d0209336331d82e0dc0c096414593","tarball":"https://registry.npmjs.org/noderpt/-/noderpt-0.0.13.tgz","integrity":"sha512-+oZGCW+/PjmEgNvphzlOfBad3Bra2xyoWAZiABZbkWCcYZOk9Y2Xe4QnVWOozA+CNGsGpEdu5dYUZ2EdNR8sKw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCRRLDlJ5IhXOyMGGw03Jv/u1WKj8fSvLc6fgR/wxtxSAIhAK0EBDaB9yslEQA0xNtpdlm/ZSH2/UsKva1TI/LZ6pbp"}]},"_npmUser":{"name":"peihsinsu","email":"simonsu.mail@gmail.com"},"maintainers":[{"name":"peihsinsu","email":"simonsu.mail@gmail.com"}]},"0.0.14":{"name":"noderpt","description":"Node.js Report Utility","version":"0.0.14","author":{"name":"Simon Su","email":"simonsu@mitac.com.tw"},"contributors":[{"name":"Simon Su","email":"simonsu@mitac.com.tw"}],"dependencies":{"underscore":"*","nodeutil":"*","mysql":"*","express":"*","log4js":"*","node-expat":"~2.3.3"},"keywords":["report"],"repository":{"type":"git","url":"https://github.com/peihsinsu/noderpt"},"main":"index","engines":{"node":">= 0.6.0"},"optionalDependencies":{},"_engineSupported":true,"_npmVersion":"1.3.24","_nodeVersion":"v0.6.13","_defaultsLoaded":true,"_from":".","bugs":{"url":"https://github.com/peihsinsu/noderpt/issues"},"homepage":"https://github.com/peihsinsu/noderpt","_id":"noderpt@0.0.14","dist":{"shasum":"0d031a2aaf4867fe33f5b5379dfca72201c937aa","tarball":"https://registry.npmjs.org/noderpt/-/noderpt-0.0.14.tgz","integrity":"sha512-wLSs+fHJ/X+07LDb5N+tAG+Y7WlwEUyS0fVZKPj4U8DoVT2GKce/bAxpLiwmEhstrXNwef8lX6eFfBtkP0yr8Q==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIB5V2xhKQwDoF+IydHI/lRy26+uhau0h5Hj6mQ/jQtAXAiEAhgS40NH1Priwr/h1nfhSGKXjgIJOvWq5HKpxTqmupQk="}]},"_npmUser":{"name":"peihsinsu","email":"simonsu.mail@gmail.com"},"maintainers":[{"name":"peihsinsu","email":"simonsu.mail@gmail.com"}]}},"readme":"Node Report Server (MySQL only now!)\n=======\nSimple MySQL DB SQL to JSON mapping module, and also provide web function to render table.\n\n# Installation\n```bash\nnpm install noderpt\n```\n\n# Useage\nFew steps to build the report...\n## Step1: Config the DB and SQL mapping file\nThe database config file's path need to export to environment and the config will like:\n```json\n{\n  \"host\": \"database.ip.address\",\n  \"port\": 3306,\n  \"user\": \"dbuser\",\n  \"password\": \"dbpassword\",\n  \"database\": \"dbname\"\n}\n```\nYou need to create a config file inside your project, in our sample we create the report config in $project/report.\n\nYou can use json format config\n```json\n{\n  \"name\": \"queryUserInfo\",\n  \"sql\" : \"select * from user where 1=1 \",\n  \"conditions\": [\n    {\"field\":\"USERNAME\", \"condition\":\"and username = ?\"},\n    {\"field\":\"USER_ID\", \"condition\":\"and user_id = ?\"}\n  ],\n  \"endsql\": \"order by 1\"\n}\n```\nOr using xml format config\n```xml\n<config>\n  <name>queryUserInfo</name>\n  <sql>select * from user where 1=1</sql>\n  <conditions>\n    <field>USERNAME</field> <condition>and username = ?</condition>\n  </conditions>\n  <conditions>\n    <field>USER_ID</field> <condition>and user_id = ?</condition>\n  </conditions>\n  <endsql>\n    order by 1\n  </endsql>\n</config>\n```\n\nIn the configuration, the fields are:\n* name: report name\n* sql: the main sql block, that is static and will combined with conditions and endsql directly\n* conditions: you can have many conditions to let query bring into query, in the api, if you specify a query string in the end of rest url and the parameter will combine the condition to sql\n* endsql: the final sql, like \"order by\", \"group by\"..., that will combine to the end of sql statement\n\n## Testing your configure (test.js)\n\n```js\nvar rpt = require('./lib');\nrpt.setup(null,\n  {\n    dbCfgFile: '/root/project/report/lib/.database.cfg',\n    rptConfigPath: '/root/project/report/report/',\n    reportRoot:'/report/rest',\n    reportDoc: '/report/restdoc'\n  }\n);\n\nrpt.getRptFromConfig('simple.rpt.xml', false, function(d){\n  console.log(d);\n});\n\nrpt.datasource.end();\n```\n\nAfter run the test.js, you will get a query result of the configure file as a json array format.\n\n# Other Documents\n\n* [ExpressJS web support configure](./doc/reportConfigure.md)\n* [Form mashalling script](./doc/formMarshalling.md)\n\n","maintainers":[{"name":"peihsinsu","email":"simonsu.mail@gmail.com"}],"time":{"modified":"2022-06-22T03:30:14.893Z","created":"2012-12-30T05:57:11.339Z","0.0.1":"2012-12-30T05:57:13.815Z","0.0.2":"2013-01-02T04:13:12.728Z","0.0.3":"2013-01-03T17:13:09.808Z","0.0.4":"2013-01-03T18:08:35.798Z","0.0.5":"2013-01-04T02:14:37.305Z","0.0.6":"2013-01-04T09:33:03.282Z","0.0.7":"2013-01-08T08:55:15.689Z","0.0.8":"2013-01-23T09:39:53.645Z","0.0.9":"2013-02-26T16:00:33.687Z","0.0.10":"2013-03-05T09:19:58.620Z","0.0.11":"2013-03-29T01:26:37.253Z","0.0.12":"2013-06-12T05:17:56.565Z","0.0.13":"2014-12-09T06:16:15.225Z","0.0.14":"2014-12-09T06:24:06.888Z"},"author":{"name":"Simon Su","email":"simonsu@mitac.com.tw"},"repository":{"type":"git","url":"https://github.com/peihsinsu/noderpt"},"homepage":"https://github.com/peihsinsu/noderpt","keywords":["report"],"contributors":[{"name":"Simon Su","email":"simonsu@mitac.com.tw"}],"bugs":{"url":"https://github.com/peihsinsu/noderpt/issues"},"readmeFilename":"README.md"}