SlicingDice/slicingdice-javascriptPublic

NotificationsYou must be signed in to change notification settings
Fork2
Star11

Official JavaScript client for SlicingDice, Data Warehouse and Analytics Database as a Service.

License

MIT license

11 stars 2 forks Branches Tags Activity

Star

Notifications

You must be signed in to change notification settings

Branches Tags

Folders and files

Name		Name	Last commit message	Last commit date
Latest commit History 114 Commits
src		src
tests_and_examples		tests_and_examples
.gitignore		.gitignore
CHANGELOG.md		CHANGELOG.md
LICENSE.txt		LICENSE.txt
README.md		README.md
bower.json		bower.json
circle.yml		circle.yml
package.json		package.json

Repository files navigation

SlicingDice Official JavaScript Client (v2.1.0)

Official JavaScript client forSlicingDice - Data Warehouse and Analytics Database as a Service.

SlicingDice is a serverless, SQL & API-based, easy-to-use and really cost-effective alternative to Amazon Redshift and Google BigQuery.

Build Status:

Code Quality:

Documentation

If you are new to SlicingDice, check ourquickstart guide and learn to use it in 15 minutes.

Please refer to theSlicingDice official documentation for more information onhow to create a database,how to insert data,how to make queries,how to create columns,SlicingDice restrictions andAPI details.

Tests and Examples

Whether you want to test the client installation or simply check more examples on how the client works, take a look attests and examples directory.

Installing

In order to install the JavaScript client, you only need to usenpm.

npm install slicerjs

Usage

The following code snippet is an example of how to add and query datausing the SlicingDice javascript client. We entry data informinguser1@slicingdice.com has age 22 and then query the database forthe number of users with age between 20 and 40 years old.If this is the first register ever entered into the system,the answer should be 1.

varSlicingDice=require('slicerjs');// only required for Node.js// Configure the clientconstclient=newSlicingDice({masterKey:'MASTER_API_KEY',writeKey:'WRITE_API_KEY',readKey:'READ_API_KEY'});// Inserting dataconstinsertData={"user1@slicingdice.com":{"age":22},"auto-create":["dimension","column"]};client.insert(insertData);// Querying dataconstqueryData={"query-name":"users-between-20-and-40","query":[{"age":{"range":[20,40]}}]};client.countEntity(queryData).then((resp)=>{console.log(resp);},(err)=>{console.err(err);});

Reference

SlicingDice encapsulates logic for sending requests to the API. Its methods are thin layers around theAPI endpoints, so their parameters and return values are JSON-likeObject objects with the same syntax as theAPI endpoints

Constructor

SlicingDice(apiKeys)

apiKeys (Object) -API key to authenticate requests with the SlicingDice API.

`getDatabase()`

Get information about current database. This method corresponds to aGET request at/database.

Request example

letSlicingDice=require('slicerjs');constclient=newSlicingDice({masterKey:'MASTER_API_KEY'});client.getDatabase().then((resp)=>{console.log(resp);},(err)=>{console.error(err);});

Output example

{"name":"Database 1","description":"My first database","dimensions": ["default","users"    ],"updated-at":"2017-05-19T14:27:47.417415","created-at":"2017-05-12T02:23:34.231418"}

`getColumns()`

Get all created columns, both active and inactive ones. This method corresponds to aGET request at /column.

Request example

letSlicingDice=require('slicerjs');constclient=newSlicingDice({masterKey:'MASTER_API_KEY'});client.getColumns().then((resp)=>{console.log(resp);},(err)=>{console.error(err);});

Output example

{"active": [        {"name":"Model","api-name":"car-model","description":"Car models from dealerships","type":"string","category":"general","cardinality":"high","storage":"latest-value"        }    ],"inactive": [        {"name":"Year","api-name":"car-year","description":"Year of manufacture","type":"integer","category":"general","storage":"latest-value"        }    ]}

`createColumn(jsonData)`

Create a new column. This method corresponds to aPOST request at /column.

Request example

letSlicingDice=require('slicerjs');constclient=newSlicingDice({masterKey:'MASTER_API_KEY'});column={"name":"Year","api-name":"year","type":"integer","description":"Year of manufacturing","storage":"latest-value"};client.createColumn(column).then((resp)=>{console.log(resp);},(err)=>{console.error(err);});

Output example

{"status":"success","api-name":"year"}

`insert(jsonData)`

Insert data to existing entities or create new entities, if necessary. This method corresponds to aPOST request at /insert.

Request example

letSlicingDice=require('slicerjs');constclient=newSlicingDice({masterKey:'MASTER_API_KEY',writeKey:'WRITE_API_KEY'});constinsertData={"user1@slicingdice.com":{"car-model":"Ford Ka","year":2016},"user2@slicingdice.com":{"car-model":"Honda Fit","year":2016},"user3@slicingdice.com":{"car-model":"Toyota Corolla","year":2010,"test-drives":[{"value":"NY","date":"2016-08-17T13:23:47+00:00"},{"value":"NY","date":"2016-08-17T13:23:47+00:00"},{"value":"CA","date":"2016-04-05T10:20:30Z"}]},"user4@slicingdice.com":{"car-model":"Ford Ka","year":2005,"test-drives":{"value":"NY","date":"2016-08-17T13:23:47+00:00"}}};client.insert(insertData).then((resp)=>{console.log(resp);},(err)=>{console.error(err);});

Output example

{"status":"success","inserted-entities":4,"inserted-columns":10,"took":0.023}

`existsEntity(ids, dimension = null)`

Verify which entities exist in a tabdimensionle (usesdefault dimension if not provided) given a list of entity IDs. This method corresponds to aPOST request at /query/exists/entity.

Request example

letSlicingDice=require('slicerjs');constclient=newSlicingDice({masterKey:'MASTER_KEY',readKey:'READ_KEY'});ids=["user1@slicingdice.com","user2@slicingdice.com","user3@slicingdice.com"];client.existsEntity(ids).then((resp)=>{console.log(resp);},(err)=>{console.error(err);});

Output example

{"status":"success","exists": ["user1@slicingdice.com","user2@slicingdice.com"    ],"not-exists": ["user3@slicingdice.com"    ],"took":0.103}

`countEntityTotal()`

Count the number of inserted entities in the whole database. This method corresponds to aPOST request at /query/count/entity/total.

Request example

letSlicingDice=require('slicerjs');constclient=newSlicingDice({masterKey:'MASTER_KEY',readKey:'READ_KEY'});client.countEntityTotal().then((resp)=>{console.log(resp);},(err)=>{console.error(err);});

Output example

{"status":"success","result": {"total":42    },"took":0.103}

`countEntityTotal(dimensions)`

Count the total number of inserted entities in the given dimensions. This method corresponds to aPOST request at /query/count/entity/total.

Request example

letSlicingDice=require('slicerjs');constclient=newSlicingDice({masterKey:'MASTER_KEY',readKey:'READ_KEY'});constdimensions=["default"];client.countEntityTotal(dimensions).then((resp)=>{console.log(resp);},(err)=>{console.error(err);});

Output example

{"status":"success","result": {"total":42    },"took":0.103}

`countEntity(jsonData)`

Count the number of entities matching the given query. This method corresponds to aPOST request at /query/count/entity.

Request example

letSlicingDice=require('slicerjs');constclient=newSlicingDice({masterKey:'MASTER_KEY',readKey:'READ_KEY'});constquery=[{"query-name":"corolla-or-fit","query":[{"car-model":{"equals":"toyota corolla"}},"or",{"car-model":{"equals":"honda fit"}}],"bypass-cache":false},{"query-name":"ford-ka","query":[{"car-model":{"equals":"ford ka"}}],"bypass-cache":false}];client.countEntity(query).then((resp)=>{console.log(resp);},(err)=>{console.error(err);});

Output example

{"result":{"ford-ka":2,"corolla-or-fit":2   },"took":0.083,"status":"success"}

`countEvent(jsonData)`

Count the number of occurrences for time-series events matching the given query. This method corresponds to aPOST request at /query/count/event.

Request example

letSlicingDice=require('slicerjs');constclient=newSlicingDice({masterKey:'MASTER_KEY',readKey:'READ_KEY'});constquery=[{"query-name":"test-drives-in-ny","query":[{"test-drives":{"equals":"NY","between":["2016-08-16T00:00:00Z","2016-08-18T00:00:00Z"]}}],"bypass-cache":true},{"query-name":"test-drives-in-ca","query":[{"test-drives":{"equals":"CA","between":["2016-04-04T00:00:00Z","2016-04-06T00:00:00Z"]}}],"bypass-cache":true}];client.countEvent(query).then((resp)=>{console.log(resp);},(err)=>{console.error(err);});

Output example

{"result":{"test-drives-in-ny":3,"test-drives-in-ca":0   },"took":0.063,"status":"success"}

`topValues(jsonData)`

Return the top values for entities matching the given query. This method corresponds to aPOST request at /query/top_values.

Request example

letSlicingDice=require('slicerjs');constclient=newSlicingDice({masterKey:'MASTER_KEY',readKey:'READ_KEY'});query={"car-year":{"year":2},"car models":{"car-model":3}}client.topValues(query).then((resp)=>{console.log(resp);},(err)=>{console.error(err);});

Output example

{"result":{"car models":{"car-model":[            {"quantity":2,"value":"ford ka"            },            {"quantity":1,"value":"honda fit"            },            {"quantity":1,"value":"toyota corolla"            }         ]      },"car-year":{"year":[            {"quantity":2,"value":"2016"            },            {"quantity":1,"value":"2010"            }         ]      }   },"took":0.034,"status":"success"}

`aggregation(jsonData)`

Return the aggregation of all columns in the given query. This method corresponds to aPOST request at /query/aggregation.

Request example

letSlicingDice=require('slicerjs');constclient=newSlicingDice({masterKey:'MASTER_KEY',readKey:'READ_KEY'});query={"query":[{"year":2},{"car-model":2,"equals":["honda fit","toyota corolla"]}]};client.aggregation(query).then((resp)=>{console.log(resp);},(err)=>{console.error(err);});

Output example

{"result":{"year":[         {"quantity":2,"value":"2016","car-model":[               {"quantity":1,"value":"honda fit"               }            ]         },         {"quantity":1,"value":"2005"         }      ]   },"took":0.079,"status":"success"}

`getSavedQueries()`

Get all saved queries. This method corresponds to aGET request at /query/saved.

Request example

letSlicingDice=require('slicerjs');constclient=newSlicingDice({masterKey:'MASTER_KEY'});client.getSavedQueries().then((resp)=>{console.log(resp);},(err)=>{console.error(err);});

Output example

{"status":"success","saved-queries": [        {"name":"users-in-ny-or-from-ca","type":"count/entity","query": [                {"state": {"equals":"NY"                    }                },"or",                {"state-origin": {"equals":"CA"                    }                }            ],"cache-period":100        }, {"name":"users-from-ca","type":"count/entity","query": [                {"state": {"equals":"NY"                    }                }            ],"cache-period":60        }    ],"took":0.103}

`createSavedQuery(jsonData)`

Create a saved query at SlicingDice. This method corresponds to aPOST request at /query/saved.

Request example

letSlicingDice=require('slicerjs');constclient=newSlicingDice({masterKey:'MASTER_KEY'});query={"name":"my-saved-query","type":"count/entity","query":[{"car-model":{"equals":"honda fit"}},"or",{"car-model":{"equals":"toyota corolla"}}],"cache-period":100}client.createSavedQuery(query).then((resp)=>{console.log(resp);},(err)=>{console.error(err);});

Output example

{"took":0.053,"query":[      {"car-model":{"equals":"honda fit"         }      },"or",      {"car-model":{"equals":"toyota corolla"         }      }   ],"name":"my-saved-query","type":"count/entity","cache-period":100,"status":"success"}

`updateSavedQuery(queryName, jsonData)`

Update an existing saved query at SlicingDice. This method corresponds to aPUT request at /query/saved/QUERY_NAME.

Request example

letSlicingDice=require('slicerjs');constclient=newSlicingDice({masterKey:'MASTER_KEY'});newQuery={"type":"count/entity","query":[{"car-model":{"equals":"ford ka"}},"or",{"car-model":{"equals":"toyota corolla"}}],"cache-period":100};client.updateSavedQuery("my-saved-query",newQuery).then((resp)=>{console.log(resp);},(err)=>{console.error(err);});

Output example

{"took":0.037,"query":[      {"car-model":{"equals":"ford ka"         }      },"or",      {"car-model":{"equals":"toyota corolla"         }      }   ],"type":"count/entity","cache-period":100,"status":"success"}

`getSavedQuery(queryName)`

Executed a saved query at SlicingDice. This method corresponds to aGET request at /query/saved/QUERY_NAME.

Request example

letSlicingDice=require('slicerjs');constclient=newSlicingDice({masterKey:'MASTER_KEY',readKey:'READ_KEY'});client.getSavedQuery("my-saved-query").then((resp)=>{console.log(resp);},(err)=>{console.error(err);});

Output example

{"result":{"query":2   },"took":0.035,"query":[      {"car-model":{"equals":"honda fit"         }      },"or",      {"car-model":{"equals":"toyota corolla"         }      }   ],"type":"count/entity","status":"success"}

`deleteSavedQuery(queryName)`

Delete a saved query at SlicingDice. This method corresponds to aDELETE request at /query/saved/QUERY_NAME.

Request example

letSlicingDice=require('slicerjs');constclient=newSlicingDice({masterKey:'MASTER_KEY'});client.deleteSavedQuery("my-saved-query").then((resp)=>{console.log(resp);},(err)=>{console.error(err);});

Output example

{"took":0.029,"query":[      {"car-model":{"equals":"honda fit"         }      },"or",      {"car-model":{"equals":"toyota corolla"         }      }   ],"type":"count/entity","cache-period":100,"status":"success","deleted-query":"my-saved-query"}

`result(jsonData)`

Retrieve inserted values for entities matching the given query. This method corresponds to aPOST request at /data_extraction/result.

Request example

letSlicingDice=require('slicerjs');constclient=newSlicingDice({masterKey:'MASTER_KEY',readKey:'READ_KEY'});query={"query":[{"car-model":{"equals":"ford ka"}},"or",{"car-model":{"equals":"toyota corolla"}}],"columns":["car-model","year"],"limit":2};client.result(query).then((resp)=>{console.log(resp);},(err)=>{console.error(err);});

Output example

{"took":0.113,"next-page":null,"data":{"customer5@mycustomer.com":{"year":"2005","car-model":"ford ka"      },"user1@slicingdice.com":{"year":"2016","car-model":"ford ka"      }   },"page":1,"status":"success"}

`score(jsonData)`

Retrieve inserted values as well as their relevance for entities matching the given query. This method corresponds to aPOST request at /data_extraction/score.

Request example

letSlicingDice=require('slicerjs');constclient=newSlicingDice({masterKey:'MASTER_KEY',readKey:'READ_KEY'});query={"query":[{"car-model":{"equals":"ford ka"}},"or",{"car-model":{"equals":"toyota corolla"}}],"columns":["car-model","year"],"limit":2};client.score(query).then((resp)=>{console.log(resp);},(err)=>{console.error(err);});

Output example

{"took":0.063,"next-page":null,"data":{"user3@slicingdice.com":{"score":1,"year":"2010","car-model":"toyota corolla"      },"user2@slicingdice.com":{"score":1,"year":"2016","car-model":"honda fit"      }   },"page":1,"status":"success"}

`sql(query)`

Retrieve inserted values using a SQL syntax. This method corresponds to a POST request at /query/sql.

Query statement

letSlicingDice=require('slicerjs');constclient=newSlicingDice({masterKey:'MASTER_KEY',readKey:'READ_KEY'});query="SELECT COUNT(*) FROM default WHERE age BETWEEN 0 AND 49";client.sql(query).then((resp)=>{console.log(resp);},(err)=>{console.error(err);});

Insert statement

letSlicingDice=require('slicerjs');constclient=newSlicingDice({masterKey:'MASTER_KEY',readKey:'READ_KEY'});query="INSERT INTO default([entity-id], name, age) VALUES(1, 'john', 10)";client.sql(query).then((resp)=>{console.log(resp);},(err)=>{console.error(err);});

Output example

{"took":0.063,"result":[       {"COUNT":3}   ],"count":1,"status":"success"}

License

MIT

About

Official JavaScript client for SlicingDice, Data Warehouse and Analytics Database as a Service.

www.slicingdice.com/

Releases5

v2.1.0 Latest

Sep 8, 2018

+ 4 releases

Packages

No packages published

Contributors12

Languages

JavaScript100.0%

Movatterモバイル変換

License

SlicingDice/slicingdice-javascript

Folders and files

Latest commit

History

Repository files navigation

SlicingDice Official JavaScript Client (v2.1.0)

Build Status:

Code Quality:

Documentation

Tests and Examples

Installing

Usage

Reference

Constructor

getDatabase()

Request example

Output example

getColumns()

Request example

Output example

createColumn(jsonData)

Request example

Output example

insert(jsonData)

Request example

Output example

existsEntity(ids, dimension = null)

Request example

Output example

countEntityTotal()

Request example

Output example

countEntityTotal(dimensions)

Request example

Output example

countEntity(jsonData)

Request example

Output example

countEvent(jsonData)

Request example

Output example

topValues(jsonData)

Request example

Output example

aggregation(jsonData)

Request example

Output example

getSavedQueries()

Request example

Output example

createSavedQuery(jsonData)

Request example

Output example

updateSavedQuery(queryName, jsonData)

Request example

Output example

getSavedQuery(queryName)

Request example

Output example

deleteSavedQuery(queryName)

Request example

Output example

result(jsonData)

Request example

Output example

score(jsonData)

Request example

Output example

sql(query)

Query statement

Insert statement

Output example

License

About

Topics

Resources

License

Uh oh!

`getDatabase()`

`getColumns()`

`createColumn(jsonData)`

`insert(jsonData)`

`existsEntity(ids, dimension = null)`

`countEntityTotal()`

`countEntityTotal(dimensions)`

`countEntity(jsonData)`

`countEvent(jsonData)`

`topValues(jsonData)`

`aggregation(jsonData)`

`getSavedQueries()`

`createSavedQuery(jsonData)`

`updateSavedQuery(queryName, jsonData)`

`getSavedQuery(queryName)`

`deleteSavedQuery(queryName)`

`result(jsonData)`

`score(jsonData)`

`sql(query)`

Packages