QGIS » QGIS Application

in case it helps, if the spatialite view / QGIS layer in question is named 'vw_nodecallout_editor',

SELECT count(*) from sqlite_master
WHERE type='trigger'
and tbl_name='vw_nodecallout_editor'

will check for the existence of a trigger on the layer (and 'instead of' is the only type of trigger that SQLite allows on views, so the trigger's sql statement is actually irrelevant now that I think about it)

Heh. I'm pretty embarrassed. In re-reading some other tickets, I think I may have misunderstood the bounty purpose.

I'd like to PAY someone 100 euros to take a crack at this. I'm not looking to receive 100 euros for making this suggestion, that'd be silly.
Sorry for the misunderstanding.

Is there a different place to request features/fixes for hire?

The way you have done it is correct. Bounty value in euros: is intended for how much money you want to give to get this fixed.

Oh, good. Another post had the OP asking where he could get paid, and I got confused.

Thanks for taking this on, I'm excited!

Had a go at adding something tonight. Everything seems to be working, just going to do some more testing over the rest of the weekend.

That's great to hear! Thanks for the status update

Ok added it in.

One thing to note is that QGIS is a little crude in it's error reporting, if something goes wrong in the trigger or you don't have one defined for DELETE and you try and delete it will just say "Can't commit N features".

The error reporting method might be something that needs to be looked at in the future.

I also think this will be a 1.8 release thing vs 1.7.4 as it's not really a bug fix more of a new feature.

Nathan Woodrow wrote:

One thing to note is that QGIS is a little crude in it's error reporting, if something goes wrong in the trigger or you don't have one defined for DELETE and you try and delete it will just say "Can't commit N features".

The error reporting method might be something that needs to be looked at in the future.

Maybe when checking for triggers you could enable only some editing actions (by setting the appropriate capabilities) depending on which triggers are defined on the view.

Martin Dobias wrote:

Maybe when checking for triggers you could enable only some editing actions (by setting the appropriate capabilities) depending on which triggers are defined on the view.

True. I can work on adding this in. Shouldn't be too hard, just search for "Instead Of Delete" or Update or Insert in the trigger SQL.

Excellent! And yeah, I've gotten the hang of the error reporting by now - whenever I get that cryptic message, I do the same operation manually in Spatialite-GUI, and can see what's going on from there. I plan to use the RAISE function to have Spatialite pass a useable error message on to QGIS in the event of deletes and inserts (for the particular implementation I have in mind right now)

It's Sunday here, so I won't be at the office until tomorrow, but I know my boss will be eager to make payment, and I'm eager to check it out. Nathan, how do we get in touch to figure out payment method, etc?

And for testing it out, is my best bet to grab the OSGeo installer and install qgis-dev?

Brian Freed wrote:

And for testing it out, is my best bet to grab the OSGeo installer and install qgis-dev?

If you are on windows, yes. But the next build it still about 4h out...