As far as I can understand I am using it properly and not all the tables are versionned :
http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Record-versioning As I set it for auth_user only and not use .enable_record_versioning() but ._enable_record_versioning()... Can someone confirm that? Thanks Richard On Tue, Mar 14, 2017 at 4:11 PM, Richard Vézina <ml.richard.vez...@gmail.com > wrote: > About redefine auth tables, I don't know another way to set username=True > than : > > auth.define_tables(username=True) > > I had in my todo-list to refactor my code to use the new way of > customizing auth tables, maybe it would solve this issue if it really is > one?? > > Richard > > On Tue, Mar 14, 2017 at 3:55 PM, Richard Vézina < > ml.richard.vez...@gmail.com> wrote: > >> Good catch for the IS_IN_DB() I wrote this part fast (address book part) >> long time ago in a pet app and copy the code in production without too much >> double check... >> >> I am not sure I understand why you say that I record versioning the whole >> tables as far as I understand this version only auth_user, no?? >> >> db.auth_user._enable_record_versioning(archive_db=db, >> >> archive_name='auth_user_archive', >> >> current_record='current_record', >> >> is_active='is_active') >> >> Or you talk about another part of the code? >> >> Thanks >> >> >> Richard >> >> On Tue, Mar 14, 2017 at 3:42 PM, Richard Vézina < >> ml.richard.vez...@gmail.com> wrote: >> >>> Thanks for the look up... Too many questions at the same time, will >>> review my code base on your pin point... >>> >>> :) >>> >>> Richard >>> >>> On Tue, Mar 14, 2017 at 3:28 PM, Leonel Câmara <leonelcam...@gmail.com> >>> wrote: >>> >>>> Ok I've found the problem. >>>> >>>> You have 2 IS_IN_DB validator calls where you use db.address.id and >>>> db.phone_number_kind.id instead of "address.id" and " >>>> phone_number_kind.id" >>>> >>>> But the bigger problem is that you are enabling record versioning for >>>> all tables which pretty much makes them all load. >>>> >>>> Instead of this you can add an on_define to each table where you turn >>>> record versioning on for that specific table. >>>> >>>> def toggle_versioning(table): >>>> table._enable_record_versioning() >>>> >>>> db.define_table('my_versioned_table', >>>> Field('name'), >>>> on_define=toggle_versioning >>>> ) >>>> >>>> >>>> >>>> >>>> By the way why are you defining auth tables in your model and then >>>> calling auth.define_tables to define them again, also consider using >>>> auth.signature instead of tables_generic_fields. >>>> >>>> -- >>>> 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 web2py+unsubscr...@googlegroups.com. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> >> > -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
