1
edit
Changes
→Week of November 4, 2013
{{BBB Log Index | 20132}}
=Logs for 20132Bo Li=[http://blogurl kelanli.wordpress.com/ 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=
{| class="wikitable" border="1" cellpadding="5"
|-
! Week Day !! Today's work !! Blog URL(At least Oneoptional)|-| 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={| class="wikitable" border="1" cellpadding="5"|-! 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 || [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 instead of session wide || [http://kelanli.wordpress.com/2013/07/09/static-variable-scope-usiing-tomcat-classloader/ 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. || [http://jolbox.com/ 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={| class="wikitable" border="1" cellpadding="5"|-! 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 || [https://github.com/SenecaCDOT-BigBlueButton/SenecaBBB/tree/master/database/BBB_Integration_DB/src/db DB classes]|-| Wednesday || Write skeleton DAO classes and a test class, upload everything to git Hub || [https://github.com/SenecaCDOT-BigBlueButton/SenecaBBB/tree/master/database/BBB_Integration_DB 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 || [https://github.com/SenecaCDOT-BigBlueButton/SenecaBBB/commit/4f649c6fef17ca2df0e92ccd1be43761ac33873f 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={| class="wikitable" border="1" cellpadding="5"|-! Week Day !! Today's work !! Blog URL(optional)|-| Sunday || || |-| Monday || Start learning node.js and backbone.js, also familiarize with JavaScript again || [http://kelanli.wordpress.com/2013/06/24/set-attributes-inside-function/ JavaScript set Attribute inside function]|-| Tuesday || Learning the HTML5 project || |-| Wednesday || Learning more about backbone.js, callback and connection diagram || [http://kelanli.wordpress.com/bbb-html5/ 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={| class="wikitable" border="1" cellpadding="5"|-! 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 [http://kelanli.wordpress.com/2013/06/20/builder-pattern-in-java/ build pattern in Java] || [http://kelanli.wordpress.com/2013/06/20/builder-pattern-in-java/ build pattern in Java] |-| Friday || Review Gary's blog, testing writing more DB access/query classes || |-| Saturday || || |}[http://kelanli.wordpress.com/2013/06/20/weekly-report-june-17-to-june-21-2013/ Weekly Blog] =Week of June 10, 2013={| class="wikitable" border="1" cellpadding="5"|-! 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 || || |}[http://kelan-meta.blogspot.ca/2013/06/week-of-june-10-2013.html Weekly Blog] =Week of June 3, 2013={| class="wikitable" border="1" cellpadding="5"|-! 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 || || |}[http://kelan-meta.blogspot.ca/2013/06/week-of-june-3-2013.html Weekly Blog] =Week of May 27, 2013={| class="wikitable" border="1" cellpadding="5"|-! 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 || || |}[http://kelan-meta.blogspot.ca/2013/05/week-of-may-31-2013.html Weekly Blog] =Week of May 21, 2013={| class="wikitable" border="1" cellpadding="5"|-! 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 || || |}[http://kelan-meta.blogspot.ca/2013/05/week-of-may-21-2013.html Weekly Blog] =Week of May 13, 2013={| class="wikitable" border="1" cellpadding="5"|-! Week Day !! Today's work !! Blog URL(optional)|-| Sunday || || |-| Monday || Fixing origin/master of SenecaCDOT-BigBlueButton/bigbluebutton with Chad's help || [https://github.com/SenecaCDOT-BigBlueButton/bigbluebutton]|-| 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 || || |}[http://kelan-meta.blogspot.ca/2013/05/week-of-may-13.html Weekly Blog] =Week of May 6, 2013={| class="wikitable" border="1" cellpadding="5"|-! 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 || ||
|}
[http://kelan-meta.blogspot.ca/2013/05/track-week-may-6.html Weekly Blog]