Ticket #4146: sample.txt

File sample.txt, 2.2 KB (added by Collin Grady <cgrady@…>, 8 years ago)

copy of text from dpaste, since pastebins are temporary

Line 
1#### cursesite.portals.wow.profiles.models ####
2#### not in INSTALLED_APPS for this site   ####
3
4from cursesite.portals.wow.database.models import ChrClasses, ChrRaces, Item, Spell, FACTIONS, Talent, ItemRandomProperties
5from cursesite.portals.wow.database.models import ITEM_SLOTS, SpellItemEnchantment, Quest, SkillLine, SkillLineCategory, Faction
6
7class Equipment(models.Model):
8  character = models.ForeignKey(Character, db_index=True, raw_id_admin=True)
9  slot = models.IntegerField(choices=ITEM_SLOTS, db_index=True)
10  item = models.ForeignKey(Item, db_index=True, raw_id_admin=True)
11
12#### cursesite.portals.lotro.database.models ####
13#### listed in INSTALLED_APPS on this site   ####
14
15class Item(models.Model):
16  name = models.CharField(maxlength=128)
17  category = models.ForeignKey(ItemType, db_index=True)
18
19#### the DB call and its output              ####
20  equips = Equipment.objects.filter(character=char).select_related(fields=['item']).order_by('slot')
21  equips = equips.extra(
22    tables=['database_itemdisplayinfo'],
23    select={'icon': 'database_itemdisplayinfo.icon'},
24    where=['database_itemdisplayinfo.id = database_item.display']
25    )
26
27['`wow_profiles_equipment`.`id`', '`wow_profiles_equipment`.`character_id`', '`wow_profiles_equipment`.`slot`', '`wow_profiles_equipment`.`item_id`', '`wow_profiles_equipment`.`prop_id`', '`wow_profiles_equipment`.`enchant_id`', '`wow_profiles_equipment`.`socket_1_id`', '`wow_profiles_equipment`.`socket_2_id`', '`wow_profiles_equipment`.`socket_3_id`', '`wow_profiles_equipment`.`socket_4_id`', '`lotro_database_item`.`id`', '`lotro_database_item`.`name`', '`lotro_database_item`.`category_id`', '`lotro_database_item`.`slot_id`', '`lotro_database_item`.`bind_type`', '`lotro_database_item`.`is_indestructable`', '`lotro_database_item`.`is_unique`', '`lotro_database_item`.`req_level`', '`lotro_database_item`.`sturdiness`', '`lotro_database_item`.`worth`', '`lotro_database_item`.`description`', '`lotro_database_item`.`armor`', '`lotro_database_item`.`damage_min`', '`lotro_database_item`.`damage_max`', '`lotro_database_item`.`weapon_speed`', '`lotro_database_item`.`durability`', '`lotro_database_item`.`effects`', '(database_itemdisplayinfo.icon) AS `icon`']
Back to Top