I understand there are no direct writes to the shelter database.
However, is it possible to generate one model in the db that does have the ability to accept a Read or Write only new records? This allows me to create a simple form on irmashelters.org for submitting plaintext updates from anonymous users, like "this shelter is full" that could be timestamped, and the queue of "citizen updates" can be translated into the Shelter model manually.
Schema looks like this:
[UntrustedUpdates]
int id
int shelter_id
datetime created_date
string update_text
bool processed?
datetime processed_date
bool accepted?
int admin_id
Would involve creating model, creating API endpoint to read updates by shelterid, write updates to shelterid, and the admin/edit views to mark off untrusted updates when processed.
I understand there are no direct writes to the shelter database.
However, is it possible to generate one model in the db that does have the ability to accept a Read or Write only new records? This allows me to create a simple form on irmashelters.org for submitting plaintext updates from anonymous users, like "this shelter is full" that could be timestamped, and the queue of "citizen updates" can be translated into the Shelter model manually.
Schema looks like this:
[UntrustedUpdates]
int id
int shelter_id
datetime created_date
string update_text
bool processed?
datetime processed_date
bool accepted?
int admin_id
Would involve creating model, creating API endpoint to read updates by shelterid, write updates to shelterid, and the admin/edit views to mark off untrusted updates when processed.