Open main menu

CDOT Wiki β

Bo Weekly log 20132

Revision as of 12:31, 18 October 2013 by Bo Li (talk | contribs) (→‎Week of October 7, 2013)

Logs for Bo Li

Blog

Please add the daily logs (Latest week at the top of the page)

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

Retrieved from "https://wiki.cdot.senecapolytechnic.ca/w/index.php?title=Bo_Weekly_log_20132&oldid=100783"