Bo Weekly log 20132

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