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