kryptedgaming / django-eveonline-connector Goto Github PK

View Code? Open in Web Editor NEW

1.0 1.0 1.0 1.03 MB

Django extension that adds entity models, SSO views, and celery tasks to interact with the #1 sci-fi sandbox MMO.

Home Page: https://pypi.org/project/django-eveonline-connector/

License: MIT License

Python 79.61% HTML 19.35% Shell 0.08% JavaScript 0.97%

django-eveonline-connector's People

Contributors

Stargazers

Watchers

Forkers

demieno

django-eveonline-connector's Issues

User is able to view characters, corporations, and alliances tracked in the database

User(s) are able to view characters, corporations, and alliances tracked in the database based on a variety of permission matrices.

Add corporation history to EVE characters

Need to generate corporation history and show it in a tab.

User is able to view various data related to a character

Respect header limit on EveClient.call() function

EveClient returning none

Task django_eveonline_connector.tasks.update_character_contracts[1c555451-0ed0-4f4d-adbc-0e55054a5410] raised unexpected: AttributeError("'NoneType' object has no attribute 'op'",)

Traceback (most recent call last):
  File "/usr/local/lib/python3.6/site-packages/celery/app/trace.py", line 385, in trace_task
    R = retval = fun(*args, **kwargs)
  File "/usr/local/lib/python3.6/site-packages/celery/app/trace.py", line 648, in __protected_call__
    return self.run(*args, **kwargs)
  File "/usr/local/lib/python3.6/site-packages/django_eveonline_connector/tasks.py", line 275, in update_character_contracts
    op, *args, delete=False, **kwargs, character_id=character_id, data_model=data_model)
  File "/usr/local/lib/python3.6/site-packages/django_eveonline_connector/tasks.py", line 218, in update_character_eveentitydata
    response = EveClient.call(op, character_id=character.external_id)
  File "/usr/local/lib/python3.6/site-packages/django_eveonline_connector/models.py", line 91, in call
    operation = EveClient.get_esi_app().op[op]
AttributeError: 'NoneType' object has no attribute 'op'

Raise error during startup when static database is not enabled

Character needs signal to update basic information automatically

Task exists for refreshing public data, this should be triggered via a signal on character creation.

Re-design Corporation List View

Similar to #16

New Permissions

View alliance corporations
View all corporations

By default, users should be able to view the corporations that they are in across their characters. If they have director roles in that corporation, they should have full access to that corporation.

ESI Array too long

Array should be less than 1000, not 1782

Traceback (most recent call last):
  File "/usr/local/lib/python3.6/site-packages/django_eveonline_connector/models.py", line 539, in create_from_esi_response
    data, entity_external_id, *args, **kwargs)
  File "/usr/local/lib/python3.6/site-packages/django_eveonline_connector/models.py", line 997, in _create_from_esi_response
    resolved_ids = resolve_ids_with_types(ids_to_resolve)
  File "/usr/local/lib/python3.6/site-packages/django_eveonline_connector/utilities/esi/universe.py", line 27, in resolve_ids_with_types
    request = EveClient.call('post_universe_names', ids=ids)
  File "/usr/local/lib/python3.6/site-packages/django_eveonline_connector/models.py", line 158, in call
    operation(**kwargs), raise_on_error=raise_exception)
  File "/usr/local/lib/python3.6/site-packages/pyswagger/spec/v2_0/objects.py", line 283, in __call__
    _convert_parameter(final(p))
  File "/usr/local/lib/python3.6/site-packages/pyswagger/spec/v2_0/objects.py", line 264, in _convert_parameter
    c = p._prim_(v, self._prim_factory, ctx=dict(read=False))
  File "/usr/local/lib/python3.6/site-packages/pyswagger/spec/v2_0/objects.py", line 184, in _prim_
    return prim_factory.produce(self.schema, v, ctx) if i == 'body' else prim_factory.produce(self, v, ctx)
  File "/usr/local/lib/python3.6/site-packages/pyswagger/primitives/__init__.py", line 196, in produce
    val = _2nd(obj, ret, val, ctx)
  File "/usr/local/lib/python3.6/site-packages/pyswagger/primitives/comm.py", line 40, in _2nd_pass_obj
    return ret.apply_with(obj, val, ctx)
  File "/usr/local/lib/python3.6/site-packages/pyswagger/primitives/_array.py", line 55, in apply_with
    raise ValidationError('Array should be less than {0}, not {1}'.format(obj.maxItems, len(self)))
pyswagger.errs.ValidationError: Array should be less than 1000, not 1782

Additional permissions to viewing EVE Entities

Additional permissions matrix for viewing all EVE entities.

Non-special Users

Can view their character (summary only)
Can view their corporation (summary only)
Can view their alliance (summary only)

KryptedGaming/krypted#290

IndexError on Character API method

HTTP Version Not Supported: /eveonline/api/characters/

Traceback (most recent call last):
  File "/usr/local/lib/python3.6/site-packages/django/core/handlers/exception.py", line 34, in inner
    response = get_response(request)
  File "/usr/local/lib/python3.6/site-packages/django/core/handlers/base.py", line 115, in _get_response
    response = self.process_exception_by_middleware(e, request)
  File "/usr/local/lib/python3.6/site-packages/django/core/handlers/base.py", line 113, in _get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File "/usr/local/lib/python3.6/site-packages/django/contrib/auth/decorators.py", line 21, in _wrapped_view
    return view_func(request, *args, **kwargs)
  File "/usr/local/lib/python3.6/site-packages/django_eveonline_connector/views/api.py", line 63, in get_characters
    return CharacterJson.as_view()(request)
  File "/usr/local/lib/python3.6/site-packages/django/views/generic/base.py", line 71, in view
    return self.dispatch(request, *args, **kwargs)
  File "/usr/local/lib/python3.6/site-packages/django/views/generic/base.py", line 97, in dispatch
    return handler(request, *args, **kwargs)
  File "/usr/local/lib/python3.6/site-packages/django_datatables_view/mixins.py", line 50, in get
    func_val = self.get_context_data(**kwargs)
  File "/usr/local/lib/python3.6/site-packages/django_datatables_view/base_datatable_view.py", line 373, in get_context_data
    return self.handle_exception(e)
  File "/usr/local/lib/python3.6/site-packages/django_datatables_view/base_datatable_view.py", line 310, in handle_exception
    raise e
  File "/usr/local/lib/python3.6/site-packages/django_datatables_view/base_datatable_view.py", line 349, in get_context_data
    qs = self.ordering(qs)
  File "/usr/local/lib/python3.6/site-packages/django_datatables_view/base_datatable_view.py", line 204, in ordering
    sortcol = order_columns[sort_col]
IndexError: list index out of range

Error when updating tokens: TypeError("argument of type 'NoneType' is not iterable",)

Task django_eveonline_connector.tasks.update_tokens[f5e3c93d-172d-453f-8705-86a4d861290c] raised unexpected: TypeError("argument of type 'NoneType' is not iterable",)

Traceback (most recent call last):
  File "/usr/local/lib/python3.6/site-packages/urllib3/connection.py", line 170, in _new_conn
    (self._dns_host, self.port), self.timeout, **extra_kw
  File "/usr/local/lib/python3.6/site-packages/urllib3/util/connection.py", line 96, in create_connection
    raise err
  File "/usr/local/lib/python3.6/site-packages/urllib3/util/connection.py", line 86, in create_connection
    sock.connect(sa)
ConnectionRefusedError: [Errno 111] Connection refused

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/local/lib/python3.6/site-packages/urllib3/connectionpool.py", line 706, in urlopen
    chunked=chunked,
  File "/usr/local/lib/python3.6/site-packages/urllib3/connectionpool.py", line 382, in _make_request
    self._validate_conn(conn)
  File "/usr/local/lib/python3.6/site-packages/urllib3/connectionpool.py", line 1010, in _validate_conn
    conn.connect()
  File "/usr/local/lib/python3.6/site-packages/urllib3/connection.py", line 353, in connect
    conn = self._new_conn()
  File "/usr/local/lib/python3.6/site-packages/urllib3/connection.py", line 182, in _new_conn
    self, "Failed to establish a new connection: %s" % e
urllib3.exceptions.NewConnectionError: : Failed to establish a new connection: [Errno 111] Connection refused

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/local/lib/python3.6/site-packages/requests/adapters.py", line 449, in send
    timeout=timeout
  File "/usr/local/lib/python3.6/site-packages/urllib3/connectionpool.py", line 756, in urlopen
    method, url, error=e, _pool=self, _stacktrace=sys.exc_info()[2]
  File "/usr/local/lib/python3.6/site-packages/urllib3/util/retry.py", line 573, in increment
    raise MaxRetryError(_pool, url, error or ResponseError(cause))
urllib3.exceptions.MaxRetryError: HTTPSConnectionPool(host='login.eveonline.com', port=443): Max retries exceeded with url: /v2/oauth/token (Caused by NewConnectionError(': Failed to establish a new connection: [Errno 111] Connection refused',))

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/opt/krypted/app/packages/django-eveonline-connector/django_eveonline_connector/models.py", line 285, in refresh
    new_token = esi_security.refresh()
  File "/usr/local/lib/python3.6/site-packages/esipy/security.py", line 315, in refresh
    res = self._session.post(**request_data)
  File "/usr/local/lib/python3.6/site-packages/requests/sessions.py", line 590, in post
    return self.request('POST', url, data=data, json=json, **kwargs)
  File "/usr/local/lib/python3.6/site-packages/requests/sessions.py", line 542, in request
    resp = self.send(prep, **send_kwargs)
  File "/usr/local/lib/python3.6/site-packages/requests/sessions.py", line 655, in send
    r = adapter.send(request, **kwargs)
  File "/usr/local/lib/python3.6/site-packages/requests/adapters.py", line 516, in send
    raise ConnectionError(e, request=request)
requests.exceptions.ConnectionError: HTTPSConnectionPool(host='login.eveonline.com', port=443): Max retries exceeded with url: /v2/oauth/token (Caused by NewConnectionError(': Failed to establish a new connection: [Errno 111] Connection refused',))

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/local/lib/python3.6/site-packages/celery/app/trace.py", line 385, in trace_task
    R = retval = fun(*args, **kwargs)
  File "/usr/local/lib/python3.6/site-packages/celery/app/trace.py", line 648, in __protected_call__
    return self.run(*args, **kwargs)
  File "/opt/krypted/app/packages/django-eveonline-connector/django_eveonline_connector/tasks.py", line 54, in update_tokens
    token.refresh()
  File "/opt/krypted/app/packages/django-eveonline-connector/django_eveonline_connector/models.py", line 287, in refresh
    if b"invalid_grant" in e.response:
TypeError: argument of type 'NoneType' is not iterable

Re-design Character List View

Character list page is disgustingly slow, it needs to be paginated with a proper REST API. Also, it needs to be reworked a bit permissions-wise.

New Permissions

Can view same corporation characters
Can view same alliance characters
Can view all characters

By default, users should be able to see all of their characters in the character list. Additional behavior should depend on permissions.

User is able to view a summary of a character

EveData objects should filter from pools of objects with a valid token

After we lose a token for a character, their information can get out of sync (e.g contracts). We should add a Manager object so that we only get valid data objects.

Duplicate contract entry

(1062, "Duplicate entry '167553424' for key 'contract_id'")

Traceback (most recent call last):
  File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
    return self.cursor.execute(sql, params)
  File "/usr/local/lib/python3.6/site-packages/django/db/backends/mysql/base.py", line 71, in execute
    return self.cursor.execute(query, args)
  File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 206, in execute
    res = self._query(query)
  File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 312, in _query
    db.query(q)
  File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 224, in query
    _mysql.connection.query(self, query)
MySQLdb._exceptions.IntegrityError: (1062, "Duplicate entry '167553424' for key 'contract_id'")

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

Traceback (most recent call last):
  File "/usr/local/lib/python3.6/site-packages/django_eveonline_connector/models.py", line 518, in create_from_esi_row
    db_object.save()
  File "/usr/local/lib/python3.6/site-packages/django/db/models/base.py", line 741, in save
    force_update=force_update, update_fields=update_fields)
  File "/usr/local/lib/python3.6/site-packages/django/db/models/base.py", line 779, in save_base
    force_update, using, update_fields,
  File "/usr/local/lib/python3.6/site-packages/django/db/models/base.py", line 870, in _save_table
    result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
  File "/usr/local/lib/python3.6/site-packages/django/db/models/base.py", line 908, in _do_insert
    using=using, raw=raw)
  File "/usr/local/lib/python3.6/site-packages/django/db/models/manager.py", line 82, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
  File "/usr/local/lib/python3.6/site-packages/django/db/models/query.py", line 1186, in _insert
    return query.get_compiler(using=using).execute_sql(return_id)
  File "/usr/local/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 1375, in execute_sql
    cursor.execute(sql, params)
  File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py", line 67, in execute
    return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
  File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py", line 76, in _execute_with_wrappers
    return executor(sql, params, many, context)
  File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
    return self.cursor.execute(sql, params)
  File "/usr/local/lib/python3.6/site-packages/django/db/utils.py", line 89, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
    return self.cursor.execute(sql, params)
  File "/usr/local/lib/python3.6/site-packages/django/db/backends/mysql/base.py", line 71, in execute
    return self.cursor.execute(query, args)
  File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 206, in execute
    res = self._query(query)
  File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 312, in _query
    db.query(q)
  File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 224, in query
    _mysql.connection.query(self, query)
django.db.utils.IntegrityError: (1062, "Duplicate entry '167553424' for key 'contract_id'")

KeyError on pull_corporation_roster

Task django_eveonline_connector.tasks.pull_corporation_roster[71740c22-02c0-4ee7-9428-19fc78bca1f5] raised unexpected: KeyError(0,)

Traceback (most recent call last):
  File "/usr/local/lib/python3.6/site-packages/celery/app/trace.py", line 385, in trace_task
    R = retval = fun(*args, **kwargs)
  File "/usr/local/lib/python3.6/site-packages/celery/app/trace.py", line 648, in __protected_call__
    return self.run(*args, **kwargs)
  File "/usr/local/lib/python3.6/site-packages/django_eveonline_connector/tasks.py", line 384, in pull_corporation_roster
    member.update_character_corporation()
  File "/usr/local/lib/python3.6/site-packages/django_eveonline_connector/models.py", line 365, in update_character_corporation
    corporation_id = response.data[0]['corporation_id']
KeyError: 0

Able to turn on tracking with blank CEO

CEO should be resolved before allowing users to turn on corporation tracking.

Graphical glitch when viewing "Characters" on mobile

Hypernode entries do not show up in journal

Suppress error case where Tranquility fails to connect

Failed (504) ESI call 'get_characters_character_id_roles' with {'character_id': 2117061999}. Response: {'error': 'Timeout contacting tranquility', 'timeout': 10}

Add multi-threaded EveClient.call() for performance boost

Error updating Corporation Roles

Error updating corporation roles for 2115129502. Clearing roles for safety. Error: 'name'

Update EVE Connector to use new package template standards

Character dashboard errors on improper character IDs

HTTP Version Not Supported: /accounts/user/<USER>/

Traceback (most recent call last):
  File "/usr/local/lib/python3.6/site-packages/django/core/handlers/exception.py", line 34, in inner
    response = get_response(request)
  File "/usr/local/lib/python3.6/site-packages/django/core/handlers/base.py", line 115, in _get_response
    response = self.process_exception_by_middleware(e, request)
  File "/usr/local/lib/python3.6/site-packages/django/core/handlers/base.py", line 113, in _get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File "/usr/local/lib/python3.6/site-packages/django/views/generic/base.py", line 71, in view
    return self.dispatch(request, *args, **kwargs)
  File "/usr/local/lib/python3.6/site-packages/django/utils/decorators.py", line 45, in _wrapper
    return bound_method(*args, **kwargs)
  File "/usr/local/lib/python3.6/site-packages/django/contrib/auth/decorators.py", line 21, in _wrapped_view
    return view_func(request, *args, **kwargs)
  File "/usr/local/lib/python3.6/site-packages/django/views/generic/base.py", line 97, in dispatch
    return handler(request, *args, **kwargs)
  File "/opt/krypted/app/accounts/views.py", line 98, in get
    return render(request, context=context, template_name='accounts/profiles/my_profile.html')
  File "/usr/local/lib/python3.6/site-packages/django/shortcuts.py", line 36, in render
    content = loader.render_to_string(template_name, context, request, using=using)
  File "/usr/local/lib/python3.6/site-packages/django/template/loader.py", line 62, in render_to_string
    return template.render(context, request)
  File "/usr/local/lib/python3.6/site-packages/django/template/backends/django.py", line 61, in render
    return self.template.render(context)
  File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 171, in render
    return self._render(context)
  File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 163, in _render
    return self.nodelist.render(context)
  File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 937, in render
    bit = node.render_annotated(context)
  File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 904, in render_annotated
    return self.render(context)
  File "/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py", line 150, in render
    return compiled_parent._render(context)
  File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 163, in _render
    return self.nodelist.render(context)
  File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 937, in render
    bit = node.render_annotated(context)
  File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 904, in render_annotated
    return self.render(context)
  File "/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py", line 62, in render
    result = block.nodelist.render(context)
  File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 937, in render
    bit = node.render_annotated(context)
  File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 904, in render_annotated
    return self.render(context)
  File "/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py", line 188, in render
    return template.render(context)
  File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 173, in render
    return self._render(context)
  File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 163, in _render
    return self.nodelist.render(context)
  File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 937, in render
    bit = node.render_annotated(context)
  File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 904, in render_annotated
    return self.render(context)
  File "/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py", line 309, in render
    return nodelist.render(context)
  File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 937, in render
    bit = node.render_annotated(context)
  File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 904, in render_annotated
    return self.render(context)
  File "/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py", line 188, in render
    return template.render(context)
  File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 173, in render
    return self._render(context)
  File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 163, in _render
    return self.nodelist.render(context)
  File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 937, in render
    bit = node.render_annotated(context)
  File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 904, in render_annotated
    return self.render(context)
  File "/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py", line 209, in render
    nodelist.append(node.render_annotated(context))
  File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 904, in render_annotated
    return self.render(context)
  File "/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py", line 309, in render
    return nodelist.render(context)
  File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 937, in render
    bit = node.render_annotated(context)
  File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 904, in render_annotated
    return self.render(context)
  File "/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py", line 443, in render
    url = reverse(view_name, args=args, kwargs=kwargs, current_app=current_app)
  File "/usr/local/lib/python3.6/site-packages/django/urls/base.py", line 90, in reverse
    return iri_to_uri(resolver._reverse_with_prefix(view, prefix, *args, **kwargs))
  File "/usr/local/lib/python3.6/site-packages/django/urls/resolvers.py", line 673, in _reverse_with_prefix
    raise NoReverseMatch(msg)
django.urls.exceptions.NoReverseMatch: Reverse for 'django-eveonline-connector-view-character' with arguments '('',)' not found. 1 pattern(s) tried: ['eveonline\\/character\\/view\\/(?P[0-9]+)\\/$'

Jitter is not defined

Task django_eveonline_connector.tasks.update_character[24efa58f-38db-4f17-a5ac-538af59f261a] raised unexpected: NameError("name 'jitter' is not defined",)

Traceback (most recent call last):
  File "/usr/local/lib/python3.6/site-packages/celery/app/trace.py", line 385, in trace_task
    R = retval = fun(*args, **kwargs)
  File "/usr/local/lib/python3.6/site-packages/celery/app/trace.py", line 648, in __protected_call__
    return self.run(*args, **kwargs)
  File "/usr/local/lib/python3.6/site-packages/django_eveonline_connector/tasks.py", line 109, in update_character
    countdown=jitter)
NameError: name 'jitter' is not defined

Corporation alliance update should not require CEO token

Task django_eveonline_connector.tasks.update_corporation_alliance[fa90b708-8ba2-437a-bbfc-41637d81408d] raised unexpected: EveMissingScopeException('CEO missing the requested scopes to enable corporation tracking. Please update token for {removed}.',)

Traceback (most recent call last):
  File "/usr/local/lib/python3.6/site-packages/celery/app/trace.py", line 385, in trace_task
    R = retval = fun(*args, **kwargs)
  File "/usr/local/lib/python3.6/site-packages/celery/app/trace.py", line 648, in __protected_call__
    return self.run(*args, **kwargs)
  File "/usr/local/lib/python3.6/site-packages/django_eveonline_connector/tasks.py", line 366, in update_corporation_alliance
    eve_corporation.save()
  File "/usr/local/lib/python3.6/site-packages/django_eveonline_connector/models.py", line 427, in save
    raise EveMissingScopeException(f"CEO missing the requested scopes to enable corporation tracking. Please update token for {self.ceo}.")
django_eveonline_connector.exceptions.EveMissingScopeException: CEO missing the requested scopes to enable corporation tracking. Please update token for {removed}.

Corporation alliances are not updated

Corporation alliances don't seem to be updated ever, crucial to change this for eve groups.

ID resolution chain leads to too many notifications (too much logging)

Message 1

Failed (404) ESI call 'post_universe_names' with {'ids': [0, 1986775940, 2117457287, 2113072263, 603976457, 1342819338, 98552203, 98516874, 2114558736, 2117617943, 434989723, 97234079, 1185432224, 2114345510, 201319079, 1050620328, 98633005, 98472495, 1570566070, 2112658871, 96373697, 91936837, 96833356, 97226073, 2112730977, 2112600049, 2112008181, 98079862, 1552101881]}. Response: {'error': 'Ensure all IDs are valid before resolving.'}

Message 2

Failed to process ESI response for EveContract. Data: {data}

Message 3

django_eveonline_connector.exceptions.EveDataResolutionError: Failed to resolve IDs: [0, 1986775940, 2117457287, 2113072263, 603976457, 1342819338, 98552203, 98516874, 2114558736, 2117617943, 434989723, 97234079, 1185432224, 2114345510, 201319079, 1050620328, 98633005, 98472495, 1570566070, 2112658871, 96373697, 91936837, 96833356, 97226073, 2112730977, 2112600049, 2112008181, 98079862, 1552101881]

Message 4

Failed to batch update  for 2114345510: {'Date': ['Fri, 12 Feb 2021 08:21:46 GMT'], 'Content-Type': ['application/json; charset=UTF-8'], 'Content-Length': ['55'], 'Connection': ['keep-alive'], 'Access-Control-Allow-Credentials': ['true'], 'Access-Control-Allow-Headers': ['Content-Type,Authorization,If-None-Match,X-User-Agent'], 'Access-Control-Allow-Methods': ['GET,HEAD,OPTIONS'], 'Access-Control-Allow-Origin': ['*'], 'Access-Control-Expose-Headers': ['Content-Type,Warning,ETag,X-Pages,X-ESI-Error-Limit-Remain,X-ESI-Error-Limit-Reset'], 'Access-Control-Max-Age': ['600'], 'Allow': ['GET,HEAD,OPTIONS'], 'Strict-Transport-Security': ['max-age=31536000'], 'X-Esi-Error-Limit-Remain': ['99'], 'X-Esi-Error-Limit-Reset': ['14'], 'X-Esi-Request-Id': ['f33805b9-c5c8-4684-b8cb-96e24ecea414']} {'error': 'Timeout contacting tranquility', 'timeout': 10}

EveTransaction failling for long location names

[2020-11-24 04:49:44,563: WARNING/ForkPoolWorker-4] Failed to create EveTransaction from ESI data row:

celery_1  | [2020-11-24 04:49:44,564: ERROR/ForkPoolWorker-4] (1406, "Data too long for column 'location_name' at row 1")
celery_1  | Traceback (most recent call last):
celery_1  |   File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
celery_1  |     return self.cursor.execute(sql, params)
celery_1  |   File "/usr/local/lib/python3.6/site-packages/django/db/backends/mysql/base.py", line 71, in execute
celery_1  |     return self.cursor.execute(query, args)
celery_1  |   File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 206, in execute
celery_1  |     res = self._query(query)
celery_1  |   File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 312, in _query
celery_1  |     db.query(q)
celery_1  |   File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 224, in query
celery_1  |     _mysql.connection.query(self, query)
celery_1  | MySQLdb._exceptions.DataError: (1406, "Data too long for column 'location_name' at row 1")

Update characters triggering for untracked characters

Task django_eveonline_connector.tasks.update_characters[2e218bcc-e0bd-4098-aa76-22f6a5c259ea] raised unexpected: AttributeError("'NoneType' object has no attribute 'track_characters'",)

Traceback (most recent call last):
  File "/usr/local/lib/python3.6/site-packages/celery/app/trace.py", line 385, in trace_task
    R = retval = fun(*args, **kwargs)
  File "/usr/local/lib/python3.6/site-packages/celery/app/trace.py", line 648, in __protected_call__
    return self.run(*args, **kwargs)
  File "/usr/local/lib/python3.6/site-packages/django_eveonline_connector/tasks.py", line 70, in update_characters
    if eve_character.token and eve_character.token.valid and eve_character.corporation.track_characters:
AttributeError: 'NoneType' object has no attribute 'track_characters'

Create update_corporation_members task

We need a task that pulls all of the members of a corporation, and adds them to authentication.

This will allow us to search for members that aren't signed up.

Corporation needs a signal to update basic information automatically

Whenever a corporation is created, it should trigger

Updating the CEO
Updating the Alliance

This should be done by a signal

Primary Character Selection needs UI update

Show ISK on character view

Display total wallet value when viewing a character.

Item name too long

(1406, "Data too long for column 'item_name' at row 1")

Traceback (most recent call last):
  File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
    return self.cursor.execute(sql, params)
  File "/usr/local/lib/python3.6/site-packages/django/db/backends/mysql/base.py", line 71, in execute
    return self.cursor.execute(query, args)
  File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 206, in execute
    res = self._query(query)
  File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 312, in _query
    db.query(q)
  File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 224, in query
    _mysql.connection.query(self, query)
MySQLdb._exceptions.DataError: (1406, "Data too long for column 'item_name' at row 1")

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

Traceback (most recent call last):
  File "/usr/local/lib/python3.6/site-packages/django_eveonline_connector/models.py", line 518, in create_from_esi_row
    db_object.save()
  File "/usr/local/lib/python3.6/site-packages/django/db/models/base.py", line 741, in save
    force_update=force_update, update_fields=update_fields)
  File "/usr/local/lib/python3.6/site-packages/django/db/models/base.py", line 779, in save_base
    force_update, using, update_fields,
  File "/usr/local/lib/python3.6/site-packages/django/db/models/base.py", line 870, in _save_table
    result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
  File "/usr/local/lib/python3.6/site-packages/django/db/models/base.py", line 908, in _do_insert
    using=using, raw=raw)
  File "/usr/local/lib/python3.6/site-packages/django/db/models/manager.py", line 82, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
  File "/usr/local/lib/python3.6/site-packages/django/db/models/query.py", line 1186, in _insert
    return query.get_compiler(using=using).execute_sql(return_id)
  File "/usr/local/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 1375, in execute_sql
    cursor.execute(sql, params)
  File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py", line 67, in execute
    return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
  File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py", line 76, in _execute_with_wrappers
    return executor(sql, params, many, context)
  File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
    return self.cursor.execute(sql, params)
  File "/usr/local/lib/python3.6/site-packages/django/db/utils.py", line 89, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
    return self.cursor.execute(sql, params)
  File "/usr/local/lib/python3.6/site-packages/django/db/backends/mysql/base.py", line 71, in execute
    return self.cursor.execute(query, args)
  File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 206, in execute
    res = self._query(query)
  File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 312, in _query
    db.query(q)
  File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 224, in query
    _mysql.connection.query(self, query)
django.db.utils.DataError: (1406, "Data too long for column 'item_name' at row 1")

Error pulling SP

Task django_eveonline_connector.tasks.update_character_skills[1fec1d46-5b51-49db-acba-b96f3fa268cd] raised unexpected: TypeError("'NoneType' object is not subscriptable",)

Traceback (most recent call last):
  File "/usr/local/lib/python3.6/site-packages/celery/app/trace.py", line 385, in trace_task
    R = retval = fun(*args, **kwargs)
  File "/usr/local/lib/python3.6/site-packages/celery/app/trace.py", line 648, in __protected_call__
    return self.run(*args, **kwargs)
  File "/usr/local/lib/python3.6/site-packages/django_eveonline_connector/tasks.py", line 287, in update_character_skills
    info.skill_points = response['total_sp']
TypeError: 'NoneType' object is not subscriptable

Looks like issue when tranquility is down

Special integration with applications

Users that are assigned to an application should be able to view the characters for that application, regardless of connector permissions.

Require CEO token to enable 'track_characters' and 'track_corporation'

Token should be valid and require the appropriate scopes.

Users can bypass character view by searching

return qs.filter(Q(token__user=self.request.user) | search_filter)

Instead of an &, used an |. Users can "cheat" the character list and display characters they shouldn't be able to see.

Custom user models

Foreign key for user should use the defined setting :- settings.AUTH_USER_MODEL for compatibility with custom users models.

Implement corporation view

Add a corporation view that lists the corporations currently tied to authentication.

Also allow a corporation to be added to the list by name, so that we can add corporations that don't yet exist.

Cache error on 1.2.1

On database caching, keys does not resolve.

Error 500 when viewing structures with a low power structure

    @property
    def fuel_expires_soon(self):
        if (self.fuel_expires - timezone.now()).days < 7:
            return True
        return False

Fuel expires is a null-able field, need to make sure we catch it.

Investigate issue with lingering contracts

Add "autoresolve_token" toggle on EveClient

Sometimes we don't want to autoresolve the token.

Searching for non-existant corporation

Failed (404) ESI call 'get_corporations_corporation_id' with {'corporation_id': None}. Response: {'error': 'Not found'}

Likely tied to
Error updating corporation roles for 2115129502. Clearing roles for safety. Error: 'name'

Implement and EveGroup system, alternative to user states

States are good, but some specific group assignment based on a multitude of EVE Online parameters would be a nice alternative to manage.

KryptedGaming/krypted#292
KryptedGaming/krypted#289

Model EveGroup

Adds users to group by parameters specified in EVE Online
Support for corporation roles, in-game standings, corporation status, etc

Show ISK in asset summary

Improve audit modal when clicking an entity name

Should include affiliation history.