patterns-crud

Find it fast

sed -n '<from>,<to>p' SKILL.md one section rather than reading the file; ./mxcli syntax <topic> answers how do I write this for a fraction of either.

lines	section
29-37	Naming Conventions
38-67	Save Pattern (Create/Update)
68-107	Validation Pattern
108-131	Delete Pattern
132-155	Cancel Pattern
156-179	Create New Pattern
180-202	Data Source Pattern
203-224	Edit Pattern
225-238	Complete CRUD Set
239-246	Best Practices

CRUD Action Patterns

Standard patterns for Create, Read, Update, Delete operations on entities.

Naming Conventions

Prefix	Purpose	Example
ACT_	Action microflow (page button)	ACT_Customer_Save
VAL_	Validation microflow	VAL_Customer_Save
DS_	Data source microflow	DS_Customer_GetAll
SUB_	Sub-microflow (internal)	SUB_Customer_SendEmail

Save Pattern (Create/Update)

Used for Save buttons on NewEdit pages.

mdl 1;
/**
 * Save action for Customer NewEdit page
 * Validates, commits, and closes the page
 *
 * @param $Customer The customer to save
 * @returns true if saved successfully
 */
create microflow Module.ACT_Customer_Save (
  $Customer: Module.Customer
)
returns boolean
begin
  -- Validate first
  $IsValid = call microflow Module.VAL_Customer_Save(Customer = $Customer);

  if $IsValid then
    commit $Customer;
    close page;
  end if;

  return $IsValid;
end;

Validation Pattern

Companion validation microflow for Save actions.

mdl 1;
/**
 * Validate Customer before save
 *
 * @param $Customer The customer to validate
 * @returns true if valid
 */
create microflow Module.VAL_Customer_Save (
  $Customer: Module.Customer
)
returns boolean
begin
  declare $IsValid boolean = true;

  -- Required field validation
  if $Customer/Name = empty then
    validation feedback $Customer/Name message 'Name is required';
    set $IsValid = false;
  end if;

  if $Customer/Email = empty then
    validation feedback $Customer/Email message 'Email is required';
    set $IsValid = false;
  end if;

  -- Business rule validation
  if $Customer/CreditLimit < 0 then
    validation feedback $Customer/CreditLimit message 'Credit limit cannot be negative';
    set $IsValid = false;
  end if;

  return $IsValid;
end;