1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
use sql;
// Database declaration of a database for storing
// authors and their books.
DATABASE ExampleDB {
TABLE authors(
id INTEGER PRIMARY KEY,
name TEXT
);
TABLE books(
id INTEGER PRIMARY KEY,
author INTEGER,
title TEXT
);
}
Str[] getBooksBy(ExampleDB db, Str authorName) {
Str[] result;
WITH db {
// Query the database:
var query = SELECT books.title FROM books
JOIN authors ON authors.id == books.author
WHERE authors.name == authorName;
// Extract the result:
for (row in query) {
result.push(row.books.title);
}
}
return result;
}
|
