diff options
Diffstat (limited to 'gentoobrowse-api/service/sql')
3 files changed, 5 insertions, 3 deletions
diff --git a/gentoobrowse-api/service/sql/maintenance/repoSetLastCommit.sql b/gentoobrowse-api/service/sql/maintenance/repoSetLastCommit.sql new file mode 100644 index 0000000..a5397ea --- /dev/null +++ b/gentoobrowse-api/service/sql/maintenance/repoSetLastCommit.sql @@ -0,0 +1 @@ +UPDATE gentoobrowse.repos SET lastCommit = ? WHERE repoId = ? diff --git a/gentoobrowse-api/service/sql/maintenance/reposToGitRefresh.sql b/gentoobrowse-api/service/sql/maintenance/reposToGitRefresh.sql index 068ddb9..f7a4638 100644 --- a/gentoobrowse-api/service/sql/maintenance/reposToGitRefresh.sql +++ b/gentoobrowse-api/service/sql/maintenance/reposToGitRefresh.sql @@ -1,4 +1,4 @@ -SELECT repoid, name, path, lastcommit +-- libdbpp:no-cursor +SELECT repoid, name, path, upstream, branch, lastcommit FROM gentoobrowse.repos WHERE lastcommit IS NOT NULL - diff --git a/gentoobrowse-api/service/sql/maintenance/reposToUpdate.sql b/gentoobrowse-api/service/sql/maintenance/reposToUpdate.sql index d373418..318a796 100644 --- a/gentoobrowse-api/service/sql/maintenance/reposToUpdate.sql +++ b/gentoobrowse-api/service/sql/maintenance/reposToUpdate.sql @@ -1,4 +1,5 @@ -SELECT path, upstream, branch +-- libdbpp:no-cursor +SELECT repoid, name, path, upstream, branch, lastcommit FROM gentoobrowse.repos WHERE upstream IS NOT NULL AND branch IS NOT NULL |