···
On Fri, Jan 16, 2015 at 11:29 AM, Knut Staring knutst@gmail.com wrote:
Yeah, that was my key question - and I thing it could work ok that way. But I would think you could achieve most of what you want through preparing things in Excel and then using the Metadata import instead (so you don’t have to worry about the internal database IDs)
–
On Fri, Jan 16, 2015 at 9:25 AM, Greg Rowles greg.rowles@gmail.com wrote:
Let me not forget to mention that this type of work would be preparatory and not after roll out…
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
–
Knut Staring
Dept. of Informatics, University of Oslo
Liberia: +231 770 496 123 or +231 886 146 381
Norway: +4791880522
Skype: knutstar
http://dhis2.org
On Fri, Jan 16, 2015 at 11:20 AM, Greg Rowles greg.rowles@gmail.com wrote:
Thanks Bob, Jason & Others
I agree and understand but we have a DHIS2 implementors who prefer to work directly inside the DBMS who are still new to this complex environment. If they need to insert records directly into tables this gives them the opportunity to do the work they’re used to (coming from version 1.4)…
Regards,
Greg
–
Health Information Systems Program - South Africa
**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **
Mobile : 073 246 2992
Landline: 021 554 3130
Fax: 086 733 8432
Skype: gregory_rowles
On Fri, Jan 16, 2015 at 11:17 AM, Bob Jolliffe bobjolliffe@gmail.com wrote:
Jason is right. You should only need the hibernate sequence number if you are dealing with the database through sql. And if you are, then the only safe way to use it is to get the sequence during the execution of the statement.
Getting the next sequence number and storing it to some variable with the aim of using it at some time in the future is inherently fragile.
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
–
Health Information Systems Program - South Africa
**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **
Mobile : 073 246 2992
Landline: 021 554 3130
Fax: 086 733 8432
Skype: gregory_rowles
On 16 January 2015 at 09:10, Jason Pickering jason.p.pickering@gmail.com wrote:
Hi Greg,
I would tend to agree with Lars that this should really not ever be required, but it would be good to know what the use case actually is.
The easiest way to do this would be to create an SQL view in DHIS2 as
SELECT currval(‘hibernate_sequence’)
In a multi-user database environment, this value is of course volatile, so you can never be sure what the actual current value is.
If you really need to inject SQL into your database, then using something like 'nextval(‘hibernate_sequence’::regclass)'in your SQL, which will provide the next value of the sequence.
Regards,
Jason
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
On Fri, Jan 16, 2015 at 9:49 AM, Lars Helge Øverland larshelge@gmail.com wrote:
Hi Greg,
that would be easy to implement, but the idea is that it should never be necessary to expose database details and instead work with the API. Do you think you could elaborate a bit on the use-case?
Lars
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049
–
On Fri, Jan 16, 2015 at 8:35 AM, Greg Rowles greg.rowles@gmail.com wrote:
Hi Devs
Is there an easy way to expose the last hibernate sequence value through the web API?
Greg
–
Health Information Systems Program - South Africa
**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **
Mobile : 073 246 2992
Landline: 021 554 3130
Fax: 086 733 8432
Skype: gregory_rowles
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Health Information Systems Program - South Africa
**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **
Mobile : 073 246 2992
Landline: 021 554 3130
Fax: 086 733 8432
Skype: gregory_rowles