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