Try follow my instructions above and fake_migrate goes here:
db.define_table('performer', __performer, __audit,fake_migrate=True or
False)
db.define_table('performer_audit_trail', __performer,
__audit_trail,fake_migrate=True or False)
On Apr 24, 10:07 am, Matthew <[email protected]> wrote:
> Here are the relevant parts of the model. I didn't copy the
> boilerplate code like connection string, etc at the start of the db.py
> file:
>
> # Common fields.
> ###############################################################
>
> # Web data.
> __web_resource = db.Table(db,
> '__web_resource',
> Field('wikipedia_id'),
> Field('myspace_id'),
> Field('facebook_id'))
>
> # All tables will inherit this simple audit.
> current_user_id = (auth.user and auth.user.id) or 1
>
> __audit = db.Table(db,
> '__audit',
> Field('created_on', 'datetime',
> default=request.now),
> Field('created_by', db.auth_user,
> default=current_user_id),
> Field('modified_on', 'datetime',
> default=request.now),
> Field('modified_by', db.auth_user,
> default=current_user_id))
>
> # Each table's corresponding *audit table will inherit this audit.
> __audit_trail = db.Table(db,
> '__audit_trail',
> Field('modified_on', 'datetime',
> default=request.now),
> Field('modified_by', db.auth_user,
> default=current_user_id))
>
> # Tables.
> ######################################################################
>
> # Performer
> __performer = db.Table(db,
> '__performer',
> Field('name'),
> Field('slug'),
> Field('twitter_id'),
> Field('musicbrainz_guid'), # the offending new
> field
> __web_resource)
>
> db.define_table('performer', __performer, __audit)
> db.define_table('performer_audit_trail', __performer, __audit_trail)
>
> On Apr 24, 10:46 am, mdipierro <[email protected]> wrote:
>
> > hmmm. I guess I need to the model then. fake_migrate was supported in
> > 1.76.5
>
> > Massimo
>
> > On Apr 24, 9:37 am, Matthew <[email protected]> wrote:
>
> > > 1.76.5
>
> > > On Apr 24, 10:35 am, mdipierro <[email protected]> wrote:
>
> > > > you must have a very old web2py version.
>
> > > > On Apr 24, 9:25 am, Matthew <[email protected]> wrote:
>
> > > > > I'm including previously-defined tables in other tables to reduce
> > > > > maintenance. For example, I have "__web_resource" table that has
> > > > > Wikipedia IDs, etc that I'm using in other tables.
>
> > > > > When I tried your suggestion, I got the following error:
>
> > > > > File "/home/matthew/dev/projects/webapp/src/app/applications/myapp/
> > > > > models/db.py", line 114, in <module>
> > > > > __web_resource, fake_migrate=True)
> > > > > TypeError: __init__() got an unexpected keyword argument
> > > > > 'fake_migrate'
>
> > > > > Is this due to the inclusion of other tables?
>
> > > > > On Apr 23, 10:13 am, mdipierro <[email protected]> wrote:
>
> > > > > > Something went wrong with migration. Do this:
>
> > > > > > 1) comment the field that gives you problem and set migrate to fake:
>
> > > > > > db.define_table('performer',
> > > > > > ...
> > > > > > # Field('musicbrainz_guid'....),
> > > > > > ...,
> > > > > > fake_migrate=True) # <<<
>
> > > > > > 2) run appadmin once (it should work)
>
> > > > > > 3) uncomment field and remove fake migrate
>
> > > > > > db.define_table('performer',
> > > > > > ...
> > > > > > Field('musicbrainz_guid'....),
> > > > > > ...)
>
> > > > > > 4) run appadmin again. If you get an error something is wrong in
> > > > > > your
> > > > > > model.
>
> > > > > > On Apr 23, 6:19 am, Matthew <[email protected]> wrote:
>
> > > > > > > >>> perf = db(db.performer.id > 0).first()
>
> > > > > > > Traceback (most recent call last):
> > > > > > > File "<console>", line 1, in <module>
> > > > > > > AttributeError: 'Set' object has no attribute 'first'>>> perf =
> > > > > > > db(db.performer.id > 0).select().first()
>
> > > > > > > Traceback (most recent call last):
> > > > > > > File "<console>", line 1, in <module>
> > > > > > > File "/home/matthew/dev/projects/webapp/src/app/gluon/sql.py",
> > > > > > > line
> > > > > > > 3056, in select
> > > > > > > rows = response(query)
> > > > > > > File "/home/matthew/dev/projects/webapp/src/app/gluon/sql.py",
> > > > > > > line
> > > > > > > 3051, in response
> > > > > > > db._execute(query)
> > > > > > > File "/home/matthew/dev/projects/webapp/src/app/gluon/sql.py",
> > > > > > > line
> > > > > > > 958, in <lambda>
> > > > > > > self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
> > > > > > > ProgrammingError: column performer.musicbrainz_guid does not exist
> > > > > > > LINE 1: ..._id, performer.facebook_id, performer.twitter_id,
> > > > > > > performer....
>
> > > > > > > On Apr 22, 8:48 am, Kuba Kucharski <[email protected]>
> > > > > > > wrote:
>
> > > > > > > > Can you show us the line with a query code?
>
> > > > > > > > --
> > > > > > > > Kuba
>
> > > > > > > > --
> > > > > > > > Subscription
> > > > > > > > settings:http://groups.google.com/group/web2py/subscribe?hl=en
