you might want to look into Elixir since its the current version of
ActiveMapper, and is much better documented. http://elixir.ematia.de/
trac/wiki
On Oct 10, 2007, at 2:24 PM, Wes Duff wrote:
> Hello gentelmen and ladies,
>
> I am very new to sqlalchemy and put in a position where I had to
> jump out of and airplane and land on my head and walk on my hands
> to the end of this project.
>
> I wanted to know how one_to_man and many_to_many are carried out.
>
> Here is an example
>
> class Document(ActiveMapper):
> class mapping:
> __table__= 'document'
> id = column(Integer, primary_key=True)
> title = column(Unicode)
> shortdesc_dc = column(Unicode, nullable=True)
>
> doc_type_id = column(Integer, foreign_key=ForeignKey
> ('doc_type.id'))
> layout_id = column(Integer, foreign_key=ForeignKey
> ('layout.id'))
> body_id = column(Integer, foreign_key=ForeignKey(' body.id'))
>
> dochists = one_to_many('DocumentHistory', colname='doc_id',
> backref='document')
> doctags = many_to_many('DocTag', document_doc_tag_table,
> backref='document')
>
>
>
> Does this mean that there is one document to many DocumentHistory.
> If so that is what I need
>
> And below is the DocumentHistory section
>
>
> class DocumentHistory(ActiveMapper):
> class mapping:
> __table__= 'document_hist'
> id = column(Integer, primary_key=True)
> user_guid = column(Integer, nullable=True)
> timestamp = column(TIMESTAMP, nullable=False)
> rev_num = column(Integer, nullable=True)
> change = column(Unicode, nullable=True)
>
> doc_id = column(CHAR(32), foreign_key=ForeignKey('
> document.id'))
>
>
> Thanks for your help. Some day I will repay the group with my
> knowlege.
>
> Wes Duff
>
> >
--~--~---------~--~----~------------~-------~--~----~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
