Platform: GTK
Python Version: 2.5.2 on linux2
Dabo Version: Version 0.9.1; Revision ~5105
UI Version: 2.8.7.1 on wxGTK (gtk2)
I am trying to figure out DataStructure. Given a bizobj of:
class PublicStockInfoBizobj(dabo.biz.dBizobj):
def afterInit(self):
self.DataSource = "stockInfo"
self.AutoPopulatePK = False
self.addFrom("public.stock_info")
self.KeyField = "si_stock_sym"
self.addOrderBy("si_stock_sym")
self.setLimit(None)
self.DataStructure = [
("si_stock_sym","C",True,"public.stock_info","si_stock_sym"),
("si_stock_name","C",False,"public.stock_info",\
"si_stock_name"),
("si_stock_exch","C",False,"public.stock_info",\
"si_stock_exch")
]
self.SaveNewUnchanged = True
self.RequeryChildOnSave = True
publicStockInfoBizobj = PublicStockInfoBizobj(self.Connection)
self.addBizobj(publicStockInfoBizobj)
Why do I get the below?
biz=self.getBizobj("stockInfo")
biz.AutoSQL
'select *\n from "public"."stock_info"\n order by "si_stock_sym"'
biz.getDataStructure()
(('si_stock_sym', 'C', True, 'public.stock_info', 'si_stock_sym', None),
('si_stock_name', 'C', False, 'public.stock_info', 'si_stock_name', None),
('si_stock_exch', 'C', False, 'public.stock_info', 'si_stock_exch', None))
biz.getDataStructureFromDescription()
(('si_stock_sym', '?', None), ('si_stock_name', '?', None),
('si_stock_exch', '?', None), ('si_ts_insert', '?', None),
('si_user_insert', '?', None), ('si_ts_update', '?', None),
('si_user_update', '?', None))
I would have thought the cursor would only fetch the columns specified in the
DataStructure. Am I missing something? Be warned the answer to this leads to
another question :)
--
Adrian Klaver
[email protected]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message:
http://leafe.com/archives/byMID/[email protected]
