700285 - fix balrog database to be compatible with MySQL

Status: RESOLVED FIXED

(Release Engineering Graveyard :: Applications: Balrog (backend), defect)

Description

[[e-mail] (:bhearsum)]

Attachment: add lengths to string columns

When it got deployed to the dev environment, we had a Traceback that ended with:
[Fri Nov 04 12:50:32 2011] [error] [client 10.8.33.248]   File "/usr/lib/python2.6/site-packages/sqlalchemy/sql/visitors.py", line 59, in _compiler_dispatch
[Fri Nov 04 12:50:32 2011] [error] [client 10.8.33.248]     return getter(visitor)(self, **kw)
[Fri Nov 04 12:50:32 2011] [error] [client 10.8.33.248]   File "/usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.py", line 1587, in visit_string
[Fri Nov 04 12:50:32 2011] [error] [client 10.8.33.248]     return self.visit_VARCHAR(type_)
[Fri Nov 04 12:50:32 2011] [error] [client 10.8.33.248]   File "/usr/lib/python2.6/site-packages/sqlalchemy/dialects/mysql/base.py", line 1656, in visit_VARCHAR
[Fri Nov 04 12:50:32 2011] [error] [client 10.8.33.248]     self.dialect.name)
[Fri Nov 04 12:50:32 2011] [error] [client 10.8.33.248] InvalidRequestError: VARCHAR requires a length on dialect mysql

Setting a length on all of the String columns fixes this.

I also changed the 'options' field in Permissions to be Text, because it's a JSON blob.

Comment 1

[[e-mail] (:bhearsum)]

mass component change