Hi,
have you verified that there is a matching record in the second bizobj ?
From the code posted it is not clear whether return value/RowNumber # -1.
HTH
tg
Vineet Deodhar schrieb:
> Hello List !
>
> This is in continuation with my earlier mail on 'propython' mailing list.
> As suggested by Paul, I am posting my dabo related queries here.
>
> Preamble to my query:-
> I am trying to use just the BizObj layer into my 'web2py' framework.
> Before putting the bizobj into actual project, I am learning 'how it works'.
> So I have created a directory with full dabo folder in it.
> I import dabo and use the bizobj & connection classes.
> Working on Win7, Intel core i3, python 2.6, MySQL 5512 (no install version),
> pyScripter IDE
>
> My Query:-
>
> Data structure:
>
> 1st table name: stat
> fields: statid, statnm
>
> 2nd table name: dist
> fields: distid, distnm, statid (foreign key)
>
> Code:
>
> /MyDir/bo.py file contains ---
>
> import dabo
>
> #create a connection object
> ci = dabo.db.dConnectInfo(Host='localhost', DbType='MySQL',
> Database='whlbel', User='root', PlainTextPassword='123')
> conn = dabo.db.dConnection(ci)
>
> #create stat bizobj
> statBizObj = dabo.biz.dAutoBizobj(conn)
> statBizObj.DataSource = 'stat'
> statBizObj.KeyField = 'statid'
> statBizObj.NonUpdateFields = ['statid']
> statBizObj.UserSQL = 'select * from stat'
> statBizObj.requery()
>
> #create dist bizobj
> distBizObj = dabo.biz.dBizobj(conn)
> distBizObj.KeyField = 'distid'
> distBizObj.ParentLinkField = 'statid'
> distBizObj.NonUpdateFields = ['distid']
> distBizObj.UserSQL = 'select distid,distnm,statid,statnm from dist join stat
> using(statid)'
> distBizObj.addChild(statBizObj)
> distBizObj.requery()
>
> ---end of file---
>
> In the python shell, I tried to change a record in tables---
>
> 1] successful example--
>
>>>> from myDir import bo
>>>> bo.statBizObj.seek('MyState1', fld='statnm')
>>>> bo.statBizObj.setFieldVal('statnm', 'MyState2')
>>>> bo.statBizObj.isAnyChanged()
>>>>
> True
>
>>>> bo.statBizObj.save()
>>>>
> The record gets saved in the database (verified from MySQL clc).
> (note: this table doesn't have any foreign key relationship with any other
> table)
>
> 2] Unsuccessful example--
>
>>>> from myDir import bo
>>>> bo.distBizObj.seek('MyDist1', fld='distnm')
>>>> bo.distBizObj.setFieldVal('distnm', 'MyDist2')
>>>> bo.distBizObj.isAnyChanged()
>>>>
> False
>
>>>> bo.distBizObj.save()
>>>>
> The record DOES NOT get saved in the database (verified from MySQL clc).
> (note: this table has foreign key relationship with 'stat' table)
>
> I am not able to find out why the case 2] is not working.
> Can anybody pl. suggest?
>
> Best regards,
>
> Vineet
>
> --- 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]
>
>
_______________________________________________
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]
