accessor_sqlite

A simple wraper for developer to access their SQLite database without writing SQL code

npm install accessor_sqlite
8 downloads in the last week
22 downloads in the last month

Accessor_SQLite 0.2.0

A MySQL database wrapper, provide easy access to database without writing SQL code

Install & Setup

  1. Install through npm, following command will do that:

     npm install Accessor_SQLite
    
  2. Create a config directory under your application, and create a database.js under that, which may contain like:

     exports.db_path = "path to database";
    
  3. Now, Accessor_SQLite is ready to use.

Usage

  1. Require the Accessor module in your script

     var Accessor = require("Accessor");
    
  2. Place constructor where you need the Accessor. Do not forget to specify your database engine.

     var tester = Accessor("YOUR_TARGET_TABLE", "SQLite");
    
  3. After initialization, Accessor will try to obtain the schema, and store it to verify column existence while updating or creating.

Methods

accessor.select( {options}, callback(err, data, fields) );

Perform a select query to obtain data, for example:

    // test_table schema: id, name, email

    var tester = Accessor("test_table");

    var options = {
        where: [
            ["id", ">", 10],
            "AND",
            ["email","LIKE","%@gmail.com"]
        ],

        limit: 100,
        offset: 50,

        fields: ["name"]
    };

    tester.select( options, function(err, data, fields) {
        if(err) {
            throw err;
        }    

        return data;
    } );

Currently, {options} has implements following attributes:

  • where
  • limit
  • offset
  • fields
Note

Options may omit which retrieve all records, i.e.

    // test_table schema: id, name, email

    var tester = Accessor("test_table");

    tester.select( function(err, data, fields) {
        if(err) {
            throw err;
        }    

        return data;
    } );

accessor.create( {dataObject}, callback(err, info) );

Insert data record by given dataObject

    // test_table schema: id, name, email

    var tester = Accessor("test_table");

    var dataObject = {
        name: "bu",
        email: "bu@hax4.in",
        nonSchemaColumn: "test"
    };

    tester.create( dataObject, function(err, info) {
        if(err) {
            throw err;
        }    

        return info.insertId;
    } );
Note
  • On above example, we give a non-exist column called "nonSchemaColumn" to Accessor, which may cause hangup if we insert that to sql query.

    Indeed, Accessor will try to check each attribute and ignore them if not exists, and that should print (on console)

      Warning: nonSchemaColumn is not in database schema, and is not inserted into queryset
    

accessor.update( {options}, {updated_dataObject}, callback(err, info) );

Update records filter by option.where with updated_dataObject

    // test_table schema: id, name, email

    var tester = Accessor("test_table");

    var dataObject = {
        email: "bu@hax4.in",
        nonSchemaColumn: "test"
    };

    var options = {
        where: [ 
            ["name", "=", "bu"] 
        ],
    };

    tester.update( options, dataObject, function(err, info) {
        if(err) {
            throw err;
        }    

        return info.affectedRows;
    } );
Note
  • On above example, we give a non-exist column called "nonSchemaColumn" to Accessor, which may cause hangup if we update that in sql query.

    Indeed, Accessor will try to check each attribute and ignore them if not exists, and that should print (on console)

      Warning: nonSchemaColumn is not in database schema, and is not inserted into queryset
    
  • If options is omitted, it will update all records. (due to no filter)

      // test_table schema: id, name, email
    
      var tester = Accessor("test_table");
    
      var dataObject = {
          email: "bu@hax4.in",
          nonSchemaColumn: "test"
      };
    
      tester.update( {}, dataObject, function(err, info) {
          if(err) {
              throw err;
          }    
    
          return info.affectedRows;
      } );
    

accessor.remove( {options}, callback(err, info) );

Remove records filter by options.where

    // test_table schema: id, name, email

    var tester = Accessor("test_table");

    var options = {
        where: [ 
            ["name", "=", "bu"] 
        ],
    };

    tester.update( options, function(err, info) {
        if(err) {
            throw err;
        }    

        return info.affectedRows;
    } );
Note
  • If options is omitted, it will remove all records. (due to no filter)

      // test_table schema: id, name, email
    
      var tester = Accessor("test_table");
    
      tester.remove( {}, function(err, info) {
          if(err) {
              throw err;
          }    
    
          return info.affectedRows;
      } );
    

Observer

You can register to some methods, that will notify when such things occured. (e.g. UPDATE)

    // following example will register a function that print out trigger event name

    var Accessor = require("Accesor");

    var Log = Accessor("Log", "MySQL");

    // methods can be register are SELECT, CREATE, UPDATE, REMOVE, INIT
    var register_methods = ["SELECT", "DELETE", "CREATE", "INIT", "UPDATE"];

    Log.registerObserver(register_methods, function(event){
        console.log(event);
    });

LICENSE

Copyright (c) 2012 Buwei Chiu bu@hax4.in

Licensed under the MIT License

npm loves you