|
// retoor <retoor@molodetz.nl>
|
|
|
|
import "dataset" for Dataset
|
|
|
|
var ds = Dataset.memory()
|
|
|
|
var users = ds["users"]
|
|
var posts = ds["posts"]
|
|
var comments = ds["comments"]
|
|
|
|
var user = users.insert({"name": "Alice"})
|
|
var userUid = user["uid"]
|
|
|
|
var post = posts.insert({"title": "Hello", "author_uid": userUid})
|
|
var postUid = post["uid"]
|
|
|
|
comments.insert({"text": "Nice!", "post_uid": postUid, "author_uid": userUid})
|
|
comments.insert({"text": "Great!", "post_uid": postUid, "author_uid": userUid})
|
|
|
|
System.print(users.count()) // expect: 1
|
|
System.print(posts.count()) // expect: 1
|
|
System.print(comments.count()) // expect: 2
|
|
|
|
var tables = ds.tables
|
|
System.print(tables.count) // expect: 3
|
|
System.print(tables.contains("users")) // expect: true
|
|
System.print(tables.contains("posts")) // expect: true
|
|
System.print(tables.contains("comments")) // expect: true
|
|
|
|
var postComments = comments.find({"post_uid": postUid})
|
|
System.print(postComments.count) // expect: 2
|
|
|
|
ds.close()
|