< Server-Side Scripting < Key-Value Databases
routes/lesson11.js
// This program creates and displays a temperature database
// with options to insert, update, and delete records.
//
// References:
// https://en.wikibooks.org/wiki/JavaScript
// https://zellwk.com/blog/async-await-express/
// https://www.npmjs.com/package/redis
const express = require("express");
const fs = require("fs");
const handlebars = require('handlebars');
const redis = require("redis")
const router = express.Router();
// Requires a Redis installation to manage the database.
// Use of a Docker container is recommended.
// See https://en.wikiversity.org/wiki/Docker/Redis .
// If both the Node website and Redis are running in containers,
// use 172.17.0.2 for the Redis host address.
// If the Node website and/or Redis are running locally, use 127.0.0.1
// for the Redis host address.
// const HOST = "172.17.0.2";
const HOST = "127.0.0.1";
const DATABASE = 0;
// Redis client
let client = null;
router.get("/", async (request, response) => {
let result = "";
try {
client = redis.createClient({host: HOST, db: DATABASE})
let result = await getData();
}
catch(error) {
result = error;
}
let source = fs.readFileSync("./templates/lesson11.html");
let template = handlebars.compile(source.toString());
let data = {
table: result
}
result = template(data);
response.send(result);
});
router.post("/", async (request, response) => {
let result = "";
try {
client = redis.createClient({host: HOST, db: DATABASE})
let country = request.body.country.trim();
let temperature = request.body.temperature.trim();
if (!await countryExists(country)) {
await insertCountry(country, temperature)
} else if (temperature != "") {
await updateCountry(country, temperature)
} else {
await deleteCountry(country)
}
result = await getData();
}
catch(error) {
result = error;
}
let source = fs.readFileSync("./templates/lesson11.html");
let template = handlebars.compile(source.toString());
let data = {
table: result
}
result = template(data);
response.send(result);
});
async function getData() {
let result = "<table><tr><th>Country</th>";
result += "<th>Temperature</th></tr>";
let countries = await getCountries();
countries.sort();
for (i = 0; i < countries.length; i++) {
let country = countries[i];
let temperature = await getCountry(country);
result += "<tr><td>" + country + "</td>";
result += "<td>"+ temperature + "</td></tr>";
}
result += "</table>";
return result;
}
async function getCountries() {
return new Promise(function(resolve, reject) {
client.keys("*", function(err, keys) {
if (err)
reject(err);
else
resolve(keys);
});
});
}
async function getCountry(country) {
return new Promise(function(resolve, reject) {
client.get(country, function(err, key) {
if (err)
reject(err);
else
resolve(key);
});
});
}
async function countryExists(country) {
return new Promise(function(resolve, reject) {
client.exists(country, function(err, key) {
if (err)
reject(err);
else
resolve(key);
});
});
}
async function insertCountry(country, temperature) {
return new Promise(function(resolve, reject) {
client.set(country, temperature, function(err, key) {
if (err)
reject(err);
else
resolve(key);
});
});
}
async function updateCountry(country, temperature) {
return new Promise(function(resolve, reject) {
client.set(country, temperature, function(err, key) {
if (err)
reject(err);
else
resolve(key);
});
});
}
async function deleteCountry(country) {
return new Promise(function(resolve, reject) {
client.del(country, function(err, key) {
if (err)
reject(err);
else
resolve(key);
});
});
}
module.exports = router;
templates/lesson11.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Lesson 11</title>
<link rel="stylesheet" href="styles.css">
</head>
<body>
<h1>Temperature Data Entry</h1>
<p>Enter country and temperature. Enter again to update.</p>
<p>Enter country without temperature to delete.</p>
<form method="POST">
<p><label for="country">Country:</label>
<input type="text" id="country" name="country" required>
</p>
<p><label for="stop">Temperature:</label>
<input type="text" id="temperature" name="temperature">
</p>
<p><input type="submit" name="submit" value="Submit"></p>
</form>
<hr>
{{{table}}}
</body>
</html>
Try It
See Server-Side Scripting/Routes and Templates/Node.js (Express) to create a test environment.
This article is issued from Wikiversity. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.