def temp_debug(a_session, bug_explore, row_cache): """ do not delete - see description in nw/tests/upd_order_reuse """ for each_instance in a_session.dirty: table_name = each_instance.__tablename__ if table_name.startswith("OrderDetail"): bug_explore[0] = each_instance else: bug_explore[1] = each_instance order_detail_first = False # true triggers defer if order_detail_first: each_instance = bug_explore[0] old_row = get_old_row(each_instance) logic_row = LogicRow(row=each_instance, old_row=old_row, ins_upd_dlt="upd", nest_level=0, a_session=a_session, row_sets=row_cache) logic_row.update(reason="client") each_instance = bug_explore[1] old_row = get_old_row(each_instance) logic_row = LogicRow(row=each_instance, old_row=old_row, ins_upd_dlt="upd", nest_level=0, a_session=a_session, row_sets=row_cache) logic_row.update(reason="client") else: each_instance = bug_explore[1] old_row = get_old_row(each_instance) logic_row = LogicRow(row=each_instance, old_row=old_row, ins_upd_dlt="upd", nest_level=0, a_session=a_session, row_sets=row_cache) logic_row.update(reason="client") each_instance = bug_explore[0] old_row = get_old_row(each_instance) logic_row = LogicRow(row=each_instance, old_row=old_row, ins_upd_dlt="upd", nest_level=0, a_session=a_session, row_sets=row_cache) logic_row.update(reason="client")
def order_flush_dirty(a_row, a_session: session): """ Called from module init on before_flush E.g., altering an Order ShippedDate (we must adjust Customer balance) """ old_row = get_old_row(a_row) order_update(a_row, old_row, a_session)
def customer_flush_dirty(a_row, a_session: session): """ Called from listeners.py on before_flush """ old_row = get_old_row(a_row) row_prt(a_row, "\ncustomer_flush_dirty") customer_update(a_row, old_row, a_session)
def order_detail_flush_dirty(a_row: models.OrderDetail, a_session: session): old_row = get_old_row(a_row) # type: models.OrderDetail if a_row.OrderId == old_row.OrderId: if a_row.ProductId != old_row.ProductId: product = a_session.query(models.Product). \ filter(models.Product.Id == a_row.ProductId).one() a_row.UnitPrice = product.UnitPrice a_row.Amount = a_row.UnitPrice * a_row.Quantity if a_row.Amount != old_row.Amount: order = a_row.OrderHeader order.AmountTotal += a_row.Amount - old_row.Amount old_order = ObjectView(row2dict(order)) order_update(order, old_order, a_session) row_prt( order, "order_detail_flush_dirty adjusted to: " + str(order.AmountTotal)) else: # moved item to different order order = a_row.OrderHeader # reduce the old one order.AmountTotal -= old_row.Amount old_order = ObjectView(row2dict(order)) order_update(order, old_order, a_session) row_prt( order, "order_detail_flush_dirty adjusted to: " + str(order.AmountTotal)) if a_row.ProductId != old_row.ProductId: product = a_session.query(models.Product). \ filter(models.Product.Id == old_row.ProductId).one() a_row.UnitPrice = product.UnitPrice a_row.Amount = a_row.UnitPrice * a_row.Quantity order = a_session.query(models.Order). \ filter(models.Order.Id == a_row.OrderId).one() old_order = ObjectView(row2dict(order)) order.AmountTotal += a_row.Amount order_update(order, old_order, a_session) row_prt( order, "order_detail_flush_dirty adjusted to: " + str(order.AmountTotal))
def before_flush(a_session: session, a_flush_context, an_instances): """ Logic Execution processes LogicRows: row and old_row Note old_row is critical for: * user logic (did the value change? by how much?) * performance / pruning (skip rules iff no dependent values change) * performance / optimization (1 row adjustments, not expensive select sum/count) """ """ Logic Phase """ logic_bank.logic_logger.debug("Logic Phase:\t\tROW LOGIC (sqlalchemy before_flush)\t\t\t") # print("\n***************** sqlalchemy calls logic_bank\n") row_sets = RowSets() # type : RowSet for each_instance in a_session.dirty: row_sets.add_submitted(each_instance) bug_explore = None # None to disable, [None, None] to enable if bug_explore is not None: # temp hack - order rows to explore bug (upd_order_reuse) temp_debug(a_session, bug_explore, row_sets) else: for each_instance in a_session.dirty: table_name = each_instance.__tablename__ old_row = get_old_row(each_instance) logic_row = LogicRow(row=each_instance, old_row=old_row, ins_upd_dlt="upd", nest_level=0, a_session=a_session, row_sets=row_sets) logic_row.update(reason="client") for each_instance in a_session.new: table_name = each_instance.__tablename__ logic_row = LogicRow(row=each_instance, old_row=None, ins_upd_dlt="ins", nest_level=0, a_session=a_session, row_sets=row_sets) logic_row.insert(reason="client") for each_instance in a_session.deleted: table_name = each_instance.__tablename__ logic_row = LogicRow(row=each_instance, old_row=None, ins_upd_dlt="dlt", nest_level=0, a_session=a_session, row_sets=row_sets) logic_row.delete(reason="client") """ Commit Logic Phase """ logic_bank.logic_logger.debug("Logic Phase:\t\tCOMMIT \t\t\t\t\t\t\t\t\t") processed_rows = dict.copy(row_sets.processed_rows) for each_logic_row_key in processed_rows: each_logic_row = processed_rows[each_logic_row_key] logic_bank.engine_logger.debug("visit: " + each_logic_row.__str__()) commit_row_events = rule_bank_withdraw.rules_of_class(each_logic_row, CommitRowEvent) for each_row_event in commit_row_events: each_logic_row.log("Commit Event") each_row_event.execute(each_logic_row) """ Proceed with sqlalchemy flush processing """ logic_bank.logic_logger.debug("Logic Phase:\t\tFLUSH (sqlalchemy flush processing \t")
def customer_commit_dirty(a_row, a_session: session): old_row = get_old_row(a_row) row_prt(a_row, "order_commit_dirty")
def order_detail_commit_dirty(a_row, a_session: session): old_row = get_old_row(a_row) row_prt(a_row, "\norder_detail_commit_dirty")
def before_flush(a_session: session, a_flush_context, an_instances): """ Logic Execution processes LogicRows: row and old_row Note old_row is critical for: * user logic (did the value change? by how much?) * performance / pruning (skip rules iff no dependent values change) * performance / optimization (1 row adjustments, not expensive select sum/count) """ """ Logic Phase """ logic_bank.logic_logger.info(f'Logic Phase:\t\tROW LOGIC(session={str(hex(id(a_session)))}) (sqlalchemy before_flush)\t\t\t') row_sets = RowSets() # type : RowSet client_inserts = [] for each_instance in a_session.dirty: row_sets.add_submitted(each_instance) for each_instance in a_session.new: row_sets.add_submitted(each_instance) """ inserts first... SQLAlchemy queues these on a_session.new (but *not* updates!) so, process the client changes, so that triggered inserts (eg. audit) aren't run twice """ client_inserts.append(each_instance) bug_explore = None # None to disable, [None, None] to enable if bug_explore is not None: # temp hack - order rows to explore bug (upd_order_reuse) temp_debug(a_session, bug_explore, row_sets) else: for each_instance in a_session.dirty: old_row = get_old_row(each_instance, a_session) logic_row = LogicRow(row=each_instance, old_row=old_row, ins_upd_dlt="upd", nest_level=0, a_session=a_session, row_sets=row_sets) logic_row.update(reason="client") for each_instance in client_inserts: # a_session.new: logic_row = LogicRow(row=each_instance, old_row=None, ins_upd_dlt="ins", nest_level=0, a_session=a_session, row_sets=row_sets) logic_row.insert(reason="client") # if len(a_session.deleted) > 0: # print("deleting") for each_instance in a_session.deleted: logic_row = LogicRow(row=each_instance, old_row=None, ins_upd_dlt="dlt", nest_level=0, a_session=a_session, row_sets=row_sets) logic_row.delete(reason="client") """ Commit Logic Phase """ logic_bank.logic_logger.info(f'Logic Phase:\t\tCOMMIT(session={str(hex(id(a_session)))}) \t\t\t\t\t\t\t\t\t\t') processed_rows = dict.copy(row_sets.processed_rows) # set in LogicRow ctor for each_logic_row_key in processed_rows: each_logic_row = processed_rows[each_logic_row_key] logic_bank.engine_logger.debug("visit: " + each_logic_row.__str__()) commit_row_events = rule_bank_withdraw.rules_of_class(each_logic_row, CommitRowEvent) for each_row_event in commit_row_events: each_logic_row.log("Commit Event") each_row_event.execute(each_logic_row) """ Proceed with sqlalchemy flush processing """ logic_bank.logic_logger.info(f'Logic Phase:\t\tFLUSH(session={str(hex(id(a_session)))}) (sqlalchemy flush processing) \t')