This is a Flask-based web application designed to manage events and visualize them on a dynamic timeline. This application supports integration with Grafana for visual analytics and the Giphy API for enhanced user interaction.
To get the application running locally, you have several options:
docker-compose up --buildThe app will be available at http://127.0.0.1:5001/.
Alternatively, you can set up a development container or any other Python environment. After setting up, start the application with the following command:
flask run --debugFor production, you would use Gunicorn as a WSGI server:
gunicorn -w 4 -b "127.0.0.1:5000" "app:create_app()"Ensure your environment has all the necessary dependencies installed as specified in the requirements.txt file.
To integrate with Giphy, create a .env file in the project root and add the following key:
GIPHY_API_TOKEN=<your_giphy_api_token>
To populate the application with sample data, run:
curl -X POST http://127.0.0.1:5000/batch-import -H "Content-Type: application/json" -d @testdata.json- Purge Old Entries
- Set to automatically execute at the start of each month.
- Update Serial Entries
- Scheduled to run at the start of every new year.
These tasks use the APScheduler, with the scheduler API enabled for enhanced interaction through HTTP endpoints. More details and the API can be accessed here: APScheduler API Documentation.
Below are the available API endpoints with their respective usage:
-
Home
- GET
/ - Returns the main page of the application.
- GET
-
Timeline
- GET
/timeline?timeline-height=<height>&font-family=<font>&font-scale=<scale>&categories=<category_names>&max-past-entries=<number> - Displays a timeline of all entries. Supports the following optional query parameters:
timeline-height: Sets the CSS height of the timeline.font-family: Specifies the font used.font-scale: Applies a scaling factor to the font sizes.categories: Comma-separated list of category names to filter entries.max-past-entries: Limits the number of past entries displayed (only the most recent past entries up to this number are shown).
- Example:
This renders a timeline using Arial font scaled by 1.5, filtering to show only entries under “Cake” and “Birthday” categories and including at most the last five past entries.
/timeline?timeline-height=100%&font-family=Arial&font-scale=1.5&categories=Cake,Birthday&max-past-entries=5
- GET
-
Create Entry
- POST
/create - Creates a new entry. Requires form data including
date,category,title, anddescription.
- POST
-
Update Entry
- GET/POST
/update/<int:id> - Retrieves an entry for editing or updates an entry if POST method is used.
- GET/POST
-
Delete Entry
- POST
/delete/<int:id> - Deletes an entry by ID.
- POST
-
Toggle Entry Cancellation
- POST
/toggle_canceled/<int:id> - Toggles the cancellation status of an entry by ID. The route changes the
cancelledstate of the entry to eitherTrueorFalsedepending on its current state. A successful operation will redirect back to the main page, updating the entry's status in the view.
- POST
-
API Data Access
- GET
/api/data - Returns all entries in JSON format, including additional attributes such as
date_formattedandindexwhich help in sorting and formatting entries relative to the current date.
- GET
-
Export Data
- GET
/export-data - Exports all entries and associated images as a zip file.
- GET
-
Batch Import
- POST
/batch-import - Imports a batch of entries from a JSON file. Note: This endpoint now also processes quotes.
- POST
-
Update Serial Entries
- POST
/update-serial-entries - Updates all entries linked to categories that are set to repeat annually, adjusting their dates to the current year.
- POST
-
Purge Old Entries
- POST
/purge-old-entries - Deletes all entries where the date is in the past and the category is not marked as protected.
- POST
The application includes full quote management functionality with both API endpoints and HTML views.
The quote selection system implements intelligent rotation with the following features:
-
Daily Quote Rotation: Daily quotes use a fair rotation system that ensures all quotes are shown before any quote repeats:
- The system selects quotes based on their
last_showndate, prioritizing those shown longest ago - Quotes never shown before (null
last_shown) are prioritized first - When multiple quotes have the same earliest
last_showndate, a deterministic tiebreaker using SHA-256 hash ensures consistent selection throughout the day - Each selected quote has its
last_showndate updated to today - Database transactions are properly handled with rollback on errors
- The system selects quotes based on their
-
Category Filtering: All endpoints support filtering by one or more categories:
- Single category:
?category=inspiration - Multiple categories:
?category=inspiration,motivation - Empty or whitespace-only categories are ignored
- The rotation system considers only quotes within the selected categories
- Category filtering is applied consistently throughout the selection process
- Single category:
-
Deterministic Selection: Daily quotes remain consistent throughout the day using a deterministic tiebreaker, ensuring all users see the same quote on a given day
-
Error Handling: Robust error handling with proper database transaction management and graceful fallbacks
-
Current Day Quote
- GET
/quotes/daily - Returns a JSON response containing a deterministically selected quote
- Quote selection is consistent throughout the day using the day as seed
- Uses fair rotation based on
last_showndates to ensure all quotes are cycled through - Optional query parameters:
category: Filter by category (e.g.,?category=inspiration,motivation)color: If present, generates a consistent background color based on the seed (e.g.,?color=true)
- GET
-
Random Quote
- GET
/quotes/random - Returns a JSON response containing a randomly selected quote
- Optional query parameters:
category: Filter by category (e.g., 8000?category=inspiration,motivation)color: If present, generates a random background color (e.g.,?color=true)
- GET
-
Daily Quote View
- GET
/quotes/daily/view - Returns a styled HTML page displaying the daily quote
- Uses same selection logic as the JSON endpoint
- Optional query parameters:
category: Filter by categorycolor: If present, generates a consistent background color based on the seed
- GET
-
Random Quote View
- GET
/quotes/random/view - Returns a styled HTML page displaying a random quote
- Uses same selection logic as the JSON endpoint
- Optional query parameters:
category: Filter by categorycolor: If present, generates a random background color
- GET
-
View and Manage Quotes
- GET
/quotes/ - Returns an HTML page displaying all quotes with management interface
- GET
-
Create Quote
- POST
/quotes/create - Creates a new quote
- Required fields:
text: Quote content (supports Markdown syntax including lists, emphasis, code blocks, and links) - max 1000 charactersauthor: Quote author - max 200 characters
- Optional fields:
category: Quote categoryurl: Reference URL
- Validation: Returns appropriate error messages for missing required fields or content that exceeds length limits
- POST
-
Update Quote
- POST
/quotes/edit/<int:id> - Updates existing quote
- Accepts same fields as create
- Validation: Returns appropriate error messages for missing required fields or content that exceeds length limits
- POST
-
Delete Quote
- POST
/quotes/delete/<int:id> - Deletes quote by ID
- POST
{
"id": 1,
"text": "The quote text",
"author": "Author Name",
"category": "Inspiration",
"url": "https://example.com/source",
"backgroundColor": "hsl(178, 70%, 30%)"
}The HTML views provide a styled presentation including:
- Markdown-formatted quote text (supports lists, emphasis, code blocks, and links)
- Author attribution
- Category tag (if present)
- Source link (if URL provided)
- Optional dynamic background color
- Responsive layout
- Consistent styling across different screen sizes
-
View and Manage Categories
- GET/POST
/categories - Displays and allows management of categories including creation and update.
- GET/POST
-
Update Category
- POST
/categories/update/<int:id> - Allows updating details for a specific category by ID.
- POST
-
Delete Category
- POST
/categories/delete/<int:id> - Deletes a category if it is not associated with any entries.
- POST
Below is the database schema visualized using a Mermaid diagram:
classDiagram
class Category {
+int id
+string name : unique, not null
+string symbol : not null
+string color_hex : not null
+bool repeat_annually : default=false, not null
+bool display_celebration : default=false, not null
+bool is_protected : default=false, not null
+string last_updated_by : nullable [IP of last editor]
}
class Entry {
+int id
+string date : not null
+int category_id : ForeignKey, not null
+Category category : relationship
+string title : not null
+string description : nullable
+string image_filename : nullable
+string url : nullable
+bool cancelled : default=false, not null
+string last_updated_by : nullable [IP of last editor]
}
class Quote {
+int id
+string text : not null
+string author : not null
+string category : nullable
+string url : nullable
+string last_updated_by : nullable [IP of last editor]
+date last_shown : nullable [Date when quote was last shown as daily quote]
}
Category "1" o-- "*" Entry
This application supports integration with Grafana through a Simple JSON Datasource, enabling Grafana to pull data for visualization purposes. Here are the endpoints provided for Grafana:
-
Test Connection (
GET /grafana/)- Confirms the data source connection is functional.
-
Search (
POST /grafana/search)- Returns a list of categories that can be queried (e.g., 'cake', 'birthday').
-
Query (
POST /grafana/query)- Retrieves timeseries data based on specified categories.
-
Annotations (
POST /grafana/annotations)- Delivers event annotations for graph overlays based on specific queries.
-
Tag Keys (
POST /grafana/tag-keys)- Provides tag keys for Grafana's ad hoc filtering capabilities.
-
Tag Values (
POST /grafana/tag-values)- Supplies values for the selected tag keys for further filtering.
Query Grafana for timeseries data in the 'cake' category using this curl command:
curl -X POST http://127.0.0.1:5000/grafana/query -H "Content-Type: application/json" -d '{"targets":[{"target": "Cake", "type": "timeserie"}]}'This command will return timeseries data points for the 'cake' category if such data exists. Ensure the Grafana Simple JSON Datasource plugin is installed and properly configured to interact with these endpoints.
The Calendarium application features integration with the Giphy API to enhance the user interface with dynamic content. There are two different implementations of this integration, tailored to different deployment environments and security concerns.
In environments where the backend server has internet access, the application can directly interact with the Giphy API. This method involves the backend making API requests to Giphy and securely managing the API key via environment variables.
- Endpoint:
/search_gifs - Method:
GET - Function: This endpoint takes a search query as a parameter, directly calls the Giphy API, and returns the GIF data. This keeps the API key secure and not exposed to the client-side.
Example usage:
curl http://127.0.0.1:5000/search_gifs?q=catsThis implementation is found in the JavaScript file search_gifs.js.
For environments where the backend does not have direct internet access, we employ a proxied approach. Here, the backend generates a URL with the API key, which is then used by the frontend to make the Giphy API call. This method ensures that the API key is not exposed in the client-side code.
- Backend Endpoint:
/get-giphy-url - Method:
GET - Function: This endpoint constructs the request URL including the API key and returns it to the client. The client then uses this URL to fetch GIF data directly from Giphy.
Example usage:
curl http://127.0.0.1:5000/get-giphy-url?q=catsThis implementation is located in the JavaScript file search_gifs_proxied.js.
These methods are designed to accommodate different network security policies while maintaining functionality and protecting sensitive information.
This project uses Flickity, which is licensed under the GPLv3.
As such, modifications to the Flickity source code used in this project are documented in the repository. To comply with the GPLv3, all source code for this application is available under the same license. The full license text is included in the LICENSE file in this repository.
This project uses the icon "cracked glass" by Olena Panasovska from Noun Project licensed under CC BY 3.0. To meet the attribution requirements, this link points directly to the icon's detail page. Please refer to the Noun Project's guidelines for detailed information on how to properly attribute the creator in different formats and mediums.
Instead of Docker Hub, this project's Docker images are now built and pushed through GitHub Actions to the GitHub Container Registry.