SwissChecklist

Checklist: BUDev - SwissChecklist - Test Saving Functionality - Full Test

Use this Checklist to test saving in SwissChecklist. As this is a core feature of SwissChecklist, you must use this before you publish software changes.
  • Test Saving a Brand New Template

    Show Details Show Substeps Show Substeps Show Substeps
  • Create a new template, do this in the sandbox or somewhere

    Show Details Show Substeps Show Substeps Show Substeps
  • Add some steps, make sure you number them so you can control it afterwards

    Show Details Show Substeps Show Substeps Show Substeps
    Recommended Checklist
    • Title: Test Checklist saving new template date time
    • Description:

    test description saving (and add a link and special characters
    like ', [ and <

    Setup
    • Title 1
      • 1
      • 2 (here, add WYSIWYG notes, w/bold, italic, bulletted list)
      • 3
    • Title 2
      • a
      • b
      • c
      • d (here, add a simple text form field)
    • Title 3 (here, add some simple wysiwyg notes)
    • I
    • II (here, add a document and an image and a link)
    • III (here, attach a sub-checklist)
  • Save it, but DON'T leave the page! You will need to edit it afterwards

    Show Details Show Substeps Show Substeps Show Substeps
  • In a separate browser window, review the result - LEAVE the original window open

    Show Details Show Substeps Show Substeps Show Substeps
  • In the database, review the header fields, you should have only 1!!! record and everything should be there

    Show Details Show Substeps Show Substeps Show Substeps
  • In the DB, review the steps. You should have exactly as many steps as you added

    Show Details Show Substeps Show Substeps Show Substeps
  • In the DB, review the forms extension, you should have exactly 1 extension and a small set of values

    Show Details Show Substeps Show Substeps Show Substeps
  • In the DB, review the attachments-extension, you should have 3! and the appropriate values

    Show Details Show Substeps Show Substeps Show Substeps
  • Test Re-Saving a Brand New Template

    Show Details Show Substeps Show Substeps Show Substeps
    Continue with your browser, that is still open in editing mode. If you had to close it for some reason, you MUST start over.
  • Make the following changes and save (DON'T leave the page)

    Show Details Show Substeps Show Substeps Show Substeps
    • Rename 2 to 2 changed
    • Reorder the steps a, b, c to b, a, c
    • Add a Step IV after III
    • Change the form field on d to be a date field
    • Remove the document
    • Add a new document
    • Replace the image
    • Add an additional link
  • In the separate browser window, review it again, ensure everything worked, and that the order and values are identical

    Show Details Show Substeps Show Substeps Show Substeps
  • Control the DB, you should have EXACTLY the following

    Show Details Show Substeps Show Substeps Show Substeps
    • The HEADER should not have changed at all!
    • New Template-Step records for
      • 2 Changed (because it was changed)
      • a (because it was resorted, and now points to c)
      • b (because it was resorted, and now points to a)
      • III (because it points to IV)
      • IV (because it's new)
    • No other new template step records!!!
    • Exactly 3 new extension-records (added document and link, removed document)
    • The replaced image should not get a new extension record!
    • '''Exactly 2 new file records (added document, replaced image; deleted file shouldn't have a change in the files table?)
    • The modified form-field should have exactly 1 change in the values
    • The changes on the files should bring quite a few changes to the extension-values
  • Test Saving Unmodified Templates in the Modify-Mode

    Show Details Show Substeps Show Substeps Show Substeps
  • Leave the originally opened New-Template mode, go to use and back to Edit Template

    Show Details Show Substeps Show Substeps Show Substeps
  • Now make the following changes: None - and then save

    Show Details Show Substeps Show Substeps Show Substeps
    That's right, don't make changes, just save!
  • Control the output in a separate browser window

    Show Details Show Substeps Show Substeps Show Substeps
  • Control the DB very precisely

    Show Details Show Substeps Show Substeps Show Substeps
    You should have 0 changes in all these tables
    • Template (header)
    • Template (steps)
    • Extensions
    • Extension Values
    • Attachments
  • Test Saving Modified templates

    Show Details Show Substeps Show Substeps Show Substeps
  • Now make the following changes, and save

    Show Details Show Substeps Show Substeps Show Substeps
    • Add 4 steps to the end
    • Add a form field to an added step
    • Add an image and a link to the added step
    • Delete on of the added steps (you now only have 3 added steps left)
    • Re-order these three steps
  • Control output in separate browser

    Show Details Show Substeps Show Substeps Show Substeps
  • Control DB

    Show Details Show Substeps Show Substeps Show Substeps
    You should have
    • 0 new Records in the template-header
    • 4 new records in the steps (3 new, 1 changed because the previously last step points to the new step)
    • 2 new extensions
    • some new extension values
    • Ensure, that the previous extensions were not changed/added
  • Now change the title of the checklist and some notes, save, check output in browser and DB

    Show Details Show Substeps Show Substeps Show Substeps
    DB Should have exactly
    • 1 Change in the Template-Header
    • 0 Changes to steps
    • 0 Changes to extensions
    • 0 Changes to extension values
  • Test Saving New Checklists (Used templates)

    Show Details Show Substeps Show Substeps Show Substeps
  • Log in, open the template you just created, set the title, save

    Show Details Show Substeps Show Substeps Show Substeps
  • In a separate browser, go to "My Checklists" and re-open the started work, control

    Show Details Show Substeps Show Substeps Show Substeps
  • Control the DB

    Show Details Show Substeps Show Substeps Show Substeps
    You should have
    • 0 Changes to Template-header
    • 0 Changes to template-steps
    • 0 Changes to extensions
    • 0 Changes to files
    • 0 Changes to extension values
    • 1 New in user values-header
    • 0 Changes to user-steps
  • Save again, control DB again

    Show Details Show Substeps Show Substeps Show Substeps
    You should have 0 changes in the user-header now
  • Go into edit mode, then to sort mode, then back to use, save, control DB

    Show Details Show Substeps Show Substeps Show Substeps
    Again you should have 0 DB changes
  • Go to sort, change move one step, save, control DB

    Show Details Show Substeps Show Substeps Show Substeps
    You should have
    • 1 new record in template-headers, with a slave-header
    • 2 new records in the template-steps
    • 1 new record in the user-values-header (because the header now points to the other checklist template)
    • 2 new records in the value steps (because the checkmarks now point to the new checklist-template)
    • 0 extension changes
    • 0 extension value changes
  • Make some more random changes - TRY to break it, save, control in separate browser window

    Show Details Show Substeps Show Substeps Show Substeps
  • Test saving changed checklists (used templates, re-opened)

    Show Details Show Substeps Show Substeps Show Substeps
  • Leave the using mode, go to my-checklist, re-open the checklist, do the following & save

    Show Details Show Substeps Show Substeps Show Substeps
    • untick a step
    • tick 2 other steps (but not one with a form field)
    • write something into a form field
  • Control DB

    Show Details Show Substeps Show Substeps Show Substeps
    You should have
    • 0 template-header
    • 0 template-steps
    • 0 extension-template (assignments / specs)
    • 0 user-values-header
    • 3 user values step (the one w/the form field shouldn't have changed)
    • 1 user-value-extension (the value)
  • Change form field value only, control DB

    Show Details Show Substeps Show Substeps Show Substeps
    YOu should have 0 changes on all this
    • Template header
    • template steps
    • template extension assignments
    • user header
    • user steps

    You should have 1 change here
    • user-extension fields
  • New Step

    Show Details Show Substeps Show Substeps Show Substeps
Use this Checklist

Preview/Print

Use

Change

Sort