View source for Bo Weekly log 20132

{{BBB Log Index | 20132}}
=Logs for Bo Li=
[http://kelanli.wordpress.com/ 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=
{| class="wikitable" border="1" cellpadding="5"
|-
! Week Day !! Today's work !! Blog URL(optional)
|-
| Sunday ||  || 
|-
| Monday || Finish Use Cases, clear distinction between roles, create diagram to show the relation among roles, edit Use Case structure || 
|-
| Tuesday || Peer review User Cases || 
|-
| Wednesday || Explore options to write classes, class diagram || 
|-
| Thursday || making new blog, writing a blog about [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 || Review Gary's blog, testing writing more DB access/query classes || 
|-
| Saturday ||  || 
|}
[http://kelanli.wordpress.com/2013/06/20/weekly-report-june-17-to-june-21-2013/ Weekly Blog]

=Week of June 10, 2013=
{| class="wikitable" border="1" cellpadding="5"
|-
! Week Day !! Today's work !! Blog URL(optional)
|-
| Sunday ||  || 
|-
| Monday || Create test cases for DB Class class, prepare for presentation || 
|-
| Tuesday || Presentation || 
|-
| Wednesday || Work on DB class, discuss use cases || 
|-
| Thursday || Meeting about use cases, create wiki page structure for use cases || 
|-
| Friday || Writing use cases || 
|-
| Saturday ||  || 
|}
[http://kelan-meta.blogspot.ca/2013/06/week-of-june-10-2013.html Weekly Blog]

=Week of June 3, 2013=
{| class="wikitable" border="1" cellpadding="5"
|-
! Week Day !! Today's work !! Blog URL(optional)
|-
| Sunday ||  || 
|-
| Monday || Update MySQL scripts, reduce compound primary keys || 
|-
| Tuesday || Reading through BBB Seneca Integration Use Cases || 
|-
| Wednesday || Plan presentation for Integration Site || 
|-
| Thursday || Attempt to create few Use Cases to Java Classes || 
|-
| Friday || Build Power Point slides for presentation  || 
|-
| Saturday ||  || 
|}
[http://kelan-meta.blogspot.ca/2013/06/week-of-june-3-2013.html Weekly Blog]



=Week of May 27, 2013=
{| class="wikitable" border="1" cellpadding="5"
|-
! Week Day !! Today's work !! Blog URL(optional)
|-
| Sunday ||  || 
|-
| Monday || Attend OCE Discovery || 
|-
| Tuesday || Learn CoffeeScript || 
|-
| Wednesday || Modify Database Design and MySQL scripts || 
|-
| Thursday || || 
|-
| Friday || Planning actual Integration site || 
|-
| Saturday ||  || 
|}
[http://kelan-meta.blogspot.ca/2013/05/week-of-may-31-2013.html Weekly Blog]



=Week of May 21, 2013=
{| class="wikitable" border="1" cellpadding="5"
|-
! Week Day !! Today's work !! Blog URL(optional)
|-
| Sunday ||  || 
|-
| Monday || Made an alternative database script that uses a table and function to manually add pk to tables instead of using auto increment, also added a sample data script || 
|-
| Tuesday || Scripts used to generated MYSQL database, connect Netbean to database, everything works fine || 
|-
| Wednesday || Setting up development environment for BBB HTML5 project || 
|-
| Thursday || Familarize myself with the integration site || 
|-
| Friday || || 
|-
| Saturday ||  || 
|}
[http://kelan-meta.blogspot.ca/2013/05/week-of-may-21-2013.html Weekly Blog]



=Week of May 13, 2013=
{| class="wikitable" border="1" cellpadding="5"
|-
! Week Day !! Today's work !! Blog URL(optional)
|-
| Sunday ||  || 
|-
| Monday || Fixing origin/master of SenecaCDOT-BigBlueButton/bigbluebutton with Chad's help || [https://github.com/SenecaCDOT-BigBlueButton/bigbluebutton]
|-
| Tuesday || Design update on the integration site ERD || 
|-
| Wednesday || Updating the SQL script and converts it to work with MYSQL || 
|-
| Thursday || Setting up development environment for the integration site || 
|-
| Friday || Setting up netbean IDE, making a HelloWeb site || 
|-
| Saturday ||  || 
|}
[http://kelan-meta.blogspot.ca/2013/05/week-of-may-13.html Weekly Blog]

=Week of May 6, 2013=
{| class="wikitable" border="1" cellpadding="5"
|-
! Week Day !! Today's work !! Blog URL(optional)
|-
| Sunday ||  || 
|-
| Monday || Orientation || 
|-
| Tuesday || Install: Ubuntu, VMPlayer BBB 8.1 || 
|-
| Wednesday || Install: LibreOffice, Ruby, ffmpeg, API Demos || 
|-
| Thursday || Setting up BBB client Dev Environment || 
|-
| Friday || Setting up Eclipse || 
|-
| Saturday ||  || 
|}
[http://kelan-meta.blogspot.ca/2013/05/track-week-may-6.html Weekly Blog]