Anthony,
>migrate_enabled=False
Good to know, I will use this instead of migrate=False
Richard,
> I don't see why select should lock... And I don't think it lock since my
> user would not able to work concurrently...
I think you have a good point. I will just make sure not insert/update/
delete to the existing tables.
On Nov 1, 12:03 pm, Richard Vézina <ml.richard.vez...@gmail.com>
wrote:
> 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 <ochib...@gmail.com> 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 <ml.richard.vez...@gmail.com> 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 <ochib...@gmail.com> 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'])
