Easily enabling/disabling issue tracking of all repositories on Gogs

Question

I want to enable/disable issue tracking of all the repositories easily. Whereas Gogs' web interface only allows enabling/disabling issue tracking option of a single repository at a time.

It is not possible enabling/disabling issue tracking of repositories under the same organization, either.

Because I have a lot of repositories, I need an easier way to do so.

score 0 · Answer 1 · answered Apr 21 '17 at 08:57

I could manage to enable/disable issue tracking feature of all or some(under the same organization) repositories. To achieve that, I used SQLiteStudio and executed following SQL commands on SQLite database:

-- Disable issue tracking of all repositories
UPDATE repository SET enable_issues = 0 WHERE enable_issues = 1;

-- Enable issue tracking of all repositories
UPDATE repository SET enable_issues = 1 WHERE enable_issues = 0;

-- Disable issue tracking of all repositories under TESTPROJECT organization 
UPDATE repository SET enable_issues = 0 WHERE owner_id IN (SELECT id FROM user WHERE name='TESTPROJECT');

-- Enable issue tracking of all repositories under TESTPROJECT organization 
UPDATE repository SET enable_issues = 1 WHERE owner_id IN (SELECT id FROM user WHERE name='TESTPROJECT');

Easily enabling/disabling issue tracking of all repositories on Gogs

1 Answers1