Using QGIS Python API, I want to avoid updating geometry with an UPDATE sql command.
My issue is that for geometry, I should update the model content with a Spatialite geometry blob (specs).
I didn't found any blob functions in Spatialite for geometry, so I could do
function_transform_geometry_to_spatialite_blob(MakePoint(0, 0, 4326)) and it returns a blob with geometry embedded as a text I can use to update my Geometry field within the model.
Are there any I missed?
Maybe, it's not the right approach. You may have another suggestions/opinions.
PS: I know about http://blog.vitu.ch/10112013-1201/qgis-relations and I've seen this discussion but it does not seem as flexible as
QSqlRelationalTableModel combined with
QDataWidgetMapper (but I could be wrong)