@signalv/domoappdb
v0.5.3
Published
Helper Utility to simplify usage of Domo AppDb in Domo Custom Apps
Downloads
33
Readme
@signalv/domoappdb
@signalv/domoappdb
is a library that provides convenient usage of the AppDb API for Domo Custom Apps, especially ones that sync collections to the Domo Datacenter.
It has a simple wrapper around the AppDb API via the AppDb class
Getting Started
npm install @signalv/domoappdb
Examples
Getting records from an AppDb collection
const allDocsInCollection = await AppDb.FetchAll<SomeTypeForContentProp>("collectionToQuery");
const docId = "Some Existing Doc Id"
const specificExistingDoc = await AppDb.FetchDoc("collectionToQuery", docId);
/*
by default any Date properties will be
deserialized from JSON as a string instead of a Date object.
if you pass `true` as the optional last param to the functions
that return values, it will check to see if JSON string values
are ISO 8601 date strings and if they are deserialize them as
Date obects. This makes the `createdOn` and `updatedOn` doc
properties Date objects instead of strings in addition to any
properies in the `content` that are ISO 8601 date strings.
*/
const docWithDatesAsStrings = await AppDb.FetchDoc("collectionToQuery", docId)
const docWithDatesAsDateObj = await AppDb.FetchDoc("collectionToQuery", docId, true)
Creating new records
const exampleData = {
content: {
someText: 'a',
someNumber: 1,
someDate: new Date(),
}
}
// newlyCreatedDoc will be type AppDbDoc<T> where T is the type of the content property
// i.e. it'll come back with populated `id`, `owner`, `createdOn`, etc.
const newlyCreatedDoc = await AppDb.Create("collectionName", exampleData);
// the `someDate` field, plus the metadata date fields will come back as strings unless
// you set the optional last param to `true`
const newDoc2 = await AppDb.Create("collectionName", exampleData, true);
Updating existing records
const exampleContent = {
someText: 'a',
someNumber: 1,
someDate: new Date(),
}
await AppDb.Update("collectionName", exampleContent); // ts won't compile and will give an error because ex doesn't have an id or content property.
// make a change and update a record created in the `Creating new records` example
newlyCreatedDoc.someText = "An example of updating an existing record"
await AppDb.Update("collectionName", newlyCreatedDoc)
Deleting records
// Delete one of the records created in the `Creating new records` example
await AppDb.Delete("collectionName", newDoc2.id)
Query records
The Query API works with valid mongodb queries. Here's a few examples:
A simple query searching for documents with a description value of "an example"
const query = { "content.description": { $eq: "an example"}}
const recordsMatchingQuery = await AppDb.Query("exampleCollectionName", query)
A more complex query example that has multiple conditions
// A query that gets all records that:
// have an authorName "Sam" and do not have a description (either description is missing from the document, or the description is null)
// OR
// have an authorName "Sam", a description "very specific" and a category "A"
const query = {
$or: [
{
$and: [
{ "content.authorName": { $eq: "Sam" }},
{ "content.description": { $exists: false }}
],
},
{
$and: [
{ "content.authorName": { $eq: "Sam" }},
{ "content.description": { $eq: "very specific" }},
{ "content.category": { $eq: "A" }}
]
}
]
}
const recordsThatMatchQuery = await AppDb.Query("exampleCollectionName", query)
A query that returns all docs that have a color prop that's in a list.
const colorsToInclude = ["red", "green", "blue"]
// A query that will return any records with `content.color` values of "red" or "green" or "blue"
const query = {
"content.color": { $in: colorsToInclude}
}
License
Licensed under either of
- Apache License, Version 2.0 (LICENSE-APACHE or http://apache.org/licenses/LICENSE-2.0)
- MIT license (LICENSE-MIT or http://opensource.org/licenses/MIT)
Contribution
look at some of these issues:
Unless you explicitly state otherwise, any contribution intentionally submitted for inclusion in the work by you, as defined in the Apache-2.0 license, shall be dual licensed as above, without any additional terms or conditions.