From: Watchara K. <wat...@gm...> - 2007-05-01 15:25:26
|
I'm new user of SQLObject and now i have a problem. I want to use "Nortwind" of MS SQL 2000. I want to use Orders, OrderDetails, Product Photo of RelationShip http://images.temppic.com/01-05-2007/images_vertis/1178032644_0.06632000.png I have problem with OrderDetails. I don't know how to create on SQLObject. I use Turbogears. My Model.py is " from turbogears.database import PackageHub from sqlobject import * hub = PackageHub("ordercontrol") __connection__ = hub # class YourDataClass(SQLObject): # pass class Orders(SQLObject): class sqlmeta: idName = 'OrderID' style= MixedCaseStyle(longID=True) CustomerID = UnicodeCol(length=5) EmployeeID = IntCol() OrderDate = DateTimeCol() RequiredDate = DateTimeCol() ShippedDate = DateTimeCol() ShipVia = IntCol() Freight = CurrencyCol() ShipName = UnicodeCol(length=40) ShipAddress = UnicodeCol(length=60) ShipCity = UnicodeCol(length=15) ShipRegion = UnicodeCol(length=15) ShipPostalCode = UnicodeCol(length=10) ShipCountry = UnicodeCol(length=15) class OrderDetails(SQLObject): class sqlmeta: table = 'OrderDetails' idName = 'OrderID' style = MixedCaseStyle(longID=True) Order = ForeignKey('Orders',unique=False) Product = ForeignKey('Products',unique=False) UnitPrice = CurrencyCol(notNone= True) Quantity = IntCol(length=256,notNone=True) Discount = FloatCol(notNone=True) class Products(SQLObject): class sqlmeta: idName='ProductID' style = MixedCaseStyle(longID=True) ProductName = UnicodeCol(length=40,notNone=True) SupplierID = IntCol() CategoryID = IntCol() QuantityPerUnit = UnicodeCol(length=20) UnitPrice = CurrencyCol() UnitsInStock = IntCol() UnitsOnOrder = IntCol() ReorderLevel = IntCol() Discontinued = BoolCol(notNone=True) " But it have problem , it show only 1 ProductID / 1 OrderID. it incorrect! if true it show "many" ProductID / 1 OrderID How did i will do ? Thank You Very Much. [My english is pool] |
From: sophana <so...@zi...> - 2007-05-02 09:39:30
|
Watchara Kangkun a écrit : > > But it have problem , it show only 1 ProductID / 1 OrderID. it incorrect! > if true it show "many" ProductID / 1 OrderID > > How did i will do ? > > Thank You Very Much. I think you want to create a "Related join". You should check that in the main SqlObject documentation. |
From: Oleg B. <ph...@ph...> - 2007-05-02 13:13:32
|
On Tue, May 01, 2007 at 10:25:22PM +0700, Watchara Kangkun wrote: > But it have problem , it show only 1 ProductID / 1 OrderID. it incorrect! > if true it show "many" ProductID / 1 OrderID ForeignKey is 1-to-1 join. ForeignKey+MultipleJoin is 1-to-many join. RelatedJoin+RelatedJoin is many-to-many join. Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |