• 1 Post
  • 19 Comments
Joined 1 year ago
Cake day: June 12th, 2023
  • idle@158436977.xyztoSelfhosted@lemmy.world•Configurable self-hosted "personal dashboard"?English
    2·
    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`