<div dir="ltr">thank you so much,<div>works very well!</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Il giorno mar 4 mag 2021 alle ore 20:10 Benjamin Jakimow <<a href="mailto:benjamin.jakimow@geo.hu-berlin.de">benjamin.jakimow@geo.hu-berlin.de</a>> ha scritto:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div style="font-size:10pt;font-family:Verdana,Geneva,sans-serif">
<p>You need to write t back to the feature, e.g. by</p>
<p>feat['assessment_investigator_actor'] = t</p>
<p><br></p>
<p>Greetings,</p>
<p>Benjamin</p>
<p><br></p>
<p id="gmail-m_3970999403051205630reply-intro">On 2021-05-04 19:59, Enzo Cocca wrote:</p>
<blockquote type="cite" style="padding:0px 0.4em;border-left:2px solid rgb(16,16,255);margin:0px">
<div id="gmail-m_3970999403051205630replybody1">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">Hi people:
<div>I'm trying to update an table sqlite not geometric but the update does not take place.</div>
<div> </div>
<div>this is my code:</div>
<div> </div>
<div>
<div>def convert_table(self):</div>
<div> cfg_rel_path = os.path.join(os.sep, 'HFF_DB_folder', 'config.cfg')</div>
<div> file_path = '{}{}'.format(self.HOME, cfg_rel_path)</div>
<div> conf = open(file_path, "r")</div>
<div> con_sett = conf.read()</div>
<div> conf.close()</div>
<div> settings = Settings(con_sett)</div>
<div> settings.set_configuration()</div>
<div> if settings.SERVER == 'sqlite':</div>
<div> sqliteDB_path = os.path.join(os.sep, 'HFF_DB_folder', settings.DATABASE)</div>
<div> db_file_path = '{}{}'.format(self.HOME, sqliteDB_path)</div>
<div> uri = QgsDataSourceUri()</div>
<div> uri.setDatabase(db_file_path)</div>
<div> uri.setDataSource('','eamena_table', None,'')</div>
<div> layerEamena=QgsVectorLayer(uri.uri(), 'eamena_table', 'spatialite')</div>
<div> QgsProject.instance().addMapLayers([layerEamena], True)</div>
<div> layer = QgsProject.instance().mapLayersByName('eamena_table')[0]</div>
<div> with edit(layer):</div>
<div> for feat in layer.getFeatures():</div>
<div> a=str(feat['assessment_investigator_actor'])</div>
<div> if "[['" not in a and a!='NULL':</div>
<div> t=a.replace(a[0],"[['"+a[0]).replace("|","'], ['").replace(a[-1],a[-1]+"']]") </div>
<div> layer.updateFeature(feat) </div>
<div> QgsProject.instance().removeMapLayer(<a href="http://layer.id" rel="noopener noreferrer" target="_blank">layer.id</a>())</div>
<div> </div>
<div>If I print the results it's ok but into table doesn't update.</div>
<div>Some one has some suggestions?</div>
<div> </div>
<div>Best<br>E</div>
<div> </div>
-- <br>
<div dir="ltr">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">Enzo Cocca PhD</div>
<div dir="ltr">in "Science and Technology for Archaeology and Cultural Heritage"</div>
<div dir="ltr"> </div>
<div dir="ltr">
<div style="font:400 13.33px/19.99px Arial,Helvetica,sans-serif;text-align:left;color:rgb(34,34,34);text-transform:none;text-indent:0px;letter-spacing:normal;overflow:visible;text-decoration:none;word-spacing:0px;white-space:normal;background-color:transparent">
<div style="font:400 13.33px/19.99px Arial,Helvetica,sans-serif;overflow:visible"><span style="font:400 13.33px/19.99px Arial,Helvetica,sans-serif;overflow:visible">ISMEO</span></div>
<div style="font:400 13.33px/19.99px Arial,Helvetica,sans-serif;overflow:visible">International Association of Mediterranean and Oriental Studies </div>
</div>
</div>
<div dir="ltr"><img style="font: 400 13.33px / 19.99px Arial, Helvetica, sans-serif; text-align: left; color: rgb(0, 0, 0); text-transform: none; text-indent: 0px; letter-spacing: normal; overflow: visible; text-decoration: none; word-spacing: 0px; white-space: normal; background-color: transparent;" src="cid:17938d67943527484c21" width="200" height="75"></div>
<div dir="ltr"><u></u><span style="text-decoration:line-through"></span><br>
<div>mail: <a href="mailto:enzo.ccc@gmail.com" rel="noreferrer" target="_blank">enzo.ccc@gmail.com</a></div>
<div>cell: +393495087014</div>
<div> </div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<div style="margin:0px;padding:0px;font-family:monospace">_______________________________________________<br>QGIS-Developer mailing list<br><a href="mailto:QGIS-Developer@lists.osgeo.org" target="_blank">QGIS-Developer@lists.osgeo.org</a><br>List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noopener noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noopener noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a></div>
</blockquote>
<p><br></p>
<div id="gmail-m_3970999403051205630signature">-- <br>
<div style="margin:0px;padding:0px;font-family:monospace">--<br>Benjamin Jakimow, Doctoral Researcher<br>Earth Observation Lab | Geography Department | Humboldt-Universität zu Berlin<br><br>e-mail: <a href="mailto:benjamin.jakimow@geo.hu-berlin.de" target="_blank">benjamin.jakimow@geo.hu-berlin.de</a><br><br>phone: +49 (0) 30 2093 6894<br>mobile: +49 (0) 157 5656 8477<br>fax: +49 (0) 30 2093 6848<br>mail: Unter den Linden 6 | 10099 Berlin | Germany<br>room: 2'222</div>
</div>
</div>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr">Enzo Cocca PhD</div><div dir="ltr">in "Science and Technology for Archaeology and Cultural Heritage"</div><div dir="ltr"><br></div><div dir="ltr"><div style="font:400 13.33px/19.99px Arial,Helvetica,sans-serif;text-align:left;color:rgb(34,34,34);text-transform:none;text-indent:0px;letter-spacing:normal;overflow:visible;text-decoration:none;word-spacing:0px;white-space:normal;background-color:transparent"><div style="font:400 13.33px/19.99px Arial,Helvetica,sans-serif;overflow:visible"><span style="font:400 13.33px/19.99px Arial,Helvetica,sans-serif;overflow:visible">ISMEO</span></div><div style="font:400 13.33px/19.99px Arial,Helvetica,sans-serif;overflow:visible">International Association of Mediterranean and Oriental Studies </div></div><br></div><div dir="ltr"><img width="200" height="75" style="font: 400 13.33px / 19.99px Arial, Helvetica, sans-serif; text-align: left; color: rgb(0, 0, 0); text-transform: none; text-indent: 0px; letter-spacing: normal; overflow: visible; text-decoration: none; word-spacing: 0px; white-space: normal; background-color: transparent;" src="https://docs.google.com/uc?export=download&id=1ho_PBK4C-4cl8Ubqw4oyvusZOhM5P92l&revid=0B2EWPB0itz-iQ3dwZVBaaTVKcEN4VUpwa09scDNRNmNvQkw0PQ"></div><div dir="ltr"><b></b><i></i><u></u><sub></sub><sup></sup><strike></strike><br><div>mail: <a href="mailto:enzo.ccc@gmail.com" target="_blank">enzo.ccc@gmail.com</a></div><div>cell: +393495087014</div><div><br></div></div></div></div></div></div></div></div></div>