{"id":2133,"date":"2021-01-13T17:29:07","date_gmt":"2021-01-13T14:29:07","guid":{"rendered":"https:\/\/artem.services\/?p=2133"},"modified":"2022-06-08T22:48:38","modified_gmt":"2022-06-08T19:48:38","slug":"jenkins-active-choice-postgesql-%d0%b2%d0%b5%d1%80%d0%bd%d1%83%d1%82%d1%8c-%d1%80%d0%b5%d0%b7%d1%83%d0%bb%d1%8c%d1%82%d0%b0%d1%82-select-%d0%b7%d0%b0%d0%bf%d1%80%d0%be%d1%81%d0%b0","status":"publish","type":"post","link":"https:\/\/artem.services\/?p=2133","title":{"rendered":"Jenkins &#8212; Active Choice: PostgreSQL &#8212; \u0412\u0435\u0440\u043d\u0443\u0442\u044c \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 SELECT \u0437\u0430\u043f\u0440\u043e\u0441\u0430"},"content":{"rendered":"<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-819\" src=\"https:\/\/artem.services\/wp-content\/uploads\/2019\/02\/Jenkins-Logo.png\" alt=\"\" width=\"1280\" height=\"412\" srcset=\"https:\/\/artem.services\/wp-content\/uploads\/2019\/02\/Jenkins-Logo.png 1280w, https:\/\/artem.services\/wp-content\/uploads\/2019\/02\/Jenkins-Logo-300x97.png 300w, https:\/\/artem.services\/wp-content\/uploads\/2019\/02\/Jenkins-Logo-768x247.png 768w, https:\/\/artem.services\/wp-content\/uploads\/2019\/02\/Jenkins-Logo-1024x330.png 1024w, https:\/\/artem.services\/wp-content\/uploads\/2019\/02\/Jenkins-Logo-954x307.png 954w\" sizes=\"(max-width: 1280px) 100vw, 1280px\" \/><\/p>\n<p>\u0414\u043b\u044f \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u0438\u0437\u043e\u0432\u0430\u043d\u043d\u043e\u0439 \u0441\u0431\u043e\u0440\u043a\u0438 \u0441 \u0432\u044b\u0431\u043e\u0440\u043e\u043c \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u0430 \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0435 SQL \u0437\u0430\u043f\u0440\u043e\u0441\u0430, \u043f\u043e\u043d\u0430\u0434\u043e\u0431\u0438\u0442\u0441\u044f \u043f\u043b\u0430\u0433\u0438\u043d <a href=\"https:\/\/plugins.jenkins.io\/uno-choice\/\" target=\"_blank\" rel=\"noopener noreferrer\">Active Choices<\/a><\/p>\n<p>\u041f\u0435\u0440\u0435\u0445\u043e\u0434\u0438\u043c \u0432 \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 <strong>Jenkins<\/strong>&#39;\u0430<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-1782\" src=\"https:\/\/artem.services\/wp-content\/uploads\/2020\/03\/001.png\" alt=\"\" width=\"349\" height=\"383\" srcset=\"https:\/\/artem.services\/wp-content\/uploads\/2020\/03\/001.png 349w, https:\/\/artem.services\/wp-content\/uploads\/2020\/03\/001-273x300.png 273w\" sizes=\"(max-width: 349px) 100vw, 349px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>\u0420\u0430\u0437\u0434\u0435\u043b &quot;<strong>\u0423\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u043f\u043b\u0430\u0433\u0438\u043d\u0430\u043c\u0438<\/strong>&quot;<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-1783\" src=\"https:\/\/artem.services\/wp-content\/uploads\/2020\/03\/002.png\" alt=\"\" width=\"927\" height=\"493\" srcset=\"https:\/\/artem.services\/wp-content\/uploads\/2020\/03\/002.png 927w, https:\/\/artem.services\/wp-content\/uploads\/2020\/03\/002-300x160.png 300w, https:\/\/artem.services\/wp-content\/uploads\/2020\/03\/002-768x408.png 768w\" sizes=\"(max-width: 927px) 100vw, 927px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>\u041f\u0435\u0440\u0435\u0445\u043e\u0434\u0438\u043c \u043a \u0432\u043a\u043b\u0430\u0434\u043a\u0435 &quot;<strong>\u0414\u043e\u0441\u0442\u0443\u043f\u043d\u044b\u0435<\/strong>&quot; \u0438 \u0432 \u043f\u043e\u0438\u0441\u043a\u0435 \u0443\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u043c &quot;<strong>Active Choices<\/strong>&quot;<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-1796\" src=\"https:\/\/artem.services\/wp-content\/uploads\/2020\/04\/Screenshot-2020-04-01-at-10.55.37.png\" alt=\"\" width=\"1412\" height=\"130\" srcset=\"https:\/\/artem.services\/wp-content\/uploads\/2020\/04\/Screenshot-2020-04-01-at-10.55.37.png 1412w, https:\/\/artem.services\/wp-content\/uploads\/2020\/04\/Screenshot-2020-04-01-at-10.55.37-300x28.png 300w, https:\/\/artem.services\/wp-content\/uploads\/2020\/04\/Screenshot-2020-04-01-at-10.55.37-1024x94.png 1024w, https:\/\/artem.services\/wp-content\/uploads\/2020\/04\/Screenshot-2020-04-01-at-10.55.37-768x71.png 768w, https:\/\/artem.services\/wp-content\/uploads\/2020\/04\/Screenshot-2020-04-01-at-10.55.37-954x88.png 954w, https:\/\/artem.services\/wp-content\/uploads\/2020\/04\/Screenshot-2020-04-01-at-10.55.37-1354x125.png 1354w\" sizes=\"(max-width: 1412px) 100vw, 1412px\" \/><\/p>\n<p>\u0423\u0441\u0442\u0430\u043d\u0430\u0432\u043b\u0438\u0432\u0430\u0435\u043c \u0435\u0433\u043e. \u0422\u0430\u043a \u0436\u0435 \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c \u043f\u043b\u0430\u0433\u0438\u043d\u044b:<\/p>\n<ul>\n<li><a href=\"https:\/\/plugins.jenkins.io\/database\" target=\"_blank\" rel=\"noopener noreferrer\">Database<\/a><\/li>\n<li><a href=\"https:\/\/plugins.jenkins.io\/database-postgresql\/\" target=\"_blank\" rel=\"noopener noreferrer\">PostgreSQL Database<\/a><\/li>\n<\/ul>\n<p>\u0421\u043e\u0437\u0434\u0430\u0435\u043c &quot;<strong>New Item<\/strong>&quot; &#8212; &quot;<strong>Pipeline<\/strong>&quot;, \u0443\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u043c, \u0447\u0442\u043e \u044d\u0442\u043e \u0431\u0443\u0434\u0435\u0442 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u0438\u0437\u043e\u0432\u0430\u043d\u043d\u0430\u044f \u0441\u0431\u043e\u0440\u043a\u0430, \u0438 \u0434\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u043c \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 &quot;<strong>Active Choices Parameter<\/strong>&quot;<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-2134 size-full\" src=\"https:\/\/artem.services\/wp-content\/uploads\/2021\/01\/Screenshot-2021-01-13-at-14.46.06.png\" alt=\"\" width=\"946\" height=\"502\" srcset=\"https:\/\/artem.services\/wp-content\/uploads\/2021\/01\/Screenshot-2021-01-13-at-14.46.06.png 946w, https:\/\/artem.services\/wp-content\/uploads\/2021\/01\/Screenshot-2021-01-13-at-14.46.06-300x159.png 300w, https:\/\/artem.services\/wp-content\/uploads\/2021\/01\/Screenshot-2021-01-13-at-14.46.06-768x408.png 768w\" sizes=\"(max-width: 946px) 100vw, 946px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>\u0423\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u043c, \u0447\u0442\u043e \u044d\u0442\u043e &quot;<strong>Groovy Script<\/strong>&quot; \u0438 \u0432\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u043c \u0442\u0443\u0434\u0430 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0435\u0435:<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\nimport groovy.sql.Sql\r\nimport java.sql.Driver\r\n\r\ncredentialsId = &#039;artem-services-rds-credentials&#039;\r\nurl = &#039;artem-services-rds.xxxxxxxxxxxx.eu-central-1.rds.amazonaws.com:5432\/postgres&#039;\r\n\r\ndef creds = com.cloudbees.plugins.credentials.CredentialsProvider.lookupCredentials(\r\n  com.cloudbees.plugins.credentials.common.StandardUsernameCredentials.class, Jenkins.instance, null, null ).find{\r\n    it.id == credentialsId\r\n  }\r\n\r\ndef driver = Class.forName(&#039;org.postgresql.Driver&#039;).newInstance() as Driver \r\n\r\ndef props = new Properties()\r\nprops.setProperty(&quot;user&quot;, &quot;${creds.username}&quot;) \r\nprops.setProperty(&quot;password&quot;, &quot;${creds.password}&quot;)\r\n\r\ndef conn = driver.connect(&quot;jdbc:postgresql:\/\/${url}&quot;, props) \r\ndef sql = new Sql(conn)\r\n\r\ndef artifact = []\r\n\r\nartifact.add(&quot;Not selected&quot;)\r\n\r\ndef rows = sql.rows(&quot;select * from users&quot;).each { row -&gt;\r\n  artifact.add(&quot;$row.first_name&quot;)\r\n}\r\n\r\nreturn artifact\r\n<\/pre>\n<p>&nbsp;<\/p>\n<blockquote><p>\u0413\u0434\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u044b\u0445, &quot;<strong>credentialsId<\/strong>&quot; &#8212; Jenkins Credentials ID \u0441 \u043b\u043e\u0433\u0438\u043d\u043e\u043c \u0438 \u043f\u0430\u0440\u043e\u043b\u0435\u043c \u0434\u043b\u044f \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u044f \u043a \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445;<\/p>\n<p>&quot;<strong>url<\/strong>&quot; &#8212; \u0441\u0442\u0440\u043e\u043a\u0430 \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u044f \u043a \u0431\u0430\u0437\u0435 (endpoint + port + db name);<\/p><\/blockquote>\n<p>&nbsp;<\/p>\n<p>\u0414\u0430\u043d\u043d\u044b\u0439 <strong>Active Choice<\/strong> \u0434\u0435\u043b\u0430\u0435\u0442 <strong>SELECT<\/strong> \u0437\u0430\u043f\u0440\u043e\u0441 \u043a \u0442\u0430\u0431\u043b\u0438\u0446\u0435 &quot;<strong>users<\/strong>&quot; \u0438 \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u0442\u043e\u043b\u044c\u043a\u043e \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f \u043f\u043e\u043b\u0435\u0439 &quot;<strong>first_name<\/strong>&quot;, \u0442\u0430\u043a \u0436\u0435 \u043d\u0430 \u043f\u0435\u0440\u0432\u0443\u044e \u043f\u043e\u0437\u0438\u0446\u0438\u044e \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u0430 \u0434\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u0442 &quot;<strong>Not selected<\/strong>&quot;.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0414\u043b\u044f \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u0438\u0437\u043e\u0432\u0430\u043d\u043d\u043e\u0439 \u0441\u0431\u043e\u0440\u043a\u0438 \u0441 \u0432\u044b\u0431\u043e\u0440\u043e\u043c \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u0430 \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0435 SQL \u0437\u0430\u043f\u0440\u043e\u0441\u0430, \u043f\u043e\u043d\u0430\u0434\u043e\u0431\u0438\u0442\u0441\u044f \u043f\u043b\u0430\u0433\u0438\u043d Active Choices \u041f\u0435\u0440\u0435\u0445\u043e\u0434\u0438\u043c \u0432 \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 Jenkins&#39;\u0430 &nbsp; \u0420\u0430\u0437\u0434\u0435\u043b &quot;\u0423\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u043f\u043b\u0430\u0433\u0438\u043d\u0430\u043c\u0438&quot; &nbsp; \u041f\u0435\u0440\u0435\u0445\u043e\u0434\u0438\u043c \u043a \u0432\u043a\u043b\u0430\u0434\u043a\u0435 &quot;\u0414\u043e\u0441\u0442\u0443\u043f\u043d\u044b\u0435&quot; \u0438 \u0432 \u043f\u043e\u0438\u0441\u043a\u0435 \u0443\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u043c &quot;Active Choices&quot; \u0423\u0441\u0442\u0430\u043d\u0430\u0432\u043b\u0438\u0432\u0430\u0435\u043c \u0435\u0433\u043e. \u0422\u0430\u043a \u0436\u0435 \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c \u043f\u043b\u0430\u0433\u0438\u043d\u044b: Database PostgreSQL Database \u0421\u043e\u0437\u0434\u0430\u0435\u043c &quot;New Item&quot; &#8212; &quot;Pipeline&quot;, \u0443\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u043c, \u0447\u0442\u043e \u044d\u0442\u043e \u0431\u0443\u0434\u0435\u0442 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u0438\u0437\u043e\u0432\u0430\u043d\u043d\u0430\u044f \u0441\u0431\u043e\u0440\u043a\u0430, \u0438 \u0434\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u043c &hellip; <a href=\"https:\/\/artem.services\/?p=2133\" class=\"more-link\">\u041f\u0440\u043e\u0434\u043e\u043b\u0436\u0438\u0442\u044c \u0447\u0438\u0442\u0430\u0442\u044c<span class=\"screen-reader-text\"> &quot;Jenkins &#8212; Active Choice: PostgreSQL &#8212; \u0412\u0435\u0440\u043d\u0443\u0442\u044c \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 SELECT \u0437\u0430\u043f\u0440\u043e\u0441\u0430&quot;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[37],"tags":[1455,125,1121,46,47],"_links":{"self":[{"href":"https:\/\/artem.services\/index.php?rest_route=\/wp\/v2\/posts\/2133"}],"collection":[{"href":"https:\/\/artem.services\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/artem.services\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/artem.services\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/artem.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2133"}],"version-history":[{"count":3,"href":"https:\/\/artem.services\/index.php?rest_route=\/wp\/v2\/posts\/2133\/revisions"}],"predecessor-version":[{"id":2295,"href":"https:\/\/artem.services\/index.php?rest_route=\/wp\/v2\/posts\/2133\/revisions\/2295"}],"wp:attachment":[{"href":"https:\/\/artem.services\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2133"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/artem.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2133"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/artem.services\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}