On Wed, Aug 29, 2012 at 11:37 AM, Gery . <gameji...@hotmail.com> wrote: > > Hello, > > I'm quite new in SA and I'm having some problems with a script. After > running the script, I'm getting this error: > > [<__main__.Boreholes object at 0xb7a2958c>, <__main__.Boreholes object at > 0xb7a2962c>, <__main__.Boreholes object at 0xb7a2966c>, <__main__.Boreholes > object at 0xb7a296cc>, <__main__.Boreholes object at 0xb7a2972c>, > <__main__.Boreholes object at 0xb7a2978c>, <__main__.Boreholes object at > 0xb7a297ec>, <__main__.Boreholes object at 0xb7a2984c>, <__main__.Boreholes > object at 0xb7a298ac>, <__main__.Boreholes object at 0xb7a2990c>, > <__main__.Boreholes object at 0xb7a2996c>, <__main__.Boreholes object at > 0xb7a299cc>, <__main__.Boreholes object at 0xb7a29a2c>, <__main__.Boreholes > object at 0xb7a29a8c>, <__main__.Boreholes object at 0xb7a29aec>, > <__main__.Boreholes object at 0xb7a29b4c>, <__main__.Boreholes object at > 0xb7a29bac>, <__main__.Boreholes object at 0xb7a29c2c>, <__main__.Boreholes > object at 0xb7a29cac>, <__main__.Boreholes object at 0xb7a29d2c>, > <__main__.Boreholes object at 0xb7a29dac>, <__main__.Boreholes object at > 0xb7a29e2c>, <__main__.Boreholes object at 0xb7a29eac>, <__main__.Boreholes > object at 0xb7a29f2c>, <__main__.Boreholes object at 0xb7a29fac>, > <__main__.Boreholes object at 0xb7a3504c>, <__main__.Boreholes object at > 0xb7a350cc>, <__main__.Boreholes object at 0xb7a3514c>, <__main__.Boreholes > object at 0xb7a351cc>, <__main__.Boreholes object at 0xb7a3524c>, > <__main__.Boreholes object at 0xb7a352cc>, <__main__.Boreholes object at > 0xb7a3534c>, <__main__.Boreholes object at 0xb7a353cc>, <__main__.Boreholes > object at 0xb7a3544c>, <__main__.Boreholes object at 0xb7a354cc>, > <__main__.Boreholes object at 0xb7a3554c>, <__main__.Boreholes object at > 0xb7a355cc>, <__main__.Boreholes object at 0xb7a3564c>, <__main__.Boreholes > object at 0xb7a356cc>, <__main__.Boreholes object at 0xb7a3574c>, > <__main__.Boreholes object at 0xb7a357cc>, <__main__.Boreholes object at > 0xb7a3584c>, <__main__.Boreholes object at 0xb7a358cc>, <__main__.Boreholes > object at 0xb7a3594c>, <__main__.Boreholes object at 0xb7a359cc>, > <__main__.Boreholes object at 0xb7a35a4c>, <__main__.Boreholes object at > 0xb7a35acc>, <__main__.Boreholes object at 0xb7a35b4c>, <__main__.Boreholes > object at 0xb7a35bcc>, <__main__.Boreholes object at 0xb7a35c4c>, > <__main__.Boreholes object at 0xb7a35ccc>] > > > the script is here: > > ************************************************************************************************************* > > # import things to be used > from sqlalchemy import create_engine, MetaData, Table > from sqlalchemy.orm import mapper, sessionmaker > > # connecting to database engine > myengine = create_engine('postgresql://postgres:pass@localhost:5432/mop', > echo=False) > > # MetaData: describing the database schema > mymetadata = MetaData(myengine) > > # load existing tables in postgis database > boreholes = Table('boreholes_point_wgs84', mymetadata, autoload=True) > > # defining empty classes to be mapped to existing tables > class Boreholes(object): > pass > > # mapping empty classes to existing tables [ie. ORM] > Boreholesmapper = mapper(Boreholes, boreholes) > > # session operations [finding data, adding data, modifying data and deleting > data] > Session = sessionmaker(bind=myengine) > mysession = Session() > > # queries > alldata = mysession.query(Boreholes).all() > print alldata > > ************************************************************************************************************* > > I'm working with python2.4 and SA 0.7.8 in rhel5 (32-bit). > > Any hint is appreciated, > > Best regards, > > Gery >
That's not an error - that is a list of instances of the Borehole class, which is what you get back from Query.all(). The columns in your boreholes_point_wgs84 become properties of those instances. So for example if the table has "name", "latitude" and "longitude" columns, you would be able to change your last 2 lines to say something like: for borehole in mysession.query(Boreholes).all(): print borehole.name, borehole.latitude, borehole.longitude Hope that helps, Simon -- 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 options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.