I changed SqlObject version to 0.8dev-r1706, it works now!
And I've known how to give the added foreignkey a name:
Department.sqlmeta.addColumn(ForeignKey('Employee',
dbName='chief',notNone=True),changeSchema=True)
"artman" <[EMAIL PROTECTED]> дÈëÏûÏ¢
news:[EMAIL PROTECTED]
> Hi,
> I'm using PostgreSql 8.1, and I have two classes below:
>
> class Department(SqlObject):
> attr1 = StringCol(...)
> ...
> chief = ForeignKey('Employee')
>
> class Employee(SqlObject):
> attr2 = StringCol(...)
> ...
> department = ForeignKey('Department')
>
> I know because they are referred by each other, I can't create them in any
> order.
> So I modify the Department class like this:
>
> class Department(SqlObject):
> attr1 = StringCol(...)
> ...
> Now I think I can create the two classes and add new column to the
> Department class:
> Department.createTable()
> Employee.createTable()
> Department.sqlmeta.addColumn(ForeignKey('Employee',notNone=True),changeSchema=True)
> But there is an error in the sql command:
> ALTER TABLE department ADD COLUMN employee_id INT NOT NULL, CONSTRAINT
> employee_id_exists FOREIGN KEY (employee_id) REFERENCES employee (id)
> Is it a bug or I'm using addColumn in a wrong way? and HOW CAN I GIVE A
> NAME TO THE ADDED FOREIGNKEY?
> Thanks in advance!
>
>
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting
> language
> that extends applications into web and mobile media. Attend the live
> webcast
> and join the prime developer group breaking into this new coding
> territory!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
