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/gluon/restricted.py", line 212, in
>> restricted
>> exec ccode in environment
>> File
>> "/home/pvalleri/src/web2py/applications/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_point')
>> File "/home/pvalleri/src/web2py/gluon/dal.py", line 7221, in __getattr__
>> return self.lazy_define_table(tablename,*fields,**args)
>> File "/home/pvalleri/src/web2py/gluon/dal.py", line 7174, in
>> lazy_define_table
>> table = table_class(self, tablename, *fields, **args)
>> File "/home/pvalleri/src/web2py/gluon/dal.py", line 7594, in __init__
>> field.requires = sqlhtml_validators(field)
>> File "/home/pvalleri/src/web2py/gluon/dal.py", line 6338, in
>> sqlhtml_validators
>> referenced = db[field_type[10:]]
>> File "/home/pvalleri/src/web2py/gluon/dal.py", line 7215, in __getitem__
>> return self.__getattr__(str(key))
>> File "/home/pvalleri/src/web2py/gluon/dal.py", line 7221, in __getattr__
>> return self.lazy_define_table(tablename,*fields,**args)
>> File "/home/pvalleri/src/web2py/gluon/dal.py", line 7177, in
>> lazy_define_table
>> table._create_references() # must follow above line to handle self
>> references
>> File "/home/pvalleri/src/web2py/gluon/dal.py", line 7663, in
>> _create_references
>> rtable = db[rtablename]
>> File "/home/pvalleri/src/web2py/gluon/dal.py", line 7215, in __getitem__
>> return self.__getattr__(str(key))
>> File "/home/pvalleri/src/web2py/gluon/dal.py", line 7221, in __getattr__
>> return self.lazy_define_table(tablename,*fields,**args)
>> File "/home/pvalleri/src/web2py/gluon/dal.py", line 7189, in
>> lazy_define_table
>> polymodel=polymodel)
>> File "/home/pvalleri/src/web2py/gluon/dal.py", line 935, in create_table
>> self.create_sequence_and_triggers(query,table)
>> File "/home/pvalleri/src/web2py/gluon/dal.py", line 2483, in
>> create_sequence_and_triggers
>> self.execute(query)
>> File "/home/pvalleri/src/web2py/gluon/dal.py", line 1709, in execute
>> return self.log_execute(*a, **b)
>> File "/home/pvalleri/src/web2py/gluon/dal.py", line 1703, in log_execute
>> ret = self.cursor.execute(*a, **b)
>> File "/home/pvalleri/src/web2py/gluon/contrib/pg8000/dbapi.py", line 246,
>> in _fn
>> return fn(self, *args, **kwargs)
>> File "/home/pvalleri/src/web2py/gluon/contrib/pg8000/dbapi.py", line 317,
>> in execute
>> self._execute(operation, args)
>> File "/home/pvalleri/src/web2py/gluon/contrib/pg8000/dbapi.py", line 322,
>> in _execute
>> self.cursor.execute(new_query, *new_args)
>> File "/home/pvalleri/src/web2py/gluon/contrib/pg8000/interface.py", line
>> 399, in execute
>> self._stmt.execute(*args, **kwargs)
>> File "/home/pvalleri/src/web2py/gluon/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/gluon/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>
>>
>>
--
