Josef K
Josef K
_From [[email protected]](https://code.google.com/u/106492356751350430132/) on January 09, 2014 11:16:08_ to increase sqlite performance specially useful for custom and section plots see http://snorf.net/blog/2013/12/07/multithreading-in-qgis-python-plugins/ _Original issue: http://code.google.com/p/midvatten-plugin-for-qgis/issues/detail?id=28_
**Solved see comment** Improve sanity checks, number of columns etc., and give user more relevant error messages. **Solved see comment** _High priority_: Better way to remove null and empty values...
Put ? as a placeholder and use the parameter substitution in every sqlite "execute". Follow recommendations here: https://docs.python.org/2/library/sqlite3.html
Whenever an update/revision of the database (INSERT, UPDATE, etc.) is interrupted due to some constraint violations - then the database connection must be closed. Currently, these situations results in python...
Foreign keys constraints must be activated before any transaction to the database. This is due to the fact that the foreign keys validation is by default turned off in any...
For strings use .join instead of += This is valid for all "sql += ..." See w_levels_import_calc_calibr.py for example of alternative usage
FREEWAT plugin includes several useful tools and it would be a great enhancement to enable the production of e.g. SAR, Stiff and schoeller plots directly from data in the midvatten...
Add features to create stiff and schoeller diagrams for selected obs_points. See following links for inspiration: http://hatarichem.gidahatari.com/ http://python.hydrology-amsterdam.nl/scripts/stiff_fill.py https://training.usgs.gov/TEL/WQPrinciples/Lesson13-Freeze.pdf
The plugin https://github.com/ghtmtt/DataPlotly includes some very interesting plotting features. It may be worth to include some feature in midvatten plugin to create (temporary?) layers to be used for DataPlotly plots....
Add four columns to the water quality report: min, max, mean and median (for each parameter). Related issue: https://github.com/jkall/qgis-midvatten-plugin/issues/165