sails-oradb

Oracle Database Sails/Waterline Adapter

A Waterline adapter for Oracle Database. It uses the Node.JS Oracle Driver mantained by Oracle Corp. May be used in a Sails app or anything using Waterline for the ORM.

¡Important advice!

The Adapter is not finished yet. It only has implemented a few functionalities for testing purposes.

Things that you can do NOW:

• Connect to an Oracle database.
• Do find request.
• Populate find request (Joins).
• Create, modify and delete automatically DB tables (Alter mode).

Notice:

• The automatic addition of new collumns for existing tables is not working properly yet.
• Autoincrement for a primary key is not implemented automatically when a table is created. You must do it manually for the moment.

ToDo List:

• Insert request.
• Update request.
• Delete request.
• Count request.
• More.

Main functionalities like insert, update and delete will be done as soon as posible!

Install

As oracledb driver module is a dependency you must read How to Install

Install is through NPM.

$ npm install sails-oradb

Configuration

The following config options are available along with their default values:

config: {
    adapter: 'sails-oradb',
    connectString: 'host:port/databaseName',
    user: 'root',
    password: ''
};

About Waterline

Waterline is a new kind of storage and retrieval engine. It provides a uniform API for accessing stuff from different kinds of databases, protocols, and 3rd party APIs. That means you write the same code to get users, whether they live in mySQL, LDAP, MongoDB, or Facebook.

To learn more visit the project on GitHub at Waterline.