def where_clindocs_current(viewmaker: ViewMaker) -> None:
if not viewmaker.progargs.clindocs_current_only:
return
viewmaker.add_where(
"{bt}.{last_doc_col} = 1 AND {bt}.DeletedDate IS NULL".format(
bt=viewmaker.basetable, last_doc_col=CRATE_COL_LAST_DOC))
viewmaker.record_lookup_table_keyfield(viewmaker.basetable, 'DeletedDate')
viewmaker.enforce_same_n_rows_as_base = False
def simple_view_where(viewmaker: ViewMaker,
where_clause: str,
index_cols: Iterable[str] = None) -> None:
assert where_clause, "Missing where_clause"
index_cols = index_cols or []
viewmaker.add_where(where_clause)
# noinspection PyTypeChecker
for col in index_cols:
viewmaker.record_lookup_table_keyfield(viewmaker.basetable, col)
def where_prognotes_current(viewmaker: ViewMaker) -> None:
if not viewmaker.progargs.prognotes_current_only:
return
viewmaker.add_where(
"({bt}.EnteredInError <> 1 OR {bt}.EnteredInError IS NULL) "
"AND {bt}.{last_note_col} = 1".format(
bt=viewmaker.basetable, last_note_col=CRATE_COL_LAST_NOTE))
viewmaker.record_lookup_table_keyfield(viewmaker.basetable,
'EnteredInError')
viewmaker.enforce_same_n_rows_as_base = False
def rio_amend_standard_noncore(viewmaker: ViewMaker) -> None:
# Add user:
rio_add_user_lookup(viewmaker,
"type12_UpdatedBy",
column_prefix="Updated_By",
internal_alias_prefix="ub")
# Omit deleted:
viewmaker.add_where(
"{bt}.type12_DeletedDate IS NULL".format(bt=viewmaker.basetable))
viewmaker.record_lookup_table_keyfield(viewmaker.basetable,
'type12_DeletedDate')
viewmaker.enforce_same_n_rows_as_base = False
def where_not_deleted_flag(viewmaker: ViewMaker, basecolumn: str) -> None:
assert basecolumn, "Missing basecolumn"
viewmaker.add_where("({table}.{col} IS NULL OR {table}.{col} = 0)".format(
table=viewmaker.basetable, col=basecolumn))
viewmaker.record_lookup_table_keyfield(viewmaker.basetable, basecolumn)
viewmaker.enforce_same_n_rows_as_base = False
