WkpmEvis

1import sqlite3
2from typing import namedtuple
3
4class Environment(NamedTuple):
5    SLACK_CLIENT_ID: str
6    SLACK_CLIENT_SECRET: str
7    SECRET_KEY: str
8        
9conn = sqlite3.connect('config.db')
10conn.row_factory = sqlite3.Row
11
12cur = conn.execute('SELECT * FROM environment')
13res = cur.fetchall()
14env = Environment(**{r['name']: r['value'] for r in res})
15# env == Environment(SLACK_CLIENT_ID='1234.5678', SLACK_CLIENT_SECRET='akshdfjhafhadf', SECRET_KEY='verysecret')