Hi, Here's a paste of how my app works with Pylons 0.9.7, Elixir 0.6.x, SQLAlchemy 0.5.x.
http://pylonshq.com/pasties/c889fcaf392c198cd3482fae4db4dc90 Hope this helps... --Isaac Csandl On Feb 23, 12:58 pm, Chris Curvey <[email protected]> wrote: > On Feb 23, 1:20 pm, Kumar McMillan <[email protected]> wrote: > > > > > On Mon, Feb 23, 2009 at 10:57 AM, Chris Curvey <[email protected]> wrote: > > > > I'm trying to set up a new project with 0.9.7 and Elixir. I followed > > > the steps athttp://cleverdevil.org/computing/68/(Ireplaced the > > > contents of __init__ with the listed contents), and everything works > > > if I create my tables on my own. > > > > But, how I can I tell Elixir to create the tables for me? If I go > > > into "paster shell" and try to run create_all(), I get: > > > > ProgrammingError: (ProgrammingError) (1146, "Table > > > 'mydatabase.mytablel' doesn't exist") 'DESCRIBE `mytable`' {} > > > > If I try to run "paster setup-app", I get: > > > > sqlalchemy.exceptions.UnboundExecutionError: The MetaData is not bound > > > to an Engine or Connection. Execution can not proceed without a > > > database to execute against. Either execute with an explicit > > > connection or assign the MetaData's .bind to enable implicit > > > execution. > > > It seems like you might be using reflection. (Is that the default for > > Elixir? I forget.) I would suggest not calling elixir.setup_all() at > > the module level contrary to the article above. Maybe the code is > > trying to connect to the db before you get to the create_all() part? > > > I have Elixir working in 0.9.7. Instead of setup_all() in __init__.py > > I have it in load_environment() : > > > def load_environment(global_conf, app_conf): > > # ... > > # CONFIGURATION OPTIONS HERE (note: all config options will override > > # any Pylons config options) > > > from sqlalchemy import create_engine > > bind = create_engine(config['sqlalchemy.default.uri']) > > elixir.metadata.bind = bind # probably a better way to do this > > elixir.setup_all() > > > My websetup.py looks like: > > > def setup_config(command, filename, section, vars): > > """Place any commands to setup <yourapp> here""" > > conf = appconfig('config:' + filename) > > load_environment(conf.global_conf, conf.local_conf) > > I put the setup_all in load_environment (in environment.py), and that > seemed to do no harm. But I can't find a method called setup_config > anywhere. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "pylons-discuss" 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/pylons-discuss?hl=en -~----------~----~----~----~------~----~------~--~---
