Skip to main content

Databases — Regression Test

Run on a release build containing PR #1193, #1240, #1244, #1246, #1247, and #1248. The inline-name variation also requires PR #1584. Use disposable data and English app labels.

Steps​

  1. Open a document, type /, and choose Database.
    • An inline database appears in the document
  2. Click Add row, enter a title, then use Add property to add a text property and fill its cell.
    • The row and property value are visible
  3. Open the row's Open page action, add a paragraph, then close the row panel.
    • The row opens in a panel on the right; the table stays visible and clickable
    • Reopening the row shows the paragraph
  4. Add a second row with a different title. Use Search rows to find one title, then clear the search.
    • Search shows the matching row; clearing it shows both rows again
  5. Leave the document, reopen it, and open it on a second client signed in to the same account.
    • Both rows, property values, and the row-page paragraph persist

Variations​

  1. In the sidebar, open New page → New database.
    • A full-page database opens and accepts a row
    • The sidebar entry reopens the database after navigating away
  2. Open View actions → Database history, preview an earlier revision, then restore it on this disposable database.
    • Properties and row values return to that revision; current row-page bodies are kept

Relations​

Use two disposable databases in the same workspace, Tasks and Projects, each with two rows.

  1. In Tasks, add a property, set its type to Relation, and pick Projects as the Related database.
    • Projects gains a relation property named Tasks
  2. In a Tasks row, open the relation cell, search, and pick a Projects row.
    • The cell shows the picked row's title
    • Without reloading, the Projects row shows the Tasks row in its paired cell
  3. In Projects, remove that link from the paired cell.
    • Both cells are empty
  4. Link a Projects row again, then archive that Projects row.
    • The Tasks cell shows a muted Missing row chip that can be removed
    • Restoring the Projects row from trash shows its title again
  5. Delete the relation property in Tasks.
    • The confirmation names Projects; after confirming, both relation properties are gone

Row panel​

  1. Open the first row, type a paragraph, then click Open page on the second row without closing the panel.
    • The panel switches to the second row; reopening the first row shows the paragraph
  2. Drag the panel's left edge to make it wider, then reload the app and open a row.
    • The panel keeps the new width; in a full-page database the table shrinks beside it
  3. On the web app, make the window narrower than 600px and open a row.
    • The row panel fills the screen; Close returns to the table
  4. With the row panel open, rename the row's title in the panel, then use that row's Duplicate action in the table.
    • The copy is created on the first try with the new title, and no conflict message appears
  5. With the row panel open, add a property from the table header, then edit a property in the panel.
    • The panel shows the new property, and the edit saves without a conflict message

Property settings​

  1. Click Add property, set Property name to Status, choose a select type, add two named options, then click Create property.
    • One Status column appears; its cells offer both options
  2. Open that property's settings, rename it, click Save, then use Move left or Move right where another column is available. Reload the app.
    • The new name, options, and column order persist
  3. Add another property, then click Cancel before creating it.
    • No extra column is created

Inline database name (PR #1584)​

  1. In the inline database from step 1, edit Database name above the table and press Enter.
    • The table shows the new name; the containing document keeps its own title
  2. Reload the document and open it on a second client signed in to the same account.
    • Both clients show the saved database name and the existing rows
  3. Change the database name again, then press Escape before saving.
    • The last saved database name returns