PostgreSQL - Repository Polling - Scheduled (v5.7-)
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Fisheye および Crucible は除く
製品 | バージョン | データベース | Documentation reference |
---|---|---|---|
Bamboo | V5.7.X | PostgreSQL | リポジトリをポーリングして変更を確認する |
Lets find out how to get Bamboo's repository polling scheduled values from PostgreSQL database along with updating those values.
Get repository polling as Scheduled
/*
* Bamboo version: 5.7-
* Database: PostgreSQL
* Triggers: 'Repository polling' > 'Polling strategy' > 'Scheduled'
*/select B.FULL_KEY as PLAN_KEY,
B.TITLE as TITLE,
VL.PLUGIN_KEY as REPOSITORY_TYPE,
unnest(xpath
('//buildStrategies/buildStrategy/key[text()="poll"]/../config/item/key[text()="repository.change.poll.type"]/../value[text()="CRON"]/../../item/key[text()="repository.change.poll.cronExpression"]/../value/text()',CAST(BD.XML_DEFINITION_DATA as XML)
))::text as SCHEDULED,
BD.BUILD_DEFINITION_ID as BUILD_DEFINITION_ID
from VCS_LOCATION as VL
join PLAN_VCS_LOCATION as PVL on PVL.VCS_LOCATION_ID = VL.VCS_LOCATION_ID
join BUILD as B on PVL.PLAN_ID = B.BUILD_ID
join BUILD_DEFINITION as BD on B.BUILD_ID = BD.BUILD_ID
where B.SUSPENDED_FROM_BUILDING = false
order by SCHEDULED desc, PLAN_KEY, TITLE;
What expect from query above:
PLAN_KEY | タイトル | SCHEDULED | BUILD_DEFINITION_ID |
---|---|---|---|
REP-GIT | Git | 0 0 12 ? * * | 425985 |
REP-SUB | Subversion | 0 0 13 ? * * | 451238 |
最終更新日 2018 年 11 月 1 日
Powered by Confluence and Scroll Viewport.