One or an other is ok, they lead to the same thing! I am adding them to my project :) However, after I first test, i could see any difference, I will investigate more asap
2013/1/15 Niphlod <[email protected]> > I'd rather specify also that auth.define_tables(migrate=False) is the way > to go to turn migrations off of all the auth_* tables > > Il giorno martedì 15 gennaio 2013 14:11:48 UTC+1, Paolo valleri ha scritto: >> >> Thanks for clarifying it. >> So that, to speed up web2py, we must use migrate_enabled=False instead of >> migrate=False at DAL definition. Otherwise for all the auth_* tables, >> web2py will access the disk to verify if the relative file in >> databases/hash_tablename.table exists and is updated, right? >> If what I have said is correct I would suggest to update the book, >> http://web2py.com/books/**default/chapter/29/13#**Efficiency-tricks<http://web2py.com/books/default/chapter/29/13#Efficiency-tricks> >> changing migrate=False with migrate_enabled=False >> >> Paolo >> >> >> 2013/1/15 Anthony <[email protected]> >> >> DAL(..., migrate=False) does not completely turn off migrations but >>> merely sets the default migrate value for each table to False if it is not >>> set explicitly. The auth.define_tables() method, however, explicitly sets >>> migrate to True for each Auth table unless otherwise specified, so you >>> would have to do auth.define_tables(..., migrate=False). Another option is >>> to completely disable all migrations, regardless of individual table >>> settings, via: >>> >>> DAL(..., migrate_enabled=False) >>> >>> Anthony >>> >>> >>> On Tuesday, January 15, 2013 7:35:14 AM UTC-5, Paolo valleri wrote: >>>> >>>> is on the db definition. >>>> db = DAL('postgres://web2py:web2py@****localhost:5432/traffic', >>>> migrate=False, >>>> lazy_tables=True, >>>> ) >>>> >>>> Paolo >>>> >>>> On Tuesday, January 15, 2013 11:38:49 AM UTC+1, Niphlod wrote: >>>>> >>>>> migrate=False is on the db or on Auth define_table() call ? >>>>> >>>>> >>>>> >>>>> Il giorno martedì 15 gennaio 2013 11:07:49 UTC+1, Paolo valleri ha >>>>> scritto: >>>>>> >>>>>> Hi all, I tried something odd. >>>>>> I pulled a fresh copy of my code from git and I connected the app to >>>>>> an already 'working' database. 'working' in the meaning that both tables >>>>>> and data are already in the database. In web2py this approach >>>>>> fails, because at the first run it tries to create all the tables, and >>>>>> the >>>>>> db raises an exception like 'table already exist'. >>>>>> In order to fix that I thought that migrate=False would help, however >>>>>> it fails again. due to Auth that tries to create the tables. Ticket: >>>>>> >>>>>> Traceback (most recent call last): >>>>>> >>>>>> >>>>>> >>>>>> File "/home/pvalleri/src/web2py/**glu**on/restricted.py", line 212, in >>>>>> restricted >>>>>> >>>>>> >>>>>> >>>>>> exec ccode in environment >>>>>> >>>>>> >>>>>> >>>>>> File >>>>>> "/home/pvalleri/src/web2py/**app**lications/vtraffic/**controllers**/default.py" >>>>>> >>>>>> <http://127.0.0.1:8000/admin/default/edit/vtraffic/controllers/default.py>, >>>>>> line 6, in <module> >>>>>> >>>>>> >>>>>> >>>>>> start = db.record.with_alias('start_**po**int') >>>>>> >>>>>> >>>>>> >>>>>> File "/home/pvalleri/src/web2py/**glu**on/dal.py", line 7221, in >>>>>> __getattr__ >>>>>> >>>>>> >>>>>> >>>>>> return self.lazy_define_table(tablena****me,*fields,**args) >>>>>> >>>>>> >>>>>> >>>>>> File "/home/pvalleri/src/web2py/**glu**on/dal.py", line 7174, in >>>>>> lazy_define_table >>>>>> >>>>>> >>>>>> >>>>>> table = table_class(self, tablename, *fields, **args) >>>>>> >>>>>> >>>>>> >>>>>> File "/home/pvalleri/src/web2py/**glu**on/dal.py", line 7594, in >>>>>> __init__ >>>>>> >>>>>> >>>>>> >>>>>> field.requires = sqlhtml_validators(field) >>>>>> >>>>>> >>>>>> >>>>>> File "/home/pvalleri/src/web2py/**glu**on/dal.py", line 6338, in >>>>>> sqlhtml_validators >>>>>> >>>>>> >>>>>> >>>>>> referenced = db[field_type[10:]] >>>>>> >>>>>> >>>>>> >>>>>> File "/home/pvalleri/src/web2py/**glu**on/dal.py", line 7215, in >>>>>> __getitem__ >>>>>> >>>>>> >>>>>> >>>>>> return self.__getattr__(str(key)) >>>>>> >>>>>> >>>>>> >>>>>> File "/home/pvalleri/src/web2py/**glu**on/dal.py", line 7221, in >>>>>> __getattr__ >>>>>> >>>>>> >>>>>> >>>>>> return self.lazy_define_table(tablena****me,*fields,**args) >>>>>> >>>>>> >>>>>> >>>>>> File "/home/pvalleri/src/web2py/**glu**on/dal.py", line 7177, in >>>>>> lazy_define_table >>>>>> >>>>>> >>>>>> >>>>>> table._create_references() # must follow above line to handle self >>>>>> references >>>>>> >>>>>> >>>>>> >>>>>> File "/home/pvalleri/src/web2py/**glu**on/dal.py", line 7663, in >>>>>> _create_references >>>>>> >>>>>> >>>>>> >>>>>> rtable = db[rtablename] >>>>>> >>>>>> >>>>>> >>>>>> File "/home/pvalleri/src/web2py/**glu**on/dal.py", line 7215, in >>>>>> __getitem__ >>>>>> >>>>>> >>>>>> >>>>>> return self.__getattr__(str(key)) >>>>>> >>>>>> >>>>>> >>>>>> File "/home/pvalleri/src/web2py/**glu**on/dal.py", line 7221, in >>>>>> __getattr__ >>>>>> >>>>>> >>>>>> >>>>>> return self.lazy_define_table(tablena****me,*fields,**args) >>>>>> >>>>>> >>>>>> >>>>>> File "/home/pvalleri/src/web2py/**glu**on/dal.py", line 7189, in >>>>>> lazy_define_table >>>>>> >>>>>> >>>>>> >>>>>> polymodel=polymodel) >>>>>> >>>>>> >>>>>> >>>>>> File "/home/pvalleri/src/web2py/**glu**on/dal.py", line 935, in >>>>>> create_table >>>>>> >>>>>> >>>>>> >>>>>> self.create_sequence_and_**trigg**ers(query,table) >>>>>> >>>>>> >>>>>> >>>>>> File "/home/pvalleri/src/web2py/**glu**on/dal.py", line 2483, in >>>>>> create_sequence_and_triggers >>>>>> >>>>>> >>>>>> >>>>>> self.execute(query) >>>>>> >>>>>> >>>>>> >>>>>> File "/home/pvalleri/src/web2py/**glu**on/dal.py", line 1709, in >>>>>> execute >>>>>> >>>>>> >>>>>> >>>>>> return self.log_execute(*a, **b) >>>>>> >>>>>> >>>>>> >>>>>> File "/home/pvalleri/src/web2py/**glu**on/dal.py", line 1703, in >>>>>> log_execute >>>>>> >>>>>> >>>>>> >>>>>> ret = self.cursor.execute(*a, **b) >>>>>> >>>>>> >>>>>> >>>>>> File "/home/pvalleri/src/web2py/**glu**on/contrib/pg8000/dbapi.py"**, >>>>>> line 246, in _fn >>>>>> >>>>>> >>>>>> >>>>>> return fn(self, *args, **kwargs) >>>>>> >>>>>> >>>>>> >>>>>> File "/home/pvalleri/src/web2py/**glu**on/contrib/pg8000/dbapi.py"**, >>>>>> line 317, in execute >>>>>> >>>>>> >>>>>> >>>>>> self._execute(operation, args) >>>>>> >>>>>> >>>>>> >>>>>> File "/home/pvalleri/src/web2py/**glu**on/contrib/pg8000/dbapi.py"**, >>>>>> line 322, in _execute >>>>>> >>>>>> >>>>>> >>>>>> self.cursor.execute(new_query, *new_args) >>>>>> >>>>>> >>>>>> >>>>>> File >>>>>> "/home/pvalleri/src/web2py/**glu**on/contrib/pg8000/**interface.**py", >>>>>> line 399, in execute >>>>>> >>>>>> >>>>>> >>>>>> self._stmt.execute(*args, **kwargs) >>>>>> >>>>>> >>>>>> >>>>>> File >>>>>> "/home/pvalleri/src/web2py/**glu**on/contrib/pg8000/**interface.**py", >>>>>> line 169, in execute >>>>>> >>>>>> >>>>>> >>>>>> self._row_desc, cmd = self.c.bind(self._portal_name, >>>>>> self._statement_name, args, self._parse_row_desc, kwargs.get("stream")) >>>>>> >>>>>> >>>>>> >>>>>> File >>>>>> "/home/pvalleri/src/web2py/**glu**on/contrib/pg8000/protocol.**py"**, >>>>>> line 943, in _fn >>>>>> >>>>>> >>>>>> >>>>>> return fn(self, *args<span style="color: #660;" class="styled-by... >>>>>> >>>>>> >>>>>> Mostra originale >>>>>> <https://groups.google.com/group/web2py/msg/64de6b8ababbd2a3?dmode=source&output=gplain&noredirect> >>>>>> >>>>>> -- >>> >>> >>> >>> >> >> >> >> -- >> Paolo >> > -- > > > > -- Paolo --
