Why did you add that line? If you look at the quickstart, you'll see you should have no reason to do so (unless I am grossly misunderstanding what you did). Specifically, look at project/model/__init__.py
You're supposed to import any other SQLAlchemy objects you make into that file, and then everything will work fine. By making your own metadata, and possibly overriding the other metadata object in __init__.py, you've ensured that your app will likely never work. If any of the above is unable to clear up the issues, please post some example code in your next email, and we will try to show you what changes to make. As for how to use SQLAlchemy with your code, have you worked through the tutorials yet? They cover it pretty well. On Wed, Sep 8, 2010 at 9:19 PM, ernst <[email protected]> wrote: > Hi, > I have made a quickstart project with authentication. > paster setup-app development.ini > creates the tables for model/auth.py > > I add file model/Application.py which contains nothing relating to > sql alchemy (except the imports) > setup-app still works fine. > > Then I add this line: > metadata = MetaData() > and setup-app breaks (see output at end of mail =========) > > A) It did work when I set up tables and mappings for joint table > inheritance (sort of: the tables for > model/Application.py were created correctly but the ones for model/ > auth.py were no longer created ! ). > > B) Then I changed table and mapping definitions to single table > inheritance and I get this error. By eliminating lines from the new > code I could isolate the problem back to that one line: > metadata = MetaData() > > Thank you for advice. Also pointers to documentation about the > SQLAlchemy integration into TurboGears are welcome. > > Regards > Ernst > > ================= > paster setup-app development.ini > /home/ernst/tg21b2/bin/paster:5: UserWarning: Module pkg_resources was > already imported from /home/ernst/tg21b2/lib/python2.5/site-packages/ > setuptools-0.6c8-py2.5.egg/pkg_resources.pyc, but /usr/lib/python2.5/ > site-packages is being added to sys.path > from pkg_resources import load_entry_point > /home/ernst/tg21b2/bin/paster:5: UserWarning: Module site was already > imported from /home/ernst/tg21b2/lib/python2.5/site.pyc, but /usr/lib/ > python2.5/site-packages is being added to sys.path > from pkg_resources import load_entry_point > Running setup_config() from tg21tut.websetup > Creating tables > 10:47:05,272 INFO [sqlalchemy.engine.base.Engine.0x...1f0c] BEGIN > 10:47:05,280 INFO [sqlalchemy.engine.base.Engine.0x...1f0c] select > nextval('"tg_user_user_id_seq"') > 10:47:05,280 INFO [sqlalchemy.engine.base.Engine.0x...1f0c] None > 10:47:05,287 INFO [sqlalchemy.engine.base.Engine.0x...1f0c] ROLLBACK > Traceback (most recent call last): > File "/home/ernst/tg21b2/bin/paster", line 9, in <module> > load_entry_point('PasteScript==1.7.3', 'console_scripts', 'paster') > () > File "/home/ernst/tg21b2/lib/python2.5/site-packages/ > PasteScript-1.7.3-py2.5.egg/paste/script/command.py", line 84, in run > invoke(command, command_name, options, args[1:]) > File "/home/ernst/tg21b2/lib/python2.5/site-packages/ > PasteScript-1.7.3-py2.5.egg/paste/script/command.py", line 123, in > invoke > exit_code = runner.run(args) > File "/home/ernst/tg21b2/lib/python2.5/site-packages/ > PasteScript-1.7.3-py2.5.egg/paste/script/appinstall.py", line 68, in > run > return super(AbstractInstallCommand, self).run(new_args) > File "/home/ernst/tg21b2/lib/python2.5/site-packages/ > PasteScript-1.7.3-py2.5.egg/paste/script/command.py", line 218, in run > result = self.command() > File "/home/ernst/tg21b2/lib/python2.5/site-packages/ > PasteScript-1.7.3-py2.5.egg/paste/script/appinstall.py", line 456, in > command > self, config_file, section, > self.sysconfig_install_vars(installer)) > File "/home/ernst/tg21b2/lib/python2.5/site-packages/ > PasteScript-1.7.3-py2.5.egg/paste/script/appinstall.py", line 598, in > setup_config > mod.setup_app, command, filename, section, vars) > File "/home/ernst/tg21b2/lib/python2.5/site-packages/ > PasteScript-1.7.3-py2.5.egg/paste/script/appinstall.py", line 612, in > _call_setup_app > func(command, conf, vars) > File "/home/ernst/tg21b2/tg21tut/tg21tut/websetup/__init__.py", line > 19, in setup_app > bootstrap.bootstrap(command, conf, vars) > File "/home/ernst/tg21b2/tg21tut/tg21tut/websetup/bootstrap.py", > line 47, in bootstrap > model.DBSession.flush() > File "/home/ernst/tg21b2/lib/python2.5/site-packages/ > SQLAlchemy-0.5.8-py2.5.egg/sqlalchemy/orm/scoping.py", line 127, in do > return getattr(self.registry(), name)(*args, **kwargs) > File "/home/ernst/tg21b2/lib/python2.5/site-packages/ > SQLAlchemy-0.5.8-py2.5.egg/sqlalchemy/orm/session.py", line 1354, in > flush > self._flush(objects) > File "/home/ernst/tg21b2/lib/python2.5/site-packages/ > SQLAlchemy-0.5.8-py2.5.egg/sqlalchemy/orm/session.py", line 1432, in > _flush > flush_context.execute() > File "/home/ernst/tg21b2/lib/python2.5/site-packages/ > SQLAlchemy-0.5.8-py2.5.egg/sqlalchemy/orm/unitofwork.py", line 261, in > execute > UOWExecutor().execute(self, tasks) > File "/home/ernst/tg21b2/lib/python2.5/site-packages/ > SQLAlchemy-0.5.8-py2.5.egg/sqlalchemy/orm/unitofwork.py", line 753, in > execute > self.execute_save_steps(trans, task) > File "/home/ernst/tg21b2/lib/python2.5/site-packages/ > SQLAlchemy-0.5.8-py2.5.egg/sqlalchemy/orm/unitofwork.py", line 768, in > execute_save_steps > self.save_objects(trans, task) > File "/home/ernst/tg21b2/lib/python2.5/site-packages/ > SQLAlchemy-0.5.8-py2.5.egg/sqlalchemy/orm/unitofwork.py", line 759, in > save_objects > task.mapper._save_obj(task.polymorphic_tosave_objects, trans) > File "/home/ernst/tg21b2/lib/python2.5/site-packages/ > SQLAlchemy-0.5.8-py2.5.egg/sqlalchemy/orm/mapper.py", line 1428, in > _save_obj > c = connection.execute(statement.values(value_params), params) > File "/home/ernst/tg21b2/lib/python2.5/site-packages/ > SQLAlchemy-0.5.8-py2.5.egg/sqlalchemy/engine/base.py", line 824, in > execute > return Connection.executors[c](self, object, multiparams, params) > File "/home/ernst/tg21b2/lib/python2.5/site-packages/ > SQLAlchemy-0.5.8-py2.5.egg/sqlalchemy/engine/base.py", line 872, in > _execute_clauseelement > parameters=params > File "/home/ernst/tg21b2/lib/python2.5/site-packages/ > SQLAlchemy-0.5.8-py2.5.egg/sqlalchemy/engine/base.py", line 938, in > __create_execution_context > return dialect.execution_ctx_cls(dialect, connection=self, > **kwargs) > File "/home/ernst/tg21b2/lib/python2.5/site-packages/ > SQLAlchemy-0.5.8-py2.5.egg/sqlalchemy/engine/default.py", line 172, in > __init__ > self.__process_defaults() > File "/home/ernst/tg21b2/lib/python2.5/site-packages/ > SQLAlchemy-0.5.8-py2.5.egg/sqlalchemy/engine/default.py", line 359, in > __process_defaults > val = drunner.get_column_default(c) > File "/home/ernst/tg21b2/lib/python2.5/site-packages/ > SQLAlchemy-0.5.8-py2.5.egg/sqlalchemy/databases/postgres.py", line > 907, in get_column_default > return self.execute_string(exc.encode(self.dialect.encoding)) > File "/home/ernst/tg21b2/lib/python2.5/site-packages/ > SQLAlchemy-0.5.8-py2.5.egg/sqlalchemy/engine/base.py", line 1861, in > execute_string > conn._cursor_execute(self.cursor, stmt, params) > File "/home/ernst/tg21b2/lib/python2.5/site-packages/ > SQLAlchemy-0.5.8-py2.5.egg/sqlalchemy/engine/base.py", line 950, in > _cursor_execute > self._handle_dbapi_exception(e, statement, parameters, cursor, > context) > File "/home/ernst/tg21b2/lib/python2.5/site-packages/ > SQLAlchemy-0.5.8-py2.5.egg/sqlalchemy/engine/base.py", line 931, in > _handle_dbapi_exception > raise exc.DBAPIError.instance(statement, parameters, e, > connection_invalidated=is_disconnect) > sqlalchemy.exc.ProgrammingError: (ProgrammingError) relation > "tg_user_user_id_seq" does not exist > 'select nextval(\'"tg_user_user_id_seq"\')' None > > -- > You received this message because you are subscribed to the Google Groups > "TurboGears" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<turbogears%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/turbogears?hl=en. > > -- Michael J. Pedersen My IM IDs: Jabber/[email protected], ICQ/103345809, AIM/pedermj022171 Yahoo/pedermj2002, MSN/[email protected] -- You received this message because you are subscribed to the Google Groups "TurboGears" 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/turbogears?hl=en.
