Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Allow CRUD in admin dashboard #30

Open
Wulf opened this issue Apr 2, 2022 · 1 comment
Open

Allow CRUD in admin dashboard #30

Wulf opened this issue Apr 2, 2022 · 1 comment
Labels
plugin Anything related to plugins

Comments

@Wulf
Copy link
Owner

Wulf commented Apr 2, 2022

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 Wulf added the plugin Anything related to plugins label Apr 2, 2022
@Wulf
Copy link
Owner Author

Wulf commented Jul 18, 2022

Progress screenshots :)

image

image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
plugin Anything related to plugins
Projects
None yet
Development

No branches or pull requests

1 participant