Hi,
Yesterday I was searching this group and the SA 5.0 doc to get something
working. Somewere I came across an option to specify the columnames to
return
(and getting a tuple or so)
Let me explain:
Keep the following in mind:
I have a table which stores files defined with Declarative_base:
Class file(Base):
__tablename__ = "sometable"
Id = Column(Integer, primary_key=True)
Filename = Column(String(255), index=True)
Permissions = Column(Integer)
Store = Column(Someblobtype)
Now I need to build a query which results in the following information
in any form:
Filename, permissions and the "size of" Store
I think I need func from sqlalchemy.sql but whatever I try I cannot find
any sizeof or alike, I know MySQL has something like that.
To build a list of files (in realality it is a store for a webdav server
and I greatly simplified this example, I need this since listing a
"directory" causes
Martijn
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---