Jérôme Caba a écrit : > Hi, > > I try to use GeoAlchemy with an existant postgis db and I have one error > when I want to query tables. > My model : > class Communes(Base): > __tablename__ = "COMMUNES" > id_commune = Column(Integer,primary_key=True) > article_majuscule_commune = Column(Unicode) > nom_majuscule_commune = Column(Unicode) > article_minuscule_commune = Column(Unicode) > nom_minuscule_commune = Column(Unicode) > the_geom_rt500 = GeometryColumn(Polygon(2)) > the_geom_dgi = GeometryColumn(Polygon(2)) > the_geom_bdc = GeometryColumn(Polygon(2)) > > I can query all fields like this : > my_comm = session.query(Communes).filter_by(id_commune='46626').first() > print our_comm .nom_minuscule_commune > and it works > > But when I want to retry the geometry (in wkt or other formats): > print session.scalar(Communes.the_geom_bdc.wkt) > I only obtain an error : "AttributeError : 'NoneType' object has no > attribute 'scalar' > > My version of sqlalchemy is 0.5.6, Geoalchemy 0.1 and python 2.5 > Have I misunderstood something ? It seems like the geom format is not > recognized... > > Thank you very much > > > I progress a little, sorry for my mistake : I wrote
print session.scalar(Communes.the_geom_bdc.wkt) and obtain an error like this : AttributeError : Neither 'InstrumentedAttribute' object nor 'Comparator' object has an attribute 'wkt' What did I do wrong ? thanks -- Jérôme Caba BMSQ Département Information Géographique BP 12668 31326 CASTANET TOLOSAN Cedex téléphone : 05.61.28.93.43 fax : 05.61.28.92.82 mail : [email protected] _______________________________________________ Community mailing list [email protected] http://lists.gispython.org/mailman/listinfo/community
