0.7.0 • Published 9 years ago

spark-mysql-protocol v0.7.0

Weekly downloads
6
License
LGPL-3.0
Repository
github
Last release
9 years ago

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.

0.7.0

9 years ago

0.6.9

9 years ago

0.6.8

9 years ago

0.6.7

9 years ago

0.6.6

9 years ago

0.6.5

9 years ago

0.6.4

9 years ago

0.6.3

9 years ago

0.6.2

9 years ago

0.6.0

9 years ago

0.5.11

9 years ago

0.5.10

9 years ago

0.5.9

9 years ago

0.5.8

9 years ago

0.5.7

9 years ago

0.5.6

9 years ago

0.5.5

9 years ago

0.5.3

9 years ago

0.5.2

9 years ago

0.5.1

9 years ago

0.5.0

9 years ago

0.4.9

9 years ago

0.4.8

9 years ago

0.4.7

9 years ago

0.4.6

9 years ago

0.4.5

9 years ago

0.4.4

9 years ago

0.4.3

9 years ago

0.4.2

9 years ago

0.4.1

9 years ago

0.4.0

9 years ago

0.3.8

9 years ago

0.3.7

9 years ago

0.3.6

9 years ago

0.3.5

9 years ago

0.3.4

9 years ago

0.3.3

9 years ago

0.3.2

9 years ago

0.3.1

9 years ago

0.3.0

9 years ago

0.2.9

9 years ago

0.2.8

9 years ago

0.2.7

9 years ago

0.2.6

9 years ago

0.2.5

9 years ago

0.2.4

9 years ago

0.2.3

9 years ago

0.2.2

9 years ago

0.2.1

9 years ago

0.2.0

9 years ago

0.1.9

9 years ago

0.1.8

9 years ago

0.1.7

9 years ago

0.1.6

9 years ago

0.1.5

9 years ago

0.1.4

9 years ago

0.1.3

9 years ago

0.1.2

9 years ago

0.1.1

9 years ago

0.1.0

9 years ago

0.0.20

9 years ago

0.0.19

9 years ago

0.0.18

9 years ago

0.0.17

10 years ago

0.0.16

10 years ago

0.0.15

10 years ago

0.0.14

10 years ago

0.0.13

10 years ago

0.0.12

10 years ago

0.0.11

10 years ago

0.0.10

10 years ago

0.0.9

10 years ago

0.0.8

10 years ago

0.0.7

10 years ago

0.0.6

10 years ago

0.0.5

10 years ago

0.0.4

10 years ago

0.0.3

10 years ago

0.0.2

10 years ago

0.0.1

10 years ago

0.0.0

10 years ago