You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
The text was updated successfully, but these errors were encountered:
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:
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.
The text was updated successfully, but these errors were encountered: