
Product
Announcing Socket Fix 2.0
Socket Fix 2.0 brings targeted CVE remediation, smarter upgrade planning, and broader ecosystem support to help developers get to zero alerts.
hapi-plugin-mysql
Advanced tools
hapi plugin for MySQL
Attaches a MySQL connection from a pool to every request.
Via request.app.db
.
You can also manually get a connection from the server via server.getDb(function (err, connection) {})
.
await server.register({
plugin: require('hapi-plugin-mysql'),
options: {
host: "localhost",
user: "root",
password: ""
}
});
server.route({
method: 'GET',
path: '/',
handler: async (request, h) => {
request.app.db.query(...);
return 'ok';
}
});
The options are the same options you can pass onto the mysql
lib for making a connection. See https://www.npmjs.com/package/mysql for more info on the mysql
lib itself.
The keyword db
is used because connection
was used by <= hapi@16
and could have caused confusion/collision.
If you want more manual control or you want to use the same pool outside of the hapi part of your server
you can initialize the pool before the plugin registration by calling await HapiPluginMysql.init(options)
and then call require('hapi-plugin-mysql').getConnection
to get a connection from the pool.
If you still want to register the plugin (to get all the goodies) just don't pass any options to the plugin registration
and it will use the same pool as first created.
To manually stop the pool call await HapiPluginMySQL.stop()
.
See the tests for more granular use cases.
test
db with a table test
and {user: root, password: ""}
..travis.yml
and the tests for more info.See the releases page
FAQs
Hapi plugin for MySQL
The npm package hapi-plugin-mysql receives a total of 14 weekly downloads. As such, hapi-plugin-mysql popularity was classified as not popular.
We found that hapi-plugin-mysql demonstrated a not healthy version release cadence and project activity because the last version was released a year ago. It has 2 open source maintainers collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Product
Socket Fix 2.0 brings targeted CVE remediation, smarter upgrade planning, and broader ecosystem support to help developers get to zero alerts.
Security News
Socket CEO Feross Aboukhadijeh joins Risky Business Weekly to unpack recent npm phishing attacks, their limited impact, and the risks if attackers get smarter.
Product
Socket’s new Tier 1 Reachability filters out up to 80% of irrelevant CVEs, so security teams can focus on the vulnerabilities that matter.