[QGIS-Developer] pyqgis: no update data into table sqlite !

[Enzo Cocca]

thank you so much,
works very well!

Il giorno mar 4 mag 2021 alle ore 20:10 Benjamin Jakimow <
benjamin.jakimow at geo.hu-berlin.de> ha scritto:

> You need to write t back to the feature, e.g. by
>
> feat['assessment_investigator_actor'] = t
>
>
> Greetings,
>
> Benjamin
>
>
> On 2021-05-04 19:59, Enzo Cocca wrote:
>
> Hi people:
> I'm trying to update an table sqlite not geometric but the update does not
> take place.
>
> this is my code:
>
> def convert_table(self):
>         cfg_rel_path = os.path.join(os.sep, 'HFF_DB_folder', 'config.cfg')
>         file_path = '{}{}'.format(self.HOME, cfg_rel_path)
>         conf = open(file_path, "r")
>         con_sett = conf.read()
>         conf.close()
>         settings = Settings(con_sett)
>         settings.set_configuration()
>         if settings.SERVER == 'sqlite':
>             sqliteDB_path = os.path.join(os.sep, 'HFF_DB_folder',
> settings.DATABASE)
>             db_file_path = '{}{}'.format(self.HOME, sqliteDB_path)
>             uri = QgsDataSourceUri()
>             uri.setDatabase(db_file_path)
>             uri.setDataSource('','eamena_table', None,'')
>             layerEamena=QgsVectorLayer(uri.uri(), 'eamena_table',
> 'spatialite')
>             QgsProject.instance().addMapLayers([layerEamena], True)
>             layer =
> QgsProject.instance().mapLayersByName('eamena_table')[0]
>             with edit(layer):
>                 for feat in layer.getFeatures():
>                     a=str(feat['assessment_investigator_actor'])
>                     if "[['" not in a and a!='NULL':
>                         t=a.replace(a[0],"[['"+a[0]).replace("|","'],
> ['").replace(a[-1],a[-1]+"']]")
>             layer.updateFeature(feat)
>         QgsProject.instance().removeMapLayer(layer.id())
>
> If I print the results it's ok but into table doesn't update.
> Some one has some suggestions?
>
> Best
> E
>
> --
> Enzo Cocca PhD
> in "Science and Technology for Archaeology and Cultural Heritage"
>
> ISMEO
> International Association of Mediterranean and Oriental Studies
>
> mail: enzo.ccc at gmail.com
> cell: +393495087014
>
>
> _______________________________________________
> QGIS-Developer mailing list
> QGIS-Developer at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>
>
> --
> --
> Benjamin Jakimow, Doctoral Researcher
> Earth Observation Lab | Geography Department | Humboldt-Universität zu
> Berlin
>
> e-mail: benjamin.jakimow at geo.hu-berlin.de
>
> phone:  +49 (0) 30 2093 6894
> mobile: +49 (0) 157 5656 8477
> fax:    +49 (0) 30 2093 6848
> mail:   Unter den Linden 6 | 10099 Berlin | Germany
> room: 2'222
>


-- 
Enzo Cocca PhD
in "Science and Technology for Archaeology and Cultural Heritage"

ISMEO
International Association of Mediterranean and Oriental Studies


mail: enzo.ccc at gmail.com
cell: +393495087014
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20210504/9dd71aa0/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: blocked.gif
Type: image/gif
Size: 118 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20210504/9dd71aa0/attachment.gif>