create-rust-app icon indicating copy to clipboard operation
create-rust-app copied to clipboard

Allow CRUD in admin dashboard

Open Wulf opened this issue 3 years ago • 1 comments

The task here is to add CRUD features to the admin dashboard.

Currently, we only read information from the database but don't have means of modifying it.

Creating

Generate forms based on column types. Initially, we can support the following types:

  • boolean,
  • all character types,
  • all numeric types,
  • all temporal types,
  • all json types

We can disable the creation feature for tables which contain unsupported column types.

Updating

Similar to creation, except we should add a WHERE clause that updates the row which matches all column values. Before this, we should check that only 1 column exists for those particular values -- otherwise we won't be able to update only one row for tables without candidate keys.

Deleting

We can easily add deletion based by deleting ONE row where all columns are equivalent to the one that the user wanted to delete.

Wulf avatar Apr 02 '22 13:04 Wulf

Progress screenshots :)

image image

Wulf avatar Jul 18 '22 06:07 Wulf