What does "#now do something with newreorderrow" do? On Thursday, 12 June 2014 14:12:45 UTC-5, Chris Farrar wrote: > > 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
