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.
- 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)
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,);
- Github: Peter Njenga
- Twitter handle: [https://twitter.com/Hanselpeter4]
- LinkedIn: [www.linkedin.com/in/peter-njenga]
- Java
- Spark
- Postman
- Psql
- Intellij
You can contact me through my email[[email protected]]
Copyright (c) 2022 click here to view license