count-management-module v2.0.3

count-management-module

Author: Chandrakant Thakkar

Created on: 14th Oct 2016

count-management-module is used to manage counter for specific key passed by the user. It also manage past state of counter for all key through database entry.

• To use this module, It requires 'tbl_uniquekey' table into database.'tbl_uniquekey' table defination is as following.

• mysql script for table 'tbl_uniquekey'

CREATE TABLE `tbl_uniquekey` (
  `UK_key` varchar(30) NOT NULL,
  `UK_value` int(11) DEFAULT NULL,
  PRIMARY KEY (`UK_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Function

• getUniqueNumber :

• Sample 1

  var generateNextCounter = require('count-management-module');  
  var sendData = {
    "id": "UNIQUEKEY",//id: unique key for which it create unique counter
    "count": 1,//count: update counter value to plus 1 in 'tbl_uniquekey' table at a time
    "dbConfig": sampleConfig
  };
  generateNextCounter.getUniqueNumber(sendData, {}, function(data) {
  var nextCounter=data.content;
  });

• sampleConfig : Configuration for database connection. (As given below)

  var sampleConfig = {
    type: "database",
    engine: 'MyISAM',
    databaseType: 'mysql',
    database: 'database',
    host: "hostname",
    port: "port",
    user: "user",
    password: "password",
    cacheResponse: false
  };

• In Sample 1 it creates one entry into table 'tbl_uniquekey' with UK_key as 'UNIQUEKEY' and UK_value as 1 and return 1 value as next counter in 'data.content' variable. while calling same method again it update entry into table 'tbl_uniquekey' for UK_key 'UNIQUEKEY' with UK_value as 2 and return next counter value as 2 in 'data.content' variable.

• Sample 2

  var generateNextCounter = require('count-management-module');  
  var sendData = {
    "id": "UNIQUEKEY",//id: unique key for which it create unique counter
    "count": 5,//count: update counter value to plus 5 in 'tbl_uniquekey' table at a time
    "dbConfig": sampleConfig
  };
  generateNextCounter.getUniqueNumber(sendData, {}, function(data) {
    var counterStart=data.content;
    for(i=0;i<5;i++){
     console.log("counter value:"+counterStart);
     counterStart=counterStart+1;
    }
  });

• In Sample 2 we require 5 counters at a same time, it creates one entry into table 'tbl_uniquekey' with UK_key as 'UNIQUEKEY' and UK_value as 5 and return 1 value as next counter in 'data.content' variable. now we can generate all five counter for key 'UNIQUEKEY' with starting value as 1 and go till 5 using loop.

• while calling same method again it update entry into table 'tbl_uniquekey' for UK_key 'UNIQUEKEY' with UK_value as 10 and return next counter value as 6 in 'data.content' variable.now we can generate all five counter for key 'UNIQUEKEY' with starting value as 6 and go till 10 using loop.