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]
