Migration was not disabled. However, I made a new application
duplicating the original db procedures, and I was able to add a field
in the field definition in db.py.
The new one:
db = DAL('sqlite://storage2.db')
from gluon.tools import Auth
auth = Auth(db)
auth.define_tables()
db.define_table('info',Field('a')
,Field('b')
,Field('c',requires=IS_NOT_EMPTY()),
Field('d'),
Field('e'),
Field('f',requires=IS_NOT_EMPTY())
)
It should be made clear in the documentation that some db operations
must use web2py DAL concepts. In the original, I added a field once
using db.sqlexecute and once in the sqlite3 bash command line and they
do not show in sqlform indicating some operations must have a specific
format which is not defined in the current documentation. Also, in
order to customize sqlform, etc., the underlying definitions should be
made clear in the documentation. I have not looked at the source yet,
but I anticipate this will be time consuming.
There was an initial effort at collaborative documentation. Please
resume this.
On Feb 22, 11:35 am, Anthony <abasta...@gmail.com> wrote:
> Did you turn off migrations via DAL(..., migrate=False) or DAL(...,
> migrate_enabled=False)? Is this in a web2py app, or an external script or
> shell?
>
>
>
>
>
>
>
> On Wednesday, February 22, 2012 2:16:17 PM UTC-5, davidjensen wrote:
>
> > In db.py, I created a db 'contacts' with a table 'mytable'. I later
> > added a field 'date' to mytable.
>
> > db.define_table('mytable',
> > Field('date',requires=IS_NOT_EMPTY()),
> > Field('name',requires=IS_NOT_EMPTY()),
> > Field('organization'),
> > Field('notes','text', requires=IS_NOT_EMPTY())
> > )
>
> > The new field did not show. Is it necessary to use db.executesql with
> > an alter statement or is there a way to do this in web2py? I can also
> > use sqlite3 command line.
>
> > Thanks,
