Validation on aid package title

[nshamit]

• Validation on aid package title to stop the creation of two packages with the same name

[manuranga]

We can simply add UNIQUE(NAME), to AID_PACKAGE table.

[jayasanka-sack]

Need a human readable error message for the FE/

[manuranga]

DB is altered, users will not be able to create duplicate names.
We will get an error like:

Error while executing SQL query: INSERT INTO AID_PACKAGE(NAME, DESCRIPTION, STATUS)
                                        VALUES ( ? ,  ? ,  ? );. Duplicate entry 'newpkg' for key 'aid_package.NAME_UNIQUE'.

[manuranga]

Frontend error is not informative for now.

[manuranga]

@jayasanka-sack I can send a better error form backend later, for now can we use above error and show a meaningful error to the user

[manuranga]

Isn't this not the expectation? Otherwise name will be duplicate.

[jayasanka-sack]

Quick fix:

Catch this from the frontend.

[jayasanka-sack]

Temporally fixed with #372 . Need a proper solution from the backend.

[jayasanka-sack]

I think what we need to do here is,

1. fetch the aidpackage from the DB
2. Validate the payload and throw relevant error messages
3. Execute the update query if the payload is valid

@manuranga Could you please assign someone from the BE team?

Later on, we need to send a proper error resource. So that we can catch it from the front end and display validation errors in necessary places.

ex:

{
  "error": {
    "type": "/aidpackage/duplicate_title",
    "message": "Invalid OAuth access token.",
  }
}