async def update_guild(pg, guild): await pg.execute("INSERT INTO guild(guild_id) VALUES($1) ON CONFLICT DO NOTHING", guild.id) for chan in guild.text_channels: await pg.execute("INSERT INTO channel(channel_id, guild) VALUES($1, $2) ON CONFLICT DO NOTHING", chan.id, guild.id) async def get_output_channel(pg, guild_id): return await pg.fetchval("SELECT output_channel FROM guild WHERE guild_id = $1", guild_id) async def get_report_deleted(pg, guild_id): return await pg.fetchval("SELECT report_deleted FROM guild WHERE guild_id = $1", guild_id) async def get_report_edited(pg, guild_id): return await pg.fetchval("SELECT report_edited FROM guild WHERE guild_id = $1", guild_id)