Difference between revisions of "Bo Weekly log 20132"

From CDOT Wiki
Jump to: navigation, search
(Week of July 29, 2013)
(Week of July 29, 2013)
Line 18: Line 18:
 
| Wednesday || write stored procedure sp_update_ms_repeats ||
 
| Wednesday || write stored procedure sp_update_ms_repeats ||
 
|-
 
|-
| Thursday || ||  
+
| 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 || ||  
+
| Friday || mirrors the SPs I've written for meeting into lecture SPs||  
 
|-
 
|-
 
| Saturday ||  ||  
 
| Saturday ||  ||  

Revision as of 13:33, 2 August 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 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