I should probably make the pair method:
def pair(name1, name2):
p1, p2 = Pairs(name1), Pairs(name2)
p1.other = p2
p2.other = p1
On Feb 3, 11:57 am, lars van gemerden <[email protected]> wrote:
> Hi, I am trying to sote pairs in a table as follows:
>
> #--------------------------------------------------------------------------
> ------------
> from elixir import *
>
> metadata.bind = "sqlite:///:memory:"
> metadata.bind.echo = False
>
> class Pairs(Entity):
> name = Field(String(50), primary_key = True)
> other = OneToOne('Pairs', inverse = 'other')
>
> def __init__(self, name):
> self.name = name
>
> def pair(name1, name2):
> p1, p2 = Pairs(name1), Pairs(name2)
> p1.other = p2
>
> if __name__ == '__main__':
>
> setup_all()
> create_all()
>
> pair('p1', 'p2')
> #--------------------------------------------------------------------------
> ------------
>
> I am not very famiiar with SQL etc. but logically this seems possible
> (please orrect me if I am wrong). However I get the following error:
> ------------------------
> File "D:\Documents\Code\Eclipse\workspace\SQLAdata\src\tests.py", line
> 22, in <module>
> setup_all()
> File "build\bdist.win-amd64\egg\elixir\__init__.py", line 94, in
> setup_all
>
> File "build\bdist.win-amd64\egg\elixir\entity.py", line 951, in
> setup_entities
> File "build\bdist.win-amd64\egg\elixir\entity.py", line 198, in
> create_pk_cols
> File "build\bdist.win-amd64\egg\elixir\entity.py", line 481, in
> call_builders
> File "build\bdist.win-amd64\egg\elixir\relationships.py", line 448,
> in create_pk_cols
> File "build\bdist.win-amd64\egg\elixir\relationships.py", line 791,
> in create_keys
> File "build\bdist.win-amd64\egg\elixir\relationships.py", line 521,
> in inverse
> AssertionError: Relationships 'other' in entity 'Pair' and 'other' in
> entity 'Pair' cannot be inverse of each other because their types do
> not form a valid combination.
> ------------------------
>
> Can anyone help me to understand the error and possibly fix it?
>
> Thanks in advance, Lars
--
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.
