Hi all,

I am trying to add new rows into an existing many to one database via 
sqlalchemy ORM.

What I am doing now(it seems working):
# The many to one relationship is:
stock = relationship('Stock', backref=backref('historicalprices', 
order_by=id))

# query an object
stock = session.query(Stock).filter_by(code='00001').one()

# add row
stock.historicalprices.append([something])
session.add(stock)

The problem is that it is too slow to query one object. Is there a 
fast/standard way to do this?

Thanks,
Chengjun






-- 
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.

Reply via email to