def setup_app(command, conf, vars): """Place any commands to setup raidgear here""" # Don't reload the app if it was loaded under the testing environment if not pylons.test.pylonsapp: load_environment(conf.global_conf, conf.local_conf) # Create the tables if they don't already exist Base.metadata.drop_all(bind=Session.bind) Base.metadata.create_all(bind=Session.bind) republic = Faction('Republic') Session.add(republic) empire = Faction('Empire') Session.add(empire) Session.add(AdvClass(republic, 'Guardian')) Session.add(AdvClass(republic, 'Sentinel')) Session.add(AdvClass(republic, 'Sage')) Session.add(AdvClass(republic, 'Shadow')) Session.add(AdvClass(republic, 'Commando')) Session.add(AdvClass(republic, 'Vanguard')) Session.add(AdvClass(republic, 'Scoundrel')) Session.add(AdvClass(republic, 'Gunslinger')) Session.add(AdvClass(empire, 'Marauder')) Session.add(AdvClass(empire, 'Juggernaut')) Session.add(AdvClass(empire, 'Sorcerer')) Session.add(AdvClass(empire, 'Assassin')) Session.add(AdvClass(empire, 'Mercenary')) Session.add(AdvClass(empire, 'Powertech')) Session.add(AdvClass(empire, 'Sniper')) Session.add(AdvClass(empire, 'Operative')) # Add the basic fields head = Slot('Head', 9, 0.0897) chest = Slot('Chest', 10, 0.0818) gloves = Slot('Gloves', 11, 0.0897) belt = Slot('Belt', 12, 0.0628) legs = Slot('Legs', 13, 0.0897) boots = Slot('Boots', 14, 0.0818) ear = Slot('Ear', 1, 0.0743) implant = Slot('Implant', 2, 0.07232, 2) bracers = Slot('Bracers', 4, 0.0687) relic = Slot('Relic', 5, 0.0304, 2) mainhand = Slot('Mainhand', 7, 0.0838) offhand = Slot('Offhand', 8, 0.0723) Session.add_all([head, chest, belt, legs, boots, ear, implant, relic, mainhand, offhand]) # Not actually in game #Session.add(Gear('Unavailable', rank=-1)) weak = Gear('Blues or worse', rank=0) Session.add(weak) purple = Gear('Generic purple at 49+', rank=1) Session.add(purple) Session.add(Gear('Centurion', rank=2, pvp=True)) xenotech = Gear('Xenotech', rank=2) Session.add(xenotech) energized = Gear('Energized', rank=2) Session.add(energized) tionese = Gear('Tionese', rank=2) Session.add(tionese) Session.add(Gear('Champion', rank=3, pvp=True)) columi = Gear('Columi', rank=3) Session.add(columi) exotech = Gear('Exotech', rank=3) Session.add(exotech) rakata = Gear('Rakata', rank=4) Session.add(rakata) Session.add(Gear('Battlemaster', rank=4, pvp=True)) Session.add(Gear('Matrix cube at 50', rank=4)) esseles_instance = Instance('Esseles', 'Black Talon') esseles = [ Boss(1, esseles_instance, 'Lieutenant Isric', 'GXR-5 Sabotage Droid'), Boss(2, esseles_instance, 'Ironfist', 'Commander Ghulil'), Boss(3, esseles_instance, 'ISS-994 Power Droid', 'GXR-7 Command Droid'), Boss(4, esseles_instance, 'Vokk', 'Yadira Ban'), ] Session.add_all(esseles) Session.add(Drop(esseles[0], tionese, belt)) Session.add(Drop(esseles[1], energized, legs)) Session.add(Drop(esseles[2], tionese, ear)) Session.add(Drop(esseles[3], columi, bracers)) emperor_instance = Instance('False Emperor') emperor = [ Boss(1, emperor_instance, 'Jindo Krey'), Boss(2, emperor_instance, 'HK-47'), Boss(3, emperor_instance, 'Sith Entity'), Boss(4, emperor_instance, 'Darth Malgus'), ] Session.add_all(emperor) Session.add(Drop(emperor[0], tionese, gloves)) Session.add(Drop(emperor[1], tionese, mainhand)) Session.add(Drop(emperor[2], tionese, implant)) Session.add(Drop(emperor[3], columi, chest)) directive7_instance = Instance('Directive 7') directive7 = [ Boss(1, directive7_instance, 'Interrogator'), Boss(2, directive7_instance, 'Bulwark'), Boss(3, directive7_instance, 'Replicator'), Boss(4, directive7_instance, 'Mentor'), ] Session.add_all(directive7) Session.add(Drop(directive7[0], tionese, bracers)) Session.add(Drop(directive7[1], energized, chest)) Session.add(Drop(directive7[2], purple, relic)) Session.add(Drop(directive7[3], columi, legs)) ilum_instance = Instance('Battle of Ilum') ilum = [ Boss(1, ilum_instance, 'Velasu & Drinda'), Boss(2, ilum_instance, 'Krel Thak'), Boss(3, ilum_instance, 'Guid Patriach'), Boss(4, ilum_instance, 'Darth Serevin'), ] Session.add_all(ilum) Session.add(Drop(ilum[0], tionese, bracers)) Session.add(Drop(ilum[1], energized, head)) Session.add(Drop(ilum[2], tionese, ear)) Session.add(Drop(ilum[3], columi, offhand)) taral5_instance = Instance('Taral V', 'Boarding Party') taral5 = [ Boss(1, taral5_instance, 'Handler Gattan', 'HXI-54'), Boss(2, taral5_instance, 'Ripper', "Sakan Do'nair"), Boss(3, taral5_instance, 'Lord Hasper', 'Engineer Kels'), Boss(4, taral5_instance, 'General Edikar', 'Jorland'), ] Session.add_all(taral5) Session.add(Drop(taral5[0], purple, relic)) Session.add(Drop(taral5[1], energized, boots)) Session.add(Drop(taral5[2], tionese, implant)) Session.add(Drop(taral5[3], columi, gloves)) maelstrom_instance = Instance('Maelstrom Prison', 'The Foundry') maelstrom = [ Boss(1, maelstrom_instance, '', 'Foundry Guardian'), Boss(2, maelstrom_instance, '', 'HK-47'), Boss(3, maelstrom_instance, '', 'Borrower Matriarch'), Boss(4, maelstrom_instance, 'Grand Moff Kilran', 'Revan'), ] Session.add_all(maelstrom) Session.add(Drop(maelstrom[0], tionese, boots)) Session.add(Drop(maelstrom[1], tionese, offhand)) Session.add(Drop(maelstrom[2], tionese, belt)) Session.add(Drop(maelstrom[3], columi, boots)) kaon_instance = Instance('Kaon Under Siege') kaon = [ Boss(1, kaon_instance, 'Defend vs Zombie'), Boss(2, kaon_instance, 'Rakghoul Behemoth'), Boss(3, kaon_instance, 'KR-82 Expulser'), Boss(4, kaon_instance, "Commander Lk'Graagth"), ] Session.add_all(kaon) Session.add(Drop(kaon[0], xenotech, gloves)) Session.add(Drop(kaon[1], tionese, mainhand)) Session.add(Drop(kaon[2], columi, head)) Session.add(Drop(kaon[3], columi, head)) ev_normal_instance = Instance('Eternity Vault (normal)') ev = [ Boss(1, ev_normal_instance, 'Annihilation Droid XRR-3'), Boss(2, ev_normal_instance, 'Gharj'), Boss(3, ev_normal_instance, 'Ancient Pylons'), Boss(4, ev_normal_instance, 'Infernal Council'), Boss(5, ev_normal_instance, 'Soa'), ] Session.add_all(ev) Session.add(Drop(ev[0], energized, head)) Session.add(Drop(ev[0], columi, gloves)) Session.add(Drop(ev[1], tionese, belt)) Session.add(Drop(ev[1], columi, offhand)) Session.add(Drop(ev[2], columi, legs)) Session.add(Drop(ev[2], tionese, bracers)) Session.add(Drop(ev[3], columi, boots)) Session.add(Drop(ev[3], tionese, relic)) Session.add(Drop(ev[4], columi, chest)) Session.add(Drop(ev[4], tionese, mainhand)) ev_hard_instance = Instance('Eternity Vault (hard)') ev_hard = [ Boss(1, ev_hard_instance, 'Annihilation Droid XRR-3'), Boss(2, ev_hard_instance, 'Gharj'), Boss(3, ev_hard_instance, 'Ancient Pylons'), Boss(4, ev_hard_instance, 'Infernal Council'), Boss(5, ev_hard_instance, 'Soa'), ] Session.add_all(ev_hard) Session.add(Drop(ev_hard[0], exotech, head)) Session.add(Drop(ev_hard[0], rakata, gloves)) Session.add(Drop(ev_hard[1], columi, belt)) Session.add(Drop(ev_hard[1], rakata, offhand)) Session.add(Drop(ev_hard[1], columi, implant)) Session.add(Drop(ev_hard[2], rakata, legs)) Session.add(Drop(ev_hard[2], columi, bracers)) Session.add(Drop(ev_hard[3], rakata, boots)) Session.add(Drop(ev_hard[3], columi, relic)) Session.add(Drop(ev_hard[4], rakata, chest)) Session.add(Drop(ev_hard[4], columi, mainhand)) kp_instance = Instance("Karagga's Palace (normal)") kp = [ Boss(1, kp_instance, 'Bonethrasher'), Boss(2, kp_instance, 'Jarg & Sorno'), Boss(3, kp_instance, 'Foreman Crusher'), Boss(4, kp_instance, 'G4-B3 Fabricator'), Boss(5, kp_instance, 'Karagga the Fatty'), ] Session.add_all(kp) Session.add(Drop(kp[0], columi, head)) Session.add(Drop(kp[0], xenotech, gloves)) Session.add(Drop(kp[1], columi, belt)) Session.add(Drop(kp[1], tionese, offhand)) Session.add(Drop(kp[2], xenotech, legs)) Session.add(Drop(kp[2], columi, bracers)) Session.add(Drop(kp[3], xenotech, boots)) Session.add(Drop(kp[3], columi, relic)) Session.add(Drop(kp[4], xenotech, chest)) Session.add(Drop(kp[4], columi, mainhand)) kp_hard_instance = Instance("Karagga's Palace (hard)") kp_hard = [ Boss(1, kp_hard_instance, 'Bonethrasher'), Boss(2, kp_hard_instance, 'Jarg & Sorno'), Boss(3, kp_hard_instance, 'Foreman Crusher'), Boss(4, kp_hard_instance, 'G4-B3 Fabricator'), Boss(5, kp_hard_instance, 'Karagga the Fatty'), ] Session.add_all(kp_hard) Session.add(Drop(kp_hard[0], rakata, head)) Session.add(Drop(kp_hard[0], exotech, gloves)) Session.add(Drop(kp_hard[1], rakata, belt)) Session.add(Drop(kp_hard[1], columi, offhand)) Session.add(Drop(kp_hard[2], exotech, legs)) Session.add(Drop(kp_hard[2], rakata, bracers)) Session.add(Drop(kp_hard[3], exotech, boots)) Session.add(Drop(kp_hard[3], rakata, relic)) Session.add(Drop(kp_hard[4], exotech, chest)) Session.add(Drop(kp_hard[4], rakata, mainhand)) Session.add(Mode(4, 1)) Session.add(Mode(8, 2)) Session.add(Mode(16, 4)) Session.add(Spec('Melee DPS', 'melee')) Session.add(Spec('Ranged DPS', 'ranged')) Session.add(Spec('Heal', 'healing')) Session.add(Spec('Tank', 'tank')) Session.commit()