Thanks. I'm still not sure what I'm doing wrong even with the output of the
log. Here are the 2 relevant bizobj's, my *creatBizobj and also the output of
the log.
GeskiedenisBizobj
import dabo
class GeskiedenisBizobj(dabo.biz.dBizobj):
def afterInit(self):
self.DataSource = "Geskiedenis"
self.KeyField = "pkid"
self.Linkfield = "Nr"
self.ParentLinkField = "pkid"
self.FillLinkFromParent = True
self.addFrom("Geskiedenis")
self.addField("Notas")
self.addField("Datum")
self.addField("Gebeurtenis")
self.addField("Geslag van kalf")
self.addField("Bul")
self.addField("Nr")
self.addField("pkid")
def validateRecord(self):
"""Returning anything other than an empty string from
this method will prevent the data from being saved.
"""
ret = ""
# Add your business rules here.
return ret
KuddeBizobj
import dabo
class KuddeBizobj(dabo.biz.dBizobj):
def afterInit(self):
self.DataSource = "Kudde"
self.KeyField = "pkid"
self.addFrom("Kudde")
self.addField("Grootmoeder ID")
self.addField("Notas")
self.addField("pkid")
self.addField("Moeder ID")
self.addField("Geboortedatum")
self.addField("ID Nommer")
self.addField("Grootvader ID")
self.addField("Vader ID")
def validateRecord(self):
"""Returning anything other than an empty string from
this method will prevent the data from being saved.
"""
ret = ""
# Add your business rules here.
return ret
*createBizobj
def createBizobjs(self):
kuddeBizobj = self.Application.biz.KuddeBizobj(self.Connection)
self.addBizobj(kuddeBizobj)
geskiedenisBizobj = self.Application.biz.GeskiedenisBizobj(self.Connection)
self.addBizobj(geskiedenisBizobj)
kuddeBizobj.addChild(geskiedenisBizobj)
And the log output:
2011-11-23 13:31:56 - INFO - execute() SQL: select * from sqlite_master
2011-11-23 13:34:46 - INFO - execute() SQL: select "Grootmoeder ID",
"Notas", "pkid", "Moeder ID", "Geboortedatum", "ID
Nommer", "Grootvader ID", "Vader ID" from "Kudde" limit 1
2011-11-23 13:34:46 - INFO - execute() SQL: pragma table_info('Kudde')
2011-11-23 13:34:46 - INFO - execute() SQL: select "Grootmoeder ID",
"Notas", "pkid", "Moeder ID", "Geboortedatum", "ID
Nommer", "Grootvader ID", "Vader ID" from "Kudde" limit 1000
2011-11-23 13:34:46 - INFO - execute() SQL: select "Notas", "Datum",
"Gebeurtenis", "Geslag van kalf", "Bul", "Nr",
"pkid" from "Geskiedenis" limit 1
2011-11-23 13:34:46 - INFO - execute() SQL: pragma table_info('Geskiedenis')
2011-11-23 13:34:46 - INFO - execute() SQL: select "Notas", "Datum",
"Gebeurtenis", "Geslag van kalf", "Bul", "Nr",
"pkid" from "Geskiedenis" limit 1000
2011-11-23 13:34:54 - INFO - execute() SQL: select "Notas", "Datum",
"Gebeurtenis", "Geslag van kalf", "Bul", "Nr",
"pkid" from "Geskiedenis" limit 1000
2011-11-23 13:34:55 - INFO - execute() SQL: select "Notas", "Datum",
"Gebeurtenis", "Geslag van kalf", "Bul", "Nr",
"pkid" from "Geskiedenis" limit 1000
Any idea what I am doing wrong or forgetting?
Thanks
Dewald
On 23 Nov 2011, at 11:39 AM, Jacek Kałucki wrote:
> Użytkownik Dewald Jacobs napisał:
>> Hi. I'm not familiar with the database activity log. How do I enable and
>> check it?
>
> In your Dabo application directory where the startup script is located
> add file "settings_override.py" with the entry like:
>
> dbLogFile = "database.log"
>
> Then you will be able to monitor framework database activity.
> --
> Regards
> Jacek Kałucki
> _______________________________________________
> 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]
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
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]