Build relational table functions

[Operator873]

New tables 'people' and 'channels' are created for relational support. Add populating sql commands to add to and delete from these tables on !watch add and !watch del respectively. !globalwatch should also write to these tables, but in people table, project should be global and no difference to the channels table.

Table: people
Columns

• nick
• project

Table channels
Columns

• channel
• nick

[Operator873]

    if (
        len(
            c.execute(
                '''SELECT * FROM %s WHERE nick="%s";''' % (project, nick)
            ).fetchall()
        ) == 0
    ):
        c.execute('''DELETE FROM people WHERE nick=? AND project=?;''', (nick, project))
        db.commit()

This is a good example of how to do the check, but this will take more thinking. Pseudo code follows:

!watch del ptwiki SomePage

check if following that page in that project table
   if yes
      delete from project table
      commit change

   check nick in has other watched pages in project
      if no
         delete from people (nick, project)
         commit change

   select projects nick is following
      for proj in projects
         check to see if nick has watched pages on that proj in this channel
         if no
             delete from channels table

[Operator873]

Might be best to do this whole process in a separate function.

def synctables(project, chan, nick, action=add/del/etc)??