This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.
···
I am looking for links or documentations on interacting with DHIS2 database from the SQL Shell commands. For instance, when I would like to UPDATE, DELETE or ADD some records values, do I only run the SQL command on the “datavalue” table or also on all linked tables? Same thing when making changes on metadata to make some UPDATE, DELETE or ADD some organization units.
I would try encourage you to use the Web API for really everything. If you start updating directly in the database, you can very easily end up with a corrupted system. Direct inserts into the data value tables should be OK. But given the complexity of the model, directly manipulating the database tables can lead to serious problems, unless you are exceedingly careful.
Regards,
Jason
···
On Thu, Jul 21, 2016 at 3:58 PM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:
Hi All,
I am looking for links or documentations on interacting with DHIS2 database from the SQL Shell commands. For instance, when I would like to UPDATE, DELETE or ADD some records values, do I only run the SQL command on the “datavalue” table or also on all linked tables? Same thing when making changes on metadata to make some UPDATE, DELETE or ADD some organization units.
Thank you for your support.
Tantely.
This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.