Module `dbops.db_utils`

db utility functions

Functions

def clone_as_new_case(existing: dict[str, typing.Any]) ‑> dict[str, typing.Any]: Create a copy of a case from the DB such that it can be imported under a new ID. Also clears patient_info, schedule, and input from the existing case to avoid updates to the existing case's db data.
def db_check(select_only=False, common_db=False): decorator for funcs with DB interactiosn to ensure connectivity and log transaction data.
def initialize_data_entry_fields(job: dict[str, typing.Any]) ‑> dict[str, typing.Any]: initialize data entry fields data as vStr custom attrs
def minimized_query(query_string) ‑> str: convenience function for eliminating superfluous whitespace from query strings.
def set_db_globals(db_host, db_user, db_pwd, db_name, no_db) ‑> bool: sets globabl variables for module to be used in all subsequent db ops. called by extract_s3.py

Classes

class TrimEncoder (*args, **kwargs)

Custom json encoder for pretty printing nested dicts

Constructor for JSONEncoder, with sensible defaults.

If skipkeys is false, then it is a TypeError to attempt encoding of keys that are not str, int, float or None. If skipkeys is True, such items are simply skipped.

If ensure_ascii is true, the output is guaranteed to be str objects with all incoming non-ASCII characters escaped. If ensure_ascii is false, the output can contain non-ASCII characters.

If check_circular is true, then lists, dicts, and custom encoded objects will be checked for circular references during encoding to prevent an infinite recursion (which would cause an RecursionError). Otherwise, no such check takes place.

If allow_nan is true, then NaN, Infinity, and -Infinity will be encoded as such. This behavior is not JSON specification compliant, but is consistent with most JavaScript based encoders and decoders. Otherwise, it will be a ValueError to encode such floats.

If sort_keys is true, then the output of dictionaries will be sorted by key; this is useful for regression tests to ensure that JSON serializations can be compared on a day-to-day basis.

If indent is a non-negative integer, then JSON array elements and object members will be pretty-printed with that indent level. An indent level of 0 will only insert newlines. None is the most compact representation.

If specified, separators should be an (item_separator, key_separator) tuple. The default is (', ', ': ') if indent is None and (',', ': ') otherwise. To get the most compact JSON representation, you should specify (',', ':') to eliminate whitespace.

If specified, default is a function that gets called for objects that can't otherwise be serialized. It should return a JSON encodable version of the object or raise a TypeError.

Ancestors

json.encoder.JSONEncoder

Methods

def encode(self, o)

Return a JSON string representation of a Python data structure.

>>> from json.encoder import JSONEncoder
>>> JSONEncoder().encode({"foo": ["bar", "baz"]})
'{"foo": ["bar", "baz"]}'