Weekly Update

[jstambaugh]

Week 1:

• Setup database using AWS RDS and got the database to connect to MySQL Workbench.
• Created tables in the Database for Users and included such data as first name, last name, username, etc.

[jstambaugh]

Weekly Update:

Created new columns in the User table for the database.

Columns added were for the security questions and their answers to be stored along with the users profile in the Users table in the database.

Currently working on getting some code together to connect the database to our project so I can make some queries for getting user profiles setup.

[jstambaugh]

Updated the security questions field to include more questions for the user to select from.

Created a signup user database Kotlin file to have the queries to actually set up a profile in Kotlin.

This will send the query from the method and create a new user profile in the database.

[jstambaugh]

Weekly Update:

Made a Kotlin file to connect to the database and insert user signup information into the database.

Created a test file that will take user information and test the SignUp function to make sure it inserts the data properly into the database

Made a css file to make the signup page more appealing to the user.

[jstambaugh]

Weekly Update:

-Created several database query files for the front end to use when needing to grab information from the database.

-Created DeleteUser for when either the student is no longer in the class, or wishes to delete their account.

-Created UserProfile which stores all user information into array so the front end can grab whatever information on the user they need from that array to display to the page.

-Updated verifyUser to make sure that it works and can actually verify that users email and password is in the database.

-Discussed with front end on converting some functions to Classes such as User class so that the information can be sent to front end easier.

Issues:
#4
#8
#23

[jstambaugh]

Weekly Update:

Finished loadExperiment which was large file to pull all the information across different tables in the database.

Also made updates to code to convert them to boolean so we can verify if they work when the query runs.

fbffc0d
8f33180
1b17136

[jstambaugh]

• Created some code that will use php to send a verification email link so the user can be moved from quarantine users to users table in the database.

bb91596
01617d3

[jstambaugh]

• Started creating Search bar on main page for users to search for experiments.

• Created search query to grab title of experiment from database using the like clause so if looking for iodine clock and they search 'io cloc' it still grabs it.

• Created post mapping for backend to handle the search bar

• Have search bar linked to search page where I will display the search results dependent on their search input.

-Created Javascript classes for Graduated Cylinder and Erlenmeyer flask as well as pictures for them and their respected functions

Commits:
976b451 -Search Query
5709d44 -Search Bar and Search Page creation
1915efb

32db61d
b4e8fee
862b495 - All of these are for the javascript object classes
1a7db1a

[jstambaugh]

• Got the search bar working more so that when you search it will list the title, creator name and have a button to load the experiment.

• Got the the javascript to write out divs and each element based on how many search results there are.

• Need to get the load button to work properly with the creation through javascript.

• Only had it available with single search results, need it working with multiple.

Commits:

1a05664

a3961ca

60d5025

[jstambaugh]

Finally finished the search bar. Fully functional, with included CSS and Javascript features to allow for the button to load the simulation, show the title, creator name, and yes. The back button does work. ;)

2150067
a38b07d