[sqlalchemy] flask + sqlalchemy +postgresql how can i check out the data from my db???

['Frank Liou' via sqlalchemy]

this is my code . my question is how can i check out the data from my db. 
 i have try query=session.query(Friend)

but i think  that might be wrong

so..what place i have to add the code "query=seesion.query(frined)???

p.s. i just the rookie 

this is my database

 id |     name
----+--------------
  1 | test to edit
 13 | 10113
 25 | 31w2w2
 26 | 31w2w2
(4 rows)




import sqlalchemy as sqla
import sqlalchemy.orm as sqlorm
from flask import Flask
from sqlalchemy.ext.declarative import declarative_base as 
sqla_declarative_base
from flask.ext.sqlalchemy import SQLAlchemy
app=Flask(__name__)
@app.route('/user/<username>')
def hello(username):
        save_friends(username)
        return u
Base = sqla_declarative_base()
engine = 
sqla.create_engine('postgresql://frank:mypassword@192.168.10.114/mydb',echo=True)

class Friends(Base):
    __tablename__ = 'friends'
    friends_id = sqla.Column('id', sqla.Integer, primary_key=True)
    name = sqla.Column('name', sqla.String)
Base.metadata.bind = engine
Base.metadata.create_all()

Session = sqlorm.scoped_session(sqlorm.sessionmaker(bind=engine))
query.session.query(friends)
u=query.get(1)
def save_friends(username):
    friends = Friends(name=username)
    session = Session()
    try:
        session.add(friends)
        session.flush()
        session.commit()
    finally:
        session.close()

if __name__ == '__main__':
    app.debug=True
    app.run()








error log :

[Tue Jul 01 01:29:53 2014] [error] 2014-07-01 01:29:53,812 INFO 
sqlalchemy.engine.base.Engine {}
[Tue Jul 01 01:29:53 2014] [error] 2014-07-01 01:29:53,814 INFO 
sqlalchemy.engine.base.Engine select current_schema()
[Tue Jul 01 01:29:53 2014] [error] 2014-07-01 01:29:53,814 INFO 
sqlalchemy.engine.base.Engine {}
[Tue Jul 01 01:29:53 2014] [error] 2014-07-01 01:29:53,815 INFO 
sqlalchemy.engine.base.Engine SELECT CAST('test plain returns' AS 
VARCHAR(60)) AS anon_1
[Tue Jul 01 01:29:53 2014] [error] 2014-07-01 01:29:53,815 INFO 
sqlalchemy.engine.base.Engine {}
[Tue Jul 01 01:29:53 2014] [error] 2014-07-01 01:29:53,816 INFO 
sqlalchemy.engine.base.Engine SELECT CAST('test unicode returns' AS 
VARCHAR(60)) AS anon_1
[Tue Jul 01 01:29:53 2014] [error] 2014-07-01 01:29:53,817 INFO 
sqlalchemy.engine.base.Engine {}
[Tue Jul 01 01:29:53 2014] [error] 2014-07-01 01:29:53,817 INFO 
sqlalchemy.engine.base.Engine show standard_conforming_strings
[Tue Jul 01 01:29:53 2014] [error] 2014-07-01 01:29:53,817 INFO 
sqlalchemy.engine.base.Engine {}
[Tue Jul 01 01:29:53 2014] [error] 2014-07-01 01:29:53,819 INFO 
sqlalchemy.engine.base.Engine select relname from pg_class c join 
pg_namespace n on n.oid=c.relnamespace where n.nspname=current_schema() and 
relname=%(name)s
[Tue Jul 01 01:29:53 2014] [error] 2014-07-01 01:29:53,820 INFO 
sqlalchemy.engine.base.Engine {'name': 'friends'}
[Tue Jul 01 01:29:53 2014] [error] [client 192.168.10.8] mod_wsgi 
(pid=4684): Target WSGI script '/var/www/html/ft/ft2.wsgi' cannot be loaded 
as Python module.
[Tue Jul 01 01:29:53 2014] [error] [client 192.168.10.8] mod_wsgi 
(pid=4684): Exception occurred processing WSGI script 
'/var/www/html/ft/ft2.wsgi'.
[Tue Jul 01 01:29:53 2014] [error] [client 192.168.10.8] Traceback (most 
recent call last):
[Tue Jul 01 01:29:53 2014] [error] [client 192.168.10.8]   File 
"/var/www/html/ft/ft2.wsgi", line 3, in <module>
[Tue Jul 01 01:29:53 2014] [error] [client 192.168.10.8]     from req 
import app as application
[Tue Jul 01 01:29:53 2014] [error] [client 192.168.10.8]   File 
"/var/www/html/ft/ft2/req.py", line 22, in <module>
[Tue Jul 01 01:29:53 2014] [error] [client 192.168.10.8]     
query=session.query(friends)
[Tue Jul 01 01:29:53 2014] [error] [client 192.168.10.8] NameError: name 
'session' is not defined





i try to put the code in "try"

but it can't work too



plaese help me!!

thanks for all^^





-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.