0.5.2 • Published 9 years ago
grand-central-records v0.5.2
Grand Central Records (GCR)
A promise-based Node ORM/ActiveRecord library that can connect to MySQL, Postgres, and SQLite3. Allows chainable, raw or queueable queries.
Getting started
var GCR = require('grand-central-records');
var Model = new GCR({
adapter: "mysql",
host: "localhost",
database: "test",
username: "admin",
password: "admin"
}, "users");
Model.find(8).then(function(users) {
console.log(users[0].name);
}).catch(console.error);
Model.select(["name","address"]).where({admin: true})
.then(function(result) {
result.forEach(function(user) { ... });
});
Creating a new instance of the GCR object creates a connection to a new database.
- connection
object
— Database connection parameters.- adapter — mysql/MySQL, postgresql/postgres/pg, sqlite3/sqlite
- host, database, username, password — connection parameters
- table
string
— An optional table name if only a single table is being queried. - options
object
— Options to pass to the model.- verbose
boolean
function
— Turning verbose on will log all queries to the console.false
by default. If a function is provided, it will be used to log all outputs. - idAttribute
string
— The name of the unique ID attribute field (defaults to'id'
). - (see Models)
- verbose
- table
string
— The name of the table the model is associated with. - options
json
— See above.
Multiple models can also be created from the same database.
var GCR = require('grand-central-records');
var db = new GCR({
adapter: "mysql",
host: "localhost",
database: "test",
username: "admin",
password: "admin"
}, { verbose: true });
var User = db.model("users"),
Project = db.model("projects");
Documentation
Getting started
Raw queries
Models
Other functions
Query methods
Postgres
Inspiration
0.5.2
9 years ago
0.5.1
10 years ago
0.5.0
10 years ago
0.1.5
10 years ago
0.1.4
10 years ago
0.1.35
10 years ago
0.1.3
10 years ago
0.1.2
10 years ago
0.1.11
10 years ago
0.1.1
10 years ago
0.1.0
10 years ago
0.0.91
10 years ago
0.0.9
10 years ago
0.0.85
10 years ago
0.0.82
10 years ago
0.0.81
10 years ago
0.0.8
10 years ago
0.0.72
10 years ago
0.0.71
10 years ago
0.0.7
11 years ago
0.0.65
11 years ago
0.0.6
11 years ago
0.0.55
11 years ago
0.0.5
11 years ago
0.0.4
11 years ago
0.0.32
11 years ago
0.0.31
11 years ago
0.0.3
11 years ago