-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathapp.py
107 lines (91 loc) · 2.89 KB
/
app.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
from flask import Flask, request
from data import get_user_cards, get_users, get_user, get_transitive_reports, get_direct_reports
app = Flask(__name__)
page = """<html><head>
<style>
a {{
text-decoration: none;
}}
a:hover {{
text-decoration: underline;
}}
.sql {{
font-family: monospace;
background-color: #EEE;
border: 2px solid #888;
padding: 15px;
margin-top: 5px;
}}
.oso-fragment {{
color: blue;
}}
.code {{
font-family: monospace;
}}
</style>
</head><body>{}</body></html>""".format
@app.route("/users")
def html_users():
past = request.args.get("past")
users_data = get_users(past)
if not users_data['users']:
return page("<h3>Users</h3><em>No results</em>")
users_list = ''.join(
f"""<li><a href="/users/{user['user_id']}/cards">{user['name']}</li>"""
for user in users_data['users']
)
return page(f"""
<h3>Users</h3>
<ul>{users_list}</ul>
<a href="/users?past={users_data['past']}">Next Page</a>
""")
@app.route("/users/<user_id>/cards")
def html_user_cards(user_id):
past = request.args.get("past")
user = get_user(user_id)
if user is None:
return page(f"""
<a href="/users">< Users</a>
<br />
<h3><em>User not found</em></h3>
""")
reports = get_transitive_reports(user_id)
direct_reports = get_direct_reports(user_id)
cards_data = get_user_cards(user_id, past)
cards_list = ''.join(
f"<li>{card['card_id']} (owner: <a href='/users/{card['owner_id']}/cards'>{card['owner']}</a>)</li>"
if 'owner' in card else f"<li>{card['card_id']}</li>"
for card in cards_data['cards']
) or "No results"
next_page_button = f"""<a href="/users/{user_id}/cards?past={cards_data['past']}">Next Page</a>""" if cards_data['past'] else ""
manager_line = f"""<li>Manager: <a href="/users/{user['manager_id']}/cards">{user['manager_name']}</a></li>""" if user['manager_id'] else ""
sql_html = (
cards_data['sql']
.replace(cards_data['oso_fragment'], f"<span class='oso-fragment'>{cards_data['oso_fragment']}</span>")
.replace("\n", "<br />")
)
query_time = f"{cards_data['query_time'] * 1000:.2f}"
return page(f"""
<a href="/users">< Users</a>
<h1>{user['name']}</h1>
<ul>
<li>{len(reports)} transitive reports</li>
<li>{len(direct_reports)} direct reports</li>
{manager_line}
</ul>
<div>
<h3>Cards ({cards_data['total_cards']} total)</h3>
<ul>{cards_list}</ul>
{next_page_button}
</div>
<hr>
<div>
<h3>Cards Query</h3>
<p>
This is the full Postgres query to fetch cards this user is allowed to view.
The section in blue is the authorization filter returned by <span class="code">oso.list_local</span>.
</p>
Query ran in {query_time}ms
<div class="sql">{sql_html}</div>
</div>
""")