spark-mysql-protocol v0.7.0
Usage
Init mysqldb ( Singleton pattern ):
db architecture: db.sql
var MysqlClient = require("spark-mysql-protocol/lib/MysqlDb.js")
MysqlClient.InitMysqlClient(
settings.db.host_master,
settings.db.host_slave,
settings.db.user,
settings.db.password,
settings.db.database,
settings.db.poolCap
);
- host_master: mysql's master ip addr
- host_slave: mysql's slave ip addr
- user
- password
- database
- poolCap: connection pool's limit
Init Redis
For save device online/offline status.
var RedisClient = require("spark-mysql-protocol/lib/Redis.js");
RedisClient.InitRedisClient(
settings.redis.domain,
settings.redis.port,
settings.redis.key
);
- domain: redis server domain
- port: redis server port
- key: storage key
Use
all functions return a promise.
var client = require("spark-mysql-protocol/lib/MysqlDb.js").InitMysqlClient();
client.find(table, where, values, orderby, limit).then(...);
client.save(table, values).then(...);
client.delete(table, where, values).then(...);
client.update(table, sets, where, values).then(...);
client.query(query_string, values).then(...);
client.slave_query(query_string, values).then(...); // slave node read action.
- table: String --- table's name
- where: [] --- where's array --- exp: "id=?", "username=?"
- values: [] --- for find function: where's values, for save function: insert values
- orderby: [] --- orderby array
- limit: String --- limit
- sets: object --- exp: {"username" : "ZachBergh"}
- query_string --- original query_string, params use '?': "select * from user where id=?"
Claim Code
Send by soft-AP protocal, and saved in core_key.
Warning
Nodejs version need 0.10.41 is great.
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
9 years ago
10 years ago
10 years ago
10 years ago
10 years ago
10 years ago
10 years ago
10 years ago
10 years ago
10 years ago
10 years ago
10 years ago
10 years ago
10 years ago
10 years ago
10 years ago
10 years ago
10 years ago
10 years ago