Django EVE Online SDE

Common errors

• ModuleNotFoundError: No module named 'eveonline_sde'

  cause The `django-eveonline-sde` package is either not installed or not added to your Django project's `INSTALLED_APPS`.
  fix Ensure you have run `pip install django-eveonline-sde` and added `'eveonline_sde'` to your `INSTALLED_APPS` list in `settings.py`.

• django.db.utils.ProgrammingError: relation "eveonline_sde_invtype" does not exist

  cause The database migrations for `eveonline_sde` have not been applied, or the SDE data has not been imported yet.
  fix Run `python manage.py migrate eveonline_sde` to create the database tables. If tables exist but are empty, run `python manage.py download_sde` followed by `python manage.py import_sde` to populate them.

• OperationalError: unable to open database file (when using SQLite)

  cause SQLite has locked the database file, or the Django process does not have write permissions to the database file or its directory, especially during SDE import.
  fix Ensure the user running `python manage.py import_sde` has full read/write permissions to your SQLite database file and its parent directory. If the issue persists, try stopping any other processes that might be accessing the database before running the import.

Warnings

• breaking As a beta package, database schema changes might occur between minor versions. This could require new migrations or even a full SDE re-import.
  Fix: Always review release notes for new versions. Be prepared to run `makemigrations` and `migrate` for `eveonline_sde` and potentially `download_sde` and `import_sde` again after upgrading.
• gotcha The EVE Online SDE is very large. Downloading and importing it into your database can take a significant amount of time and consume substantial disk space (several GB).
  Fix: Ensure you have adequate disk space and allocate sufficient time for the `download_sde` and `import_sde` commands to complete, especially on initial setup or major SDE updates. Consider running these operations in a robust environment (e.g., within a screen or tmux session).
• gotcha SDE data updates are not automatic. You must manually run `download_sde` and `import_sde` management commands to get the latest SDE version.
  Fix: Implement a scheduled task (e.g., using Celery Beat or a cron job) to periodically run `python manage.py download_sde && python manage.py import_sde` to keep your SDE data up-to-date. Note: Running `import_sde` will update existing records and insert new ones; it won't delete old data if SDE structure changes dramatically.

Install

• pip install django-eveonline-sde Install package

Imports

• InvType

  from eveonline_sde.models import InvType

• TypeCategory

  from eveonline_sde.models import TypeCategory

• SolarSystem

  from eveonline_sde.models import SolarSystem

  All SDE models are found within the `eveonline_sde.models` module.

Quickstart

To get started, add `eveonline_sde` to `INSTALLED_APPS`, run database migrations, and then use the provided management commands `download_sde` and `import_sde` to populate your database. Afterwards, you can query the SDE models like any other Django model.

# settings.py
INSTALLED_APPS = [
    # ...
    'eveonline_sde',
    # ...
]

# Run migrations
# python manage.py migrate eveonline_sde

# Download and import SDE data
# python manage.py download_sde
# python manage.py import_sde

# Example usage in a Django shell or view
from eveonline_sde.models import InvType

try:
    tristanium = InvType.objects.get(name='Tristanium')
    print(f"Tristanium Type ID: {tristanium.type_id}")
except InvType.DoesNotExist:
    print("Tristanium not found. Did you import the SDE?")