Difference between revisions of "Bo Weekly log 20132"

From CDOT Wiki
Jump to: navigation, search
(Week of July 1, 2013)
(Week of November 4, 2013)
 
(27 intermediate revisions by the same user not shown)
Line 4: Line 4:
  
 
Please add the daily logs (Latest week at the top of the page)
 
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=
 
=Week of July 8, 2013=
Line 13: Line 269:
 
|-
 
|-
 
| 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 ||  
 
| 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]|-
+
[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 isntead of session wide ||  
+
|-
 +
| 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]
 
[http://kelanli.wordpress.com/2013/07/09/static-variable-scope-usiing-tomcat-classloader/ Static Variable Scope]
 
|-
 
|-
| Wednesday ||  ||  
+
| 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 || ||  
+
| 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 || ||  
+
| 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 ||  ||  
 
| Saturday ||  ||  

Latest revision as of 13:30, 13 November 2013


BigBlueButton | BBB Weekly Log
Bo | Chad | Gary | Justin | Robert | Ystallonne

Logs for Bo Li

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

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,
    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

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

Week Day Today's work Blog URL(optional)
Sunday
Monday
  • Construct Power Point Presentation for tomorrow
Tuesday
  • Presentation on Database Layer

Presentation

Wednesday
  • Home, studying for Exam
Thursday
  • Add Lecture.java method
  • Add remove methods to Meeting.java
Friday
Saturday

Week of August 5, 2013

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
  • Getting rid of cascade delete from mysql script
  • Complete meeting sql methods
  • Change sql.java from interface to base class
Friday
  • Help Rob with a couple of bugs
  • Discussion
Saturday

Week of July 29, 2013

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
Add random values to modpass and userpass
help Robert fixing some bugs
Friday mirrors the SPs I've written for meeting into lecture SPs
Saturday

Week of July 22, 2013

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

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 query vs. other sql statements
Thursday add methods that return settings to default
Friday bug fixes, more testing
Saturday

Week of July 8, 2013

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

Ystallonne's code

Tuesday Pool Connection created and uploaded, I'm pretty sure the scope is application wide instead of session wide

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.

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

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

DB classes

Wednesday Write skeleton DAO classes and a test class, upload everything to git Hub

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

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

Week Day Today's work Blog URL(optional)
Sunday
Monday Start learning node.js and backbone.js, also familiarize with JavaScript again

JavaScript set Attribute inside function

Tuesday Learning the HTML5 project
Wednesday Learning more about backbone.js, callback and connection diagram

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

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 build pattern in Java

build pattern in Java

Friday Review Gary's blog, testing writing more DB access/query classes
Saturday

Weekly Blog

Week of June 10, 2013

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

Weekly Blog

Week of June 3, 2013

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

Weekly Blog


Week of May 27, 2013

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

Weekly Blog


Week of May 21, 2013

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

Weekly Blog


Week of May 13, 2013

Week Day Today's work Blog URL(optional)
Sunday
Monday Fixing origin/master of SenecaCDOT-BigBlueButton/bigbluebutton with Chad's help [1]
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

Weekly Blog

Week of May 6, 2013

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

Weekly Blog