Skip to content

Instantly share code, notes, and snippets.

@wroscoe
Created July 21, 2014 22:57
Show Gist options
  • Save wroscoe/b3896ce1cf5def87c516 to your computer and use it in GitHub Desktop.
Save wroscoe/b3896ce1cf5def87c516 to your computer and use it in GitHub Desktop.
```
wroscoe@wroscoe-Dell-System-XPS-L322X:~/code/lever/lever$ ../ve/bin/alembic -c alembic_local.ini upgrade head
INFO [alembic.migration] Context impl PostgresqlImpl.
INFO [alembic.migration] Will assume transactional DDL.
INFO [alembic.migration] Running upgrade 214199e187a -> 2a16dd91d8a, google_id
INFO [alembic.migration] Running upgrade 2a16dd91d8a -> e172a02f06, Normalize email addreses.
INFO [alembic.migration] Running upgrade e172a02f06 -> 3b9047833e2, Prop search api.
INFO [alembic.migration] Running upgrade 3b9047833e2 -> 1641e6ea352, Denormalize note text for search.
INFO [alembic.migration] Running upgrade 1641e6ea352 -> c20337db8c, add tag source
INFO [alembic.migration] Running upgrade c20337db8c -> 2ab3f9b513, Add contact import date.
INFO [alembic.migration] Running upgrade 2ab3f9b513 -> 592ae9316a6, invite constraint
INFO [alembic.migration] Running upgrade 592ae9316a6 -> 41710996966, lower case property names
INFO [alembic.migration] Running upgrade 41710996966 -> a995bef5cc, tag description
INFO [alembic.migration] Running upgrade a995bef5cc -> a4aa50c551, Add template id.
INFO [alembic.migration] Running upgrade a4aa50c551 -> 24ecb4d7610, Remove implicit tags.
INFO [alembic.migration] Running upgrade 24ecb4d7610 -> 3ea66415ce4, Sharing update.
Traceback (most recent call last):
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/sqlalchemy/engine/base.py", line 920, in _execute_context
context)
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/sqlalchemy/engine/default.py", line 425, in do_execute
cursor.execute(statement, parameters)
psycopg2.ProgrammingError: can't adapt type 'BindParameter'
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "../ve/bin/alembic", line 11, in <module>
sys.exit(main())
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/alembic/config.py", line 298, in main
CommandLine(prog=prog).main(argv=argv)
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/alembic/config.py", line 293, in main
self.run_cmd(cfg, options)
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/alembic/config.py", line 279, in run_cmd
**dict((k, getattr(options, k)) for k in kwarg)
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/alembic/command.py", line 124, in upgrade
script.run_env()
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/alembic/script.py", line 199, in run_env
util.load_python_file(self.dir, 'env.py')
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/alembic/util.py", line 205, in load_python_file
module = load_module_py(module_id, path)
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/alembic/compat.py", line 49, in load_module_py
return machinery.SourceFileLoader(module_id, path).load_module(module_id)
File "<frozen importlib._bootstrap>", line 584, in _check_name_wrapper
File "<frozen importlib._bootstrap>", line 1022, in load_module
File "<frozen importlib._bootstrap>", line 1003, in load_module
File "<frozen importlib._bootstrap>", line 560, in module_for_loader_wrapper
File "<frozen importlib._bootstrap>", line 868, in _load_module
File "<frozen importlib._bootstrap>", line 313, in _call_with_frames_removed
File "./alembic/env.py", line 72, in <module>
run_migrations_online()
File "./alembic/env.py", line 65, in run_migrations_online
context.run_migrations()
File "<string>", line 7, in run_migrations
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/alembic/environment.py", line 681, in run_migrations
self.get_context().run_migrations(**kw)
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/alembic/migration.py", line 225, in run_migrations
change(**kw)
File "./alembic/versions/3ea66415ce4_sharing_update.py", line 84, in upgrade
tag_user_rows)
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/sqlalchemy/engine/base.py", line 717, in execute
return meth(self, multiparams, params)
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/sqlalchemy/sql/elements.py", line 317, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/sqlalchemy/engine/base.py", line 814, in _execute_clauseelement
compiled_sql, distilled_params
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/sqlalchemy/engine/base.py", line 927, in _execute_context
context)
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/sqlalchemy/engine/base.py", line 1076, in _handle_dbapi_exception
exc_info
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/sqlalchemy/util/compat.py", line 174, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/sqlalchemy/util/compat.py", line 167, in reraise
raise value.with_traceback(tb)
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/sqlalchemy/engine/base.py", line 920, in _execute_context
context)
File "/home/wroscoe/code/lever/ve/lib/python3.3/site-packages/sqlalchemy/engine/default.py", line 425, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (ProgrammingError) can't adapt type 'BindParameter' 'INSERT INTO tags_users (created_on, modified_on, tag_id, user_id, collab_user_id) VALUES (NOW(), NOW(), %(tag_id)s, %(user_id)s, %(collab_user_id)s)' {'user_id': BindParameter('user_id', None, type_=NullType()), 'collab_user_id': BindParameter('collab_user_id', None, type_=NullType()), 'tag_id': BindParameter('tag_id', None, type_=NullType())}
wroscoe@wroscoe-Dell-System-XPS-L322X:~/code/lever/lever$
```
@ianjosephwilson
Copy link

psql -Ulever lever_local

@ianjosephwilson
Copy link

pg_dump -Ulever lever_local > lever_local.sql

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment