Looks like it's an issue with lazy_tables. I'll look into it, but for now,
give it a try by turning off lazy_tables.
Anthony
On Friday, February 7, 2014 8:45:46 AM UTC-5, Anthony wrote:
>
> Hmm, works for me. What version of web2py are you using?
>
> On Friday, February 7, 2014 8:07:10 AM UTC-5, Andrey K wrote:
>>
>> Thanks Anthony for your concise answer!
>> I have tried it in the app code - it did not work, giving me no error. I
>> have tried your code in the terminal and it looks the code does not create
>> new table field. Any idea why it does not work? Maybe its my db settings? I
>> use sqlite db. Your help would very helpful to me as all my app
>> dependent on this function.
>>
>> Here is my trial in a terminal:
>>
>> >>> from gluon import DAL, Field
>> >>> db = DAL('sqlite://se2.sqlite',check_reserved=['postgres',
>> 'postgres_nonreserved'],pool_size=10,lazy_tables=True, migrate=True,
>> fake_migrate=False)
>>
>> >>> ta_args = dict(format='%(f1)s')
>>
>>
>> >>> db.define_table('ta', Field('f1', 'string'), **ta_args)
>> >>> db._tables
>> ['ta']
>> >>> db.ta._fields
>>
>> ['id', 'f1']
>> #if understand correctly here I am trying to add new field 'newfield' to
>> the ta table.
>> >>> db.define_table('ta', db.ta,Field('newfield', 'string', default =
>> 'abc'),redefine=True, **ta_args)
>> >>> db.ta._fields
>> #it giving me no change in db.table field list
>>
>> ['id', 'f1']
>>
>> On Thursday, February 6, 2014 4:41:29 PM UTC+3, Anthony wrote:
>>>
>>> The safest way is probably to redefine the whole table.
>>>
>>> *models/dp.py:*
>>>
>>> tA_args = dict(format='%(f1)s', ...)
>>> db.define_table('tA',
>>> Field('f1', 'string'),
>>> **tA_args)
>>>
>>> *controllers/default.py:*
>>>
>>> db.define_table('tA', db.tA,
>>> Field('newfield'),
>>> redefine=True, **tA_args)
>>>
>>> Anthony
>>>
>>
--
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/groups/opt_out.
