Hello, Everyone, I'm getting to know SQLAlchemy after watching the PyCon tutorials and have a couple of questions I hope you can either can/will answer for me or point me in the correct direction.
I'm using SQLAlchemy v 0.5.3 with Python 2.6 on Windows hitting a SQL Server database. I am using reflection to define my Python objects and can "see" the column names and values as expected. Very nice. Question 1: In my database I have a timestamp column defined which will default to the current system timestamp on the db server. When I create an object then "commit" it, the database complains about the ts column. Can I exclude it from the Insert query? I found an earlier thread on this but it appeared (to me) that the op was not using reflection. If I have a very simplified class: class FileInfo(Base): __table__ = Table('file_info', metadata, autoload=True) def __init__(self, path, client): self.path = path self.client = client How would I specify not to add a ts column (which exists in the db) to the Insert query? Question 2: Along the same lines, using reflection, can I define foreign keys and backrefs in my objects? I'd like to link the above "file_info" id to a "file_id" column in another table (also defined using reflection). I see how to do this when I explicitly define my tables, but I have an existing database I would like to work with. Thanks for your help. I'm looking forward to learning more about all of this! --greg --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---