This repository is being developed by Ethan Toney for use by the Computer Science department at the University of Kentucky. Only students of Ethan Toney's Fall 2019 CS498 course have permission to download and edit this repository for the purpose of accomplishing the final project.
PostgreSQL - This is the database implementation.
Express - This is an api that handles hosting a website on a specific port and handling requests made to that website.
Objection - This is an orm (object relational mapper) api. It allows you to make database queries without having to write any mysql. I'm primary using it to resolve relations between tables since the equivalent mysql would be very difficult to manage.
Knex - This is a database migration tool. It will create database schemas and populate the tables with seed data.
Mustache - This is a logic-less templating engine for html. Basically just allows you to inject the value of a variable into html.
Mocha - This is the testing library used for this project.
Chai - This is the assertion library used for this project. This is the library you will be using to make assertions in your test cases.
src/main/views - folder containing html templates
src/main/routes - folder containing express api handlers
src/main/common - folder containing common functions used throughout the app
src/main/lib - folder containing libraries of functions used by api handler
src/main/models - folder containing Objection JS object models
src/main/migrations - folder containing database migrations
If you have a package manager on your machine I recommend using it to install npm.
Otherwise download and run the npm installer from https://nodejs.org/en/download/ (This repo has only been manually tested with version 10.16.3 LTS on Mac and Windows)
Make sure to add NPM to your PATH variable if you are on windows! The installer will do this by default as long as you don't disable the option.
Once installed run npm install from the command line in the root directory of the project. This will install all required npm packages.
If you have a package manager on your machine I recommend using it to install psql.
Otherwise, download and run the PostgreSQL installer from https://www.postgresql.org/download/
Once installed create the following database schemas abet_system_dev and abet_system_test, CREATE DATABASE abet_system_dev; CREATE DATABASE abet_system_test;.
Then open up the knexfile.js file located in the root of this project and add in your database connection information. Here is an example of what that modification could look like.
connection: {
database: 'abet_system_dev',
user: 'postgres',
password: 'password'
}
Then run npm run setup_db. This will run all database migrations and seed both the test and dev servers.
npm run test
npm run start
npm run debug
npm run migrate - run migrations on dev
npm run migrate:test - run migrations on test
npm run seed - seeds dev database
npm run seed:test - seeds test database
npm run setup_db
npm run scratch
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent