David F. Driscoll

icon indicating a website link www.linkedin.com/in/david-f-driscoll icon indicating an email [email protected]

icon location New York icon location Leveraging experience in digital academic research for application development

Results 1 issues of David F. Driscoll

Using window functions for ranking

This is an attempt to rewrite the leaderboard_rank method from DiscordMember: def my_dm_leaderboard_rank(discordmember, date_cutoff): query = my_leaderboard(date_cutoff) r = (Select(columns=[query.c.id, query.c.elo, fn.rank().over(order_by=[query.c.elo.desc()]).alias('ranked')]) .from_(query)) rank = Select(columns=[r.c.ranked]).from_(r).where(r.c.id == discordmember.id).bind(db).get() return(rank.get('ranked'), query.count())...