apemandb
Database for apeman project.
apemandb is thin wrapper of Sequelize, and optimized for apeman web apps.
Installation
$ npm install apemandb --save
Setup
Create Configuration File.
Use apemanenv to configure for each environment.
- Create database.json in env directory
- Exports env directory with apemanenv
env/database.json
"default": "DIALECT": "mysql" "SCHEMA": "apeman-demo-web" "PORT": 3306 "HOST": "localhost" "USERNAME": "apeman-demo-web" "PASSWORD": "apeman-demo-web" "production": "SCHEMA": "apeman-demo-web" "USERNAME": "xxxxxxxxxx" "PASSWORD": "xxxxxxxxxx" "development": "SCHEMA": "apeman-demo-web_dev" "USERNAME": "apeman-demo-web_dev" "PASSWORD": "apeman-demo-web_dev" "test": "DIALECT": "sqlite" "SCHEMA": "apeman-demo-web_test" "USERNAME": "apeman-demo-web_test" "PASSWORD": "apeman-demo-web_test" "STORAGE": "tmp/test-database.db"
env/index.js
'use strict' const apemanenv = moduleexports = // Exports all settings in dir.
Define Model
Create <model_name>.json at db/models directory
db/models/user.json
Exports Database module
Create database instance from env and models
db/index.js
'use strict' const apemandb = let db = // Models are exposed as db.models.<ModelName> (like db.models.User)moduleexports = db
Usage
Basic usage is same as Sequelize Models
Create a New Record
'use strict' const db = let User = dbmodels User
License
This software is released under the MIT License.