Google Summer of Code’ 17 with phpMyAdmin – Summary

This post summarizes the work done and tasks accomplished during the last twelve weeks. It was carried out as a part of Google Summer of Code 2017 with phpMyAdmin.

The project involved two separate sub-lists of tasks, one related to phpMyAdmin’s Error Reporting Server and the other related to phpMyAdmin’s selenium test-suite.

Tasks related to Error Reporting Server:

1. Use cleaner syntax for control structures in views:
   • PR: https://github.com/phpmyadmin/error-reporting-server/pull/133
2. Allow reports search by filename:
   • PR: https://github.com/phpmyadmin/error-reporting-server/pull/146
3. Sanitize versions in reports:
   • PR: https://github.com/phpmyadmin/error-reporting-server/pull/147
4. Simplify issue state:
   • PR: https://github.com/phpmyadmin/error-reporting-server/pull/152
5. Improve generated issues content:
   • PR: https://github.com/phpmyadmin/error-reporting-server/pull/151
6. Provide email notification for new reports:
   • PR: https://github.com/phpmyadmin/error-reporting-server/pull/153
7. Read-only public interface:
   • PR: https://github.com/phpmyadmin/error-reporting-server/pull/167
8. Follow linked Github-issue state:
   • PR: https://github.com/phpmyadmin/error-reporting-server/pull/155
   • PR: https://github.com/phpmyadmin/error-reporting-server/pull/163

• Some more pull requests were made as a part of fixing related issues:
  • https://github.com/phpmyadmin/error-reporting-server/pull/162
  • https://github.com/phpmyadmin/error-reporting-server/pull/164
  • https://github.com/phpmyadmin/error-reporting-server/pull/166
  • https://github.com/phpmyadmin/error-reporting-server/pull/168
  • https://github.com/phpmyadmin/error-reporting-server/pull/170
  • https://github.com/phpmyadmin/error-reporting-server/pull/171
  • https://github.com/phpmyadmin/error-reporting-server/pull/176
  • https://github.com/phpmyadmin/error-reporting-server/pull/161
  • https://github.com/phpmyadmin/error-reporting-server/pull/154

 

Tasks related to selenium testing:

1. Fix database-related selenium tests
   • https://github.com/phpmyadmin/phpmyadmin/pull/13462
2. Fix selenium tests related to Login, Normalization, ChangePassword, ServerSettings
   • https://github.com/phpmyadmin/phpmyadmin/pull/13476
3. Fix selenium tests related to Table, Export, XSS, Tracking
   • https://github.com/phpmyadmin/phpmyadmin/pull/13520
4. Fix import-related selenium tests
   • https://github.com/phpmyadmin/phpmyadmin/pull/13526
5. Add tests for typing and executing SQL query on phpMyAdmin
   • https://github.com/phpmyadmin/phpmyadmin/pull/13583
6. Add tests for Query-by-example UI in phpMyAdmin
   • https://github.com/phpmyadmin/phpmyadmin/pull/13588
7. Fix random failures in selenium tests
   • https://github.com/phpmyadmin/phpmyadmin/pull/13594
8. Minor refactoring in selenium tests
   • https://github.com/phpmyadmin/phpmyadmin/pull/13605

Weekly reports

The detailed weekly reports are available on this blog at the following links:

1. Week 1:
   • https://devenbansod.wordpress.com/2017/06/04/gsoc-2017-weekly-report-1/
2. Week 2:
   • https://devenbansod.wordpress.com/2017/06/12/gsoc-2017-weekly-report-2/
3. Week 3:
   • https://devenbansod.wordpress.com/2017/06/19/gsoc-2017-weekly-report-3/
4. Week 4:
   • https://devenbansod.wordpress.com/2017/06/26/gsoc-2017-weekly-report-4/
5. Week 5:
   • https://devenbansod.wordpress.com/2017/07/03/gsoc-2017-weekly-report-5/
6. Week 6:
   • https://devenbansod.wordpress.com/2017/07/10/gsoc-2017-weekly-report-6/
7. Week 7:
   • https://devenbansod.wordpress.com/2017/07/17/gsoc-2017-weekly-report-7/
8. Week 8:
   • https://devenbansod.wordpress.com/2017/07/26/gsoc-2017-weekly-report-8/
9. Week 9:
   • https://devenbansod.wordpress.com/2017/08/02/gsoc-2017-weekly-report-9/
10. Week 10-11:
    • https://devenbansod.wordpress.com/2017/08/15/gsoc-2017-weekly-report-10-11/
11. Week 12:
    • https://devenbansod.wordpress.com/2017/08/25/gsoc-2017-weekly-report-12/

Conclusion

The project led to a few good improvements to phpMyAdmin’s error reporting server, which I hope would make it more developer-friendly and the public interface would help more non-team contributors in fixing the errors reported on it.

phpMyAdmin’s selenium test-suite has finally stabilized in green (i.e. passing), albeit some errors popping up once in about ten runs. I do hope to fix these as they are encountered. Improvement in selenium test-suite and moving it out of allowed failures in Travis has already started to show its impact as we could track a few errors introduced while refactoring. These would otherwise be missed as the refactored code was not well-covered by the unit tests.

Finally, it has been another wonderful summer working with phpMyAdmin and its wonderful community. I would like to thank my mentor, Michal Čihař and the entire phpMyAdmin team, for their continued support throughout this project.