Still there in the yesterday trunk... Richard
On Tue, May 15, 2012 at 11:59 AM, Richard Vézina < [email protected]> wrote: > I don't see any ticket about that on google code... > > I will create it if Massimo tell me. > > In the mean time I will try the trunk. > > Richard > > On Tue, May 15, 2012 at 11:40 AM, Jim Steil <[email protected]> wrote: > >> Yes, that is a situation I ran into some time ago. In the past even if >> you used a custom ID column you could still refer to the column with .id. >> That went away in trunk some time ago. I really wish it were back, it made >> some other things very easy. I tried working with a slice just last week >> that didn't work for me any more because I use custom ID field names. >> >> -Jim >> >> >> On 5/15/2012 10:29 AM, Richard Vézina wrote: >> >> Ok, I think I had problem with model definition : 'db.auth...' : foreign >> key were quoted... I have this issue since a long time, If I was removing >> quote I didn't have proper representation... >> >> Fixed now... >> >> But now it seems that I have problem with the use of id in case were I >> have define a custom id. Ex: >> >> db.define_table('table1_tab1', >> Field('tab1_id','id'), >> ... >> >> >> In the pass I was able to call id or tab1_id : >> >> 1.99.4 >> In [1]: db.table1_tab1(1).id >> Out[1]: 1 >> >> In [2]: db.table1_tab1(1).tab1_id >> Out[2]: 1 >> >> >> 1.99.7 >> In [1]: db.table1_tab1(1).id >> KeyError: 'id' >> >> In [2]: db.table1_tab1(1).tab1_id >> Out[2]: 1 >> >> Is it something not anymore possible or this bug have been introduce >> recently? >> >> Richard >> >> On Tue, May 15, 2012 at 10:52 AM, Richard Vézina < >> [email protected]> wrote: >> >>> Wait... >>> >>> >>> On Tue, May 15, 2012 at 10:37 AM, Richard Vézina < >>> [email protected]> wrote: >>> >>>> Ok if I copy my custom auth models into a new app it keeps loading the >>>> page for ever and don't create the table at postgres level. >>>> >>>> Richard >>>> >>>> >>>> On Tue, May 15, 2012 at 10:19 AM, Richard Vézina < >>>> [email protected]> wrote: >>>> >>>>> Yes I try a new app without defining auth models myself, just changed >>>>> the connection string for postgres and it works. >>>>> >>>>> I don't have the typo in my code, it maybe happen when copy/paste >>>>> the code somehow. >>>>> >>>>> I just add this : auth=Auth(db, *hmac_key=Auth.get_or_create_key()*) >>>>> >>>>> No change. >>>>> >>>>> Richard >>>>> >>>>> >>>>> On Tue, May 15, 2012 at 10:04 AM, Massimo Di Pierro < >>>>> [email protected]> wrote: >>>>> >>>>>> There is a typo in your code: >>>>>> >>>>>> uth.settings.hmac_key='sha512:8e95c268-cc31-4119-890d-a5790d3e05d3' >>>>>> >>>>>> should be >>>>>> >>>>>> auth.settings.hmac_key='sha512:8e95c268-cc31-4119-890d-a5790d3e05d3' >>>>>> >>>>>> although this is probably not the cause for your problems. Does it >>>>>> work if you use sqlite? Does it work if you use postgresql with a new >>>>>> database? >>>>>> >>>>>> On Monday, 14 May 2012 15:53:40 UTC-5, Richard wrote: >>>>>>> >>>>>>> Hello, >>>>>>> >>>>>>> I try one more time to upgrade to 1.99.7 today without succes. But >>>>>>> now I know what append... It works fine, until I try to logon with a >>>>>>> user... >>>>>>> >>>>>>> In shell it works fine, can access to any tables... >>>>>>> >>>>>>> Is there change to the logon process has been changed between >>>>>>> 1.99.4 and 1.99.7? >>>>>>> >>>>>>> Thanks >>>>>>> >>>>>>> Richard >>>>>>> >>>>>>> On Thu, Mar 8, 2012 at 12:54 PM, Richard Vézina < >>>>>>> [email protected]> wrote: >>>>>>> >>>>>>>> Ping! >>>>>>>> >>>>>>>> Richard >>>>>>>> >>>>>>>> >>>>>>>> On Wed, Mar 7, 2012 at 10:48 AM, Richard Vézina < >>>>>>>> [email protected]> wrote: >>>>>>>> >>>>>>>>> I use to download source package and make my update by my own >>>>>>>>> (manually). I don't use the update feature. >>>>>>>>> >>>>>>>>> Here most of my db.py that contain db connection and all related >>>>>>>>> auth configuration : >>>>>>>>> >>>>>>>>> db=DAL('postgres://USER:[email protected]:5432/DATABASE', \ >>>>>>>>> migrate_enabled=False) >>>>>>>>> >>>>>>>>> >>>>>>>>> from gluon.tools import * >>>>>>>>> auth=Auth(globals(),db) # authentication/authorization >>>>>>>>> >>>>>>>>> auth_table = db.define_table( >>>>>>>>> auth.settings.table_user_name, >>>>>>>>> Field('first_name', length=128, default=None, >>>>>>>>> required=True, >>>>>>>>> notnull=True, >>>>>>>>> requires = >>>>>>>>> IS_NOT_EMPTY(error_message=T(auth.messages.is_empty)), >>>>>>>>> ), >>>>>>>>> Field('last_name', length=128, default=None, >>>>>>>>> requires = >>>>>>>>> IS_NOT_EMPTY(error_message=T(auth.messages.is_empty)), >>>>>>>>> ), >>>>>>>>> Field('email', length=128, default=None, unique=True, >>>>>>>>> label=T('Email'), >>>>>>>>> requires = >>>>>>>>> [IS_EMAIL(error_message=T(auth.messages.invalid_email)), >>>>>>>>> IS_NOT_IN_DB(db, 'auth_user.email')], >>>>>>>>> ), >>>>>>>>> Field('password', 'password', length=256, >>>>>>>>> readable=False, label=T('Password'), >>>>>>>>> required=True, >>>>>>>>> notnull=True, >>>>>>>>> requires = >>>>>>>>> CRYPT(min_length=auth.settings.password_min_length, >>>>>>>>> error_message=T('too short')) >>>>>>>>> ), >>>>>>>>> Field('registration_key', length=128, default=None, >>>>>>>>> writable=False, readable=False), >>>>>>>>> Field('reset_password_key', length=512, >>>>>>>>> writable=False, readable=False, default=None >>>>>>>>> ), >>>>>>>>> Field('initials','string',length=5), >>>>>>>>> migrate=False, >>>>>>>>> format='%(first_name)s %(last_name)s (%(id)s)') >>>>>>>>> >>>>>>>>> auth.settings.table_user = auth_table # no idea what this line >>>>>>>>> do... >>>>>>>>> >>>>>>>>> auth_table = db.define_table( >>>>>>>>> auth.settings.table_event_name, >>>>>>>>> Field('time_stamp','datetime',default=request.now), >>>>>>>>> Field('client_ip','string',length=512,default=request.client), >>>>>>>>> Field('user_id',db.auth_user), >>>>>>>>> Field('origin','string',length=512), >>>>>>>>> Field('description','text'), >>>>>>>>> migrate=False,) >>>>>>>>> >>>>>>>>> auth_table = db.define_table( >>>>>>>>> auth.settings.table_group_name, >>>>>>>>> Field('role','string',length=512), >>>>>>>>> Field('description','text'), >>>>>>>>> migrate=False, >>>>>>>>> format='%(role)s (%(id)s)') >>>>>>>>> >>>>>>>>> auth_table = db.define_table( >>>>>>>>> auth.settings.table_membership_name, >>>>>>>>> Field('user_id','db.auth_user'), >>>>>>>>> Field('group_id','db.auth_group'), >>>>>>>>> migrate=False,) >>>>>>>>> >>>>>>>>> >>>>>>>>> db.auth_membership.user_id.requires=IS_IN_DB(db,'auth_user.id','%(first_name)s >>>>>>>>> %(last_name)s (%(id)s)') >>>>>>>>> db.auth_membership.group_id.requires=IS_IN_DB(db,'auth_group.id','%(role)s-%(description)s >>>>>>>>> (%(id)s)') >>>>>>>>> >>>>>>>>> db.auth_membership.user_id.represent=\ >>>>>>>>> lambda value: (value!=None and "%(first_name)s %(last_name)s >>>>>>>>> (%(id)s)" %db.auth_user[value]) or 'None' >>>>>>>>> db.auth_membership.group_id.represent=\ >>>>>>>>> lambda value: (value!=None and "%(role)s (%(id)s)" >>>>>>>>> %db.auth_group[value]) or 'None' >>>>>>>>> >>>>>>>>> db.define_table('auth_group_allowed', >>>>>>>>> Field('id','id'), >>>>>>>>> Field('user_id','db.auth_user'), >>>>>>>>> Field('group_id','db.auth_group'), >>>>>>>>> Field('active_gr','boolean'), >>>>>>>>> migrate=False, >>>>>>>>> sequence_name='auth_group_allowed_id_seq') >>>>>>>>> >>>>>>>>> >>>>>>>>> db.auth_group_allowed.user_id.requires=IS_IN_DB(db,'auth_user.id','%(first_name)s >>>>>>>>> %(last_name)s (%(id)s)') >>>>>>>>> db.auth_group_allowed.group_id.requires=IS_IN_DB(db,'auth_group.id','%(role)s >>>>>>>>> (%(id)s)') >>>>>>>>> >>>>>>>>> db.auth_group_allowed.user_id.represent=\ >>>>>>>>> lambda value: (value!=None and "%(first_name)s %(last_name)s >>>>>>>>> (%(id)s)" %db.auth_user[value]) or 'None' >>>>>>>>> db.auth_group_allowed.group_id.represent=\ >>>>>>>>> lambda value: (value!=None and "%(role)s (%(id)s)" >>>>>>>>> %db.auth_group[value]) or 'None' >>>>>>>>> >>>>>>>>> auth_table = db.define_table( >>>>>>>>> auth.settings.table_permission_name, >>>>>>>>> Field('group_id','db.auth_group'), >>>>>>>>> Field('name','string',length=512), >>>>>>>>> Field('table_name','string',length=512), >>>>>>>>> Field('record_id','integer'), >>>>>>>>> migrate=False,) >>>>>>>>> >>>>>>>>> db.auth_permission.group_id.requires=\ >>>>>>>>> IS_IN_DB(db,'auth_group.id','%(role)s (%(id)s)') >>>>>>>>> >>>>>>>>> db.auth_permission.group_id.represent=\ >>>>>>>>> lambda id: "%(role)s (%(id)s)" %db.auth_group[id] >>>>>>>>> >>>>>>>>> auth_table = db.define_table( >>>>>>>>> auth.settings.table_cas_name, >>>>>>>>> Field('user_id','integer'), >>>>>>>>> Field('created_on','datetime'), >>>>>>>>> Field('url','string',length=512), >>>>>>>>> Field('uuid','string',length=512), >>>>>>>>> migrate=False,) >>>>>>>>> >>>>>>>>> crud=Crud(globals(),db) # for CRUD helpers using >>>>>>>>> auth >>>>>>>>> service=Service(globals()) # for json, xml, jsonrpc, >>>>>>>>> xmlrpc, amfrpc >>>>>>>>> >>>>>>>>> crud.settings.auth=auth >>>>>>>>> >>>>>>>>> >>>>>>>>> uth.settings.hmac_key='sha512:8e95c268-cc31-4119-890d-a5790d3e05d3' >>>>>>>>> auth.define_tables() # creates all needed tables >>>>>>>>> auth.settings.actions_disabled.append('profile') # prohibit users >>>>>>>>> to modify their profile >>>>>>>>> auth.settings.actions_disabled.append('register') >>>>>>>>> >>>>>>>>> Thanks >>>>>>>>> >>>>>>>>> Richard >>>>>>>>> >>>>>>>>> >>>>>>>>> On Wed, Mar 7, 2012 at 10:24 AM, pbreit <[email protected]>wrote: >>>>>>>>> >>>>>>>>>> Are you able to upgrade to most recent version of Web2py? We >>>>>>>>>> might need to see more of your model code that specifies the DB and >>>>>>>>>> auth. >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>> >>>>> >>>> >>> >> >
