srenduch/excal

Class and assignment tracker inspired by GCal and Excel

excal's Issues

Add delete modal for quick item deletion

• Just like how alt+n displays the "new" modal (popup), need a similar hotkey to display the "delete" modal
• Ideally, it would be similar in shape and size to the new modal to encourage uniformity

Maybe a item type toggler like in the new modal, and based on the active item type, display elements accordingly?

---

Possible layouts:

• Assignment

Pick the class the assignment belongs to, then in an (not pictured here) adjacent drop-down pick the assignment to delete

• Need to ensure that there are no two assignments with the same name (a_name) within the same class

---

• Class
  Similar as above, but without the extra assignment toggle

Encapsulate caching mechanism within centralized cacher

Want a method to retain caching functionality while keeping it centralized.
This would make it so that the caching mechanism is centralized, while reducing code redundancy.

Delete assignments

The current view on the homepage:

Need a way to delete this item. For now, let's try adding a clickable element to the right of the title, perhaps a button.
On button-click, remove the item from the homepage and remove the corresponding element from the db table.

Preferably, the deletion would be dynamic in that it is reflected across the page on the click itself (without reloading the page).
If that doesn't work, we might need to reload the page for the changes to take effect.

Might also need JS to do this but hopefully we can keep it in Python.

This may be useful for reference.

Database migration from local instance to server/cloud instance

Currently, the assignment, class, and tests tables are stored in a local database in /db/db.sqlite3. This is a naive approach for the following reasons:

• If the database is corrupted, there is no backup for it. All information is lost.
• When deploying, the database is overwritten. Again, all information is lost.
• When the application has been idle on Heroku's side for too long and is finally refreshed, the database is wiped and again, all information is lost.

By porting this local database instance to a server instance:

• Even if a local copy of the database is corrupted, a backup is available on the server. Information can be reobtained.
• When deploying, the application need only fetch existing information from the server.
• Even if Heroku has been idle, when it refreshes, it can simply fetch the information from the server again.

Add DB API in static files

Just like the DB API written to communicate with the DB in backend, we need a similar DB written for the frontend so that we can invoke those methods across various DOM element-user interactions. The frontend API has the same limitations and goals as the backend API.

Add an auto-updating counter for assignment tracking

Currently, assignments only refresh on page reload or HTTP request.

1. All assignments should be refreshing every X seconds (leave that to decide up to the developer, will add a setting feature to customize later).
2. Display changes on the front-end first, then after that works, write changes to database before server termination.

Things to consider:

1. Threading in javascript if it exists so that updating does not block main thread.
2. If JS does not have a threading library or threading is not feasible, might need to look into backend threading.

Add assignment creation by hotkey

Ideally, want Ctrl + Alt + <key> binds sitewide to allow on the fly item creation.

Ctrl + Alt + N: Bring up a popup to create an assignment.

Refer here for a rough idea:

Need to move HTML generation from server to client side

Current dynamic is done by generating HTML with the dynamic info on the server-side.

• Rendering should be done by the client, since the server is only meant to process requests and return responses.
• Server routes should be meant only for retrieving and return data along with the webpage to load and the response status.

We can probably offload this overhead by creating a client-sided HTML generator object, so that HTML generation is centralized and easy to modify.