On 12/21/2010 02:19 AM, John Fabiani wrote:
> On Monday, December 20, 2010 08:56:03 pm John Fabiani wrote:
>> On Monday, December 20, 2010 01:59:42 pm Ed Leafe wrote:
>>> On Dec 20, 2010, at 4:54 PM, marcelo nicolet wrote:
>>>> Thank you again, John. But is exactly in the bizobj where it's
>>>> convenient to have an "array flavor" of these data, because some of the
>>>> biz rules involve a sum over the elements.
>>>
>>> If you requery the table, can you reference biz.Record.array_column
>> (where
>>
>>> 'biz' is your bizobj, and 'array_column' is the Postgres array? Do you
>>> get a Python list of values?
>>>
>>>
>>> -- Ed Leafe
>> In testing I discovered the following:
>>
>> CREATE TABLE sal_emp
>> (
>> "name" text,
>> pay_by_quarter integer[],
>> schedule text[]
>> )
>> WITH (
>> OIDS=FALSE
>> );
>>
>> Using a standard bizobj class:
>> class Publicsal_EmpBizobj(dabo.biz.dBizobj):
>> def afterInit(self):
>> self.DataSource = "public.sal_emp"
>> self.KeyField = ""
>> self.addFrom("public.sal_emp")
>> self.addField("schedule")
>> self.addField("name")
>> self.addField("pay_by_quarter")
>>
>> 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
>>
>> Using a standard cnxml connection. I added the bizobj to a form.
>>
>> self.testbizobj= Publicsal_EmpBizobj(self.conn)
>> self.addBizobj(self.testbizobj)
>>
>> I am able to access the field without issue.
>>
>> self.testbizobj.Record.pay_by_quarter
>> provides a python list
> Forgot the PK:
> class Publicsal_EmpBizobj(dabo.biz.dBizobj):
> def afterInit(self):
> self.DataSource = "public.sal_emp"
> self.KeyField = "pkid"
> self.addFrom("public.sal_emp")
> self.addField('pkid')
> self.addField("schedule")
> self.addField("name")
> self.addField("pay_by_quarter")
>
>
>
> And of course all the list stuff just works
>
> myDS = self.testbizobj.getDataSet()
> myDS[0]['pay_by_quarter'][0]
>
> As I suggested dbPostgres.py returns the data type as unknown ('?').
> Everything works as far as the read is concerned.
>
> Writing data to the array is not working.
>
> self.testbizobj.setFieldVal('pay_by_quarter[0]', 2000)
>
> Traceback (most recent call last):
> File "<input>", line 1, in<module>
> File "/home/johnf/dabo/dabo/biz/dBizobj.py", line 1631, in setFieldVal
> ret = cursor.setFieldVal(fld, val, row)
> File "/home/johnf/dabo/dabo/db/dCursorMixin.py", line 962, in setFieldVal
> _("Field '%s' does not exist in the data set.") % (fld,))
> FieldNotFoundException: Field 'pay_by_quarter[0]' does not exist in the data
> set.
>
> I suspected this because Dabo is looking for real field and not list.
>
> but this works
> self.testbizobj.setFieldVal('pay_by_quarter',[2000,3000,4000,5000])
> self.testbizobj.save()
>
> Johnf
>
>
Thank you very much, John: you did all the job!
I'm studying carefullly all what you did, to understand the thing.
Marcelo
>
> _______________________________________________
> 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]
