Re: [dabo-users] Child doesn't relate to Parent

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