Bug report #9202

Can't write from python in integer fields of sqlite (not spatial) tables

Added by Francisco Puga over 10 years ago. Updated over 10 years ago.

Category:Python plugins
Affected QGIS version:2.0.1 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:17830


I'm using the python console to automatice a process that includes copy values from a dbf layer to a sqlite (non spatial) table. All works nice except when i need to write a value in a integer field of the sqlite table. The value of the integer fiels is always NULL in the target table, the rest of the values are correctly written.

Integer fields in the properties of the table are represented as qlonglong and i think that the python encapsulation of these fields is failing, because when i try to write to a integer field of a sqlite (spatial) layer it works correctly, and in this case the type of the field appears as int in the properties

I attach a zip with a sscce, that contains a sqlite file created with this commands:

spatialite -bail test_qlonglong.sqlite "SELECT InitSpatialMetaData();" 
spatialite  -bail test_qlonglong.sqlite "CREATE TABLE spatial (gid INTEGER PRIMARY KEY, intfield INTEGER); SELECT addgeometrycolumn('spatial', 'geom', 4326, 'POINT', 2);" 
spatialite  -bail test_qlonglong.sqlite "CREATE TABLE non_spatial (gid INTEGER PRIMARY KEY, intfield INTEGER);" 

and a script.py file that shows how in spatial layers integer values are correctly written and in non spatial not, with this content:

spatial = [x for x in iface.legendInterface().layers() if x.name() == 'spatial'][0]
spatialFields = spatial.dataProvider().fields()
feat = QgsFeature()
feat.setAttribute('intfield', 10)
(res, foo) = spatial.dataProvider().addFeatures([feat])
if not res: print "Error writing spatial layer" 

non_spatial = [x for x in iface.legendInterface().layers() if x.name() == 'non_spatial'][0]
non_spatialFields = non_spatial.dataProvider().fields()
feat = QgsFeature()
feat.setAttribute('intfield', 10)
(res, foo) = non_spatial.dataProvider().addFeatures([feat])
if not res: print "Error writing non spatial layer" 

I'm using Ubuntu 13.04 32bits, with qgis 2.01 installed from the ppa ubuntugis-unstable

test_qlonglong.tgz (312 KB) Francisco Puga, 2013-12-11 09:38 AM

screenshot_issue9202.png (225 KB) Francisco Puga, 2013-12-12 07:11 AM


#1 Updated by Matthias Kuhn over 10 years ago

  • Status changed from Open to Feedback

Just tested here (64bit Fedora)

  • spatial layer: has no intfield attribute and therefore the code fails for this
  • non spatial layer: 2.0.1 problem reproducible
  • non spatial layer: master problem solved

So it seems this has been fixed already.

#2 Updated by Francisco Puga over 10 years ago

I build qgis from source, commit 221263db95fc on Dec 8, and i'm still having this issue. Maybe a 32bit problem?

I attach a screenshot that show how the value is correctly written in the spatial table and NULL is written to non_spatial table.

#3 Updated by Francisco Puga over 10 years ago

Ouch. Shame on me. It has been fixed already. I was launching "installed" qgis instead of the builded qgis.

Should i close the bug myself?

#4 Updated by Francisco Puga over 10 years ago

  • Status changed from Feedback to Closed

Also available in: Atom PDF