{"library":"nqm-iot-database-utils","title":"nqm-iot-database-utils","description":"Database utility functions for nqminds IoT platform, providing a SQLite-based implementation for creating datasets, adding and querying data with support for ndarray fields. Version 0.7.2 is the latest stable release. This package is specific to the nqm ecosystem and not intended for general database usage. It offers a promise-based API with functions like openDatabase, createDataset, addData, getData, and ndarray utilities. The package is outdated with no recent updates and limited documentation.","language":"javascript","status":"maintenance","last_verified":"Sat Apr 25","install":{"commands":["npm install nqm-iot-database-utils"],"cli":null},"imports":["const sqliteUtils = require('nqm-iot-database-utils');","const { openDatabase } = require('nqm-iot-database-utils');","const { getNdarrayMeta } = require('nqm-iot-database-utils');"],"auth":{"required":false,"env_vars":[]},"quickstart":{"code":"const sqliteUtils = require('nqm-iot-database-utils');\nconst TDX_SCHEMA = {\n  \"schema\": {\n    \"dataSchema\": {\n      \"prop1\": { \"__tdxType\": [\"number\"] },\n      \"prop2\": { \"__tdxType\": [\"number\"] }\n    },\n    \"uniqueIndex\": []\n  }\n};\n\nlet dbIter;\nconst testData = [];\n\nsqliteUtils.openDatabase('', 'memory', 'w+')\n  .then(db => {\n    dbIter = db;\n    return sqliteUtils.createDataset(db, TDX_SCHEMA);\n  })\n  .then(() => {\n    for (let idx = 0; idx < 100; idx++) {\n      testData.push({ prop1: idx, prop2: 100 - idx - 1 });\n    }\n    return sqliteUtils.addData(dbIter, testData);\n  })\n  .then(() => {\n    return sqliteUtils.getData(dbIter,\n      { $and: [ { $or: [ { prop1: { $gte: 2, $lte: 5 } }, { prop1: { $gte: 92 } } ] }, { prop2: { $lte: 10 } } ] },\n      null,\n      { sort: { prop1: 1, prop2: -1 } });\n  })\n  .then(result => console.log(result));","lang":"javascript","description":"Demonstrates opening an in-memory SQLite database, creating a dataset with two numeric fields, inserting 100 documents, and querying with a filter and sort.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":null}