It is either
db(query).update(...)
or
for row in db(query).select(): row.update_record(...)
row.update(...) #WRONG BECUASE THIS IS PYTHON UPDATE METHOD
On May 11, 3:03 pm, Phyo Arkar <phyo.arkarl...@gmail.com> wrote:
> I did used Mercurial version Tagged 1.77.3 from googlecode. That is Same
> with release version 1.77.3 right?
>
> On Sat, May 8, 2010 at 10:10 PM, Thadeus Burgess <thade...@thadeusb.com>wrote:
>
> > 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'
