Hi I'm studying examples of using database in pylons. SQLAlchemy is most commonly used here. But I don't understand why most of them use explicit column declaration. I want to use Postgres database which supports ALTER table statement. Following those examples if I need to change column name from character(30) to charcater(50) I will have to do it in my code and then in pgadmin tool. I would prefer to do it in pgadmin only and my model applying those changes automatically.
I'm trying to get Elixir's reflection working: #models/user.py import pyoner.models as model class User(Entity): Entity.table = model.table_user #models/__init__.py from pylons.database import session_context from elixir import metadata from sqlalchemy import Table, BoundMetaData engine = session_context.current.bind_to table_user = Table('user', BoundMetaData(engine), autoload = True) Here I have simple table with id, username, password. It seems that reflection works, but User.select() ends up with: *<class 'sqlalchemy.exceptions.SQLError'>: (ProgrammingError) relation "pyoner_models_user_user" does not exist 'SELECT pyoner_models_user_user.id AS pyoner_models_user_user_id \nFROM pyoner_models_user_user ORDER BY pyoner_models_user_user.id' {}* I use sqlalchemy 0.3.7, elixir 0.3, pylons o.9.6 And maybe one could provide some arguments why I should explicitly declare tables in my models? Some pros and cons list? -- Best regards, Antipin Aleksei --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---