diff --git a/conservancy_beancount/reports/query.py b/conservancy_beancount/reports/query.py index 7385c86d58530d855dd60defa7a4e05c5a975aae..ad8e04f443db51bdfc7662a3a9e2cded59812987 100644 --- a/conservancy_beancount/reports/query.py +++ b/conservancy_beancount/reports/query.py @@ -224,6 +224,12 @@ class DBId(DBColumn): _dtype = int +class DBName(DBColumn): + """Look up an entity's display name from the database""" + _db_query = "SELECT display_name FROM donor WHERE ledger_entity_id = ?" + _dtype = str + + class DBPostal(DBColumn): """Look up an entity's postal addresses from the database""" _db_query = """ @@ -444,10 +450,12 @@ class _EnvironmentMixin: except (OSError, sqlite3.Error): columns['db_email'] = DBEmail columns['db_id'] = DBId + columns['db_name'] = DBName columns['db_postal'] = DBPostal else: columns['db_email'] = DBEmail.with_db(db_conn) columns['db_id'] = DBId.with_db(db_conn) + columns['db_name'] = DBName.with_db(db_conn) columns['db_postal'] = DBPostal.with_db(db_conn) rt_credentials = config.rt_credentials() diff --git a/setup.py b/setup.py index 1a7365258462beadc1f16c7b5f16e8ebc167e642..52f67e8f2c2b306bba26509263ac5ea9a8146ed0 100755 --- a/setup.py +++ b/setup.py @@ -5,7 +5,7 @@ from setuptools import setup setup( name='conservancy_beancount', description="Plugin, library, and reports for reading Conservancy's books", - version='1.19.5', + version='1.19.6', author='Software Freedom Conservancy', author_email='info@sfconservancy.org', license='GNU AGPLv3+',