GSOC 2022 : PSF PyZombis Final Submission Shivam Shandilya

GSoC 2022 Summary

Proposed Goals

• Work on old and incomplete pull requests
• Define and implement the final solution for SQLite lectures
• Implement the Sqlite wrapper with sql.js and brython
• Define and implement the final solution for Pygame lectures
• Implement the Pygame wrapper with game.js and Brython
• Write E2E tests for the all newly added or fixed lectures with Playwright
• Add a Pygame Challenge

What was done

• Fixed minor bugs and previous PRs

  • PR#199 - added external api to replace failing api
  • PR#202 - Update runestone install repo link
  • PR#204 -Fixed failing proxy in TWP33 lectures
  • PR#206 - Fixed failing proxy in TWP35 lectures
  • PR#208 - Fixed failing proxy in TWP45 lectures
  • PR#221 - E2E tests for TWP33 to detect API issues

• Made Pygame lectures interactive

  • PR#222 - Pygame implementation using Brython and GameJs

• Made SQL lectures interactive

  • PR#223 - Refactored TWP42_2 : Conceptos básicos de SQL

• Added SQL lecture

  • PR#224 - TWP42_3 : Más conceptos de sql

• Added Pygame Challenge

  • PR#225 - Pygame challenge

• Added E2E tests for Pygame

  • PR#226 - Added playwright tests for Pygame lectures

• Added E2E tests for SQL lectures

  • PR#227 - SQL E2E tests with playwright

What's left

• Increase the dimension of the the output window of the activecode block

  • This will make the Pygame Challenge more enjoyable to play and work with.

• Start with the web2py web development lectures

Work done summary

• All PRs (merged and open)
• All commits into branch main
• Pygame Interactive
• SQL Interactive

Commit Log table for main branch

Commit	Date	Summary	Stats
f3b8dd79	2022-07-17	added third SQL lecture for more advanced concepts	3 files changed, 341 insertions(+)
1b1c15f7	2022-07-17	updated sqlite3.py file	1 file changed, 1 insertion(+), 1 deletion(-)
a803804a	2022-07-17	added chinook example database	1 file changed, 0 insertions(+), 0 deletions(-)
73b977aa	2022-07-07	added static folder to path for second activecode block	1 file changed, 5 insertions(+)
45ddad9f	2022-07-07	refactored second sql lecture	1 file changed, 55 insertions(+), 19 deletions(-)
0fbbd62c	2022-06-25	updted sql lecture	1 file changed, 3 insertions(+), 136 deletions(-)
6cdbdc0e	2022-06-25	Merge branch 'Refactor_TWP42_SQL_JS' of https://github.com/shivamshan/PyZombis into Refactor_TWP42_SQL_JS
921f97e5	2022-06-25	updted lecture interpreter to brython and removed tests	2 files changed, 42 insertions(+), 255 deletions(-)
151ed394	2022-06-25	added sqlite3 wrapper and surfers database	2 files changed, 58 insertions(+)
6116df0d	2022-06-25	Merge branch 'main' into Refactor_TWP42_SQL_JS	--------
9cda9cd6	2022-06-17	updated collision detection exercise	1 file changed, 96 insertions(+)
03e60559	2022-06-17	made pygame exercises interactive	5 files changed, 346 insertions(+), 8 deletions(-)
353999e1	2022-06-17	added gamejs support and pygame brython package	2 files changed, 24066 insertions(+)
a4c5106b	2022-03-17	fixed failing proxy in this lecture	7 files changed, 8 insertions(+), 8 deletions(-)
b96855ee	2022-03-16	updated runestone install link	1 file changed, 1 insertion(+), 1 deletion(-)
f9b5d2f3	2022-03-13	improved commit functionality to resemble sqlite3	1 file changed, 35 insertions(+), 16 deletions(-)
ae6d8f40	2022-03-13	removed unnecessary print statement	1 file changed, 1 deletion(-)
c5015687	2022-03-13	fixed issues in commit functionality	1 file changed, 3 insertions(+), 3 deletions(-)
1cfa8c26	2022-03-13	added rollback, commit functionality and improved error logging	1 file changed, 26 insertions(+), 21 deletions(-)
03865218	2022-03-12	fixed bug that didn't clear the previous query	1 file changed, 15 insertions(+), 5 deletions(-)
1c2f5069	2022-03-12	updated the execute function the the wrapper, dispay data according to original lecture	1 file changed, 44 insertions(+), 34 deletions(-)
b23818e0	2022-03-12	added playwright end-2-end test for the lecture	1 file changed, 20 insertions(+)
9c3e3c4f	2022-03-12	added sqlite3 wrapper and fixed the timeout issue	1 file changed, 121 insertions(+), 30 deletions(-)
fd6b01da	2022-03-09	Refactored the first SQL lecture to support running any query and show result in table format	1 file changed, 126 insertions(+), 27 deletions(-)