han254 / news-portal

A rest REST API for querying and retrieving scoped news and information that are available to all employees without navigating into any department, and others that are housed/classified within departments.

News-Portal

By Peter Njenga

Description

A rest API for querying and retrieving scoped news and information that are available to all employees without navigating into any department, and others that are housed/classified within departments.

Setup/Installation Requirements

• Open Terminal {Ctrl+Alt+T}
• clone https://github.com/han254/News-Portal.git.
• Enter into the folder (cd News-Portal).
• open your IDE (e.g IntelliJ IDEA)

SQL Installation/ Setup.

1.Launch postgres

2.Type in psql

Run these commands

CREATE DATABASE news_portal;

CREATE TABLE IF NOT EXISTS department( id int PRIMARY KEY auto_increment, departmentname VARCHAR, description VARCHAR,numberOfEmployees int);

CREATE TABLE IF NOT EXISTS users(id int PRIMARY KEY auto_increment,name VARCHAR,position VARCHAR,role VARCHAR,departmentId VARCHAR,email VARCHAR);

CREATE TABLE IF NOT EXISTS news (id int PRIMARY KEY auto_increment,title VARCHAR,content VARCHAR,departmentname VARCHAR,);

Author's Information

• Github: Peter Njenga
• Twitter handle: [https://twitter.com/Hanselpeter4]
• LinkedIn: [www.linkedin.com/in/peter-njenga]

Technologies Used

• Java
• Spark
• Postman
• Psql
• Intellij

Support and contact details

You can contact me through my email[[email protected]]

License

Copyright (c) 2022 click here to view license