Vote Database Queries

README.md

Overview

For Voting App

Need MySQL queries for the following:

1. Statement: create voter. Register a unique username of reasonable lengths (3-64 characters, such as "tonypujals" and password to be able to vote. Password field will store bcrypt-encrypted strings, specifically:

• CHAR(60)
• CHARACTER SET latin1
• COLLATE latin1_bin

2. Query: fetch encrypted password for voter username. Will be used to compare encrypted strings for login.

3. Statement: create a poll. A poll is a unique name, such as "cats_vs_dogs" and identifies the names of the available choices to vote for (eg, "cats", "dogs"). The choices should have a simple incrementing unique ID (1, 2, 3, etc.)

4. Statement: cast ballot. A ballot has a voter, a poll, and vote.

5. Query: fetch voter's vote for a particular poll (ex: "cats").

6. Query: fetch vote results for a particular poll (ex: cats: 5, dogs: 3)

Run on Aurora.

1. Create a bridge network to use for communication between a MySQL CLI and database.

    $ docker network create --driver bridge sqlnet

2. Start a MySQL database container.

    $ docker run -d --name mysql --network sqlnet -e MYSQL_ROOT_PASSWORD=secret mysql:latest

3. Start a MySQL command-line client.

    $ docker run -it --rm --name mysqlcli --network sqlnet mysql:latest sh -c 'exec mysql -h mysql -uroot -p'
    Enter password: _