Employeteer

Manage your workforce databases like a puppet master.

ABOUT THE PROJECT

Overview

Be the masterhand of your employees databases.

Welcome to Employeteer, the ultimate Node.js application designed to simplify the management of employee databases without the need for any SQL expertise. With Employeteer, you can effortlessly oversee your workforce data with an intuitive, user-friendly interface that puts you in full control.

Find the repo here.
Watch our tutorial here.

Table of Contents

• License
• Resources
• Get Started
• Usage
• Demos
• Testing
• Contribute
• Credits

(Back to the Top)

Resources

• For JavaScript
  • ES6 modules.
  • Promises.
  • Extensive object and array destructuring.
  • Polymorphism for methods.
  • Classes and constructors.
  • Extended classes.
  • static methods.
  • async and await executions.
  • try & catch executions.
  • Structured error handling to prevent unexpected crashes.
  • console.table() to display SQL tables.
• For Node.js
  • NPM packages
    • Inquirer
    • PG
    • Dotenv
    • Chalk
    • Figlet
    • Nanospinner
  • process.env variables.
  • process.exit() to end the program.
• For SQL
  • CREATE
  • SELECT
  • UPDATE
  • DELETE
  • AS for column and table aliases
  • JOIN LEFT, INTO, RIGHT, etc. to join even to the same table.
  • INSERT INTO
  • FROM, ON & WHERE
  • sum() & count()
  • GROUP BY & ORDER BY

(Back to the Top)

Get Started

Watch our tutorial here.

Once you have the repo on your computer after running git clone, open your command line. Make sure to open the Logo Smith repo folder in your terminal. Use npm i to install all the modules needed to run Employeteer.

First clone:

$ git clone https://github.com/Rod-Freedom/C12-Employeteer.git

Then install the modules:

$ npm i

IMPORTANT | You need to have PostgreSQL installed in your computer to run Employeteer!

(Back to the Top)

Usage

Watch our tutorial here.

Employeteer is easy and intuitive to use. To run it, open the Employeteer folder in your terminal, then type node index.js or npm start and hit enter.

$ npm start

The first time you run Employeteer, you'll have to provide you PostgreSQL username and password. The tables and database will be created and seeded automatically, no need to run any command in your PostgreSQL.

Welcome! You need to set your user first.
? Whats your PostgreSQL username? user
? Type your PostgreSQL password **********
? Please confirm your password **********
Wait a sec, Employeteer is doing its magic!
✔ Creating your database...
✔ Creating tables...
All set! Please rerun Employeteer!

After that, run npm start again, and you're ready to start puppeteering your databases!

$ npm start

The main menu is as easy as walking; select what you want to do and answer any question the Employeteer asks.

You can view all employees, also by department and manager.

Adding, editing, and deleting are all options at your disposal. Enjoy Employeteer!

(Back to the Top)

License

See the license for more details.

(Back to the Top)

Contribute

If you have suggestions or want to help with some improvements, you can write me by email.

(Back to the Top)

Credits

All the code was created from scratch by Rod's Freedom.

(Back to the Top)