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
- Open a document, type
/, and choose Database.- An inline database appears in the document
- 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
- 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
- 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
- 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
- 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
- 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.
- In Tasks, add a property, set its type to Relation, and pick Projects as the Related database.
- Projects gains a relation property named Tasks
- 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
- In Projects, remove that link from the paired cell.
- Both cells are empty
- 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
- Delete the relation property in Tasks.
- The confirmation names Projects; after confirming, both relation properties are gone
Row panel
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- Add another property, then click Cancel before creating it.
- No extra column is created
Inline database name (PR #1584)
- 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
- 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
- Change the database name again, then press Escape before saving.
- The last saved database name returns