Thanks Chris, I found that script. Now I'm getting an error on running it:
$ initialize_pyramid-skeleton_db development.ini ... sqlalchemy.exc.OperationalError: (OperationalError) (1170, "BLOB/TEXT column 'name' used in key specification without a key length") '\nCREATE TABLE models (\n\tid INTEGER NOT NULL AUTO_INCREMENT, \n\tname TEXT, \n\tvalue INTEGER, \n\tPRIMARY KEY (id), \n\tUNIQUE (name)\n)\n\n' () Any advice? Thanks again, Ian On Thursday, 19 April 2012 13:59:25 UTC+1, Chris McDonough wrote: > > On 04/19/2012 07:41 AM, Ian McLoughlin wrote: > > I've tried simply to create an alchemy scaffold app, only changing the > > development.ini file to use a MySQL database. > > I've created the database already, but it's empty - no tables. > > > > Running pserve then i get an error because the database hasn't been > setup. > > I looked at the Pyramid tutorial here: > > > http://pyramid.readthedocs.org/en/1.3-branch/tutorials/wiki2/definingmodels.html#reinitializing-the-database > > It says to run this command in the directory containing development.ini > > > > ../bin/initialize_tutorial_db development.ini > > > > > > But I don't have a bin directory in the parent directory (Pyramid had > > nothing to do with the parent directory.) > > I do have a myapp/scripts/initializedb.py file, but running that > > directly cause relative import errors (which I think it should). > > Obviously I'm meant to import that file somehow otherwise. > > > > The github directory for the tutorial > > ( > https://github.com/Pylons/pyramid/tree/1.3-branch/docs/tutorials/wiki2/src > ) > > doesn't have the initializedb executable either. > > > > Am I missing something? > > You need to run "$yourvirtualenv/bin/python setup.py develop" > > There will be an "initialize_db" script thereafter in > "$yourvirtualenv/bin/initialize_db". > > > > > Thanks, > > Ian > > > > -- > > You received this message because you are subscribed to the Google > > Groups "pylons-devel" group. > > To view this discussion on the web visit > > https://groups.google.com/d/msg/pylons-devel/-/FvDMo2wjdKAJ. > > To post to this group, send email to pylons-devel@googlegroups.com. > > To unsubscribe from this group, send email to > > pylons-devel+unsubscr...@googlegroups.com. > > For more options, visit this group at > > http://groups.google.com/group/pylons-devel?hl=en. > > -- You received this message because you are subscribed to the Google Groups "pylons-devel" group. To view this discussion on the web visit https://groups.google.com/d/msg/pylons-devel/-/YrTTvvke9LoJ. To post to this group, send email to pylons-devel@googlegroups.com. To unsubscribe from this group, send email to pylons-devel+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/pylons-devel?hl=en.
