1
edit
Changes
→Week of November 4, 2013
{{BBB Log Index | 20132}}
=Logs for 20132Bo Li=[http://kelan-metakelanli.blogspotwordpress.cacom/ Blog]
Please add the daily logs (Latest week at the top of the page)
=Week of November 11, 2013=
* Installing BBB server on Ubuntu 10.0.4
* Changes to view_event and view_event_schedule page
* Add confirmation messages when deleting
=Week of November 4, 2013=
* create view_events.jsp, list all events in a table format
* Create delete_evetn.jsp, delete a schedule
* testing various parts of the website
=Week of October 28, 2013=
* There were errors with the mysql SP I wrote last term, had to fix them, small problems, but took a while to find
* Create view_event_schedule (combine view_m_schedule and view_l_schedule)
* various bug fixes edit_event_schedule
=Week of October 21, 2013=
* Create edit_lecture.jsp page
* Create edit_meeting.jsp page
* Create view_m_schedule.jsp page
* Create view_l_schedule.jsp page
* Edit view_event page for more better user experience
=Week of October 14, 2013=
* Create add_mpresentation.jsp page
* Create add_lpresentation.jsp page
* Create edit_event.jsp page
* Finish view_event.jsp page
=Week of October 7, 2013=
* Finished department_users.jsp page
* Create all the add users page: add_attendee.jsp add_student.jsp add_lguest.jsp add_mguest.jsp
=Week of September 23, 2013=
* create view_event.jsp
* add page validations
* create more SQL query methods
=Week of September 16, 2013=
* Division of Labour: responsible for department.jsp for now
* Work on department.jsp, list department depend on user access level
* Add create_department.jsp
* Add modify_department.jsp
=Week of September 9, 2013=
* Discussion with Chad about what need to done for the integration site
* Organize Git repo (resolve merge conflicts, pull requests)
* Learning JSP
* Continue learning JQuery
=Week of September 2, 2013=
* This semester I'll only be in CDOT a few days a week, therefore I feel I should just use a weekly list format instead of daily format
* Discussion about new semester work
* Move to a new desk
* Start learning JQuery
=Week of August 26, 2013=
{| class="wikitable" border="1" cellpadding="5"
|-
! Week Day !! Today's work !! Blog URL(optional)
|-
| Sunday || ||
|-
| Monday ||
* Testing, checking, then unloading every SQL methods I've done
* The preliminary data layer stage is finished
||
|-
| Tuesday ||
*
||
|-
| Wednesday ||
* Planning the store procedures I'll write to create schedule based on weekly or monthly schedule
||
|-
| Thursday ||
* Finish the week schedule store procedure
* store procedure allows user to create schedule on any day(s) of the week until a number session,<br /> a number of week or an end date is reached
||
|-
| Friday ||
* Finish the more complex monthly schedule, I did what I could under the time constraint, hope this is enough
* Linking java methods to the store procedures
* That's it for me this term. Whether I'm going to back or not, I just want to say thanks for the opportunity, Fardad.
||
|-
| Saturday || ||
|}
=Week of August 19, 2013=
{| class="wikitable" border="1" cellpadding="5"
|-
! Week Day !! Today's work !! Blog URL(optional)
|-
| Sunday || ||
|-
| Monday ||
* Finish Lecture.java
||
|-
| Tuesday ||
* Start Section.java
||
|-
| Wednesday ||
*
||
|-
| Thursday ||
* Create delete meeting/section Store Procedure
||
|-
| Friday ||
* Finish section.java
||
|-
| Saturday || ||
|}
=Week of August 12, 2013=
{| class="wikitable" border="1" cellpadding="5"
|-
! Week Day !! Today's work !! Blog URL(optional)
|-
| Sunday || ||
|-
| Monday ||
* Construct Power Point Presentation for tomorrow
||
|-
| Tuesday ||
* Presentation on Database Layer
||
[https://docs.google.com/file/d/0BzmbZEbktaFMRFBzb1M4Y0dJRHM/edit Presentation]
|-
| Wednesday ||
* Home, studying for Exam
||
|-
| Thursday ||
* Add Lecture.java method
* Add remove methods to Meeting.java
||
|-
| Friday || ||
|-
| Saturday || ||
|}
=Week of August 5, 2013=
{| class="wikitable" border="1" cellpadding="5"
|-
! Week Day !! Today's work !! Blog URL(optional)
|-
| Sunday || ||
|-
| Monday ||
* Holiday
||
|-
| Tuesday ||
* Implement Store Procedures with Java methods, testing
||
|-
| Wednesday ||
* Database, Store Procedure all need to change to accommodate new flexible schedule (each day of the week can be individual selected).
* Analyzing possible ways to implement this
||
|-
| Thursday ||
* Default user/meeting/section setting methods<br />
* Getting rid of cascade delete from mysql script<br />
* Complete meeting sql methods <br />
* Change sql.java from interface to base class
||
|-
| Friday ||
* Help Rob with a couple of bugs<br />
* Discussion<br />
||
|-
| Saturday || ||
|}
=Week of July 29, 2013=
{| class="wikitable" border="1" cellpadding="5"
|-
! Week Day !! Today's work !! Blog URL(optional)
|-
| Sunday || Change approach, I decided to create schedule and all its related meeting/lecture in MySQL directly as stored procedure, so I now have to figure out how to do that ||
|-
| Monday || ||
|-
| Tuesday || add exception block to sp_create_ms, write sp_update_m_duration ||
|-
| Wednesday || write stored procedure sp_update_ms_repeats ||
|-
| Thursday || write sp_update_m_time, sp_update_ms_inidatetime <br />Add random values to modpass and userpass<br />help Robert fixing some bugs||
|-
| Friday || mirrors the SPs I've written for meeting into lecture SPs||
|-
| Saturday || ||
|}
=Week of July 22, 2013=
{| class="wikitable" border="1" cellpadding="5"
|-
! Week Day !! Today's work !! Blog URL(optional)
|-
| Sunday || ||
|-
| Monday || add custom boolean class ||
|-
| Tuesday || Finished user class, clean up testing methods ||
|-
| Wednesday || Starting meeting class, run into problem with adding meeting schedule ||
|-
| Thursday || keep working on meeting class, finish off the easier methods ||
|-
| Friday || ||
|-
| Saturday || ||
|}
=Week of July 15, 2013=
{| class="wikitable" border="1" cellpadding="5"
|-
! Week Day !! Today's work !! Blog URL(optional)
|-
| Sunday || ||
|-
| Monday || ||
|-
| Tuesday || Bit-wise math on certain query methods ||
|-
| Wednesday || Distinction between query and other sql statements, rewrote some code to reflect changes, finish off queries for user class, start on db update methods || [http://kelanli.wordpress.com/2013/07/17/java-preparestatement-executequery-vs-executeupdate/ query vs. other sql statements]
|-
| Thursday || add methods that return settings to default ||
|-
| Friday || bug fixes, more testing ||
|-
| Saturday || ||
|}
=Week of July 8, 2013=
{| class="wikitable" border="1" cellpadding="5"
|-
! Week Day !! Today's work !! Blog URL(optional)
|-
| Sunday || ||
|-
| Monday || Make More Queries, discussion with Rob and Chad lead to DBConnection Design change: its now a pool connection instead of pure singleton, need to read Ystallone's code to see how do it ||
[https://github.com/ystallonne/TestingJSP/blob/master/src/db/DBConnection.java Ystallonne's code]
|-
| Tuesday || Pool Connection created and uploaded, I'm pretty sure the scope is application wide instead of session wide ||
[http://kelanli.wordpress.com/2013/07/09/static-variable-scope-usiing-tomcat-classloader/ Static Variable Scope]
|-
| Wednesday || The current DB Pool library is not efficient and crashes if max connection reached, switching to BoneCP. BoneCP is now implemented. ||
[http://jolbox.com/ BoneCP]
|-
| Thursday || Refactoring DBConnection, DBQuery. DB connection is nowed tethered to the query method (inside DBQuery). This reduce the amount of simultaneous connection. Increase MySQL total DB connection limit ||
|-
| Friday || Sucessful testing BoneCP getConnection() by leaving connections open, then close them by using anther browser window, BoneCP will wait indefinitely for a open connection if max connection reached, we could use this to our advantage ||
|-
| Saturday || ||
|}
=Week of July 1, 2013=
{| class="wikitable" border="1" cellpadding="5"
|-
! Week Day !! Today's work !! Blog URL(optional)
|-
| Sunday || ||
|-
| Monday || Canada Day ||
|-
| Tuesday || Divide DBConnection into 2 classes, one singleton connection class and a Query class ||
[https://github.com/SenecaCDOT-BigBlueButton/SenecaBBB/tree/master/database/BBB_Integration_DB/src/db DB classes]
|-
| Wednesday || Write skeleton DAO classes and a test class, upload everything to git Hub ||
[https://github.com/SenecaCDOT-BigBlueButton/SenecaBBB/tree/master/database/BBB_Integration_DB BBB_Integration_DB]
|-
| Thursday || Tried to integrate DAO files into the Integration main web-app, ran into problems, had to recreate the entire web-app ||
[https://github.com/SenecaCDOT-BigBlueButton/SenecaBBB/commit/4f649c6fef17ca2df0e92ccd1be43761ac33873f Reloaded Web-app]
|-
| Friday || DAO files integrated, clean up the test files, write a few more query methods to test ||
|-
| Saturday || ||
|}
=Week of June 24, 2013=
{| class="wikitable" border="1" cellpadding="5"
|-
! Week Day !! Today's work !! Blog URL(optional)
|-
| Sunday || ||
|-
| Monday || Start learning node.js and backbone.js, also familiarize with JavaScript again ||
[http://kelanli.wordpress.com/2013/06/24/set-attributes-inside-function/ JavaScript set Attribute inside function]
|-
| Tuesday || Learning the HTML5 project ||
|-
| Wednesday || Learning more about backbone.js, callback and connection diagram ||
[http://kelanli.wordpress.com/bbb-html5/ BBB HTML5]
|-
| Thursday || Update comments on db diagram, finalize setting mask bits, prepare to write all DB access classes ||
|-
| Friday || Start to write DAO classes for integration project ||
|-
| Saturday || ||
|}
=Week of June 17, 2013=
| Wednesday || Explore options to write classes, class diagram ||
|-
| Thursday || Meeting making new blog, writing a blog about use cases, create wiki page structure for use cases [http://kelanli.wordpress.com/2013/06/20/builder-pattern-in-java/ build pattern in Java] || [http://kelanli.wordpress.com/2013/06/20/builder-pattern-in-java/ build pattern in Java]
|-
| Friday || Writing use cases Review Gary's blog, testing writing more DB access/query classes ||
|-
| Saturday || ||
|}
[http://kelan-metakelanli.blogspotwordpress.cacom/2013/06/week20/weekly-report-june-17-ofto-june-1021-2013.html / Weekly Blog]
=Week of June 10, 2013=
