1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
import { sqliteRowsAsObject } from "https://esm.town/v/rwev/sqliteRowsAsObject";
import { sqlite } from "https://esm.town/v/std/sqlite";
export async function getLatestPageEntryDb() {
let latestVersion = await sqlite.execute(`select * from pages where id = (select max(id) from pages);`);
return sqliteRowsAsObject(latestVersion)[0];
}
export async function getAllPageEntriesDb() {
let allVersions = await sqlite.execute(`select * from pages order by id desc`);
return sqliteRowsAsObject(allVersions);
}
export async function savePageEntryDb(textValue) {
const insertResult = await sqlite.execute({
sql: `insert into pages (value) values (:value)`,
args: { value: textValue },
});
return insertResult.lastInsertRowid;
}