INFO [alembic.migration] Context impl SQLiteImpl.
INFO [alembic.migration] Will assume non-transactional DDL.
INFO [alembic.migration] Running upgrade None -> 4f21a77e91be, init
Traceback (most recent call last):
File "/Users/manuel/Work/pyenvs/grano/bin/alembic", line 11, in <module>
sys.exit(main())
File "/Users/manuel/Work/pyenvs/grano/lib/python2.7/site-packages/alembic/config.py", line 298, in main
CommandLine(prog=prog).main(argv=argv)
File "/Users/manuel/Work/pyenvs/grano/lib/python2.7/site-packages/alembic/config.py", line 293, in main
self.run_cmd(cfg, options)
File "/Users/manuel/Work/pyenvs/grano/lib/python2.7/site-packages/alembic/config.py", line 279, in run_cmd
**dict((k, getattr(options, k)) for k in kwarg)
File "/Users/manuel/Work/pyenvs/grano/lib/python2.7/site-packages/alembic/command.py", line 124, in upgrade
script.run_env()
File "/Users/manuel/Work/pyenvs/grano/lib/python2.7/site-packages/alembic/script.py", line 199, in run_env
util.load_python_file(self.dir, 'env.py')
File "/Users/manuel/Work/pyenvs/grano/lib/python2.7/site-packages/alembic/util.py", line 205, in load_python_file
module = load_module_py(module_id, path)
File "/Users/manuel/Work/pyenvs/grano/lib/python2.7/site-packages/alembic/compat.py", line 58, in load_module_py
mod = imp.load_source(module_id, path, fp)
File "alembic/env.py", line 75, in <module>
run_migrations_online()
File "alembic/env.py", line 68, in run_migrations_online
context.run_migrations()
File "<string>", line 7, in run_migrations
File "/Users/manuel/Work/pyenvs/grano/lib/python2.7/site-packages/alembic/environment.py", line 681, in run_migrations
self.get_context().run_migrations(**kw)
File "/Users/manuel/Work/pyenvs/grano/lib/python2.7/site-packages/alembic/migration.py", line 225, in run_migrations
change(**kw)
File "alembic/versions/4f21a77e91be_init.py", line 38, in upgrade
sa.PrimaryKeyConstraint('id', name=u'account_pkey')
File "<string>", line 7, in create_table
File "/Users/manuel/Work/pyenvs/grano/lib/python2.7/site-packages/alembic/operations.py", line 647, in create_table
self._table(name, *columns, **kw)
File "/Users/manuel/Work/pyenvs/grano/lib/python2.7/site-packages/alembic/ddl/impl.py", line 149, in create_table
self._exec(schema.CreateTable(table))
File "/Users/manuel/Work/pyenvs/grano/lib/python2.7/site-packages/alembic/ddl/impl.py", line 76, in _exec
conn.execute(construct, *multiparams, **params)
File "/Users/manuel/Work/pyenvs/grano/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 664, in execute
return meth(self, multiparams, params)
File "/Users/manuel/Work/pyenvs/grano/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 67, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/Users/manuel/Work/pyenvs/grano/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 718, in _execute_ddl
compiled
File "/Users/manuel/Work/pyenvs/grano/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 874, in _execute_context
context)
File "/Users/manuel/Work/pyenvs/grano/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1023, in _handle_dbapi_exception
exc_info
File "/Users/manuel/Work/pyenvs/grano/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 185, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/Users/manuel/Work/pyenvs/grano/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 867, in _execute_context
context)
File "/Users/manuel/Work/pyenvs/grano/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 388, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (OperationalError) near "account_id_seq": syntax error u"\nCREATE TABLE account (\n\tcreated_at TIMESTAMP, \n\tupdated_at TIMESTAMP, \n\tid INTEGER DEFAULT 'nextval('account_id_seq'::regclass)' NOT NULL, \n\tgithub_id INTEGER, \n\tlogin VARCHAR, \n\temail VARCHAR, \n\tapi_key VARCHAR, \n\tCONSTRAINT account_pkey PRIMARY KEY (id)\n)\n\n" ()
import os
DEBUG = True
ASSETS_DEBUG = False
SECRET_KEY = 'test'
SQLALCHEMY_DATABASE_URI = 'sqlite:////tmp/grano.db'
APP_NAME = CELERY_APP_NAME = ES_INDEX = 'grano'
CELERY_BROKER_URL = 'amqp://guest:guest@localhost:5672//'
GITHUB_CLIENT_ID = 'da79a6b5868e690ab984'
GITHUB_CLIENT_SECRET = '1701d3bd20bbb29012592fd3a9c64b827e0682d6'
# Generate a public URI for an entity, based on its ID.
ENTITY_VIEW_PATTERN = 'http://grano.io/e/%s'