CRUD baseado no exemplo da @glaucia86

Overview

NodeJS API by Francisco-gui

This is Node.js + Express rest API with a Relational Database in PostgreSQL. Front-end builded in Vue.js + Boostrap 4.

--> How to run the API

  1. clone repository and go to project folder
git clone https://github.com/Francisco-gui/employee-crud.git
cd employee-crud
cd employee-api
  1. Create a new database and a .env PostgreSQL connection string:
Schema:
  CREATE TABLE employee (
    employee_id uuid PRIMARY KEY NOT NULL DEFAULT uuid_generate_v4(),
    name VARCHAR(255) NOT NULL,
    job_role VARCHAR(255) NOT NULL,
    salary NUMERIC(12,2) NOT NULL,
    birth DATE NOT NULL,
    employee_registration INTEGER NOT NULL
  )

PostGreSQL connection string:
  DATABASE_URL=postgres://YourUserName:YourPassword@YourHostname:5432/YourDatabaseName
  1. run the development server:
npm run dev

You can use insomnia to test all endpoints

# ROUTES
GET      /employees
POST     /employees
GET      /employees/:id
PUT      /employees/:id
DELETE   /employees/:id

--> How to build Front-end

  1. go to project folder
cd employee-crud
cd front-vue2
  1. Run the command:
npm run serve
  1. on PORT localhost:8080 you can acess the employees list and create a new employee registration image image
You might also like...

Awesome books is a vanilla Javascript which offers CRUD functionalities allowing you to add, remove edit boks info and store it to the local storage.

Awesome books is a vanilla Javascript which offers CRUD functionalities allowing you to add, remove edit boks info and store it to the local storage.

Awesome Books Awesome books is a simple project that displays new books when a user updates them. Built With HTML-5 CSS3 Javacript Linters Live Demo L

Aug 6, 2022

A CRUD implementation using sequelize, mySQL, NODEJS, Express, JWT and other technologies.

A CRUD implementation using sequelize, mySQL, NODEJS, Express, JWT and other technologies.

A ideia do projeto é simular o funcionamento do backend de um blog através da implementação de uma aplicação em Node.js usando o pacote sequelize para

May 11, 2022

Simple "everyday CRUD" Postgres queries with perfect TypeScript types

Crudely Typed Simple "everyday CRUD" Postgres queries with perfect TypeScript types. Zero dependencies. Designed to work with pg-to-ts and node-postgr

Dec 26, 2022

A CRUD made with NodeJS. It's a book directory where you can see the books, add new ones, update them, or even delete .

BOOK-DIRECTORY-NODEJS A CRUD made with NodeJS. It's a book directory where you can see the books, add new ones, update them, or even delete . What I u

May 18, 2022

A CRUD made with NodeJS. It's a book directory where you can see the books, add new ones, update them, or even delete .

Book-Directory-NodeJS A CRUD made with NodeJS. It's a book directory where you can see the books, add new ones, update them, or even delete . What I u

May 13, 2022

📋 Todo List CRUD and OAuth with Firebase

📋 Todo List CRUD and OAuth with Firebase

Todo List CRUD and OAuth with Firebase Esta es una app hecha con React y Firebase en la que puedas crear, leer, actualizar y borrar tareas dentro de u

May 28, 2022

A simplified list crud that adds, removes and edits items

To-do list This project is as simplified todo list crud. Built With HTML CSS JavaScript Webpack Live version See live version Getting Started To get a

Apr 2, 2022

Aplicação Angular CRUD para uso e prática do Firebase com Authentication, Firestore e Storage

DiariosApp This project was generated with Angular CLI version 13.3.3. Development server Run ng serve for a dev server. Navigate to http://localhost:

Jun 3, 2022

Crud with GraphQL + Express + Json Server

How to run the project ### Install dependecies $ yarn install ### Run GraphQL server $ yarn dev ### Run Json Server $ yarn run json:server ### The

Jun 22, 2022
Owner
Francisco Guilherme
Web Developer, Bachelor of Science and Tecnology at Federal University of Rio Grande do Norte(UFRN).
Francisco Guilherme
Projeto de exemplo para realização de testes de integração (API) utilizando o Cypress

Projeto de exemplo para realização de testes de integração (API) utilizando o Cypress

Robson Agapito Correa 14 Nov 28, 2022
Projeto desenvolvido no ignite - Baseado em DT Money

Projeto My Wallet - Baseado no Dt Money Projeto prático na trilha de React - Ignite Sobre Instalação Sobre Aplicação abrangendo diversos conceitos e f

Maurício L S Filho 3 Mar 15, 2022
Efeito de ripples baseado no Material Design.

Efeito de ripples baseado no Material Design feito com CSS, JavaScript e jQuery Esse efeito utiliza seletores do jQuery e manipulação do DOM para obte

Gabriel Figueredo 10 Nov 24, 2022
Example CRUD API for API Fest'22. See Pull Requests for chapter 2 and 3

Example CRUD API for API Fest'22. See Pull Requests for chapter 2 and 3

Postman Student Program 6 Mar 2, 2022
Full-Stack CRUD Application With Angular + Firebase Database + Authentication + REST APIs

BookCompany Full-Stack CRUD Application With Angular + Firebase Database + Authentication + REST APIs Technologies & Features Angular front-end framew

Rodrigo Bravo 3 Apr 10, 2022
API REST de código aberto para testes frontend aplicando CRUD.

OPEN CRUD API API pública para cadastro de usuários para ser usada em testes. Ajustes e melhorias O projeto ainda está em desenvolvimento e as próxima

Pedro Henrique 5 Mar 22, 2022
Breve explicacion de Mongoose, asi como un codigo con las operaciones CRUD

Introduccion a Mongoose ¿Qué es MongoDB? MongoDB es una base de datos NoSQL (Not Only SQL) y por ende no relacional que es utilizado para proyectos we

Jair León 9 Mar 17, 2022
To do list is a simple CRUD application that allows you to add, delete, update tasks that you are supposed to do. It is built with HTML, CSS and JavaScript

to do List To do list is a simple CRUD application that allows you to add, delete, update tasks that you are supposed to do. Built With HTML-5 CSS3 Ja

Lynette Acholah 11 Jun 7, 2022
To do list is a simple CRUD application that allows you to add, delete, update tasks that you are supposed to do.

to do List To do list is a simple CRUD application that allows you to add, delete, update tasks that you are supposed to do. Built With HTML-5 CSS3 Ja

Nemwel Boniface 21 Jun 23, 2022