30
loading...
This website collects cookies to deliver better user experience
curl -fsSL https://deno.land/x/install/install.sh | sh -s v0.38.0
touch api.ts
import { serve } from "https://deno.land/[email protected]/http/server.ts";
import { DB } from "<https://deno.land/x/sqlite/mod.ts>";
const PORT = 8162;
const s = serve({ port: PORT });
console.log(` Listening on <http://localhost>:${PORT}/`);
for await (const req of s) {
req.respond({ body: "Hello World\\n" });
}
Deno api —allow-net
// Open a database
const db = new DB("test.db");
db.query(`
CREATE TABLE IF NOT EXISTS people (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT
)
`);
const names = ["Peter Parker", "Clark Kent", "Bruce Wayne"];
// Run a simple query
for (const name of names) {
db.query("INSERT INTO people (name) VALUES (?)", [name]);
}
// Print out data in table
for (const [name] of db.query("SELECT name FROM people")) {
console.log(name);
}
// Close connection
db.close();