Looks like you are not running the latest version of web2py .
--
Thadeus
On Sat, May 8, 2010 at 4:34 PM, Eldr3D <phyo.arkarl...@gmail.com> wrote:
> Hello all
>
> i just back to web2py a few weeks ago and i am still learning all the
> new changes reading online official web2py book.
>
> currently i am using web2py DALs in a non web-application , so to
> parse and import data from text files into database (to update
> records).
>
>
> here is the example of what i am doing :
>
> from gluon.sql import DAL,SQLTable,SQLField,Field
> import os,time
> import glob
> db = DAL('mysql://r...@localhost/cds')
> i=0
> db.define_table('cdsdata',
> Field('docID','string'),
> Field('grpID','string'),
> Field('author','string'),
> Field('subject','string'),
> Field('sentto','string'),
> Field('cc','string'),
> Field('bcc','string'),
> Field('sentDate','string'),
> Field('type','string'),
> Field('extracted','text'),migrate=False)
>
>
> rows=db(db.cdsdata.id>0).select('extracted')
>
> for row in rows:
> row.update(extracted=open("./exp/" + row.values()[0].values()[0]
> [-13:-1],'r').read())
> i+=1
> if i==1000:
> time.sleep(0.5)
> print "Updated Records : " + total
> i=0
> total+=1000
>
> db.commit()
> db.update()
>
>
> well it tries to update the rows but , they are not actually updated
> inside the database..
>
> also , is row.update_record() method is never existed? coz i cant call
> that function anymore..
>
> but what weird is when i try to do :
>
> db(db.cdsdata.id==1).update(extracted=" This is updated
> text!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!")
>
> it works flawlessly!
>
> So row.update is dosen't really work ?
> and row.update_record() never exist?
> :
>
>
> In [15]: row.update_record()
> ---------------------------------------------------------------------------
> KeyError Traceback (most recent call
> last)
>
> /home/v3ss/db_importer/<ipython console> in <module>()
>
> /home/v3ss/db_importer/gluon/sql.pyc in __getattr__(self, key)
> 662
> 663 def __getattr__(self, key):
> --> 664 return dict.__getitem__(self,key)
> 665
> 666 def __setattr__(self, key, value):
>
> KeyError: 'update_record'
>
>
>
