Hello Massimo, Where can I find the version for tester? Also I am using SQL with MySQL with GAE through Cloud SQL, so the check_reserved keywords is necessary right?
Once I have the new version I will test it and report here. Thanks El martes, 24 de marzo de 2015, 17:32:09 (UTC+1), Massimo Di Pierro escribió: > > I spoke too soon. Please wait I post a new version for testers. I will > email this list. > Then try: > > db = DAL('google:sql://[app-name]:[db-name]/[table-name]') > ... > auth.settings.extra_fields['auth_user'] = [Field('username_fb', > length=128, default="", unique=True, writable=False, readable=False)] > auth.define_tables(username=False, signature=False) > > consider that migrate_enabled is true by default so no need to set it. > Also the check_reserved keywords is designed for SQL and not GAE. It does > not hurt but it is not necessary. I do not swear by lazy_table because they > have some caveats. Let's try without that. > > Can you help us check if this work? If, not what behaviour do you see? Do > you get a traceback? > > > On Tuesday, 24 March 2015 11:18:06 UTC-5, Sébastien Loix wrote: >> >> Thank you for the answer. >> Could you explain a bit more the "there are no migrations on GAE", is it >> only for the actual version and the fixed version will solve it? >> I realised that I am using the 2.10.0-beta version of web2py. The one >> downloaded from the main download page. >> Thanks for the help >> >> El martes, 24 de marzo de 2015, 8:31:51 (UTC+1), Massimo Di Pierro >> escribió: >>> >>> 1) there are no migrations on GAE, web2py will still create .table files >>> but they serve no purpose. >>> 2) GAE support is broken in 2.9.12. It works in trunk pydal and we will >>> released a fixed version this week >>> >>> On Monday, 23 March 2015 21:53:04 UTC-5, Sébastien Loix wrote: >>>> >>>> Hi, >>>> >>>> I am having difficulties with table migration on GAE. >>>> >>>> I deployed perfectly in the Google App Engine and everything is working >>>> fine. >>>> >>>> I then needed to make some change in the auth_user adding some extra >>>> field but when I deploy again the new version, the migration doesn't occur >>>> and the new column is not created. >>>> >>>> Here is the code used: >>>> >>>> db = DAL('google:sql://[app-name]:[db-name]/[table-name]', >>>> migrate_enabled=True, check_reserved=['all'], lazy_tables=True) >>>> >>>> then below: >>>> >>>> auth.settings.extra_fields['auth_user'] = [Field('username_fb', >>>> length=128, default="", unique=True, writable=False, readable=False)] >>>> auth.define_tables(username=False, signature=False, migrate=True) >>>> >>>> Any idea why the migration doesn't occur? >>>> >>>> Is there a way to force web2py to do migration somehow? >>>> >>>> Thanks for the help! >>>> Best, >>>> Sebastian >>>> >>> -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.