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'}]
