nicolewallace09/u-develop-it

Application using MySQL that will hold databases about employee information

U-Develop-It

Description

A SQLite command-line voting application that will preform CRUD operations on data about candidates, parties, and votes using Express.js routes and SQLite schemas.

Table of Contents

• Installation
• Usage
• License
• Contributing
• Tests
• Questions

Installation

The user should clone the repository from GitHub. This application requires Node.js, Express, and mysqlite3. To view database from MySQL run mysqlite3 db/election.db.

Usage

This application is for users to create an election.db in mySQL so that users have access to candidate, party, and vote data.

License

This project is license under MIT

Contributing

Contributors should read the installation section.

Tests

There are tests for input validation, to view tests run npm test.

Questions

If you have any questions about this projects, please contact me directly at [email protected]. You can view more of my projects at https://github.com/nicolewallace09.

u-develop-it's Issues

Create a database that contains the candidates table

User Story

• As a user, I can request a list of all potential candidates.

• As a user, I can request a single candidate's information.

• As a user, I want to delete a candidate.

• As a user, I want to create a candidate.

Create the parties table

User Story

• As a user, I can update a candidate's party affiliation.

• As a user, I can request a single candidate's information including party affiliation.

• As a user, I can request a list of all the parties.

• As a user, I can request a single party's information.

• As a user, I can delete a party.

• As a user, I can request a single candidate's information.

• As a user, I want to delete a candidate.

• As a user, I want to create a candidate.

Create the voters table

User Story

• As a user, I can request a list of voters alphabetized by last name.

• As a user, I can request a single voter's information.

• As a user, I can create a voter.

• As a user, I can update a voter's email.

• As a user, I can delete a voter.

Create the votes table

User Story

• As a user, I can tabulate all the votes cast by candidate ID in descending order.

• As a user, I can cast a vote for a candidate.