def main():
reports = get_reports(secrets.raid_id, secrets.c_date)
print('Reports retrieved')
deaths = get_deaths(reports)
print('Deaths retrieved')
wks = wb.worksheet('deaths')
wks.append_rows(deaths, 'USER_ENTERED')
print('Worksheet updated')
def main():
reports = get_reports(secrets.raid_id, secrets.c_date)
print('Reports retrieved')
buffs = get_buffs(reports, lookup.buff_ids)
print('Buffs retrieved')
wks = wb.worksheet('buffs')
wks.append_rows(buffs, 'USER_ENTERED')
print('Worksheet updated')
def main():
reports = get_reports(secrets.raid_id, secrets.c_date)
print('Reports retrieved')
encounters = ['-3', '-2', '0']
damage = get_damage(reports, encounters)
print('Damage retrieved')
wks = wb.worksheet('damage')
wks.append_rows(damage, 'USER_ENTERED')
print('Worksheet updated')
def main():
reports = get_reports(secrets.raid_id, secrets.c_date)
print('Reports retrieved')
buff_ids = ['17626', '17627', '17628']
buffs = get_buffs(reports, buff_ids)
print('Buffs retrieved')
wks = wb.worksheet('flasks')
wks.append_rows(buffs, 'USER_ENTERED')
print('Worksheet updated')
def main():
reports = get_reports(secrets.raid_id, secrets.c_date)
print('Reports retrieved')
abilities = ['13241', '23063', '17291']
damage = get_damage(reports, abilities)
print('Damage retrieved')
wks = wb.worksheet('eng')
wks.append_rows(damage, 'USER_ENTERED')
print('Worksheet updated')
def main():
wks = wb.worksheet('add_parse')
reports = get_reports(secrets.raid_id, secrets.c_date)
print('Reports retrieved')
players = get_players(reports)
parses = get_parses(players, [])
print('Table created')
update_sheet(wks, parses)
print('Worksheet updated')
def main():
reports = get_reports(secrets.raid_id, secrets.c_date)
print('Reports retrieved')
encounters = ['-3']
abilities = ['10177', '28609', '12051', '1953', '475', '27869', '16666']
cast_info = get_casts_type(reports, 'casts', encounters, abilities, 'Mage')
print('Cast info retrieved')
wks = wb.worksheet('mage')
wks.append_rows(cast_info, 'USER_ENTERED')
print('Worksheet updated')
def main():
reports = get_reports(secrets.raid_id, secrets.c_date)
print('Reports retrieved')
encounters = ['-3']
abilities = ['23271', '24659', '23723', '28779', '26400', '24544']
cast_info = get_casts(reports, 'buffs', encounters, abilities)
print('Cast info retrieved')
wks = wb.worksheet('caster')
wks.append_rows(cast_info, 'USER_ENTERED')
print('Worksheet updated')
def main():
reports = get_reports(secrets.raid_id, secrets.c_date)
print('Reports retrieved')
encounters = ['-3']
abilities = ['10278', '4987', '10310', '10308']
cast_info = get_casts(reports, 'casts', encounters, abilities)
print('Cast info retrieved')
wks = wb.worksheet('paladin')
wks.append_rows(cast_info, 'USER_ENTERED')
print('Worksheet updated')
def main():
reports = get_reports(secrets.raid_id, secrets.c_date)
print('Reports retrieved')
encounters = ['-3']
abilities = ['13877', '13750', '1769', '9512']
cast_info = get_casts_type(reports, 'casts', encounters, abilities,
'Rogue')
print('Cast info retrieved')
wks = wb.worksheet('rogue')
wks.append_rows(cast_info, 'USER_ENTERED')
print('Worksheet updated')
def main():
reports = get_reports(secrets.raid_id, secrets.c_date)
print('Reports retrieved')
encounters = ['-3']
abilities = ['6346', '10060', '14751', '988', '17531', '27869', '16666']
cast_info = get_casts_type(reports, 'casts', encounters, abilities,
'Priest')
print('Cast info retrieved')
wks = wb.worksheet('priest')
wks.append_rows(cast_info, 'USER_ENTERED')
print('Worksheet updated')
def main():
reports = get_reports(secrets.raid_id, secrets.c_date)
print('Reports retrieved')
encounters = ['-3']
abilities = [
'5579', '23273', '23725', '24427', '24532', '24610', '25891', '26400',
'26480', '28777', '28866'
]
cast_info = get_casts(reports, 'casts', encounters, abilities)
print('Melee info retrieved')
wks = wb.worksheet('melee')
wks.append_rows(cast_info, 'USER_ENTERED')
print('Worksheet updated')
def main():
reports = get_reports(secrets.raid_id, secrets.c_date)
print('Reports retrieved')
encounters = ['1107', '1108', '1109', '1110', '1111', '1112', '1113', '1114', '1115', '1116', '1117', '1118', '1119', '1120', '1121'] # Naxx
abilities = ['9907', '17392']
cast_info = get_casts(reports, 'casts', encounters, abilities)
print('Uptime info retrieved')
wks = wb.worksheet('druid')
wks.append_rows(cast_info, 'USER_ENTERED')
print('Worksheet updated')
encounters = ['-3']
abilities = ['2782', '2893', '29166']
cast_info = get_casts(reports, 'casts', encounters, abilities)
print('Cast info retrieved')
wks.append_rows(cast_info, 'USER_ENTERED')
print('Worksheet updated')
def main():
reports = get_reports(secrets.raid_id, secrets.c_date)
print('Reports retrieved')
# encounters = ['709', '710', '711', '712', '713', '714', '715', '716', '717', '0'] # AQ40
encounters = [
'1107', '1108', '1109', '1110', '1111', '1112', '1113', '1114', '1115',
'1116', '1117', '1118', '1119', '1120', '1121', '0'
] # Naxx
abilities = [
'11717', '17937', '11722', '11713', '11672', '11661', '25307', '704',
'11719', '11708'
]
cast_info = get_casts(reports, 'casts', encounters, abilities)
print('Cast info retrieved')
wks = wb.worksheet('warlock')
wks.append_rows(cast_info, 'USER_ENTERED')
print('Worksheet updated')
def main():
reports = get_reports(secrets.raid_id, secrets.c_date)
print('Reports retrieved')
encounters = ['-3']
abilities = ['11597', '12328', '676']
start_info = get_casts_type(reports, 'casts', encounters, abilities,
'Warrior')
abilities = ['11597']
expression = 'type%3D%22cast%22%20AND%20ability.id%3D11597%20AND%20NOT%20IN%20RANGE%20FROM%20type%3D%22applydebuffstack%22%20AND%20ability.id%3D11597%20AND%20stack%3D5%20TO%20type%3D%22removedebuff%22%20AND%20ability.id%3D11597%20GROUP%20BY%20target%20ON%20target%20END'
cast_info = get_effective(reports, 'casts', encounters, abilities,
expression, start_info)
print('Cast info retrieved')
wks = wb.worksheet('warrior')
wks.append_rows(cast_info, 'USER_ENTERED')
print('Worksheet updated')
def main():
wks = wb.worksheet('players')
reports = get_reports(secrets.raid_id, secrets.c_date)
players = get_player_rows(reports)
update_sheet(wks, players)