Re: SQLAlchemy + URL Dispatch Wiki Tutorial

It's not a bug. If you use sqlite or Postgresql, it's OK. But for others ,you must provide a length to String, Integer, Numeric

Re: SQLAlchemy + URL Dispatch Wiki Tutorial

Thanks Feng, I changed this line in models.py: name = Column(Text, unique=True) to: name = Column(String(255), unique=True) I was just wondering if I was doing something wrong, or if it was a bug. I'll change the model in any case. Thanks for the help, Ian On Tuesday, 8 May 2012 06:05:56 UTC+

Re: SQLAlchemy + URL Dispatch Wiki Tutorial

what ORM do you use? SqlAlchemy? It seems that you should give a length property to the "name" column. 在 2012年5月2日星期三UTC+8下午7时45分58秒，Ian McLoughlin写道： > > Thanks Chris, > > I found that script. > Now I'm getting an error on running it: > > $ initialize_pyramid-skeleton_db development.ini > ... >

Re: SQLAlchemy + URL Dispatch Wiki Tutorial

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 INT

Re: SQLAlchemy + URL Dispatch Wiki Tutorial

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 se