sql error when uploading events/detections with a station name containing apostrophe

[jkburges]

1. Upload detection file which has station name containing apostrophe, e.g. http://aatams.emii.org.au/aatams/receiverDownloadFile/show/70615542 (spider's ledge)

A org.postgresql.util.PSQLException is thrown.

We should be escaping/quoting things properly.

[danfruehauf]

http://xkcd.com/327/

[jkburges]

@danfruehauf you tested your fix against the problematic file? Can this be closed?

[danfruehauf]

AFAIK yes, however, link this to the new bug it introduced.

[jkburges]

Closing, as @danfruehauf 's fix seems to have fixed this bug.
However, it may have introduced #29

[jkburges]

This is going to be handled as a backlog item.

[jkburges]

@pblain I guess from my previous comment here that I've discussed this issue with you already, but just confirming, do we have a backlog item for this already?

I think we need to have a bit of a re-think about how we upload and store detections. We can probably solve this problem, as well as remove the need to refresh materialised views nightly (which uses a lot of CPU on the DB) and probably some other performance problems too. But, it's not trivial :-)

[pblain]

Yes, there is a backlog item related to this (NET55). We'll need to flesh it out before it makes it to planning. But it's in there.

[jkburges]

Noting that this is still an issue for users. Andrew has just emailed Rog about it.