TaffyDB - combine methods

Question

I'm really new to TaffyDB and JavaScript. How can I combine methods in TaffyDB?

I'm trying to use distinct () and stringify(), which is not working

var xyz = db().distinct("mnths").stringify ();

console.log(xyz );

I get an error stating that stringify() is not supported.

Thank you.

Answer 1

db().distinct("mnths") returns an array and not a TaffyDB object hence .stringify() will not work on it.

You can instead do

JSON.stringify(db().distinct("mnths"))

---

This is what the documentation says

| Method          | Takes                     | Returns                                                                                   | Info                                                                                                                                    |
|-----------------|---------------------------|-------------------------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------|
| db().distinct() | One or more column names. | For one column: An array of values.For two or more columns: An array of arrays of values. | Used to select distinct values from the database for one or more columns. Pass in column names to get back an array of distinct values. |

var db = TAFFY([{
  "item":1,
    "name":"Blue Ray Player",
    "price":99.99,
    "type":"No"
}, {
    "item":2,
    name:"3D TV",
    price:1799.99,
    "type":"Yes"
}]);


var xyz = JSON.stringify(db().distinct("item"));
alert(xyz);

<script src="https://cdnjs.cloudflare.com/ajax/libs/taffydb/2.7.2/taffy-min.js"></script>

---

Update

You can do something like this

var filter = db().filter({ price: { gt : 49 } }); // filter data
var order = filter.order('price'); // this will sort 
var distinct = order.distinct('price'); // this will get distinct (at this stage TaffyDB spits out data so further chaining is not possible
var stringifiedData = JSON.stringify(distinct); // this will stringify the data
alert(stringifiedData);

var db = TAFFY(getData());

var filter = db().filter({
  price: {
    gt : 49
  }
});
var order = filter.order('price');
var distinct = order.distinct('price');
var stringifiedData = JSON.stringify(distinct);
alert(stringifiedData);


function getData() {
  return [{
    "item": 1,
    "name": "Gelato Topical Anesthetic",
    "price": 86,
    "type": false
  }, {
    "item": 2,
    "name": "Essential Shockeye and Lip",
    "price": 4,
    "type": true
  }, {
    "item": 3,
    "name": "Benazepril Hydrochloride",
    "price": 32,
    "type": false
  }, {
    "item": 4,
    "name": "Simulect",
    "price": 4,
    "type": false
  }, {
    "item": 5,
    "name": "Pollens - Weeds, Marshelder/Poverty Mix",
    "price": 59,
    "type": true
  }, {
    "item": 6,
    "name": "Carvedilol",
    "price": 88,
    "type": true
  }, {
    "item": 7,
    "name": "CardinalHealth bathing wipe with dimethicone",
    "price": 100,
    "type": true
  }, {
    "item": 8,
    "name": "Phentermine Hydrochloride",
    "price": 10,
    "type": false
  }, {
    "item": 9,
    "name": "NABUMETONE",
    "price": 14,
    "type": false
  }, {
    "item": 10,
    "name": "Members Mark Nicotine",
    "price": 82,
    "type": true
  }, {
    "item": 11,
    "name": "Amitriptyline Hydrochloride",
    "price": 13,
    "type": false
  }, {
    "item": 12,
    "name": "Oxygen",
    "price": 98,
    "type": true
  }, {
    "item": 13,
    "name": "buspirone hydrochloride",
    "price": 72,
    "type": true
  }, {
    "item": 14,
    "name": "Antibacterial Foaming Hand Sanitizer",
    "price": 94,
    "type": false
  }, {
    "item": 15,
    "name": "Nevirapine",
    "price": 61,
    "type": false
  }, {
    "item": 16,
    "name": "Tamsulosin Hydrochloride",
    "price": 39,
    "type": true
  }, {
    "item": 17,
    "name": "Aveeno Baby Daily Moisture",
    "price": 31,
    "type": false
  }, {
    "item": 18,
    "name": "Ultra Nutrition Ampoule",
    "price": 5,
    "type": true
  }, {
    "item": 19,
    "name": "Glytone essentials rejuvenate daily",
    "price": 36,
    "type": false
  }, {
    "item": 20,
    "name": "all day allergy relief",
    "price": 75,
    "type": true
  }, {
    "item": 21,
    "name": "CLE DE PEAU BEAUTE SILKY FOUNDATION I",
    "price": 7,
    "type": true
  }, {
    "item": 22,
    "name": "GABAPENTIN",
    "price": 48,
    "type": false
  }, {
    "item": 23,
    "name": "SUN Solar Defense Hydrating",
    "price": 44,
    "type": false
  }, {
    "item": 24,
    "name": "Carvedilol",
    "price": 38,
    "type": false
  }, {
    "item": 25,
    "name": "Metoprolol succinate",
    "price": 59,
    "type": false
  }, {
    "item": 26,
    "name": "Prosacea",
    "price": 38,
    "type": true
  }, {
    "item": 27,
    "name": "Russian Olive",
    "price": 50,
    "type": true
  }, {
    "item": 28,
    "name": "Silver Maple",
    "price": 33,
    "type": true
  }, {
    "item": 29,
    "name": "Dove Ultimate Visibly Smooth Nature Fresh",
    "price": 28,
    "type": true
  }, {
    "item": 30,
    "name": "Crayola Wild Blue Yonder Roll On Hand Sanitizer",
    "price": 89,
    "type": true
  }, {
    "item": 31,
    "name": "Oxygen",
    "price": 70,
    "type": false
  }, {
    "item": 32,
    "name": "infants fever reducer and pain reliever",
    "price": 80,
    "type": false
  }, {
    "item": 33,
    "name": "equaline childrens ibuprofen oral suspension",
    "price": 17,
    "type": false
  }, {
    "item": 34,
    "name": "Head and Shoulders Dual Sachets",
    "price": 80,
    "type": false
  }, {
    "item": 35,
    "name": "Kadian",
    "price": 22,
    "type": true
  }, {
    "item": 36,
    "name": "Fentanyl",
    "price": 90,
    "type": true
  }, {
    "item": 37,
    "name": "Vicks DayQuil and Vicks NyQuil",
    "price": 14,
    "type": false
  }, {
    "item": 38,
    "name": "Dr. Scholls",
    "price": 48,
    "type": true
  }, {
    "item": 39,
    "name": "Promethazine VC With Codeine",
    "price": 67,
    "type": false
  }, {
    "item": 40,
    "name": "Prestige",
    "price": 20,
    "type": true
  }, {
    "item": 41,
    "name": "propranolol hydrochloride",
    "price": 40,
    "type": false
  }, {
    "item": 42,
    "name": "KROGER",
    "price": 96,
    "type": false
  }, {
    "item": 43,
    "name": "Hydrochlorothiazide",
    "price": 16,
    "type": false
  }, {
    "item": 44,
    "name": "Herpes Sores",
    "price": 76,
    "type": true
  }, {
    "item": 45,
    "name": "TRICHOPHYTON MENTAGROPHYTES",
    "price": 10,
    "type": true
  }, {
    "item": 46,
    "name": "Promethazine Hydrochloride",
    "price": 45,
    "type": true
  }, {
    "item": 47,
    "name": "Allergy",
    "price": 27,
    "type": false
  }, {
    "item": 48,
    "name": "Hydrocortisone",
    "price": 69,
    "type": false
  }, {
    "item": 49,
    "name": "ChapStick Active Sport Ready",
    "price": 91,
    "type": false
  }, {
    "item": 50,
    "name": "Orange Pekoe Tea",
    "price": 25,
    "type": false
  }, {
    "item": 51,
    "name": "care one miconazole 7",
    "price": 63,
    "type": true
  }, {
    "item": 52,
    "name": "ACER NEGUNDO POLLEN",
    "price": 24,
    "type": false
  }, {
    "item": 53,
    "name": "Ceftriaxone",
    "price": 50,
    "type": true
  }, {
    "item": 54,
    "name": "Smart Sense Dual Action Complete",
    "price": 35,
    "type": true
  }, {
    "item": 55,
    "name": "Effexor",
    "price": 2,
    "type": false
  }, {
    "item": 56,
    "name": "Clopidogrel Bisulfate",
    "price": 82,
    "type": false
  }, {
    "item": 57,
    "name": "Methenamine Hippurate",
    "price": 89,
    "type": false
  }, {
    "item": 58,
    "name": "Glumetza",
    "price": 57,
    "type": false
  }, {
    "item": 59,
    "name": "Duloxetine",
    "price": 98,
    "type": true
  }, {
    "item": 60,
    "name": "Relaxatone",
    "price": 88,
    "type": false
  }, {
    "item": 61,
    "name": "Blues - Mood Support",
    "price": 89,
    "type": true
  }, {
    "item": 62,
    "name": "Phenytek",
    "price": 10,
    "type": true
  }, {
    "item": 63,
    "name": "LEUKERAN",
    "price": 20,
    "type": true
  }, {
    "item": 64,
    "name": "Citalopram",
    "price": 17,
    "type": true
  }, {
    "item": 65,
    "name": "ACTIFIRM RECOVERY EYE",
    "price": 34,
    "type": true
  }, {
    "item": 66,
    "name": "Potassium Chloride",
    "price": 99,
    "type": false
  }, {
    "item": 67,
    "name": "Mucus Relief",
    "price": 63,
    "type": false
  }, {
    "item": 68,
    "name": "Cold and Flu BP",
    "price": 52,
    "type": false
  }, {
    "item": 69,
    "name": "AQUAFRESH",
    "price": 10,
    "type": true
  }, {
    "item": 70,
    "name": "Buspirone Hydrochloride",
    "price": 100,
    "type": false
  }, {
    "item": 71,
    "name": "Childrens Allergy Relief",
    "price": 91,
    "type": false
  }, {
    "item": 72,
    "name": "PANCRELIPASE",
    "price": 96,
    "type": true
  }, {
    "item": 73,
    "name": "Hydrocodone Bitartrate and Acetaminophen",
    "price": 63,
    "type": false
  }, {
    "item": 74,
    "name": "Dicyclomine Hydrochloride",
    "price": 2,
    "type": false
  }, {
    "item": 75,
    "name": "clear lax",
    "price": 98,
    "type": false
  }, {
    "item": 76,
    "name": "Doxycycline",
    "price": 44,
    "type": false
  }, {
    "item": 77,
    "name": "NO-AD 45 Sunscreen",
    "price": 99,
    "type": false
  }, {
    "item": 78,
    "name": "Oxygen",
    "price": 36,
    "type": false
  }, {
    "item": 79,
    "name": "Spa Originals Antibacterial Gold Hand",
    "price": 26,
    "type": false
  }, {
    "item": 80,
    "name": "Citalopram",
    "price": 36,
    "type": true
  }, {
    "item": 81,
    "name": "BAMBOO SALT Eunganggo Jook Yeom Toothpaste",
    "price": 81,
    "type": false
  }, {
    "item": 82,
    "name": "Cefdinir",
    "price": 32,
    "type": true
  }, {
    "item": 83,
    "name": "Pravastatin Sodium",
    "price": 69,
    "type": true
  }, {
    "item": 84,
    "name": "Metoclopramide",
    "price": 61,
    "type": false
  }, {
    "item": 85,
    "name": "Loratadine and Pseudoephedrine",
    "price": 25,
    "type": true
  }, {
    "item": 86,
    "name": "Fluoxetine",
    "price": 52,
    "type": false
  }, {
    "item": 87,
    "name": "Good Sense Nicotine",
    "price": 53,
    "type": false
  }, {
    "item": 88,
    "name": "triamcinolone acetonide",
    "price": 78,
    "type": true
  }, {
    "item": 89,
    "name": "Warm Deep Original",
    "price": 60,
    "type": false
  }, {
    "item": 90,
    "name": "Pollens - Trees, Tree Mix 11",
    "price": 1,
    "type": false
  }, {
    "item": 91,
    "name": "Acidil",
    "price": 69,
    "type": true
  }, {
    "item": 92,
    "name": "Rugby GAS RELIEF",
    "price": 67,
    "type": false
  }, {
    "item": 93,
    "name": "Pandanus Calc. carb.",
    "price": 94,
    "type": false
  }, {
    "item": 94,
    "name": "Palgic",
    "price": 44,
    "type": false
  }, {
    "item": 95,
    "name": "Benzamycin Pak",
    "price": 41,
    "type": false
  }, {
    "item": 96,
    "name": "Labetalol Hydrochloride",
    "price": 31,
    "type": true
  }, {
    "item": 97,
    "name": "4 Way",
    "price": 36,
    "type": false
  }, {
    "item": 98,
    "name": "REPAIRWEAR ANTI -AGING MAKEUP",
    "price": 30,
    "type": false
  }, {
    "item": 99,
    "name": "leader cough dm",
    "price": 28,
    "type": true
  }, {
    "item": 100,
    "name": "Magnesium Oxide",
    "price": 82,
    "type": false
  }];
}

<script src="https://cdnjs.cloudflare.com/ajax/libs/taffydb/2.7.2/taffy-min.js"></script>