Re: [sqlalchemy] Filtering for element in PgArray column

2012-08-14 Thread Vlad K.
On 08/13/2012 10:13 PM, Michael Bayer wrote: we can keep turning the crank here, here's a full series of examples to make this happen: Thanks for the example, that's definitely something I'll need sooner or later, already implemented my own PostgreSQL POINT data type and was wondering how

[sqlalchemy] Re: is there a reason why lower() isn't a column operation ?

2012-08-14 Thread Jonathan Vanasco
well, that's a lot of good reasons! -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more

[sqlalchemy] Re: is there a reason why lower() isn't a column operation ?

2012-08-14 Thread Jonathan Vanasco
also, just to clarify - i didn't want a case insensitive compare but a specific sql generated just to give a quick illustration With this table structure: CREATE TABLE names ( id serial not null primary key , name varchar(255) not null ); CREATE UNIQUE INDEX

Re: [sqlalchemy] Filtering for element in PgArray column

2012-08-14 Thread Michael Bayer
On Aug 14, 2012, at 4:40 AM, Vlad K. wrote: On 08/13/2012 10:13 PM, Michael Bayer wrote: we can keep turning the crank here, here's a full series of examples to make this happen: Thanks for the example, that's definitely something I'll need sooner or later, already implemented my own

Re: [sqlalchemy] Re: is there a reason why lower() isn't a column operation ?

2012-08-14 Thread Michael Bayer
On Aug 14, 2012, at 10:46 AM, Jonathan Vanasco wrote: also, just to clarify - i didn't want a case insensitive compare but a specific sql generated just to give a quick illustration With this table structure: CREATE TABLE names ( id serial not null primary key , name

[sqlalchemy] Re: how to get into PG database, is the url the right way? newbie question

2012-08-14 Thread Gery
any ideas?? basically the idea is how to search inside a database being outside the database, especifically through SqlAlchemy from OpenLayers? On Monday, August 13, 2012 9:23:43 PM UTC+2, Gery wrote: Hello, I'm new around here and I've been using SQLalchemy (SA) for a while. I work with

Re: [sqlalchemy] Re: how to get into PG database, is the url the right way? newbie question

2012-08-14 Thread Simon King
On Monday, August 13, 2012 9:23:43 PM UTC+2, Gery wrote: Hello, I'm new around here and I've been using SQLalchemy (SA) for a while. I work with PostGis (PG), OpenLayers (OL), ExtJS, GeoExtJS and now with the great SA and GeoAlchemy. I have one problem, I created a model where I defined one

Re: [sqlalchemy] Re: how to get into PG database, is the url the right way? newbie question

2012-08-14 Thread Gery
Hello Simon, Thanks for your answer, acttually I don't use any web framework, I just did a html page and put Openlayers, GeoExt, and Ext code there. To display points/lines/polylines/rasters/etc., I use Mapserver, so I connect my PostGis database with OpenLayers. After putting the

Re: [sqlalchemy] Re: how to get into PG database, is the url the right way? newbie question

2012-08-14 Thread Simon King
On Tue, Aug 14, 2012 at 6:39 PM, Gery geryherb...@gmail.com wrote: Hello Simon, Thanks for your answer, acttually I don't use any web framework, I just did a html page and put Openlayers, GeoExt, and Ext code there. To display points/lines/polylines/rasters/etc., I use Mapserver, so I

RE: [sqlalchemy] Re: how to get into PG database, is the url the right way? newbie question

2012-08-14 Thread Gery .
Many thanks Simon, very cool explanation, I'm grateful for your neat support. I'll look for that in google and OpenLayers, about to execute the python script and Apache, I think it has something to do with modwsgi but not sure. If you could point me to some useful links for any of the ways