search

certat / do-portal

This project is in maintenance mode and will only receive bug fixes, but no new features. A new version of this software is being developed.
5 stars 5 forks source link

Make linked data from RIPE available in frontend (user interface) #38

Closed certrik closed 5 years ago

certrik commented 5 years ago

The data gained from https://github.com/certat/do-portal/issues/37 should be available in the user interface. Example: 2018-10-01-do-portal-ripe-vorschlag

davewood commented 5 years ago

please take a look at the current button placement. its quite a hassle to show them inside of the panel because of conditional visibility of the panels. (edit or not edit mode)

i placed the buttons in the panel header and pulled them to the right instead

certrik commented 5 years ago

Okay for me.

ghost commented 5 years ago

I think it is even better this way. I assumed that it would be harder.

MarkHofstetter commented 5 years ago

the backend now provides the possibility to attach/read ripe handles to/from an organization

curl -s 'http://127.0.0.1:8000/cp/1.0/organizations/4'

{ "abbreviation": "eorg-gas", "abuse_emails": [], "asns": [], "display_name": "eorg-gas", "fqdns": [], "full_name": "eorg-gas updated3", "id": 4, "ip_ranges": [], "is_sla": true, "mail_template": "EnglishReport", "mail_times": 3600, "parent_org_abbreviation": "eorg", "parent_org_id": 2, "ripe_organizations": [ { "id": 1, "organization_id": 4, "ripe_org_hdl": "ORG-AAPA1-RIPE" }, { "id": 2, "organization_id": 4, "ripe_org_hdl": "ORG-CA1-RIPE" } ] }

curl 'http://127.0.0.1:8000/cp/1.0/organizations/4' -X PUT {"abbreviation":"eorg-gas","abuse_emails":[],"asns":[],"display_name":"eorg-gas","fqdns":[],"full_name":"eorg-gas updated3","id":4,"ip_ranges":[],"is_sla":true,"mail_template":"EnglishReport","mail_times":3600,"parent_org_abbreviation":"eorg","parent_org_id":2,"ripe_handles":["ORG-AAPA1-RIPE","ORG-CA1-RIPE"]}' --compressed

ripe handles must be checked before via

curl -s 'http://127.0.0.1:8000/cp/1.0/ripe/handle/ORG-CA1-RIPE' { "_cidrs": null, "name": "CSO.net Internet Services GmbH", "organisation_automatic_id": 9, "ripe_org_hdl": "ORG-CA1-RIPE" }

MarkHofstetter commented 5 years ago

curl -s 'http://127.0.0.1:8000/cp/1.0/ripe/handle/ORG-CA1-RIPE'

liefert nun auch die cidrs und asns zurück

{ "asns": [ 5405 ], "cidrs": [ "2a00:d900::/32", "185.93.212.0/23" ], "name": "CSO.net Internet Services GmbH", "organisation_automatic_id": 9, "ripe_org_hdl": "ORG-CA1-RIPE" }

davewood commented 5 years ago

done, please pull from devel branch.

davewood commented 5 years ago

abusecs werden nun auch angezeigt.

ghost commented 5 years ago

Folgender Fehler im log:

Traceback (most recent call last):
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/flask/app.py", line 1994, in __call__
    return self.wsgi_app(environ, start_response)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/flask/app.py", line 1985, in wsgi_app
    response = self.handle_exception(e)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/flask/app.py", line 1540, in handle_exception
    reraise(exc_type, exc_value, tb)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/flask/_compat.py", line 33, in reraise
    raise value
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/flask/app.py", line 1982, in wsgi_app
    response = self.full_dispatch_request()
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/flask/app.py", line 1614, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/flask/app.py", line 1517, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/flask/_compat.py", line 33, in reraise
    raise value
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/flask/app.py", line 1612, in full_dispatch_request
    rv = self.dispatch_request()
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/flask/app.py", line 1598, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "./app/cp/organizations.py", line 94, in get_cp_organizations
    return ApiResponse({'organizations': [o.serialize() for o in orgs]})
  File "./app/cp/organizations.py", line 94, in <listcomp>
    return ApiResponse({'organizations': [o.serialize() for o in orgs]})
  File "./app/utils/mixins.py", line 37, in serialize
    data[e] = self._serialize(getattr(self, e))
  File "./app/models.py", line 903, in ripe_handles
    return [ro.ripe_org_hdl for ro in self.ripe_organizations]
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/orm/attributes.py", line 237, in __get__
    return self.impl.get(instance_state(instance), dict_)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/orm/attributes.py", line 583, in get
    value = self.callable_(state, passive)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/orm/strategies.py", line 544, in _load_for_state
    return self._emit_lazyload(session, state, ident_key, passive)
  File "<string>", line 1, in <lambda>
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/orm/strategies.py", line 614, in _emit_lazyload
    result = q.all()
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/orm/query.py", line 2613, in all
    return list(self)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/orm/query.py", line 2761, in __iter__
    return self._execute_and_instances(context)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/orm/query.py", line 2776, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 914, in execute
    return meth(self, multiparams, params)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
    context)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
    exc_info
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/util/compat.py", line 185, in reraise
    raise value.with_traceback(tb)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
    context)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) relation "fodyorg_x_organization" does not exist
LINE 2: FROM fodyorg_x_organization 
             ^

I guess I am missing some commands for the upgrade but I haven't found documentation on the upgrade (see #14 )

davewood commented 5 years ago

das is noch hier versteckt

https://github.com/certat/do-portal/blob/devel/docs/docker.md#init-database

ghost commented 5 years ago

Wir brauchen docs auch fuers Upgrade, nicht nur die Installation.

MarkHofstetter commented 5 years ago

created INSTALL file with upgrade information, we have to think about a proper changelog/install/upgrade file

Am 07.11.2018 um 14:29 schrieb Wagner:

Wir brauchen docs auch fuers Upgrade, nicht nur die Installation.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/certat/do-portal/issues/38#issuecomment-436622698, or mute the thread https://github.com/notifications/unsubscribe-auth/AAJ-GdJW7JoRhNgWheHUp-aLcFo5DB45ks5usuBWgaJpZM4XtFI5.

--

Mag. Mark Hofstetter 2452 Mannersdorf Zwischen den Weingärten 3 +43 676 7345660

ghost commented 5 years ago

what values does the DO_LOCAL_CONFIG environment variable need?

$ python3 manage.py db upgrade
/usr/bin/gpg --status-fd 2 --no-tty --batch --no-tty --yes --keyserver-options no-honor-keyserver-url,timeout=3 --version
Traceback (most recent call last):
  File "manage.py", line 272, in <module>
    cli()
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/click/core.py", line 722, in __call__
    return self.main(*args, **kwargs)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/flask/cli.py", line 374, in main
    return AppGroup.main(self, *args, **kwargs)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/click/core.py", line 697, in main
    rv = self.invoke(ctx)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/click/core.py", line 1066, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/click/core.py", line 1066, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/click/core.py", line 895, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/click/core.py", line 535, in invoke
    return callback(*args, **kwargs)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/click/decorators.py", line 17, in new_func
    return f(get_current_context(), *args, **kwargs)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/flask/cli.py", line 250, in decorator
    with __ctx.ensure_object(ScriptInfo).load_app().app_context():
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/flask/cli.py", line 223, in load_app
    rv = self.create_app(self)
  File "manage.py", line 22, in create_cli_app
    return create_app(os.getenv('DO_CONFIG') or 'default')
  File "/home/cp-server/do-portal/app/__init__.py", line 100, in create_app
    init_routes(app)
  File "/home/cp-server/do-portal/app/__init__.py", line 133, in init_routes
    from .auth import auth as auth_blueprint
  File "/home/cp-server/do-portal/app/auth/__init__.py", line 30, in <module>
    app.config.from_envvar('DO_LOCAL_CONFIG')
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/flask/config.py", line 108, in from_envvar
    variable_name)
RuntimeError: The environment variable 'DO_LOCAL_CONFIG' is not set and as such configuration could not be loaded.  Set this variable and make it point to a configuration file

A changelog does exist in docs/changelog.rst

ghost commented 5 years ago 
$ DO_LOCAL_CONFIG=/home/cp-server/do-portal/config.cfg python3 manage.py db upgrade
/usr/bin/gpg --status-fd 2 --no-tty --homedir /home/cp-server/do-portal/.gnupg --batch --no-tty --yes --keyserver-options no-honor-keyserver-url,timeout=3 --version
/home/cp-server/do-portal/lib/python3.4/site-packages/psycopg2/__init__.py:144: UserWarning: The psycopg2 wheel package will be renamed from release 2.8; in order to keep installing from binary please use "pip install psycopg2-binary" instead. For details see: <http://initd.org/psycopg/docs/install.html#binary-install-from-pypi>.
  """)
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade 12ffc87fb64d -> 563df0efdc9f, empty message
Traceback (most recent call last):
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
    context)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
    cursor.execute(statement, parameters)
psycopg2.ProgrammingError: relation "fodyorg_x_organization" already exists

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "manage.py", line 272, in <module>
    cli()
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/click/core.py", line 722, in __call__
    return self.main(*args, **kwargs)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/flask/cli.py", line 374, in main
    return AppGroup.main(self, *args, **kwargs)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/click/core.py", line 697, in main
    rv = self.invoke(ctx)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/click/core.py", line 1066, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/click/core.py", line 1066, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/click/core.py", line 895, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/click/core.py", line 535, in invoke
    return callback(*args, **kwargs)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/click/decorators.py", line 17, in new_func
    return f(get_current_context(), *args, **kwargs)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/flask/cli.py", line 251, in decorator
    return __ctx.invoke(f, *args, **kwargs)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/click/core.py", line 535, in invoke
    return callback(*args, **kwargs)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/flask_migrate/cli.py", line 132, in upgrade
    _upgrade(directory, revision, sql, tag, x_arg)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/flask_migrate/__init__.py", line 239, in upgrade
    command.upgrade(config, revision, sql=sql, tag=tag)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/alembic/command.py", line 174, in upgrade
    script.run_env()
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/alembic/script/base.py", line 407, in run_env
    util.load_python_file(self.dir, 'env.py')
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/alembic/util/pyfiles.py", line 93, in load_python_file
    module = load_module_py(module_id, path)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/alembic/util/compat.py", line 68, in load_module_py
    module_id, path).load_module(module_id)
  File "<frozen importlib._bootstrap>", line 539, in _check_name_wrapper
  File "<frozen importlib._bootstrap>", line 1614, in load_module
  File "<frozen importlib._bootstrap>", line 596, in _load_module_shim
  File "<frozen importlib._bootstrap>", line 1220, in load
  File "<frozen importlib._bootstrap>", line 1200, in _load_unlocked
  File "<frozen importlib._bootstrap>", line 1129, in _exec
  File "<frozen importlib._bootstrap>", line 1471, in exec_module
  File "<frozen importlib._bootstrap>", line 321, in _call_with_frames_removed
  File "/home/cp-server/do-portal/misc/migrations/env.py", line 87, in <module>
    run_migrations_online()
  File "/home/cp-server/do-portal/misc/migrations/env.py", line 80, in run_migrations_online
    context.run_migrations()
  File "<string>", line 8, in run_migrations
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/alembic/runtime/environment.py", line 797, in run_migrations
    self.get_context().run_migrations(**kw)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/alembic/runtime/migration.py", line 312, in run_migrations
    step.migration_fn(**kw)
  File "/home/cp-server/do-portal/misc/migrations/versions/563df0efdc9f_.py", line 28, in upgrade
    sa.UniqueConstraint('ripe_org_hdl')
  File "<string>", line 8, in create_table
  File "<string>", line 3, in create_table
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/alembic/operations/ops.py", line 1098, in create_table
    return operations.invoke(op)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/alembic/operations/base.py", line 318, in invoke
    return fn(self, operation)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/alembic/operations/toimpl.py", line 101, in create_table
    operations.impl.create_table(table)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/alembic/ddl/impl.py", line 194, in create_table
    self._exec(schema.CreateTable(table))
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/alembic/ddl/impl.py", line 118, in _exec
    return conn.execute(construct, *multiparams, **params)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 914, in execute
    return meth(self, multiparams, params)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
    return connection._execute_ddl(self, multiparams, params)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 968, in _execute_ddl
    compiled
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
    context)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
    exc_info
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/util/compat.py", line 185, in reraise
    raise value.with_traceback(tb)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
    context)
  File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) relation "fodyorg_x_organization" already exists
 [SQL: '\nCREATE TABLE fodyorg_x_organization (\n\tcreated TIMESTAMP WITHOUT TIME ZONE, \n\tupdated TIMESTAMP WITHOUT TIME ZONE, \n\tid SERIAL NOT NULL, \n\torganization_id INTEGER, \n\tripe_org_hdl VARCHAR(255), \n\tdeleted INTEGER, \n\tPRIMARY KEY (id), \n\tFOREIGN KEY(organization_id) REFERENCES organizations (id), \n\tUNIQUE (ripe_org_hdl)\n)\n\n']

I got this error but it maybe worked anyway?

davewood commented 5 years ago

there is an issue if the add_handle or delete_handle request to the backend fails

MarkHofstetter commented 5 years ago

because I already did ist ;-)

Am 07.11.2018 um 15:02 schrieb Wagner:

|$ DO_LOCAL_CONFIG=/home/cp-server/do-portal/config.cfg python3 manage.py db upgrade /usr/bin/gpg --status-fd 2 --no-tty --homedir /home/cp-server/do-portal/.gnupg --batch --no-tty --yes --keyserver-options no-honor-keyserver-url,timeout=3 --version /home/cp-server/do-portal/lib/python3.4/site-packages/psycopg2/init.py:144: UserWarning: The psycopg2 wheel package will be renamed from release 2.8; in order to keep installing from binary please use "pip install psycopg2-binary" instead. For details see: http://initd.org/psycopg/docs/install.html#binary-install-from-pypi. """) INFO [alembic.runtime.migration] Context impl PostgresqlImpl. INFO [alembic.runtime.migration] Will assume transactional DDL. INFO [alembic.runtime.migration] Running upgrade 12ffc87fb64d -> 563df0efdc9f, empty message Traceback (most recent call last): File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context context) File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute cursor.execute(statement, parameters) psycopg2.ProgrammingError: relation "fodyorg_x_organization" already exists The above exception was the direct cause of the following exception: Traceback (most recent call last): File "manage.py", line 272, in cli() File "/home/cp-server/do-portal/lib/python3.4/site-packages/click/core.py", line 722, in call return self.main(*args, kwargs) File "/home/cp-server/do-portal/lib/python3.4/site-packages/flask/cli.py", line 374, in main return AppGroup.main(self, args, kwargs) File "/home/cp-server/do-portal/lib/python3.4/site-packages/click/core.py", line 697, in main rv = self.invoke(ctx) File "/home/cp-server/do-portal/lib/python3.4/site-packages/click/core.py", line 1066, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/cp-server/do-portal/lib/python3.4/site-packages/click/core.py", line 1066, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/cp-server/do-portal/lib/python3.4/site-packages/click/core.py", line 895, in invoke return ctx.invoke(self.callback, ctx.params) File "/home/cp-server/do-portal/lib/python3.4/site-packages/click/core.py", line 535, in invoke return callback(args, kwargs) File "/home/cp-server/do-portal/lib/python3.4/site-packages/click/decorators.py", line 17, in new_func return f(get_current_context(), *args, kwargs) File "/home/cp-server/do-portal/lib/python3.4/site-packages/flask/cli.py", line 251, in decorator return __ctx.invoke(f, *args, *kwargs) File "/home/cp-server/do-portal/lib/python3.4/site-packages/click/core.py", line 535, in invoke return callback(args, kwargs) File "/home/cp-server/do-portal/lib/python3.4/site-packages/flask_migrate/cli.py", line 132, in upgrade _upgrade(directory, revision, sql, tag, x_arg) File "/home/cp-server/do-portal/lib/python3.4/site-packages/flask_migrate/init.py", line 239, in upgrade command.upgrade(config, revision, sql=sql, tag=tag) File "/home/cp-server/do-portal/lib/python3.4/site-packages/alembic/command.py", line 174, in upgrade script.run_env() File "/home/cp-server/do-portal/lib/python3.4/site-packages/alembic/script/base.py", line 407, in run_env util.load_python_file(self.dir, 'env.py') File "/home/cp-server/do-portal/lib/python3.4/site-packages/alembic/util/pyfiles.py", line 93, in load_python_file module = load_module_py(module_id, path) File "/home/cp-server/do-portal/lib/python3.4/site-packages/alembic/util/compat.py", line 68, in load_module_py module_id, path).load_module(module_id) File "", line 539, in _check_name_wrapper File "", line 1614, in load_module File "", line 596, in _load_module_shim File "", line 1220, in load File "<frozen importlib._bootstrap>", line 1200, in _load_unlocked File "<frozen importlib._bootstrap>", line 1129, in _exec File "<frozen importlib._bootstrap>", line 1471, in exec_module File "<frozen importlib._bootstrap>", line 321, in _call_with_frames_removed File "/home/cp-server/do-portal/misc/migrations/env.py", line 87, in

run_migrations_online() File "/home/cp-server/do-portal/misc/migrations/env.py", line 80, in run_migrations_online context.run_migrations() File "", line 8, in run_migrations File "/home/cp-server/do-portal/lib/python3.4/site-packages/alembic/runtime/environment.py", line 797, in run_migrations self.get_context().run_migrations(**kw) File "/home/cp-server/do-portal/lib/python3.4/site-packages/alembic/runtime/migration.py", line 312, in run_migrations step.migration_fn(**kw) File "/home/cp-server/do-portal/misc/migrations/versions/563df0efdc9f_.py", line 28, in upgrade sa.UniqueConstraint('ripe_org_hdl') File "", line 8, in create_table File "", line 3, in create_table File "/home/cp-server/do-portal/lib/python3.4/site-packages/alembic/operations/ops.py", line 1098, in create_table return operations.invoke(op) File "/home/cp-server/do-portal/lib/python3.4/site-packages/alembic/operations/base.py", line 318, in invoke return fn(self, operation) File "/home/cp-server/do-portal/lib/python3.4/site-packages/alembic/operations/toimpl.py", line 101, in create_table operations.impl.create_table(table) File "/home/cp-server/do-portal/lib/python3.4/site-packages/alembic/ddl/impl.py", line 194, in create_table self._exec(schema.CreateTable(table)) File "/home/cp-server/do-portal/lib/python3.4/site-packages/alembic/ddl/impl.py", line 118, in _exec return conn.execute(construct, *multiparams, **params) File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 914, in execute return meth(self, multiparams, params) File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection return connection._execute_ddl(self, multiparams, params) File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 968, in _execute_ddl compiled File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context context) File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception exc_info File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause reraise(type(exception), exception, tb=exc_tb, cause=cause) File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/util/compat.py", line 185, in reraise raise value.with_traceback(tb) File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context context) File "/home/cp-server/do-portal/lib/python3.4/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) relation "fodyorg_x_organization" already exists [SQL: '\nCREATE TABLE fodyorg_x_organization (\n\tcreated TIMESTAMP WITHOUT TIME ZONE, \n\tupdated TIMESTAMP WITHOUT TIME ZONE, \n\tid SERIAL NOT NULL, \n\torganization_id INTEGER, \n\tripe_org_hdl VARCHAR(255), \n\tdeleted INTEGER, \n\tPRIMARY KEY (id), \n\tFOREIGN KEY(organization_id) REFERENCES organizations (id), \n\tUNIQUE (ripe_org_hdl)\n)\n\n'] | I got this error but it maybe worked anyway? — You are receiving this because you commented. Reply to this email directly, view it on GitHub , or mute the thread .

--

Mag. Mark Hofstetter 2452 Mannersdorf Zwischen den Weingärten 3 +43 676 7345660

davewood commented 5 years ago

no, that has nothing to do with what I wrote.