Difference between revisions of "Bo Weekly log 20132"
(→Week of July 1, 2013) |
(→Week of November 4, 2013) |
||
(27 intermediate revisions by the same user not shown) | |||
Line 4: | Line 4: | ||
Please add the daily logs (Latest week at the top of the page) | 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(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,<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= | =Week of July 8, 2013= | ||
Line 13: | Line 269: | ||
|- | |- | ||
| 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 || | | 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]|- | + | [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 | + | |- |
+ | | 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] | [http://kelanli.wordpress.com/2013/07/09/static-variable-scope-usiing-tomcat-classloader/ Static Variable Scope] | ||
|- | |- | ||
− | | Wednesday || || | + | | 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 || | + | | 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 || | + | | 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 || || | | Saturday || || |
Latest revision as of 13:30, 13 November 2013
BigBlueButton |
BBB Weekly Log
Bo |
Chad |
Gary |
Justin |
Robert |
Ystallonne
Contents
- 1 Logs for Bo Li
- 2 Week of November 11, 2013
- 3 Week of November 4, 2013
- 4 Week of October 28, 2013
- 5 Week of October 21, 2013
- 6 Week of October 14, 2013
- 7 Week of October 7, 2013
- 8 Week of September 23, 2013
- 9 Week of September 16, 2013
- 10 Week of September 9, 2013
- 11 Week of September 2, 2013
- 12 Week of August 26, 2013
- 13 Week of August 19, 2013
- 14 Week of August 12, 2013
- 15 Week of August 5, 2013
- 16 Week of July 29, 2013
- 17 Week of July 22, 2013
- 18 Week of July 15, 2013
- 19 Week of July 8, 2013
- 20 Week of July 1, 2013
- 21 Week of June 24, 2013
- 22 Week of June 17, 2013
- 23 Week of June 10, 2013
- 24 Week of June 3, 2013
- 25 Week of May 27, 2013
- 26 Week of May 21, 2013
- 27 Week of May 13, 2013
- 28 Week of May 6, 2013
Logs for Bo Li
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 |
|
|
Tuesday |
|
|
Wednesday |
|
|
Thursday |
|
|
Friday |
|
|
Saturday |
Week of August 19, 2013
Week Day | Today's work | Blog URL(optional) |
---|---|---|
Sunday | ||
Monday |
|
|
Tuesday |
|
|
Wednesday |
|
|
Thursday |
|
|
Friday |
|
|
Saturday |
Week of August 12, 2013
Week Day | Today's work | Blog URL(optional) |
---|---|---|
Sunday | ||
Monday |
|
|
Tuesday |
|
|
Wednesday |
|
|
Thursday |
|
|
Friday | ||
Saturday |
Week of August 5, 2013
Week Day | Today's work | Blog URL(optional) |
---|---|---|
Sunday | ||
Monday |
|
|
Tuesday |
|
|
Wednesday |
|
|
Thursday |
|
|
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 | |
Tuesday | Pool Connection created and uploaded, I'm pretty sure the scope is application wide instead of session wide | |
Wednesday | The current DB Pool library is not efficient and crashes if max connection reached, switching to BoneCP. BoneCP is now implemented. | |
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 | |
Wednesday | Write skeleton DAO classes and a test class, upload everything to git Hub | |
Thursday | Tried to integrate DAO files into the Integration main web-app, ran into problems, had to recreate the entire 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 | |
Tuesday | Learning the HTML5 project | |
Wednesday | Learning more about backbone.js, callback and connection diagram | |
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 | |
Friday | Review Gary's blog, testing writing more DB access/query classes | |
Saturday |
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 |
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 |
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 |
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 |
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 |
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 |