\u6211\u542c\u8bf4KVS\u7684\u4e00\u79cd\u662fCassandra\uff0c\u4e8e\u662f\u6211\u7528node.js\u521b\u5efa\u4e86\u4e00\u4e2atypescript\u5e94\u7528\u7a0b\u5e8f\uff0c\u5e76\u5c1d\u8bd5\u8bbf\u95eeCassandra\u3002
\n\u4ee5\u4e0b\u662f\u6211\u4e3a\u4e86\u4e0d\u5fd8\u8bb0\u8fd9\u4e2a\u8fc7\u7a0b\u4e2d\u6240\u7ecf\u5386\u7684\u56f0\u96be\u800c\u505a\u7684\u5907\u5fd8\u5f55\u3002<\/p>\n
<\/p>\n
\u5982\u679c\u4e0d\u77e5\u9053\u81ea\u5df1\u4f7f\u7528\u7684\u7248\u672c\u4f1a\u8ba9\u6211\u5f88\u70e6\u607c\uff0c\u6240\u4ee5\u6211\u9009\u62e9\u5728Linux\u4e0a\u6784\u5efa\u4e86\u4e00\u4e2aDocker\u73af\u5883\u5e76\u5b89\u88c5\u4e86TAG\u6307\u5b9a\u7684\u7248\u672c\u3002
\n\u5982\u679c\u6709\u65f6\u95f4\uff0c\u6211\u60f3\u6311\u6218\u4e00\u4e0bCassandra\u7684\u96c6\u7fa4\u914d\u7f6e\u3002<\/p>\n
$ docker pull cassandra:3.10\r\n$ docker volume create --name main-cassandra-db\r\n$ docker run -d --name main-cassandra -v main-cassandra-db:\/var\/lib\/cassandra -p 9160:9160 -p 9042:9042 -m 1G cassandra:3.10\r\n<\/code><\/pre>\n\u7531\u4e8e\u5728Linux\u4e0a\u6ca1\u6709\u5b89\u88c5cqlsh\uff0c\u4f7f\u7528Docker\u4e2d\u7684cqlsh\u8fdb\u884c\u8bbf\u95ee\u3002\u786e\u4fdd\u5b83\u5df2\u7ecf\u542f\u52a8\u3002<\/p>\n
$ docker exec -it main-cassandra cqlsh\r\nConnected to Test Cluster at 127.0.0.1:9042.\r\n[cqlsh 5.0.1 | Cassandra 3.10 | CQL spec 3.4.4 | Native protocol v4]\r\nUse HELP for help.\r\ncqlsh>\r\n<\/code><\/pre>\n\u4e3a\u4e86\u65b9\u4fbf\u6279\u91cf\u5904\u7406keyspace\u7b49\u64cd\u4f5c\uff0c\u56e0\u6b64\u5efa\u8bae\u5728OSX\u4e0a\u5b89\u88c5cqlsh\u4ee5\u8fdb\u884c\u8bbf\u95ee\u3002\u7531\u4e8ecqlsh\u662f\u7528Python\u7f16\u5199\u7684\uff0c\u56e0\u6b64\u53ef\u4ee5\u4f7f\u7528pip\u547d\u4ee4\u8fdb\u884c\u5b89\u88c5\u3002<\/p>\n
$ python --version\r\nPython 2.7.12\r\n$ pip install cqlsh\r\n$ cqlsh --version\r\ncqlsh 5.0.1\r\n<\/code><\/pre>\n\u5f53\u5728OSX\u4e0a\u5c1d\u8bd5\u8bbf\u95eeLinux\u4e0a\u7684Cassandra\u65f6\u4f1a\u5931\u8d25\u3002(192.168.45.131\u662fLinux\u7684IP\u5730\u5740)<\/p>\n
$ cqlsh 192.168.45.131\r\nConnection error: ('Unable to connect to any servers', {'192.168.45.131': ProtocolError(\"cql_version '3.3.1' is not supported by remote (w\/ native protocol). Supported versions: [u'3.4.4']\",)})\r\n<\/code><\/pre>\n\u5c3d\u7ba1\u539f\u56e0\u4e0d\u592a\u6e05\u695a\uff0c\u4f46\u53ef\u4ee5\u53c2\u8003\u8fd9\u91cc\u5e76\u907f\u514d\u95ee\u9898\u3002\u65e2\u7136Docker\u548ccqlsh\u7684\u7248\u672c\u76f8\u540c\uff0c\u5e0c\u671b\u670d\u52a1\u5668\u548cCQL\u7248\u672c\u80fd\u591f\u5f97\u5230\u5408\u7406\u7684\u5b89\u6392\u3002<\/p>\n
\u901a\u8fc7\u5728cqlsh\u7684\u914d\u7f6e\u6587\u4ef6\u4e2d\u6dfb\u52a0\u8fd9\u4e9b\u5185\u5bb9\uff0c\u4f3c\u4e4e\u65e0\u9700\u6307\u5b9a\u7248\u672c\u5373\u53ef\u8fd0\u884c\u3002\u8bf7\u53c2\u8003\u8fd9\u91cc\uff0c\u521b\u5efa\u4e00\u4e2a\u540d\u4e3a~\/.cassandra\/cqlshrc\u7684\u6587\u4ef6\u3002
\n\u8d77\u521d\uff0c\u6211\u521b\u5efa\u4e86\u4e00\u4e2a~\/.cqlshrc\u6587\u4ef6\uff0c\u4f46\u662f\u5f53\u53d1\u73b0~\/.cassandra\/cqlshrc\u4e0d\u5b58\u5728\u65f6\uff0c\u6211\u628a\u5b83\u91cd\u547d\u540d\u4e3a~\/.cassandra\/cqlshrc\u3002<\/p>\n
[cql]\r\nversion = 3.4.4\r\n<\/code><\/pre>\n$ cqlsh 192.168.45.131\r\nConnected to Test Cluster at 192.168.45.131:9042.\r\n[cqlsh 5.0.1 | Cassandra 3.10 | CQL spec 3.4.4 | Native protocol v4]\r\nUse HELP for help.\r\ncqlsh>\r\n<\/code><\/pre>\n\u6211\u8bd5\u7740\u5c06Python\u7248\u672c\u5347\u7ea7\u52303.5.2\uff0c\u4f46\u5b83\u6839\u672c\u65e0\u6cd5\u8fd0\u884c\u3002
\n\u901a\u8fc7\u7814\u7a76\u53d1\u73b0\uff0c\u5b83\u53ef\u80fd\u53ea\u652f\u6301Python2.7\u3002
\n\u6211\u68c0\u67e5\u4e86cqlsh\u7684\u6e90\u4ee3\u7801\uff0c\u5b83\u4e25\u683c\u68c0\u67e5\u4e86Python\u7684\u7248\u672c\u3002<\/p>\n
if sys.version_info[:2] != (2, 7):\r\n sys.exit(\"\\nCQL Shell supports only Python 2.7\\n\")\r\n<\/code><\/pre>\n\u5b89\u88c5Node.js<\/h2>\n
\n
\u5b89\u88c5Node.js\u3002\u5728\u56db\u6708\u4efd\u73a9Node.js\u7684\u65f6\u5019\uff0c\u6211\u7528\u7684\u662fv6\u7248\u672c\uff0c\u4f46\u6700\u8fd1\u597d\u50cf\u51fa\u4e86v8\uff0c\u6240\u4ee5\u60f3\u8bd5\u8bd5v8\u7248\u672c\u3002<\/p>\n
$ nodebrew install-binary v8.1.2\r\n$ nodebrew use v8.1.2\r\nuse v8.1.2\r\n$ node --version\r\nv8.1.2\r\n<\/code><\/pre>\n\u6211\u6b63\u5728\u4f7f\u7528Typescript\u6765\u521b\u5efaCassandra\u7684\u5ba2\u6237\u7aef\uff0c\u56e0\u6b64\u9700\u8981\u521b\u5efa\u5fc5\u8981\u7684\u5b9a\u4e49\u6587\u4ef6\u3002<\/p>\n
package.json<\/ul>\n
{<\/span>\r\n \"name\"<\/span>:<\/span> \"cassandra\"<\/span>,<\/span>\r\n \"version\"<\/span>:<\/span> \"0.0.0\"<\/span>,<\/span>\r\n \"private\"<\/span>:<\/span> true<\/span>,<\/span>\r\n \"scripts\"<\/span>:<\/span> {<\/span>\r\n \"start\"<\/span>:<\/span> \".\/node_modules\/.bin\/tsc -w -d --sourceMap\"<\/span>\r\n }<\/span>\r\n}<\/span>\r\n<\/code><\/pre>\ntsconfig.json<\/ul>\n
{<\/span>\r\n \"compilerOptions\"<\/span>:<\/span> {<\/span>\r\n \/*<\/span> Basic<\/span> Options<\/span> *\/<\/span>\r\n \"target\"<\/span>:<\/span> \"es2015\"<\/span>,<\/span> \/*<\/span> Specify<\/span> ECMAScript<\/span> target<\/span> version.<\/span> *\/<\/span>\r\n \"module\"<\/span>:<\/span> \"commonjs\"<\/span>,<\/span> \/*<\/span> Specify<\/span> module<\/span> code<\/span> generation.<\/span> *\/<\/span>\r\n \"declaration\"<\/span>:<\/span> true<\/span>,<\/span> \/*<\/span> Generates<\/span> corresponding<\/span> '.d.ts'<\/span> file.<\/span> *\/<\/span>\r\n \"sourceMap\"<\/span>:<\/span> true<\/span>,<\/span> \/*<\/span> Generates<\/span> corresponding<\/span> '.map'<\/span> file.<\/span> *\/<\/span>\r\n\r\n \/*<\/span> Strict<\/span> Type-Checking<\/span> Options<\/span> *\/<\/span>\r\n \"strict\"<\/span>:<\/span> true<\/span> \/*<\/span> Enable<\/span> all<\/span> strict<\/span> type-checking<\/span> options.<\/span> *\/<\/span>\r\n },<\/span>\r\n\r\n \"exclude\"<\/span>:<\/span> [<\/span>\r\n \"node_modules\"<\/span>\r\n ]<\/span>\r\n}<\/span>\r\n<\/code><\/pre>\n\u5b89\u88c5\u6240\u9700\u7684\u8f6f\u4ef6\u5305\u3002<\/p>\n
$ npm install --save-dev typescript\r\n$ npm install --save cassandra-driver\r\n$ npm install --save-dev @types\/cassandra-driver\r\n<\/code><\/pre>\n\u521b\u5efaKeySpace\u8868\u683c\u548c\u7528\u4e8e\u63d2\u5165\u6570\u636e\u7684\u811a\u672c\u3002<\/h2>\n
\n
\u521b\u5efa\u5173\u952e\u7a7a\u95f4\u8868\u548c\u6570\u636e\u63d2\u5165\u811a\u672c\u3002<\/p>\n
create keyspace IF NOT EXISTS Sample\r\n with replication = {'class':'SimpleStrategy','replication_factor':1};\r\n\r\ncreate table IF NOT EXISTS Sample.Cookie (\r\n id text primary key, \/\/ Primary key SHA256 hash\r\n cookie text, \/\/ Cookie Text\r\n update_time timestamp, \/\/ Update Time\r\n create_time timestamp \/\/ Create Time\r\n) WITH comment='Cookie management table.';\r\n\r\nbegin batch\r\n\r\ninsert into Sample.Cookie ( id, create_time ) VALUES ( '6b86b273ff34fce19d6b804eff5a3f5747ada4eaa22f1d49c01e52ddb7875b4b', toTimestamp(now()) );\r\ninsert into Sample.Cookie ( id, create_time ) VALUES ( 'd4735e3a265e16eee03f59718b9b5d03019c07d8b6c51f90da3a666eec13ab35', toTimestamp(now()) );\r\n\r\napply batch;\r\n<\/code><\/pre>\n\u5c06\u6570\u636e\u6ce8\u5165\u5230Cassandra<\/h2>\n
\n
\u4f7f\u7528\u4e4b\u524d\u521b\u5efa\u7684\u811a\u672c\uff0c\u5728Docker\u4e0a\u6784\u5efa\u7684Cassandra\u6570\u636e\u5e93\u4e2d\uff0c\u8fdb\u884c\u952e\u7a7a\u95f4\u3001\u8868\u548c\u6570\u636e\u7684\u63d2\u5165\u3002<\/p>\n
$ cqlsh 192.168.45.131 < sample.cql\r\n<\/code><\/pre>\n\u5982\u679c\u4f7f\u7528-f\u9009\u9879\u6307\u5b9a\u811a\u672c\uff0c\u5e76\u5728\u6570\u636e\u63d2\u5165\u811a\u672c\u4e2d\u4f7f\u7528\u4e86”\/\/ Cookie Text”\u8fd9\u6837\u7684\u6ce8\u91ca\u6216\u8005comment\u5c5e\u6027\u4e2d\u4f7f\u7528\u4e86\u65e5\u8bed\uff0c\u5219\u4f1a\u51fa\u73b0\u4ee5\u4e0b\u9519\u8bef\u6d88\u606f\u3002\u770b\u8d77\u6765\uff0c\u4f3c\u4e4e\u5728create table\u547d\u4ee4\u4e2d\u5b58\u5728\u65e5\u8bed\u662f\u4e0d\u53ef\u4ee5\u7684\uff0c\u9650\u5b9a\u5728\u5192\u53f7\u4e4b\u524d\u3002<\/p>\n
sample.cql:11:'ascii' codec can't encode characters in position 134-137: ordinal not in range(128)\r\nsample.cql:26:InvalidRequest: Error from server: code=2200 [Invalid query] message=\"unconfigured table cookie\"\r\n<\/code><\/pre>\n\u7136\u800c\uff0c\u5728\u4f7f\u7528docker\u4e2d\u7684cqlsh\u65f6\uff0c\u53ef\u4ee5\u6210\u529f\u521b\u5efa\u8868\u800c\u4e0d\u4f1a\u51fa\u73b0\u9519\u8bef\u3002\u96be\u9053\u4e0d\u662f\u56e0\u4e3aPython\u7248\u672c\u7684\u5dee\u5f02\u5417\uff1f\u6211\u8bd5\u8fc7\u5728OSX\u4e0a\u5b89\u88c5\u4e862.7.9\uff0c\u4f46\u9519\u8bef\u5e76\u6ca1\u6709\u6539\u53d8\u3002<\/p>\n
$ docker exec -it main-cassandra bash\r\nroot@32e0a9c14cc7:\/# cqlsh -f \/tmp\/sample.cql\r\nroot@32e0a9c14cc7:\/# python --version\r\nPython 2.7.9\r\n<\/code><\/pre>\n\u4f7f\u7528Node.js\u548cTypescript\u5e94\u7528\u7a0b\u5e8f\u8bbf\u95eeCassandra\u3002<\/h2>\n
\n
cassandra-driver\u7684\u4f7f\u7528\u65b9\u5f0f\u6709\u4e24\u79cd\uff0c\u5982\u4e0b\u6240\u793a\uff0c\u4e00\u79cd\u662fPromise\u98ce\u683c\uff0c\u53e6\u4e00\u79cd\u662f\u56de\u8c03\u51fd\u6570\u98ce\u683c\u3002\u4e3a\u4e86\u8ddf\u4e0a\u65f6\u4ee3\u7684\u6f6e\u6d41\uff0c\u6211\u4eec\u51b3\u5b9a\u91c7\u7528Promise\u98ce\u683c\u3002<\/p>\n
\u7136\u800c\uff0cnpm\u4e0a\u6ce8\u518c\u7684@types\/cassandra-driver\u53ea\u5b9a\u4e49\u4e86\u56de\u8c03\u51fd\u6570\u98ce\u683c\uff0c\u56e0\u6b64\u5982\u679c\u91c7\u7528Promise\u98ce\u683c\u8fdb\u884c\u7f16\u5199\uff0c\u4f1a\u51fa\u73b0\u4ee5\u4e0b\u9519\u8bef\u3002<\/p>\n
$ npm start\r\n> tsc -w -d --sourceMap\r\nsrc\/client.ts(17,44): error TS2339: Property 'then' does not exist on type 'void'.\r\nsrc\/client.ts(24,52): error TS2339: Property 'then' does not exist on type 'void'.\r\n<\/code><\/pre>\n\u5728github\u4e0a\u5b58\u5728\u4e00\u4e2a\u5b9a\u4e49\u4e86Promise\u98ce\u683c\u7684\u7c7b\u7684\u6587\u4ef6\uff0c\u901a\u8fc7\u8986\u76d6\u5b83\u53ef\u4ee5\u4f7fTypescript\u6e90\u4ee3\u7801\u80fd\u591f\u8fdb\u884c\u7f16\u8bd1\u3002<\/p>\n
$ wget https:\/\/raw.githubusercontent.com\/aliem\/DefinitelyTyped\/feature\/cassandra-driver-promises\/cassandra-driver\/index.d.ts \\\r\n -O node_modules\/@types\/cassandra-driver\/index.d.ts\r\n<\/code><\/pre>\nclient.ts Cassandra\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u30e2\u30b8\u30e5\u30fc\u30eb<\/ul>\n
\/\/ \u3053\u306e\u30bd\u30fc\u30b9\u3092\u30b3\u30f3\u30d1\u30a4\u30eb\u3059\u308b\u306b\u306f\u3001npm --save-dev @types\/cassandra-driver \u3092\u5b9f\u884c\u3057\u305f\u5f8c\u3001<\/span>\r\n\/\/ node_modules\/@types\/cassandra-driver\/index.d.ts \u3092\u4ee5\u4e0b\u306e\u30d5\u30a1\u30a4\u30eb\u3068\u7f6e\u304d\u63db\u3048\u308b\u5fc5\u8981\u304c\u3042\u308b\u3002<\/span>\r\n\/\/ master \u306b\u306f\u3001callback\u5f62\u5f0f\u306e\u578b\u306f\u767b\u9332\u3055\u308c\u3066\u3044\u308b\u304c\u3001Promise\u5f62\u5f0f\u306e\u578b\u304c\u767b\u9332\u3055\u308c\u3066\u3044\u306a\u3044\u305f\u3081\u3001\u30b3\u30f3\u30d1\u30a4\u30eb\u30a8\u30e9\u30fc\u3068\u306a\u308b\u3002<\/span>\r\n\/\/ \u306a\u305c\u304b\u3001master\u306b\u30de\u30fc\u30b8\u3055\u308c\u3066\u3044\u306a\u3044\u3002\u304a\u305d\u3089\u304f\u3001lint\u30a8\u30e9\u30fc\u53d6\u308b\u305f\u3081\u306b\u304b\u306a\u308a\u624b\u3092\u5165\u308c\u3066\u3044\u308b\u3088\u3046\u3060\u304b\u3089\u3001\u305d\u306e\u5f71\u97ff\u304b\u3082\u3057\u308c\u306a\u3044\u3002<\/span>\r\n\/\/ wget https:\/\/raw.githubusercontent.com\/aliem\/DefinitelyTyped\/feature\/cassandra-driver-promises\/cassandra-driver\/index.d.ts \\<\/span>\r\n\/\/ -O node_modules\/@types\/cassandra-driver\/index.d.ts<\/span>\r\n\/\/<\/span>\r\nimport<\/span> {<\/span>types<\/span>,<\/span> Client<\/span>,<\/span> QueryOptions<\/span>}<\/span> from<\/span> '<\/span>cassandra-driver<\/span>'<\/span>;<\/span>\r\n\r\nexport<\/span> class<\/span> client<\/span> extends<\/span> Client<\/span> {<\/span>\r\n constructor<\/span>(<\/span>hosts<\/span>:<\/span> string<\/span>)<\/span> {<\/span>\r\n super<\/span>({<\/span> contactPoints<\/span>:<\/span> [<\/span> hosts<\/span> ]<\/span> });<\/span>\r\n }<\/span>\r\n\r\n public<\/span> select<\/span>(<\/span>id<\/span>:<\/span> string<\/span>):<\/span> Promise<\/span><<\/span>any<\/span>><\/span> {<\/span>\r\n const<\/span> query<\/span>:<\/span> string<\/span> =<\/span> \"<\/span>select * from Sample.Cookie where id = ?<\/span>\"<\/span>;<\/span>\r\n return<\/span> this<\/span>.<\/span>execute<\/span>(<\/span>query<\/span>,<\/span> [<\/span> id<\/span> ]).<\/span>then<\/span>((<\/span>result<\/span>:<\/span> types<\/span>.<\/span>ResultSet<\/span>)<\/span> =><\/span> {<\/span>\r\n return<\/span> (<\/span>result<\/span>.<\/span>rows<\/span>);<\/span>\r\n });<\/span>\r\n }<\/span>\r\n\r\n public<\/span> update<\/span>(<\/span>id<\/span>:<\/span> string<\/span>,<\/span> cookie<\/span>:<\/span> string<\/span> ):<\/span> Promise<\/span><<\/span>any<\/span>><\/span> {<\/span>\r\n const<\/span> query<\/span>:<\/span> string<\/span> =<\/span> \"<\/span>update Sample.Cookie set cookie = ?, update_time = toTimestamp(now()) where id = ? IF EXISTS<\/span>\"<\/span>;<\/span>\r\n return<\/span> this<\/span>.<\/span>execute<\/span>(<\/span>query<\/span>,<\/span> [<\/span>