|
// retoor <retoor@molodetz.nl>
|
|
|
|
import "dataset" for Dataset
|
|
|
|
var ds = Dataset.memory()
|
|
var products = ds["products"]
|
|
|
|
products.insert({"name": "Apple", "price": 10, "stock": 100})
|
|
products.insert({"name": "Banana", "price": 5, "stock": 50})
|
|
products.insert({"name": "Cherry", "price": 20, "stock": 0})
|
|
products.insert({"name": "Date", "price": 15, "stock": 25})
|
|
|
|
var gte = products.find({"price__gte": 15})
|
|
System.print(gte.count) // expect: 2
|
|
|
|
var lte = products.find({"price__lte": 10})
|
|
System.print(lte.count) // expect: 2
|
|
|
|
var ne = products.find({"name__ne": "Apple"})
|
|
System.print(ne.count) // expect: 3
|
|
|
|
var like = products.find({"name__like": "A\%"})
|
|
System.print(like.count) // expect: 1
|
|
System.print(like[0]["name"]) // expect: Apple
|
|
|
|
var inList = products.find({"name__in": ["Apple", "Banana"]})
|
|
System.print(inList.count) // expect: 2
|
|
|
|
var zeroStock = products.find({"stock": 0})
|
|
System.print(zeroStock.count) // expect: 1
|
|
System.print(zeroStock[0]["name"]) // expect: Cherry
|
|
|
|
var combined = products.find({"price__gte": 10, "stock__gt": 0})
|
|
System.print(combined.count) // expect: 2
|
|
|
|
ds.close()
|