[Qgis-user] custom db query plugin update

[Noli Sicad]

Hi Ricardo,

I like to know what version of spatialite are you using? It seems that
the pyspatialite2.6.1 could not properly setup with the current
spatialite 2.4.0 in unbutugis.

See these errors below.

Noli


noli at noli-laptop:~/Downloads/pyspatialite-2.6.1$ sudo python setup.py install
[sudo] password for noli:
running install
running build
running build_py
running build_ext
building 'pyspatialite._spatialite' extension
gcc -pthread -fno-strict-aliasing -DNDEBUG -g -fwrapv -O2 -Wall
-Wstrict-prototypes -fPIC -DMODULE_NAME="spatialite.dbapi2"
-DSQLITE_ENABLE_FTS3=1 -DSQLITE_ENABLE_RTREE=1
-DSQLITE_ENABLE_COLUMN_METADATA=1 -Iamalgamation
-I/usr/include/python2.6 -c src/module.c -o
build/temp.linux-i686-2.6/src/module.o
...

...
amalgamation/spatialite.c:13718: error: ‘GEOSGeometry’ undeclared
(first use in this function)
amalgamation/spatialite.c:13718: error: ‘g1’ undeclared (first use in
this function)
amalgamation/spatialite.c:13719: error: ‘g2’ undeclared (first use in
this function)
amalgamation/spatialite.c:13725: warning: implicit declaration of
function ‘GEOSConvexHull’
amalgamation/spatialite.c: In function ‘gaiaGeomCollBuffer’:
amalgamation/spatialite.c:13750: error: ‘GEOSGeometry’ undeclared
(first use in this function)
amalgamation/spatialite.c:13750: error: ‘g1’ undeclared (first use in
this function)
amalgamation/spatialite.c:13751: error: ‘g2’ undeclared (first use in
this function)
amalgamation/spatialite.c:13757: warning: implicit declaration of
function ‘GEOSBuffer’
amalgamation/spatialite.c: In function ‘gaiaPolygonize’:
amalgamation/spatialite.c:13789: error: ‘GEOSGeometry’ undeclared
(first use in this function)
amalgamation/spatialite.c:13789: error: ‘g_array’ undeclared (first
use in this function)
amalgamation/spatialite.c:13790: error: ‘g2’ undeclared (first use in
this function)
amalgamation/spatialite.c:13805: error: expected expression before ‘)’ token
amalgamation/spatialite.c:13825: warning: implicit declaration of
function ‘GEOSPolygonize’
amalgamation/spatialite.c:13825: error: expected ‘)’ before ‘GEOSGeometry’
amalgamation/spatialite.c:13825: warning: type defaults to ‘int’ in
declaration of ‘type name’
amalgamation/spatialite.c: At top level:
amalgamation/spatialite.c:19159: warning: return type defaults to ‘int’
amalgamation/spatialite.c: In function ‘fnct_geos_version’:
amalgamation/spatialite.c:20164: warning: implicit declaration of
function ‘GEOSversion’
amalgamation/spatialite.c:20164: warning: initialization makes pointer
from integer without a cast
amalgamation/spatialite.c: In function ‘init_static_spatialite’:
amalgamation/spatialite.c:28661: warning: implicit declaration of
function ‘initGEOS’
amalgamation/spatialite.c: In function ‘spatialite_init’:
amalgamation/spatialite.c:28771: warning: format ‘%s’ expects type
‘char *’, but argument 2 has type ‘int’
amalgamation/spatialite.c: In function ‘sqlite3_extension_init’:
amalgamation/spatialite.c:29243: warning: format ‘%s’ expects type
‘char *’, but argument 2 has type ‘int’
amalgamation/spatialite.c: At top level:
amalgamation/spatialite.c:29510: warning: function declaration isn’t a prototype
amalgamation/spatialite.c:29521: warning: function declaration isn’t a prototype
amalgamation/spatialite.c:31649: warning: function declaration isn’t a prototype
amalgamation/spatialite.c:32890: warning: function declaration isn’t a prototype
amalgamation/spatialite.c:34163: warning: function declaration isn’t a prototype
error: command 'gcc' failed with exit status 1


noli at noli-laptop:~/Downloads/pyspatialite-2.6.1$ spatialite
SpatiaLite version ..: 2.4.0	Supported Extensions:
	- 'VirtualShape'	[direct Shapefile access]
	- 'VirtualDbf'		[direct DBF access]
	- 'VirtualText'		[direct CSV/TXT access]
	- 'VirtualNetwork'	[Dijkstra shortest path]
	- 'RTree'		[Spatial Index - R*Tree]
	- 'MbrCache'		[Spatial Index - MBR cache]
	- 'VirtualFDO'		[FDO-OGR interoperability]
	- 'SpatiaLite'		[Spatial SQL - OGC]
PROJ.4 version ......: Rel. 4.7.1, 23 September 2009
GEOS version ........: 3.2.2-CAPI-1.6.2
SQLite version ......: 3.6.22
Enter ".help" for instructions
spatialite>


On 12/20/10, Noli Sicad <nsicad at gmail.com> wrote:
> Hi Ricardo,
>
> Thanks for updating the plugin.
>
> However, I still have problem. I think it is the Qgis 1.7 trunk
> version r14914M Ubuntu 10.04.. My spatial manager does not recognized
> the spatialite tables as well.
>
> What version of QGIS are you using in Ubuntu 10.04 that this plugin works?
>
> Thanks.
>
> Noli
>
>
> On 12/20/10, Ricardo Filipe Soares Garcia da
> <ricardo.garcia.silva at gmail.com> wrote:
>> Hi all
>>
>> I uploaded a new version (v0.5) of the 'Custom db query' plugin.
>> It is marked as 'experimental' and it should be treated as so by users
>> that decide on downloading it ;)
>>
>> Improvements over the previous version:
>> - There is now a shortcut key (Alt+x) for executing SQL queries
>> - The default geometry and identifier column names for SpatiaLite are
>> now 'Geometry' and 'PK_UID'
>> - I added an 'Inspect tables' tab, so that it is possible to see the
>> table's and column's names and also their data
>> - I made some changes, towards supporting utf-8 databases, but I'm not
>> sure if it is 100% all right
>>
>> Some of the plugin's shortcomings, that I hope to fix in future versions:
>> - There is no progress bar indicating that there is a query running
>> - There is no way to cancel a running query
>> - The plugin's help page is still pretty much unfinished, so there
>> aren't many clues as to how to operate it
>>
>> I think I'll release next version when I can solve these pending
>> issues. By that time I will drop the experimental mark.
>> In the meanwhile I'll try to record some videos showing off the
>> plugin's usage, while I overcome may laziness in writing a proper help
>> page.
>>
>> If you decide to test it out, please leave me some feedback on this
>> mailing-list, and, if possible, using this thread.
>>
>> Thank you
>>
>> --
>> ___________________________ ___ __
>> Ricardo Garcia Silva
>> _______________________________________________
>> Qgis-user mailing list
>> Qgis-user at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>
>