dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Hi Tantely,

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@xxxxxxxxxx> 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.*
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049