book-tracker's Introduction

Book Collection App

The purpose of this app is to track and store a record of books you have read.

Use the main books page to view all of your books, add new books to your collection, delete books from your collection, and mark and unmark favorites.
Use the genres page to add and manage genres.
Use the favorites page to view all of your favorites. You can also unmark favorites or delete books from your collection here.

Get Set Up

Use the following commands to set up your database for the app:

create database

CREATE DATABASE "book_collection";

create "genres" table

CREATE TABLE "genres" (
	"id" SERIAL PRIMARY KEY,
	"genre_name" VARCHAR(150) UNIQUE NOT NULL
);

create "books" table referencing "genre" table

	"id" SERIAL PRIMARY KEY,
	"title" VARCHAR(250),
	"author" VARCHAR(150),
	"image_url" TEXT,
	"publication_date" INT DEFAULT 2018,
	"number_of_pages" INT DEFAULT 1,
	"favorite" BOOLEAN DEFAULT FALSE,
	"genre_id" INT REFERENCES "genres"
);

Need some dummy data to get started?

Add this to your database:

("genre_name")
VALUES ('fiction'), ('mystery'), ('history'), ('biography');

INSERT INTO "books" ("title", "author", "genre_id", "image_url")
VALUES
('Harry Potter and the Order of the Phoenix', 'J.K. Rowling', 1, 'https://images-na.ssl-images-amazon.com/images/I/51lFAzVQUxL._SX342_BO1,204,203,200_.jpg'),
('The Boys in the Boat', 'Daniel James Brown', 3, 'http://www.danieljamesbrown.com/images/TheBoysintheBoat.png'),
('The Secret Place', 'Tana French', 2, 'https://images.gr-assets.com/books/1396671263l/20821043.jpg');

Recommend Projects