README
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.
Field | Type | Key | Default |
---|---|---|---|
UK_key | varchar(30) | NO | PRI |
UK_value | int(11) | YES | - |
- 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.