karenc / db-migrator

97%

master: 97%

LAST BUILD ON BRANCH update-psycopg2

branch: update-psycopg2

CHANGE BRANCH

x

Reset

• update-psycopg2
• 0.1.1
• 0.1.2
• 0.1.3
• 0.1.4
• 0.2.0
• 1.0.0
• 1.0.1
• 1.0.2
• 1.1.0
• close-db-connections
• context
• db-config
• deferred-migrations
• devops-features
• fix-list-order
• fix-tests
• fix-version
• list
• list-by-applied
• logger
• mark
• mark-multiple
• master
• migrations-directory-and-context
• move-logger
• no-migrations-directory
• no-schema-no-error
• py3-schema-diff
• repeat-migrations
• super-user
• tests
• travis
• update-readme
• version

Build # 171

Build Type

push

travis-ci

Committed by karenc

Commit Message

Update minimum version of psycopg2 required

For the `super_user` context manager, we are doing something like:

```
db_conn = psycopg2.connect('user=tester dbname=testing', user='postgres')
```

This was not supported by psycopg2 < 2.7:

```
Traceback (most recent call last):
  File \"/var/cnx/venvs/publishing/bin/dbmigrator\", line 11, in <module>
    sys.exit(main())
  File \"/var/cnx/venvs/publishing/local/lib/python2.7/site-packages/dbmigrator/cli.py\", line 104, in main
    return args['cmmd'](**args)
  File \"/var/cnx/venvs/publishing/local/lib/python2.7/site-packages/dbmigrator/utils.py\", line 145, in wrapper
    return func(cursor, *args, **kwargs)
  File \"/var/cnx/venvs/publishing/local/lib/python2.7/site-packages/dbmigrator/commands/migrate.py\", line 32, in cli_command
    run_deferred)
  File \"/var/cnx/venvs/publishing/local/lib/python2.7/site-packages/dbmigrator/utils.py\", line 227, in compare_schema
    callback(*args, **kwargs)
  File \"/var/cnx/venvs/publishing/local/lib/python2.7/site-packages/dbmigrator/utils.py\", line 257, in run_migration
    migration.up(cursor)
  File \"../../var/cnx/venvs/publishing/src/cnx-db/cnxdb/migrations/20170912134157_shred-colxml-uuids.py\", line 19, in up
    with super_user() as super_cursor:
  File \"/usr/lib/python2.7/contextlib.py\", line 17, in __enter__
    return self.gen.next()
  File \"/var/cnx/venvs/publishing/local/lib/python2.7/site-packages/dbmigrator/utils.py\", line 57, in super_user
    user=super_user) as db_conn:
  File \"/var/cnx/venvs/publishing/local/lib/python2.7/site-packages/psycopg2/__init__.py\", line 155, in connect
    % items[0][0])
TypeError: 'user' is an invalid keyword argument when the dsn is specified
```

Run Details

1011 of 1041 relevant lines covered (97.12%)

1.93 hits per line