Weekly Journal - Chris

[cdavis17]

Week of 9/22

This week I was able to implement the model classes that we are going to need for the User and for Photo. The user model class is completed, as well as the photo class. One last class I started on, but still need to complete is the HashTag model class. That will be my goal for the upcoming week, as well as working on implementing the fake database. Tom and Anthony have been working on the UI, which will be mainly for initial test purposes.

Address for commit of User and Photo Model Class https://github.com/Thon9/CS481_SeniorDesignProject/commit/4dcafbca1af45642e374b9c2289954a50da0df92

Address for commit with HashTag class, updated Model and User class to store HashTag IDS https://github.com/Thon9/CS481_SeniorDesignProject/commit/4784c9f7446783643d6591c0c96f4d006fd05536

[cdavis17]

09/15 Over the previous week, I have been looking into more articles pertaining to the DynamoDB from Amazon and trying to gain some insight as to what would be the best database option. I stumbled across the tumblr page for instagram http://instagram-engineering.tumblr.com which has a ton of extremely useful information from the developing of their android app, to how their website is hosted and which data base service they use. http://instagram-engineering.tumblr.com/post/13649370142/what-powers-instagram-hundreds-of-instances-dozens-of On top of the research, we always worked on our UML diagram and finished that up for the upcoming week, and are now ready to get started on the coding, which we will have about 2 weeks to implement a minimal working system.

[cdavis17]

Week of 9/29

We were able to get a good deal of work accomplished this week. Currently we have a basic UI just to log in. We are having issues with the servlets and the controllers being in sync, which we will be able to iron out this week. We also finished implementing the model classes, as well as implementing the fake database which we will be using at the beginning of the project. In the upcoming week, we need to work on our UI, as well as starting to handle a user's uploading of photos.

FakeDatabase and IDatabase implementation https://github.com/Thon9/CS481_SeniorDesignProject/commit/83309a5bd7861c6ece3a82f6228fdfcb636a3e82

[cdavis17]

Week of 10/12

In the past two weeks we have ran into some big issues that slowed us down, The first being the the inability for Tomcat to see some of our projects we needed for our database. We were able to resolve this issue by creating JAR files and placing them in the Web portion of our project. The next issue was a null pointer exception stemming from our database not being initialized. With the help of Dr. Hovemeyer, we created a DatabaseInitListner class that makes sure the database is loaded when the WebApp is. We are now able to create users, as well as log in with our test user from the database. Our next step in the project is to be able to store images that a user selects in the database.

Adding of a generic upload box for main view 56e01efff83fcbe6453985251f128f2faad1cbf7

[cdavis17]

Week of 10/19

After finally being able to log in to existing accounts and create new accounts, we are now in need of a database so that accounts can be created and used at anytime, not just per session like with the fakeDatabase. We have decided to use a SQL database, and over the past week I've been working on implementing that. It is nearly done, I just need to implement the methods from the Database class and double check for any bugs.

Addition of DBUtil class, more methods in SQLDatabase class https://github.com/Thon9/CS481_SeniorDesignProject/commit/675c1192472356f9840917cd9ead13093c0d5609

More methods to implement the Database, IDatabase methods added to be implemented https://github.com/Thon9/CS481_SeniorDesignProject/commit/9d14dd62dd618978456fd3cc3f54360a50ca9006

[cdavis17]

Week of 10/26

My main focus this week was to work on the database, so that it will be ready to go for our 50% working system. I started implementing the Database methods this week so we are able to handle our basic website functions. I have also downloaded mySQL and created our Database and tables for Users, Photos, and Hashtags through the command line.

Editing of SQL Database class ce2b0ca72169ee713ae466a95ae9c0338f1753e9

[cdavis17]

Week of 11/3

This week I finished updating the SQLDatabase and it now supports things such as create user, add photo, login, etc. Adding a photo as a blob into the database still creates some issues which I am working on. I also have installed WAMP onto my computer. There were multiple issues we destroyed this week, and definitely was one of the most productive weeks so far.

Commit containing massive changes 8d3c492ceb0209336b1b380df155692f3118c315

[cdavis17]

Week of 11/17

This week our main thing was to be able to retrieve photos from the SQL database, which unfortunately we were not able to do. Some of the other things we did get done was the implementation of deleting an account and importing more data into the database. We now have more photos and have hashtag IDs associated with them so we can search for photos that are associated with the hashtags the user is following.

[cdavis17]

Week of 11/24

After putting in a lot of work this week, we were able to make great strides towards completing our project. We were finally able to be able to search for images using a hashtag, which still looks a little bare because our database only contains a few images. We are almost to the point where we can upload photos and assign hashtags to them, which will allow us to create a much more detailed database for viewing purposes.

GetPhotoByHashtagString - helps return photos containing hashtag user searches for b3fb2c92c8a4359c4a953d40aa752938769f1805

Working Searching of Photos - updates to MYSQL for JOIN statements 08c46458c8ca440ebacb2d7c88aa9160754c7b3f

[cdavis17]

Week of 12/1

We were able to make a significant amount of progress towards finishing our project over the past week. This week, I added the checking if a hashtag exists, so we do not add duplicates to the table. I also added code to delete a hashtag from a photo, and various other changes

// Checks existance of hashtag in database, if it exists, returns that ID, else returns 0 to create a new hashtag df6a6872210160c9a3b8196d3d6d95ae02f26b6f

// Deletes a photo from a hashtag if user chooses to do that 8e4eacb5fdb26991bacecae71b33086bff33c332