npm package discovery and stats viewer.

Discover Tips

  • General search

    [free text search, go nuts!]

  • Package details

    pkg:[package-name]

  • User packages

    @[username]

Sponsor

Optimize Toolset

I’ve always been into building performant and accessible sites, but lately I’ve been taking it extremely seriously. So much so that I’ve been building a tool to help me optimize and monitor the sites that I build to make sure that I’m making an attempt to offer the best experience to those who visit them. If you’re into performant, accessible and SEO friendly sites, you might like it too! You can check it out at Optimize Toolset.

About

Hi, 👋, I’m Ryan Hefner  and I built this site for me, and you! The goal of this site was to provide an easy way for me to check the stats on my npm packages, both for prioritizing issues and updates, and to give me a little kick in the pants to keep up on stuff.

As I was building it, I realized that I was actually using the tool to build the tool, and figured I might as well put this out there and hopefully others will find it to be a fast and useful way to search and browse npm packages as I have.

If you’re interested in other things I’m working on, follow me on Twitter or check out the open source projects I’ve been publishing on GitHub.

I am also working on a Twitter bot for this site to tweet the most popular, newest, random packages from npm. Please follow that account now and it will start sending out packages soon–ish.

Open Software & Tools

This site wouldn’t be possible without the immense generosity and tireless efforts from the people who make contributions to the world and share their work via open source initiatives. Thank you 🙏

© 2024 – Pkg Stats / Ryan Hefner

mumba-microservice-sql

v0.5.11

Published

A Mumba Microservice module that provides SQL database support (via Sequelize).

Downloads

12

Readme

build status

Mumba Microservice SQL

Provide SQL support (via Sequelize) for a Microservice.

Configuration

This module requires that a Config object has been registered as config.

Property | Type | Description --- | :---: | --- db | object | A dictionary of options required for Sequelize. db:sync:force | boolean | Set to true if you want the database to perform a force sync (normally only used for testing). Default: false.

Models

Models need to be added to the dbModels group in the container. For example:

container.object('fooModel', fooModelFunction, ['dbModels']);

DI Container

Name | Type | Description --- | :---: | --- db | SqlDatabase | A class that wraps the Sequelize database object. dbModels | object | A dictionary of the database models.

Installation

$ npm install --save mumba-microservice-sql
$ typings install --save dicontainer=npm:mumba-typedef-dicontainer

Examples

TODO

Database migrations

Requirements

Database migrations for MySQL are provided via the Knex package. In order to use this, you will need to install []MySQL](https://www.npmjs.com/package/mysql) into your Microservice. It's also a good idea to install Knex globally so you can use some of its command-line tools.

$ npm install --save mysql
$ npm install -g knex 

In addition, your Microservice configuration must specify the name of the Knex changelog table under the db:knex path. For example:

let config: any = {
	db: {
		// ... other Sequelize database configuration.
		knex: '__knex'
	}
};

export default config;

NOTE: If you are using a shared database, the changelog table needs to be unique for each Microservice otherwise Knex will get confused about what migration has or hasn't run yet. For example, if you have an Articles Microservice, an appropriate name of the table would be __knex_articles.

Creating migrations

If you've installed Knex globally, you can create a new migration script by running:

$ knex migrate:make migration_name

where migration_name is a textual label for the migration.

Running migrations

To run the migrations during Microservice initialisation, include the following line in the entrypoint.sh file:

>&2 echo "Running database migrations"
/src/node_modules/.bin/dbmigrate --config=/src/dist/etc/config.js --vault-token=${VAULT_TOKEN} --vault=http://vault:8200/v1/secret/${CLIENT_DOMAIN}/common

Note that the expected arguments are:

  • Required Path to the JavaScript configuration file.
  • An optional Vault access token.
  • An optional Vault secret path (required is the Vault token is supplied).

Tests

To run the test suite, first install the dependencies, then run npm test:

$ npm run docker:up
$ npm install
$ npm test
$ npm docker:down

People

The original author of Mumba Microservice Vault is Andrew Eddie.

List of all contributors

License

Apache 2.0


© 2017 Mumba Pty Ltd. All rights reserved.