Skip to content

Latest commit

 

History

History
70 lines (52 loc) · 2.3 KB

readme.md

File metadata and controls

70 lines (52 loc) · 2.3 KB
Raw

Sample full-stack web

This is the sample full-stack web site that we worked on during the meetup on June 20th, 2016

Requirements

Before you can run this project, you need the following:

  • Nodejs - If you are using Mac, I recommend installing nodejs via nvm.
  • MySQL with phpMyAdmin (or some other visual tool for administrating your MySQL database). If you are using Windows or Mac, I recommend installing XAMPP. It includes both MySQL server and phpMyAdmin.
  • Git

Goals

Create simple web page to display data from a database

  • The nodejs app does the following:
    • Connects to database (knexjs)
    • Gets data from database table (knexjs)
    • Renders the data in an HTML template (handlebars)
    • Starts a web server (express) to connect everything together

Getting Started

Using phpMyAdmin (or some other MySQL admin tool):

  • Create a database named learn_web_app
  • Create a table in the database named books with the following structure:
CREATE TABLE IF NOT EXISTS `books` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB ;
  • Add a user to the learn_web_app database with the same name. Sample SQL statement to do this:
CREATE USER 'learn_web_app'@'localhost' IDENTIFIED BY  'password';

GRANT USAGE ON * . * TO  'learn_web_app'@'localhost' IDENTIFIED BY  'password' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

GRANT ALL PRIVILEGES ON  `learn_web_app` . * TO  'learn_web_app'@'localhost';
  • Insert some data into the books table

Clone this repository to your local environment by using the following command from a terminal window:

git clone https://github.com/Learn-by-doing/full-stack-web-sample.git

Change into the directory that was just created:

cd full-stack-web-sample

Install node modules:

npm install

Run the web server:

node index.js

Open your browser and navigate to the following URL: localhost:3000/books

You should see a list of the books from your database.