Weekly Journal update

[acastro7]

Week 1, downloaded mysql bench and confirmed I could edit the databases

[acastro7]

Week 1, I mostly just created and edited issues on github
Issue #2 System requests an objects' attributes to System
Issue #9 Back end query methods can communication Database server
Issue #10 System requests Encrypted information from Server
Issue #11 System submits encrypted information to Server
Issue #24 User resets lab to start lab from a clean slate
Issue #30 User throws out materials into the Wastebin
Issue #32 User starts up a lab that a different user created
Issue #35 User wishes to view a different user's profile

[acastro7]

Week 2

• This week was mostly working on the uml.
• Pretty much everyone in the group got together and worked out all necessary classes.
• We then keep setting up meetings to work out minor details that were not worked out yet.

[acastro7]

Week 3

• I began working on Database Query Kotlin classes that will be how the back end interacts with the Database.

• Initial commit just showing how to fully iterate through the Result Set of the SQL database 706b499

• My commit for a bulk work on verifying user and pulling user info. It can work if they act as stand alone classes, but obviously don't want that so im working on how to make it methods 9840db7

• On this week's Saturday the team sat in a group call and discussed on how to set up Tables for the future. Josh mentioned making certain information in the database binary numbers through recommendation.

[acastro7]

Week 4

• I did not complete code wise for the Database. Just finishing code I was working last week.
• my final commit finishing the f0f070c
• Most of my work has been established a bunch of query tables: Chemicals, Steps, Experiments.
• I then also discussed with my team mates what data entries they needed out of the database so I
  could reconfigure the columns
  -I then added some generic entries so that we will be able to test the entries
  -I was not the person who joined the tables to the experiment table, that was Dennis

[acastro7]

Week 5

• Began removing the MySqlBench Server Credentials from the project. b9bb1dd
  This method simply grabs the server credentials from a text file just outside of the actual project folder

• d0aacc4 Began editing the code of other database query files to make sure they actually used the credentials outside of the project. Will need to send the text document to the team

• 942177c Terrible Misfortune, everything went wrong.

• The commit above was work on completing the issue User access his profile information  #4

• The week ended with an Intellij project folder property error (No programs were able to run), that cause to expend an extra hour just to fix.
  Luckily I was smart enough to store the NEW changes I was working on in a new branch, even though the folder was broken

• Waiting on a test on other machines before I actually re-merge with my real branch
  Broken branch #64

• Adrian has done this in the sql database, aka Created the Quarantine_Users data table

CREATE TABLE Database.Quarantine_Users (
id INT NOT NULL AUTO_INCREMENT,
firstName VARCHAR(45) NULL,
lastName VARCHAR(45) NULL,
email VARCHAR(45) NULL,
password VARCHAR(45) NULL,
organization VARCHAR(45) NULL,
PRIMARY KEY (id));

[acastro7]

Week 6

• The last push for the big milestone presentation! yay!

Oct 10

• I updated loadUser and serverCredentials. loadUser now returns a User Model Class
  serverCredentials will now load the MySQL server connection credentials. So that when we finalize the public key we can simply update this one file. 69b386a

Oct 12

• Wrote code to verify a user's Security Question, answer so we know if they are really them
  Wrote code to modify a user in the database based upon a given User Class, the query will search based on the user's email
  7f1f60d

• I fixed ModifyUser because I previously did not notice I executed the wrong code method. It should be executeUpdate instead of executeQuery. Update will provide no return value since there is nothing to return.
  c3345bd

• Created the basis for CreateExperiments so I could work on it the next day
  8f7341e

Oct 13

• finished writing the code for Create Experiment
  0db79f0

• Updated my Database Test cases File since there were changes made to them
  fc6019d

[acastro7]

Week 7

• Created code for deleting experiments along with all data in the Steps, Experiments, Equipments, and Chemicals tables that have the experiment Id. Was most done editing the MySQL Workbench properties like so.

ALTER TABLE Database.Equipments
DROP FOREIGN KEY Equipments_ibfk_1;
ALTER TABLE Database.Equipments
ADD CONSTRAINT Equipments_ibfk_1
FOREIGN KEY (experiment_ID)
REFERENCES Database.Experiments (ExperimentsID)
ON DELETE CASCADE;

• Created methods for quarantine users. Such as creating a quarantine user, deleting one (for when we don't want the user at all), loading the profile data of quarantine user, and Transfering a quarantine user to the A

• 2e60d9f

[acastro7]

Week 8

• Created code for Modify Experiment and Find My experiments
  f13541a

• Finished code for Find my experiments
  2173854

• This is me checking if prepared statements do work. So far they do seem to work. Got to SQL Inject my own database, pretty cool.
  12b8768

• Then I went to work on ensuring the new changes to the database was correct. It seemed like the new additions were added correctly except Experiments_Equation so I had to alter columns and change the table name. Not much else

[acastro7]

Week 10

• Mostly did work on the database schema

• Added method that will recreate the database if it is deleted
  ed56336

• Added in the Admin users table to the database

[acastro7]

Week 11

• Created data schema model for MySQL workbench databases

• Accidently delete all of it

• Recreate everything

DBModel.zip

• Create all of the methods needed for accessing the admin user class in database

• Additionally I created a profile html page for the admin

c27631b

• Minor fixes (like changing comment lines) to the admin database methods
  d35182b

• Started researching "website creation" websites to take the css code i generate from using their websites

• Wix.com creates an .xml file when trying to export the website created, does not seem usable

• Squarespace.com when exporting the website created, it transforms it into a wordpress file type

• Need to try Wordpress.com