Massimo , how about making Web2py able to analyse table structures via SQLReflections ?
That is done with Squlsoup extension of SQLAlchemy., Wont be difficult to implement. On my free time i will check how SQLSoup works and try to implement for web2py. On Fri, Oct 17, 2008 at 4:22 PM, Phyo Arkar <[EMAIL PROTECTED]>wrote: > have you delete all under databases folder? > > > On Fri, Oct 17, 2008 at 4:18 PM, billf <[EMAIL PROTECTED]>wrote: > >> >> Ok did the following: >> 1) delete all tables >> 2) select 'data administration': get ticket >> File "/usr/local/web2py/gluon/sql.py", line 500, in define_table >> raise e >> ProgrammingError: (1146, "Table 'onestepbeyond.newsitem' doesn't >> exist") >> 3) sql.log contains: >> timestamp: 2008-10-17T17:13:59.772235 >> ALTER TABLE newsitem ADD author_id__tmp INT; >> UPDATE newsitem SET author_id__tmp=author_id; >> ALTER TABLE newsitem DROP COLUMN author_id; >> ALTER TABLE newsitem ADD author_id INT; >> UPDATE newsitem SET author_id=author_id__tmp; >> ALTER TABLE newsitem DROP COLUMN author_id__tmp; >> >> S'not good is it? >> >> On Oct 17, 4:25 pm, yarko <[EMAIL PROTECTED]> wrote: >> > what does your sql.log show? >> > >> > On Oct 17, 10:08 am, billf <[EMAIL PROTECTED]> wrote: >> > >> > > I'm a bit confused re migrate. >> > >> > > I thought that if changes had been made to a table in the model and >> > > migrate=True, whether specific or by default, then web2py would >> > > magically alter the table. And I could have sworn that this is what >> > > had happened when I made some changes in the past(?) >> > >> > > However, having just made a change, I get an ticket because the table >> > > already exists! BTW this is MySQL. >> > >> > > So for web2py to change the table I have to delete it first? Is that >> > > correct? >> > >> > > Bill >> >> >> > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
