This repository has been archived by the owner on Oct 28, 2024. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 39
/
TODO
84 lines (74 loc) · 3.27 KB
/
TODO
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
See below for a list of completed items. Things still in progress (roughly in
order of priority):
*) Cache a user-object upon login in memcache
*) Begin using the g request global where possible
*) Scripting via Flask-Script (both shell setup and cron-like jobs)
*) Change the User model so that specific attributes call the appropriate SQL
to update the parameters in the database. Most of User is populated via a
VIEW.
*) Support gettext()
*) Add a file that handles all of the neuances of integrating Babel and accounts
*) Unit testing framework
*) Migrate to using setup.py instead of providing a fixed requirements.txt
*) Services API example (XML, maybe protobuf)
*) pgmemcache
*) Example of sending mail
*) Remaining session tedium:
*) Beef up the @logged_in decorator so that it:
a) checks memcache for a matching session
b) Logs a user out if their session has expired (or updates it accordingly)
c) Populates memcache with a user object upon cache miss
*) Loop detection for clients that have cookies disabled
*) Add no cookie page
*) Add support for insecure and secure cookies
*) Reissue cookie id's older than 24hrs
*) Cookies can have their freshness reset after 10min of life. A cookie
looses its fresh status after 20min of total life if not
refreshed. Each cookie has a timestamp that it was issued, a min
renewal time and a max freshness life.
*) Include the level of strength of the authenticated session (password,
old/renewed token, or 2FA auth'ed token)
*) Integrate/use Flask-Login where possible?
*) Add authorization decorators. Each session id needs to be given an
authorization token that gets refreshed every 300sec. User
automatically gets redirected from the decorator with the missing or
expired token and requests an authorization token that lasts for a
given app for 300sec.
*) Logout = kill session in memcache
Alpha sorted list of demonstrated components (some better than others):
AAA (Access, Authentication, Authorization):
*) Login (via pl functions)
*) Logout
*) Registration
Application:
*) Integration with other WSGI Middleware's
*) Modularized development (filesystem layout)
*) Basic profile management
*) Session management (secure cookie handling)
*) Static assets management
Database (PostgreSQL):
*) Give each "application class" different database users to connect as
*) Ordered list of .sql files to execute in order to recreate (and
maintain) the database.
*) ORM Layer and examples
*) PostgreSQL pl functions
*) Use schemas as a management tool for setting correct permissions
*) Use a "DBA" role for owning objects and a DBA user for per-user
connections
*) Support two DBA roles per user, a read-only acount that lets a DBA see
the entire database (but not make changes), and a read-write account
that gives the user write privileges. Think of it like being an "admin"
and then having to "sudo to the root UID" to complete any real work.
Caching (memcached):
*) memoized functions
*) Objects
*) Views
Development:
*) Application profiling
*) Debugging toolbar
ORM (SQLAlchemy):
*) Declarative table use
*) Use of PostgreSQL functions with SQLAlchemy
Templating (Jinja2):
*) Template filters
*) Template layout