// retoor <retoor@molodetz.nl>
|
|
|
|
import "dataset" for Dataset
|
|
import "tempfile" for TempFile
|
|
import "io" for File
|
|
|
|
var path = TempFile.mkstemp(".db")
|
|
var ds = Dataset.open(path)
|
|
|
|
var users = ds["users"]
|
|
users.insert({"name": "Alice"})
|
|
|
|
var result = users.find({"nonexistent": "value"})
|
|
System.print(result.count) // expect: 0
|
|
|
|
var one = users.findOne({"missing_col": "test"})
|
|
System.print(one == null) // expect: true
|
|
|
|
var all = users.all()
|
|
System.print(all.count) // expect: 1
|
|
|
|
ds.close()
|
|
File.delete(path)
|