| 12345678910111213141516171819202122232425262728 |
- 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 set_output_channel(pg, guild_id, value):
- return await pg.execute("UPDATE guild SET output_channel = $1 WHERE guild_id = $2 ", value, 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)
- async def get_guild_games(pg, guild_id):
- return await pg.fetchval("SELECT games FROM guild WHERE guild_id=$1::bigint", guild_id)
- async def get_guild_interact(pg, guild_id):
- return await pg.fetchval("SELECT interact FROM guild WHERE guild_id=$1::bigint", guild_id)
|
