|
// retoor <retoor@molodetz.nl>
|
|
|
|
import "dataset" for Dataset
|
|
|
|
var ds = Dataset.memory()
|
|
var users = ds["users"]
|
|
|
|
var user = users.insert({"name": "Alice"})
|
|
var uid = user["uid"]
|
|
|
|
System.print(users.count()) // expect: 1
|
|
|
|
users.delete(uid)
|
|
System.print(users.count()) // expect: 0
|
|
|
|
var softDeleted = ds.db.query("SELECT * FROM users WHERE uid = ?", [uid])
|
|
System.print(softDeleted.count) // expect: 1
|
|
System.print(softDeleted[0]["deleted_at"] != null) // expect: true
|
|
|
|
var user2 = users.insert({"name": "Bob"})
|
|
var uid2 = user2["uid"]
|
|
|
|
System.print(users.hardDelete(uid2)) // expect: true
|
|
var hardDeleted = ds.db.query("SELECT * FROM users WHERE uid = ?", [uid2])
|
|
System.print(hardDeleted.count) // expect: 0
|
|
|
|
System.print(users.hardDelete("nonexistent")) // expect: false
|
|
|
|
ds.close()
|