1
0

guild.py 554 B

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