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'