Add support for multiple repositories per user

[cmccandless]

Currently, this bot has the following limitation:

Currently i can watch only one repository from each user.

[artemgurzhii]

Hi @cmccandless, thank you for your issue.

Currently, this repository is not under active development, and I'm not going to soon start working on it, but all PR's are welcome

[cmccandless]

I think I have an idea on how to implement this. What database does the backend use (MySQL?)?

[artemgurzhii]

@cmccandless Postgresql

[cmccandless]

@artemgurzhii My idea is to replace the existing table with the following:

CREATE TABLE(
    id SERIAL NOT NULL,
    url VARCHAR(100) NOT NULL,
    json VARCHAR(120),
    watching BOOLEAN,
    build VARCHAR(9),
    watchonlyfailing BOOLEAN,
    PRIMARY KEY(id, url)
);

Commands would also need modified to allow selective or universal stop/start watching, or toggle failed builds only per repo.

I one thing I'm not sure I'd be able to do myself is migrate the existing DB to the new table. There is likely a way to include a conditional migration in a PGSQL query, but as this would only need to be a one-time migration it would be better not to include that migration code in the source code. Would you be willing/able to do the appropriate migration if I created a PR with all of the necessary code changes?

[artemgurzhii]

@cmccandless Yes!

[artemgurzhii]

@cmccandless Thank you very much for your help!

[cmccandless]

It will take me some time, maybe not before the New Year.