I would like to have a screen in my home displaying a summary of different information that is relevant to me, like weather forecast, bus/train times, news headlines, etc. I was planning to use a Raspberry Pi and either buy a screen to display the information or just show it on my TV. It could probably be as simple as serving a page with HTML and JavaScript and then displaying it in a full screen web browser.

I feel like this is probably something that a lot of people want so I am wondering if there is something out there already that can easily be extended with custom “widgets”. Nextcloud actually has a dashboard that’s a bit like this but ideally I’d like something that is standalone and easier to extend with my own widgets.

Anyone have any recommendations?

    • idle@158436977.xyzEnglish
      1·
      1 year ago

      Keep in mind they are hacked together and were not meant for mass consumption. Here is an example of one of the scripts that contacts the gitea api and inserts the most recent 10 issues into Flames database with a specific category.

      `import sqlite3 from datetime import datetime import requests import re import json from datetime import datetime, timezone

      def insert_bookmark(name, url, category_id, order_id): conn = sqlite3.connect(‘/app/db.sqlite’) cursor = conn.cursor()

      cursor.execute("SELECT MAX(id) FROM bookmarks")
result = cursor.fetchone()
max_id = result[0] if result[0] else 0

current_time = datetime.now().strftime('%Y-%m-%d %H:%M:%S.%f %z')
values = (name, url, category_id, "", current_time, current_time, 0, order_id)

cursor.execute("INSERT INTO bookmarks (name, url, categoryId, icon, createdAt, updatedAt, isPublic, orderId) VALUES (?, ?, ?, ?, ?, ?, ?, ?);", values)

max_id += 1

conn.commit()
conn.close()

return max_id

      def delete_bookmark(category_id): conn = sqlite3.connect(‘/app/db.sqlite’) cursor = conn.cursor() cursor.execute(“DELETE FROM bookmarks WHERE categoryId = ?”, (category_id,)) # Commit the changes and close the connection conn.commit() conn.close()

      def get_recently_updated_issues(repo_urls, user_name, api_token): headers = { “Authorization”: f"token {api_token}", “Content-Type”: “application/json” }

      all_issues = []

for repo_url, repo_name in repo_urls:
    api_url = repo_url

    # Query the Gitea API to get the issues
    response = requests.get(api_url, headers=headers, params={"state": "all"})
    response.raise_for_status()

    issues = response.json()

    sorted_issues = sorted(issues, key=lambda x: x["updated_at"], reverse=True)

    all_issues.extend(sorted_issues[:5])

sorted_all_issues = sorted(all_issues, key=lambda x: x["updated_at"], reverse=True)

recent_issue_titles = []
recent_issue_links = []
recent_timestamps = []

for issue in sorted_all_issues[:10]:
    title = issue["title"]
    link = issue["html_url"]
    timestamp = issue["updated_at"]

    recent_issue_titles.append(title)
    recent_issue_links.append(link)
    recent_timestamps.append(timestamp)

return recent_issue_titles, recent_issue_links, recent_timestamps

      repo_urls = [ (“https://gitea.example.com/api/v1/repos/user1/repo1/issues”, “repo1”), (“https://gitea.example.com/api/v1/repos/user1/repo2/issues”, “repo2”) ] user_name = “user1” api_token = “example token”

      delete_bookmark(8) order_id = 1

      recent_issue_titles, recent_issue_links, recent_timestamps = get_recently_updated_issues(repo_urls, user_name, api_token)

      for title, link, timestamp in zip(recent_issue_titles, recent_issue_links, recent_timestamps): print(“Issue Title:”, title) print(“Issue Link:”, link) print(“Last Updated:”, timestamp) print() bookmark_id = insert_bookmark(title, link, 8, order_id) order_id += 1`