Product
Introducing Dashboard Analytics
We're introducing a new Analytics feature in the Socket dashboard so you can view changes in your organization's and repositories' alerts over time.
ORM for every database: redis, mysql, neo4j, mongodb, rethinkdb, postgres, sqlite, tingodb
CaminteJS is cross-db ORM for nodejs, providing common interface to access most popular database formats.
mysql, sqlite3, riak, postgres, couchdb, mongodb, redis, neo4j, firebird, rethinkdb, tingodb
First install node.js. Then:
$ npm install caminte --save
var caminte = require('caminte');
var Schema = caminte.Schema;
var schema = new Schema('redis', {port: 6379});
// define models
var Post = schema.define('Post', {
title: { type: schema.String, limit: 255 },
userId: { type: schema.Number },
content: { type: schema.Text },
created: { type: schema.Date, default: Date.now },
updated: { type: schema.Date },
published: { type: schema.Boolean, default: false, index: true }
});
var User = schema.define('User', {
name: { type: schema.String, limit: 255 },
bio: { type: schema.Text },
email: { type: schema.String, limit: 155, unique: true },
approved: { type: schema.Boolean, default: false, index: true }
joinedAt: { type: schema.Date, default: Date.now },
age: { type: schema.Number },
gender: { type: schema.String, limit: 10 }
});
// setup hooks
Post.afterUpdate = function (next) {
this.updated = new Date();
this.save();
next();
};
// define any custom method for instance
User.prototype.getNameAndAge = function () {
return this.name + ', ' + this.age;
};
// define scope
Post.scope('active', { published : true });
// setup validations
User.validatesPresenceOf('name', 'email');
User.validatesUniquenessOf('email', {message: 'email is not unique'});
User.validatesInclusionOf('gender', {in: ['male', 'female']});
User.validatesNumericalityOf('age', {int: true});
// setup relationships
User.hasMany(Post, {as: 'posts', foreignKey: 'userId'});
// Common API methods
var user = new User({
name: 'Alex',
email: 'example@domain.aga',
age: 40,
gender: 'male'
});
user.isValid(function (valid) {
if (!valid) {
return console.log(user.errors);
}
user.save(function(err){
if (!err) {
return console.log(err);
}
console.log('User created');
});
})
// just instantiate model
new Post
// save model (of course async)
Post.create(cb);
// all posts
Post.all(cb)
// all posts by user
Post.all({where: {userId: user.id}, order: 'id', limit: 10, skip: 20});
// the same as prev
user.posts(cb)
// get one latest post
Post.findOne({where: {published: true}, order: 'date DESC'}, cb);
// same as new Post({userId: user.id});
user.posts.build
// save as Post.create({userId: user.id}, cb);
user.posts.create(cb)
// find instance by id
User.findById(1, cb)
// count instances
User.count([conditions, ]cb)
// destroy instance
user.destroy(cb);
// destroy all instances
User.destroyAll(cb);
// models also accessible in schema:
schema.models.User;
schema.models.Post;
Now all common logic described in ./lib/*.js
, and database-specific stuff in ./lib/adapters/*.js
. It's super-tiny, right?
# run all tests
$ make test
# run sqlite tests
$ make test-sqlite
# run mysql tests
$ make test-mysql
# run postgres tests
$ make test-postgres
# run redis tests
$ make test-redis
# run mongodb tests
$ make test-mongo
# run rethinkdb tests
$ make test-rethinkdb
If you have found a bug please write unit test, and make sure all other tests still pass before pushing code to repo.
(The MIT License)
Copyright (c) 2011 by Anatoliy Chakkaev <mail [åt] anatoliy [døt] in>
Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the 'Software'), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:
The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.
THE SOFTWARE IS PROVIDED 'AS IS', WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
FAQs
ORM for every database: redis, mysql, neo4j, mongodb, rethinkdb, postgres, sqlite, tingodb
The npm package caminte receives a total of 111 weekly downloads. As such, caminte popularity was classified as not popular.
We found that caminte demonstrated a not healthy version release cadence and project activity because the last version was released a year ago. It has 1 open source maintainer 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
We're introducing a new Analytics feature in the Socket dashboard so you can view changes in your organization's and repositories' alerts over time.
Security News
A new OpenSSF report uncovers critical gaps in secure software training, with 75% of new developers unfamiliar with secure practices, highlighting urgent educational needs.
Security News
The 2023 Python Developers Survey reveals key trends in packaging, web frameworks, and developer demographics, highlighting a shift toward innovative tools as the Python community diversifies and grows among less experienced developers.