Module Gnumed.business.gmExternalCare
GNUmed external care classes.
Functions
def create_external_care_item(pk_health_issue=None, issue=None, pk_org_unit=None, pk_encounter=None)-
Expand source code
def create_external_care_item(pk_health_issue=None, issue=None, pk_org_unit=None, pk_encounter=None): args = { 'pk_health_issue': pk_health_issue, 'issue': issue, 'pk_org_unit': pk_org_unit, 'enc': pk_encounter } cmd = """ INSERT INTO clin.external_care ( issue, fk_health_issue, fk_encounter, fk_org_unit ) VALUES ( gm.nullify_empty_string(%(issue)s), (CASE WHEN gm.is_null_or_blank_string(%(issue)s) IS TRUE THEN %(pk_health_issue)s ELSE NULL END)::integer, %(enc)s, %(pk_org_unit)s ) RETURNING pk""" rows = gmPG2.run_rw_queries(queries = [{'sql': cmd, 'args': args}], return_data = True) return cExternalCareItem(aPK_obj = rows[0]['pk']) def delete_external_care_item(pk_external_care=None)-
Expand source code
def delete_external_care_item(pk_external_care=None): args = {'pk': pk_external_care} cmd = "DELETE FROM clin.external_care WHERE pk = %(pk)s" gmPG2.run_rw_queries(queries = [{'sql': cmd, 'args': args}]) return True def get_external_care_items(order_by=None,
pk_identity=None,
pk_health_issue=None,
exclude_inactive=False,
return_pks=False)-
Expand source code
def get_external_care_items(order_by=None, pk_identity=None, pk_health_issue=None, exclude_inactive=False, return_pks=False): args = { 'pk_pat': pk_identity, 'pk_issue': pk_health_issue } where_parts = [] if pk_identity is not None: where_parts.append('pk_identity = %(pk_pat)s') if pk_health_issue is not None: where_parts.append('pk_health_issue = %(pk_issue)s') if exclude_inactive is True: where_parts.append('inactive IS FALSE') if len(where_parts) == 0: where = 'TRUE' else: where = ' AND '.join(where_parts) if order_by is not None: where = '%s ORDER BY %s' % ( where, order_by ) cmd = _SQL_get_external_care_items % where rows = gmPG2.run_ro_queries(queries = [{'sql': cmd, 'args': args}]) if return_pks: return [ r['pk_external_care'] for r in rows ] return [ cExternalCareItem(row = {'data': r, 'pk_field': 'pk_external_care'}) for r in rows ]
Classes
class cExternalCareItem (aPK_obj: int | dict = None, row: dict = None, link_obj=None)-
Expand source code
class cExternalCareItem(gmBusinessDBObject.cBusinessDBObject): """Represents an external care item. Note: Upon saving .issue being (non-empty AND not None) will override .fk_health_issue (IOW, if your code wants to set .fk_health_issue to something other than NULL it needs to unset .issue explicitly (to u'' or None)). """ _cmd_fetch_payload = _SQL_get_external_care_items % "pk_external_care = %s" _cmds_store_payload = [ """UPDATE clin.external_care SET comment = gm.nullify_empty_string(%(comment)s), fk_encounter = %(pk_encounter)s, issue = gm.nullify_empty_string(%(issue)s), provider = gm.nullify_empty_string(%(provider)s), fk_org_unit = %(pk_org_unit)s, inactive = %(inactive)s, fk_health_issue = ( CASE WHEN gm.is_null_or_blank_string(%(issue)s) IS TRUE THEN %(pk_health_issue)s ELSE NULL END )::integer WHERE pk = %(pk_external_care)s AND xmin = %(xmin_external_care)s RETURNING xmin AS xmin_external_care """, _SQL_get_external_care_items % "pk_external_care = %(pk_external_care)s" ] _updatable_fields = [ 'pk_encounter', 'pk_health_issue', 'pk_org_unit', 'issue', 'provider', 'comment', 'inactive' ] #-------------------------------------------------------- def format(self, with_health_issue=True, with_address=False, with_comms=False): lines = [] lines.append(_('External care%s #%s') % ( gmTools.bool2subst ( self._payload['inactive'], ' (%s)' % _('inactive'), '', ' [ERROR: .inactive is NULL]' ), self._payload['pk_external_care'] )) if with_health_issue: if self._payload['pk_health_issue'] is None: lines.append(' ' + _('Issue: %s') % self._payload['issue']) else: lines.append(' ' + _('Health issue: %s') % self._payload['issue']) lines.append(' (' + _('also treated here') + ')') if self._payload['provider'] is not None: lines.append(' ' + _('Provider: %s') % self._payload['provider']) lines.append(' ' + _('Location: %s@%s') % (self._payload['unit'], self._payload['organization'])) unit = self.org_unit if with_address: adr = unit.address if adr is not None: lines.extend(adr.format()) if with_comms: for comm in unit.comm_channels: lines.append(' %s: %s%s' % ( comm['l10n_comm_type'], comm['url'], gmTools.bool2subst(comm['is_confidential'], _(' (confidential)'), '', '') )) if self._payload['comment'] is not None: lines.append('') lines.append(' ' + self._payload['comment']) return lines #-------------------------------------------------------- def _get_org_unit(self): return gmOrganization.cOrgUnit(self._payload['pk_org_unit']) org_unit = property(_get_org_unit)Represents an external care item.
Note: Upon saving .issue being (non-empty AND not None) will override .fk_health_issue (IOW, if your code wants to set .fk_health_issue to something other than NULL it needs to unset .issue explicitly (to u'' or None)).
Call init from child classes like so:
super().__init__(aPK_obj = aPK_obj, row = row, link_obj = link_obj)Args
aPK_obj- retrieve data from backend
- an scalar value the ._cmd_fetch_payload WHERE condition must be a simple column: "… WHERE pk_col = %s"
- a dictionary of values the ._cmd_fetch_payload WHERE condition must consume the dictionary and produce a unique row
row- must hold the fields
- data: list of column values for the row selected by ._cmd_fetch_payload (as returned by cursor.fetchone() in the DB-API)
- pk_field: the name of the primary key column OR
- pk_obj: a dictionary suitable for being passed to cursor.execute and holding the primary key values, used for composite PKs
- for example:
row = { 'data': rows[0], 'pk_field': 'pk_XXX (the PK column name)', 'pk_obj': {'pk_col1': pk_col1_val, 'pk_col2': pk_col2_val} } rows = gmPG2.run_ro_queries(queries = [{'sql': cmd, 'args': args}]) objects = [ cChildClass(row = {'data': r, 'pk_field': 'the PK column name'}) for r in rows ]
Ancestors
Instance variables
prop org_unit-
Expand source code
def _get_org_unit(self): return gmOrganization.cOrgUnit(self._payload['pk_org_unit'])
Inherited members