Hi,
I'm struggling with a strange issue.
I have a web2py application with a simple data model. I have a table
called "reorder". The user is able to interact with "reorder" using a
SQLFORM.grid. I have implemented the oncreate call back. My oncreate
callback gets the id of the newly inserted reorder record then does
something with it.
def oncreatereorderhandler(form):
myid = form.vars.id
newreorderrow = db.reorder(myid)
#now do something with newreorderrow
Generally this works well. form.vars.id correctly corresponds to the id of
the newly inserted row and life is happy. The problem occurs when I put a
database trigger on the reorder table that fires after the insert.
Whenever this trigger is on the database the value of form.vars.id is
nonsense. The actual id of the inserted row is fine it's just that the
value of form.vars.id in now way corresponds to it. For example, after the
trigger is added, the values of form.vars.id will be 4 for the very next
insert. For every insert after the value will increment by 3 (eg 4, 7, 10,
13, etc). When I remove the trigger everything returns to normal.
How is form.vars.id populated and how would a DB trigger interfere?
Here's the trigger and associated procedure. It was generated by
symmetricds.
CREATE TRIGGER sym_on_i_for_rrdr_trggr_crp
AFTER INSERT
ON reorder
FOR EACH ROW
EXECUTE PROCEDURE fsym_on_i_for_rrdr_trggr_crp();
-- Function: fsym_on_i_for_rrdr_trggr_crp()
-- DROP FUNCTION fsym_on_i_for_rrdr_trggr_crp();
CREATE OR REPLACE FUNCTION fsym_on_i_for_rrdr_trggr_crp()
RETURNS trigger AS
$BODY$
begin
if 1=1 and
"public".sym_triggers_disabled() = 0 then
insert into "public".sym_data
(table_name,
event_type, trigger_hist_id, row_data, channel_id, transaction_id,
source_node_id, external_data, create_time)
values(
'reorder',
'I',
8,
case when new."uuid" is null then '' else '"' ||
replace(replace(cast(new."uuid" as varchar),$$\$$,$$\\$$),'"',$$\"$$) ||
'"' end||','||
case when new."id" is null then '' else '"' || cast(cast(new."id"
as numeric) as varchar) || '"' end||','||
case when new."modified_on" is null then '' else '"' ||
to_char(new."modified_on", 'YYYY-MM-DD HH24:MI:SS.US') || '"' end||','||
case when new."productid" is null then '' else '"' ||
replace(replace(cast(new."productid" as varchar),$$\$$,$$\\$$),'"',$$\"$$)
|| '"' end||','||
case when new."reorderquantity" is null then '' else '"' ||
cast(cast(new."reorderquantity" as numeric) as varchar) || '"' end||','||
case when new."receivedquantity" is null then '' else '"' ||
cast(cast(new."receivedquantity" as numeric) as varchar) || '"' end||','||
case when new."reorderdate" is null then '' else '"' ||
to_char(new."reorderdate", 'YYYY-MM-DD HH24:MI:SS.US') || '"' end||','||
case when new."expectedreceivedate" is null then '' else '"' ||
to_char(new."expectedreceivedate", 'YYYY-MM-DD HH24:MI:SS.US') || '"'
end||','||
case when new."vendorso" is null then '' else '"' ||
replace(replace(cast(new."vendorso" as varchar),$$\$$,$$\\$$),'"',$$\"$$)
|| '"' end||','||
case when new."customerpo" is null then '' else '"' ||
replace(replace(cast(new."customerpo" as varchar),$$\$$,$$\\$$),'"',$$\"$$)
|| '"' end||','||
case when new."edigenerated" is null then '' else '"' ||
replace(replace(cast(new."edigenerated" as
varchar),$$\$$,$$\\$$),'"',$$\"$$) || '"' end||','||
case when new."active" is null then '' else '"' ||
replace(replace(cast(new."active" as varchar),$$\$$,$$\\$$),'"',$$\"$$) ||
'"' end,
'sschannel',
txid_current(),
"public".sym_node_disabled(),
null,
CURRENT_TIMESTAMP
);
end if;
return null;
end;
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100;
ALTER FUNCTION fsym_on_i_for_rrdr_trggr_crp()
OWNER TO tom;
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
