I don't see why select should lock... And I don't think it lock since my user would not able to work concurrently...
Richard On Tue, Nov 1, 2011 at 12:46 PM, Omi Chiba <[email protected]> wrote: > Richard, > > Thanks for your reply. Yep, I set the migrate=False at DAL level so > that I don't have to specify each table. > > > If you use crud and you define permissions, just don't give update, > delete > > and create rigths (so just read and select, maybe). > > > > About the not lock any record, I don't know how it works exactly, but I > > think that if you only use read and select there will be not lock (to be > > confirmed). > > Yeah, that's kind of what I thought. As long as I'm SELECTing it's > should not lock the record but I wasn't sure. > > On Nov 1, 9:31 am, Richard Vézina <[email protected]> wrote: > > migrate=False > > > > If you use crud and you define permissions, just don't give update, > delete > > and create rigths (so just read and select, maybe). > > > > About the not lock any record, I don't know how it works exactly, but I > > think that if you only use read and select there will be not lock (to be > > confirmed). > > > > Richard > > > > > > > > > > > > > > > > On Tue, Nov 1, 2011 at 10:25 AM, Omi Chiba <[email protected]> wrote: > > > I'm connecting existing tables on DB2 which is for a mission critical > > > system. I just want to read them and don't want to lock any record on > > > the tables. > > > > > Shoud I explicitly put readonly or it doesn't matter if I don't use > > > like crud.update ?? > > > > > My definition for existing table > > > ----------------------------------------- > > > db.define_table('SDTH2L01', > > > Field('H2DNO', length=8), > > > Field('H2JDNO', length=8), > > > Field('H2JGNO', 'integer'), > > > Field('H2PRCD', length=15), > > > Field('H2PRKJ', length=50), > > > Field('H2TRS', 'integer'), > > > Field('H2HZS', 'integer'), > > > primarykey=['H2DNO']) >
