def main(args): """ """ for sheet in args.sheets[0]: item = Sheet('Sports', sheet) item.set_options(args) stat = Stat(item) stat.publish()
def main(args): """ """ sheet = Sheet('Misery Index', args.name) sheet.set_options(args) if args.live: misery = MiseryLive(sheet) else: misery = Misery(sheet) misery.publish()
def main(args): """ """ #sheet = Sheet('Verdict', 'config') #sheet.set_options(args) #verdict = Verdict(sheet) #verdict.publish() #sheet = Sheet('Verdict', 'numeric') #sheet.set_options(args) #verdict = Verdict(sheet) #verdict.publish() sheet = Sheet('Verdict', 'death_penalty') sheet.set_options(args) verdict = Verdict(sheet) verdict.publish()
def test_publish(): """ Test publish method. """ sheet = Sheet('test-sheet', 'worksheet-name') publish = Stat(sheet) publish_value = publish.publish() assert publish_value == True
def main(args): """ Handle the command line. """ sheet = Sheet('NYDN Sports', args.sheet) sheet.options = args sheet.rows = sheet.get_sheet_rows() sheet.rows = sheet.filter_mostly_blank_rows(sheet.rows) sheet.publish() # We want to build a list of per-day misery scores too if 'misery' in args.sheet: m = Misery(sheet) m.publish()
def test_filename(): """ Test the build_filename() method. """ sheet = Sheet('test-sheet', 'worksheet-name') sheet.add_filter('name', 'test') sheet.build_filename() assert sheet.filename == 'worksheet-name-test'
import os import discord import asyncio from discord.ext import commands from tinydb import TinyDB, Query from spreadsheet import Sheet sheet = Sheet("osutournamentdiscordjoincheck-84f8d6e67c81.json") db = TinyDB('db.json') class Qualifier(commands.Cog): def __init__(self, bot): self.bot = bot @commands.command(name="roomSet") @commands.has_permissions(administrator=True) async def create_qualifier(self, ctx, action, room_id, day="", time=""): """ Sets up a qualifier room. action: add or remove room_id: name of the room. """ qualifier_settings = db.table("guilds").get( Query().guild_id == ctx.guild.id)["qualifier_sheet_settings"] if qualifier_settings != None: pass
def test_publish(): """ Test the Sheet's publish method. """ sheet = Sheet('test-sheet', 'worksheet-name') publish_value = sheet.publish() assert publish_value == True
def test_filters(): """ Test adding a filter to the sheet. """ sheet = Sheet('test-sheet', 'worksheet-name') sheet.add_filter('name', 'test') assert sheet.filters == [{'value': 'test', 'key': 'name'}]