# zkill-susser

Simple tool to try find lossmails of ships fitting certain modules<br>
The idea is to find "an algos that died in faction warfare having at least 2 remote reps"

## Data

One half of the data is the eve static dump coming from [fuzzworks](https://www.fuzzwork.co.uk/dump/) specifically the [SQLite dump](https://www.fuzzwork.co.uk/dump/sqlite-latest.sqlite.bz2)<br>
The other half are the dumps from [everef](https://data.everef.net/killmails/)

Killmails are to be put into data in their .tar.bz2 format

## Database Setup

### EVE Static Data (SQLite)

The EVE static data comes as a SQLite database file. Extract the `.sqlite` file from the `.bz2` archive and place it in the project root as `sqlite-latest.sqlite`.

### Killmail Data (ClickHouse)

Killmail data is stored in ClickHouse. The schema and ingestion will be handled separately.

## Generating database types

Via [gorm gentool](https://gorm.io/gen/gen_tool.html)<br>
See mprocs.yaml for example