Re: sql/Pg-database.sql FUNCTION person__get_my_entity

On Thu, Oct 31, 2013 at 12:43 PM, herman vierendeels <..hidden..> wrote:

Hello,

with more and more triggers in DB,
you hit problems , e.g. with audittrail, when doing
sql-work outside of ledgerSMB, e.g. psql

person__get_my_entity_id() returning empty list

Could we redefine function as to always receive default row?

If you do that, then you will run into fkey violations since a lot of things like audit trails have foreign key constraints attached.

I think the best approach is to create a LedgerSMB user for out of LSMB operations. (My largest customer has at least one user account for automated tasks).

In 1.4, we might want to change the fkey on the audit trail from person(entity_id) to entity(id) as tat would enable more flexible external user frameworks without sacrificing auditability.

Note this attaches to the db user.

CREATE OR REPLACE FUNCTION person__get_my_entity_id() RETURNS INT AS
$$
SELECT entity_id from users where username = SESSION_USER union
select 1 order by 1 desc limit 1;
$$ LANGUAGE SQL;

In general, if you are writing to the db, the audit trails should be preserved.

Best Wishes,

Chris Travers

Greetings,
Herman Vierendeels

------------------------------------------------------------------------------
Android is increasing in popularity, but the open development platform that
developers love is also attractive to malware creators. Download this white
paper to learn more about secure code signing practices that can help keep
Android apps secure.
http://pubads.g.doubleclick.net/gampad/clk?id=65839951&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-devel mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

Best Wishes,

Chris Travers

Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in.

http://www.efficito.com/learn_more.shtml

Re: sql/Pg-database.sql FUNCTION person__get_my_entity_id()