1
0

channel.py 712 B

1234567891011121314
  1. async def insert_channel(pg, channel_id, guild_id):
  2. await pg.execute("INSERT INTO channel(channel_id, guild) VALUES($1, $2)", channel_id, guild_id)
  3. async def get_interact(pg, channel_id):
  4. return await pg.fetchval("SELECT interact FROM channel WHERE channel_id=$1::bigint", channel_id)
  5. async def set_interact(pg, value, channel_id):
  6. await pg.execute("UPDATE channel SET interact = $1 WHERE channel_id=$2::bigint", value, channel_id)
  7. async def get_games(pg, channel_id):
  8. return await pg.fetchval("SELECT games FROM channel WHERE channel_id=$1::bigint", channel_id)
  9. async def set_games(pg, value, channel_id):
  10. await pg.execute("UPDATE channel SET games = $1 WHERE channel_id=$2::bigint", value, channel_id)