Itr2_Database and Mapify Plugin - talshi/Yerushalmit GitHub Wiki

Iteration Goals

  • Establishing database using MongoDB.
  • Establishing database using Wordpress.
  • Building the Classes: DBController, ActivityList, CategoryList and Mapify.
  • Building database tables (Maps, Activities and Categories) and init tables' columns.
  • Write activate and deactivate functions (for create and drop tables).
  • Building the manage map page.
  • Building the manage activities page.
  • Building the manage category page.
  • Classes tests.

Roles

  • Scrum Master: stavdv

Issues

  • Closed issues

Iteration Result

We have done quite much. Unfortunately, we did not finished the database part because of problems that appeared during work.
In the next iteration, we plan to find solutions for the new problems in database section. All other tasks have done successfully and we move on with the new tasks. Briefly, the plan for the next iteration is to concentrate in the site (until now we concentrated in the site's admin section). We plan to design the Wordpress template and inject the plugin to one of the page.

Team Cooperation

As usual, we will seperate to pairs and teams for efficient work. Those who built the classes will continue with classes test. Those who built the UI will continue to build the rest of the pages. Someone will care about establishing the data base.

Tasks Status

  • We established the plugin database, including 3 tables - map, activities and categories.
  • We built the UI screens:
    • Manage map page was finished.
    • We started to build the manage activities page. Most of the work has done.
    • We started to build the manage categories page.
    • We still need to connect the database to the UI, meaning that each add/remove activities/categories is occured in the database.
  • We have done some simple tests on the database to ensure that the tables are created by activate function automatic call, and also are dropped by deactivate function automatic call.
  • The significant tests will be done in the next iteration.

Points Summary

  • Building database tables (Maps, Activities and Categories) and init tables' columns - 10 points
  • Write activate and deactivate functions (for create and drop tables) - 10 points
  • Building the manage map page - 10 points
  • Building the manage activities page - 13 points
  • Building the manage category page - 8 points
  • Classes tests - 9 points

Total: 60 points.

Iteration Conclusion

We finished most of the tasks we wanted. We are going to continue working on part of the tasks which are undone (database, pages) and make some tests in the next iteration.

Demonstration:

  • Manage Map page

  • Manage Activity page

  • Manage Categories page

  • Establishing database using Wordpress

Code Review

Notes that were up during the work:

  • Make efforts to build OOP way, i.e use classes and access identifiers (public, private) instead of scripting-like and on the fly programming.
  • Consider code design before coding. Don't code on the fly, because it causes bugs in the future.

Testing

Local tests only (no unit tests):

  • Create database tables on press activate button.
  • Insert values to the tables.
  • Delete the tables on press deactivate button.

All tests passed successfully.

Next Iteration

Iteration 3