Thanks Simon again for your nice explanation, I finally found a way to do that,
thanks.
Cheers,
Gery
__________________________________________________________________________________________
Piensa en el medio ambiente - mantenlo en la pantalla. NO lo imprimas si NO es
necesario.
Think green - keep it on the screen. Do NOT print if it is NOT necessary.
Denken Sie an die Umwelt - bewahren Sie es auf dem Bildschirm. Drucken Sie
NICHT, wenn es NICHT notwendig ist.
> From: si...@simonking.org.uk
> Date: Tue, 14 Aug 2012 19:14:36 +0100
> Subject: Re: [sqlalchemy] Re: how to get into PG database, is the "url" the
> right way? newbie question
> To: sqlalchemy@googlegroups.com
>
> 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 connect my
> > PostGis database with OpenLayers. After putting the
> > http://localhost/mop/py/dbmodel.py link, I get the whole model (I think this
> > should be my model, is it right?), so the Apache works well =):
> >
> > #created: 30 July 2012
> > #updated: 12 August 2012
> > #Gery
> >
> > from sqlalchemy import *
> > from sqlachemy import create_engine, MetaData, Table
> > from sqlalchemy.orm import *
> > from sqlalchemy.orm import mapper, relation, backref, sessionmaker
> > from sqlalchemy.ext.declarative import declarative_base
> >
> > # Setup the url, database engine and session
> > url = 'postgresql://postgres:password@localhost:5432/mop'
> > engine = create_engine(url, echo=True)
> > session = sessionmaker(bind=engine)
> > session = Session()
> >
> > # Setup the declarative extension and metadata
> > Base = declarative_base(metadata=metadata)
> > metadata = MetaData(engine)
> >
> > # Define the model classes
> > class Boreholes(Base):
> > __tablename__ = 'boreholes_point_wgs84'
> > __table_args__ = {'autoload':True}
> >
> > # DDL Extensions for geometry specific DDL
> > GeometryDDL(Boreholes.__table__)
> >
> >
> > Do I really need a web framework? I know some people use GeoAlchemy and
> > SqlAlchemy with Pylons, but I don't want to use that, well in general any
> > web framework. What could it be that "something" you mentioned that I need?
> > I've been reading that with PHP I can make the connection to do the HTTP
> > requests/responds, am I right? is this the unique way or solution to do
> > this?
> >
> > Thanks again
> >
> >
>
> Hi Gery,
>
> At the moment, your javascript code (running in your web browser) is
> making an HTTP request to Apache. Apache is simply returning the
> contents of the requested file, so your javascript is receiving a
> string of Python code that it has no way of interpreting. I'm afraid
> this will never work.
>
> What you need is for Apache to *execute* the python script and return
> the contents to your browser. There are lots of ways of doing this,
> but you'll really need to at least have a basic understanding of web
> technologies. You will have to understand how OpenLayers requests data
> from the server, know how to extract query parameters from the
> request, turn those into a database query, format the results as JSON
> and return them back to the browser. I'm afraid all of those things
> are outside the scope of this list.
>
> Sorry I can't be more help,
>
> 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.
>
--
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.
