EVE Static Data Export management

Main module

SDE (EVE Static Data Exporty) related module

sni.sde.sde.download_latest_sde(dump_path: str) → str[source]

Downloads and decompresses the latest SDE sqlite dump.

Returns

The MD5 checksum of the dump (before decompression).

sni.sde.sde.get_latest_sde_md5() → str[source]

Returns the latest md5 checksum of the bz2 sqlite dump

sni.sde.sde.import_sde_dump(dump_path: str) → None[source]

Imports the relevant SDE table in to the database

sni.sde.sde.import_sde_dump_inv_categories(client: sqlite3.Connection) → None[source]

Imports the invCategories table

sni.sde.sde.import_sde_dump_inv_constellations(client: sqlite3.Connection) → None[source]

Imports the mapConstellations table

sni.sde.sde.import_sde_dump_inv_groups(client: sqlite3.Connection) → None[source]

Imports the invGroups table

sni.sde.sde.import_sde_dump_inv_solar_systems(client: sqlite3.Connection) → None[source]

Imports the mapSolarSystems table

sni.sde.sde.import_sde_dump_inv_types(client: sqlite3.Connection) → None[source]

Imports the invTypes table

sni.sde.sde.import_sde_dump_map_regions(client: sqlite3.Connection) → None[source]

Imports the mapRegions table

sni.sde.sde.sde_get_name(field_id: int, field_name: Optional[str]) → Optional[str][source]

Fetches a document from the esi_object_name collection. See sni.sde.models.EsiObjectName.

Database models

Teamspeak database models

class sni.sde.models.EsiObjectName(*args, **values)[source]

Bases: mongoengine.document.Document

Represents an ID to object name mapping

SCHEMA_VERSION = 1

Latest schema version for this collection

_version

Schema version of this document

expires_on

When this document expires, if applicable

field_id

ID

field_names

ESI field names this type of field can have, e.g. solar_system_id, character_id

name

Name

Jobs

Recurrent SDE jobs

sni.sde.jobs.update_sde() → None[source]

Checks the hash of the SDE, and if needed, downloads and imports it.

Database signals

Database signals. See Mongoengine signals

Migration

Database migrations

sni.sde.migration.migrate() → None[source]

Runs migration tasks