As Redrossa, I can format my input files, which will insert all optional columns into them

[redrossa]

Description

The current workflow on the integrity verification with the checksum file is bugged. When optional but essential columns like the ID is omitted in input records, the checksum produced fills in the ID, which errors out subsequent formatting because the input record still has omitted IDs, while the checksum doesn't, which evaluates to an invalid checksum. Furthermore, the checksum file produced as input for subsequent formatting puts an extra burden on the user workflow.

A proposed solution to address these issues are:

1. Formatting does not produce checksum file anymore, instead it edits the input files directly with the fully filled and correct values and columns.
2. A new column is added to store hash of each posted entry, this is supposed to not be edited by users
3. The integrity of a record is checked so that each row's hash equals the stored hash

Acceptance Criteria

• [x] Formatting does not produce checksum file
• [x] Formatting edits input record files directly and coerce it to the schema
• [x] Formatted records have all auto-calculable cells filled
• [x] Adds a new read-only column to store posted entry's hash, in place of the checksum file
• [ ] Record integrity is checked by equaling calculated entry's hash by its stored hash
• [ ] If integrity check fails, throw error
• [ ] CLI removes checksum file input argument
• [ ] CLI format mode only edits input files
• [ ] CLI compile mode formats and produces a compiled record file

[redrossa]

Definitions in a Record

• Column properties pertaining to status == 'posted':
  • Variability:
    1. fixed = once filled cannot be changed
    2. variable = can be changed
  • Optionality:
    1. required = must be manually filled
    2. optional = may be empty
• Column definitions:
  • transaction.id fixed optional
  • date fixed required
  • description variable optional
  • entity fixed required
  • category variable optional
  • amount fixed required
  • ~worth fixed optional~
  • status variable required
  • account.name fixed required
  • account.mask fixed required
  • account.type fixed required
  • account.subtype fixed required
  • balance.current variable optional
  • balance.available variable optional
  • balance.limit fixed optional
  • hash fixed optional

[redrossa]

Properties of a Record

• Pending entries can be altered in any way
• Posted entries column values must follow the properties above
• Posted entries cannot be deleted
• The current balance of the first entry of an account is the opening balance of that account
• An entry with equal entity and account name is a "no-op" entry that's supposed to show the current balance of the account at that entry