G Torq
ALTA B2O
270
   |
Posted - 2013.12.10 14:37:00 -
[1] - Quote
Introduction
The following is meant as a primer for the Dust SDE, and how to use it for some basic operations, as being written by myself, and others from the #dust-dev channel.
The SDE is provided as a single file, which is an SQLite3 database, that can either be used directly, or trivially converted for use on another platform.
For browsing it easily, the program SQLiteSpy can be used. These posts will also contain some sample SQL, that should work directly with SQLite3.
Structure of Catma
The provided data represents a set of Dust classes (or types of objects/data) used in the game, with each Object belonging to 1 class (with some exceptions).
The classes included are:
- ActiveSkillGainBooster - Active SP Boosters
- AttributeData - Listing of all Attributes
- AttributeDescriptor - Display Hints for Attributes
- DamageType - Damage Types
- DustHealingActor - Supply depot healing attributes
- DustModule - Every module/equipment/weapon
- DustOMSOrbitalStrike - Orbital Strikes
- DustPawn - Dropsuits
- ExplosionContent - Explosion types
- FactionBoosterAmarr - LP Boosters, Amarr
- FactionBoosterCaldari - LP Boosters, Caldari
- FactionBoosterGallente - LP Boosters, Gallente
- FactionBoosterMinmatar - LP Boosters, Minmatar
- InstallationContent - All installations
- InventoryCategory - Market Grouping
- ModifierDeclaration - Various attribute modifiers
- PassiveSkillGainBooster - Passive SP Boosters
- ProjectileContent - All Projectiles
- Tag - Tags
- TurretWeaponContent - Turret weapons (not turrets)
- VehicleContent - All vehicles
The data is provided in 3 tables, which describes the type and class of the data, and the attributes:
- CatmaAttributes - Attributes
- CatmaClasses - The class of every object
- CatmaTypes - The specific typeName of each object
Every object and class in the system is identified by a "typeID" value, a number that uniquely identifies it.
CatmaClasses
The CatmaClasses table consists of 2 columns:
- typeID - the typeID for an object
- className - the name of the class that object belongs to
To locate e.g. all suits, you can first get a list of all objects (all typeIDs) of the class "DustPawn" from CatmaClasses, and then retrieve any relevant attributes from CatmaAttributes.
CatmaTypes
The CatmaTypes table consists of 2 columns:
- typeID - the typeID of an object
- typeName - the specific typeName of that object
Most, if not all objects and classes in the system have a typeName associated with it, and the typeName is structured such that objects of a given kind have similar typeNames.
CatmaAttributes
The CatmaAttributes table consists of 5 columns:
- typeID - typeID of an object
- catmaAttributeName - name of an attribute
- catmaValueInt - integer (whole number) value
- catmaValueFloat - float (decimal number) value
- catmaValueText - text value
Any catmaAttributeName will only use 1 of the three catmaValue* fields, and it cannot immediately be determined from the data which to use. You will basically need to look at your data and see what field to use for any catmaAttributeName.
(more when written ...)
Team Fairy DUST
|