thanks villas, after modified the dal parameter DAL(..., ignore_field_case
= True, entity_quoting = False, ...), theres a lot of thing deal with
auth_user in firebird:
e.g.
1. deal with auth_user password field (already posted above)
auth.settings.password_field = 'password2'
auth.define_tables(username = True, signature = True, migrate = False)
custom_auth_table.password2.label = T('Password')
custom_auth_table.password2.widget = lambda field, value: \
SQLFORM.widgets.password.widget(field, value,
_class = "form-control password",
_placeholder = T('Should be filled') )
2. query auth_user
auth_user_customer = db(db.customer.auth_user ==
auth.user_id).iterselect().first()
3. event log when user insert, update or delete
for table in db.tables:
if '_archive' not in table and '_queue' not in table and table !=
'auth_event':
db[table]._after_insert.append(partial(test_event.after_insert_event, table
= table) )
db[table]._after_update.append(partial(test_event.after_update_event, table
= table) )
db[table]._before_delete.insert(0, partial(test_event.before_delete_event,
table = table) )
4. record versioning
auth.enable_record_versioning(db)
*traceback error:*
ProgrammingError: (-607, 'isc_dsql_execute: \n unsuccessful metadata
update\n Table AUTH_USER not found')
*Solution:*
- Comment the code in no 2 till 4 (assuming you put the code no 2 till 4 in
models)
- Hit the app once, if you need the code in no 2 till 4, remove the comment
after you hit the app
thanks and best regards,
stifan
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
