ShelterApp / AddResources

http://shelterapp.org/
11 stars 10 forks source link

Script for data verification before puting into temp collection #58

Open prabhushrikant opened 3 years ago

prabhushrikant commented 3 years ago

Before putting the final dataframe into mongo db, we would like to verify if it's correct and maintains the business rules mentioned here in our wiki

E.g we can have programmatic check on following things

  1. resource name can't be null or empty
  2. Field names on dataframe are matching as mentioned in wiki #6
  3. if zip is null or emtpy then city, state, country can't be null or empty and vice versa
  4. Do we have duplicate services for which categories can be combined in string of categories.
  5. Service summary field can't be null or empty.
  6. notes column is added for each record (can be null or empty)

Verification tests will fail and tmpCollection wont't be updated if there is test failure.

ShelterApp commented 3 years ago

Shak is working on it....but I can't assign ticket to him since he hasn't accepted the invitation to join as collaborator.