danielkwood’s gists

danielkwood / Students.sql

Created June 29, 2025 02:53

SQL code: Create Students table and insert sample data.

	-- Create the Students table
	CREATE TABLE Students (
	StudentID INT PRIMARY KEY,
	FirstName VARCHAR(50),
	LastName VARCHAR(50),
	YearLevel INT,
	AverageScore INT
	);

	-- Insert sample data into Students table

danielkwood / index.js

Last active June 17, 2025 02:41

Currency API example

	// You will need a free API key at https://app.exchangerate-api.com/

	const express = require('express');
	var path = require('path');
	const bodyParser = require('body-parser');
	const request = require('request');

	const app = express();
	app.set('views', path.join(__dirname, 'views'));
	app.set('view engine', 'ejs');

danielkwood / index.js

Last active May 27, 2025 04:57

Updated index.js code with /add routes

	const express = require('express');
	const sqlite3 = require('sqlite3').verbose();
	const path = require('path');

	const app = express();

	app.set('views', path.join(__dirname, 'views'));
	app.set('view engine', 'ejs');
	app.use(express.static('public'));
	app.use(express.urlencoded({ extended: true}));

danielkwood / add.ejs

Created May 27, 2025 04:41

Template for the Add page

	<html>
	<head>
	<title>My Movies</title>
	<link rel="stylesheet" type="text/css" href="/css/style.css">
	<link href="https://fonts.googleapis.com/css?family=Open+Sans:300" rel="stylesheet" type="text/css">
	</head>

	<body>
	<div class="container">
	<h1>Add a new movie</h1>

danielkwood / movie.ejs

Created May 27, 2025 04:36

Template for the Movie page

	<html>
	<head>
	<title>My Movies</title>
	<link rel="stylesheet" type="text/css" href="/css/style.css">
	<link href="https://fonts.googleapis.com/css?family=Open+Sans:300" rel="stylesheet" type="text/css">
	</head>

	<body>
	<div class="container">
	<h1><%= title %></h1>

danielkwood / index.js

Created May 27, 2025 04:33

Updated code for displaying individual movies

	const express = require('express');
	const sqlite3 = require('sqlite3').verbose();
	const path = require('path');

	const app = express();

	app.set('views', path.join(__dirname, 'views'));
	app.set('view engine', 'ejs');
	app.use(express.static('public'));

danielkwood / index.ejs

Created May 27, 2025 03:35

Home page for movies app (HTML template code)

	<html>
	<head>
	<title>My Movies</title>
	<link rel="stylesheet" type="text/css" href="/css/style.css">
	<link href="https://fonts.googleapis.com/css?family=Open+Sans:300" rel="stylesheet" type="text/css">
	</head>

	<body>
	<div class="container">
	<h1>My Movies</h1>

danielkwood / index.js

Created May 27, 2025 03:30

Home page for movies app

	const express = require('express');
	const sqlite3 = require('sqlite3').verbose();
	const path = require('path');

	const app = express();

	app.set('views', path.join(__dirname, 'views'));
	app.set('view engine', 'ejs');
	app.use(express.static('public'));

danielkwood / index.js

Created May 27, 2025 02:51

How to insert and select records from an SQLite database

	const express = require('express');
	const sqlite3 = require('sqlite3').verbose();
	const path = require('path');

	const app = express();

	app.set('views', path.join(__dirname, 'views'));
	app.set('view engine', 'ejs');
	app.use(express.static('public'));

danielkwood / index.js

Created May 27, 2025 01:47

Add records to an SQLite database

	const express = require('express');
	const sqlite3 = require('sqlite3').verbose();
	const path = require('path');

	const app = express();

	app.set('views', path.join(__dirname, 'views'));
	app.set('view engine', 'ejs');
	app.use(express.static('public'));