![\"\"](\"https:\/\/artem.services\/wp-content\/uploads\/2019\/02\/Jenkins-Logo.png\"){kind=logo}
<\/p>\n<\/p>\n
For a parameterized assembly with an image tag selection, you will need the Active Choices<\/a> plugin<\/p>\n Go to "Manage Jenkins<\/strong>"<\/p>\n <\/p>\n Section "Manage Plugins<\/strong>"<\/p>\n <\/p>\n Go to the "Available<\/strong>" tab and select "Active Choices<\/strong>" in the search.<\/p>\n Install it. You also need plugins:<\/span><\/span><\/span><\/p>\n Create a "New Item<\/strong>" \u2013 "Pipeline<\/strong>", indicate that it will be a parameterized assembly, and add the parameter "Active Choices Parameter<\/strong>"<\/p>\n <\/p>\n <\/p>\n <\/p>\n We indicate that this is "Groovy Script<\/strong>" and paste the following into it:<\/p>\n <\/p>\n Where is the value of the variables, "credentialsId<\/strong>" — Jenkins Credentials ID with login and password to connect to the database;<\/span><\/span><\/span><\/p>\n "url<\/strong>" — database connection string (endpoint + port + db name);<\/span><\/span><\/span><\/p><\/blockquote>\n <\/p>\n This Active Choice<\/strong> makes a SELECT<\/strong> query on the "users<\/strong>" table and returns only the values of the "first_name<\/strong>" fields, as well as adding "Not selected<\/strong>" to the first position of the result.<\/span><\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":" For a parameterized assembly with an image tag selection, you will need the Active Choices plugin Go to "Manage Jenkins" Section "Manage Plugins" Go to the "Available" tab and select "Active Choices" in the search. Install it. You also need plugins: Database PostgreSQL Database Create a "New Item" \u2013 "Pipeline", indicate that it … \u041f\u0440\u043e\u0434\u043e\u043b\u0436\u0438\u0442\u044c \u0447\u0438\u0442\u0430\u0442\u044c "\u00a0Jenkins — Active Choice: PostgreSQL — Return result of SELECT query"<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[613],"tags":[1465,617,1247,1089,1091],"_links":{"self":[{"href":"https:\/\/artem.services\/index.php?rest_route=\/wp\/v2\/posts\/2292"}],"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=2292"}],"version-history":[{"count":2,"href":"https:\/\/artem.services\/index.php?rest_route=\/wp\/v2\/posts\/2292\/revisions"}],"predecessor-version":[{"id":2296,"href":"https:\/\/artem.services\/index.php?rest_route=\/wp\/v2\/posts\/2292\/revisions\/2296"}],"wp:attachment":[{"href":"https:\/\/artem.services\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2292"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/artem.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2292"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/artem.services\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2292"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"\"](\"https:\/\/artem.services\/wp-content\/uploads\/2020\/03\/001.png\")
<\/p>\n![\"\"](\"https:\/\/artem.services\/wp-content\/uploads\/2020\/03\/002.png\")
<\/p>\n![\"\"](\"https:\/\/artem.services\/wp-content\/uploads\/2020\/04\/Screenshot-2020-04-01-at-10.55.37.png\")
<\/p>\n\n
![\"\"](\"https:\/\/artem.services\/wp-content\/uploads\/2021\/01\/Screenshot-2021-01-13-at-14.46.06.png\")
<\/p>\n\r\nimport groovy.sql.Sql\r\nimport java.sql.Driver\r\n\r\ncredentialsId = 'artem-services-rds-credentials'\r\nurl = 'artem-services-rds.xxxxxxxxxxxx.eu-central-1.rds.amazonaws.com:5432\/postgres'\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('org.postgresql.Driver').newInstance() as Driver \r\n\r\ndef props = new Properties()\r\nprops.setProperty("user", "${creds.username}") \r\nprops.setProperty("password", "${creds.password}")\r\n\r\ndef conn = driver.connect("jdbc:postgresql:\/\/${url}", props) \r\ndef sql = new Sql(conn)\r\n\r\ndef artifact = []\r\n\r\nartifact.add("Not selected")\r\n\r\ndef rows = sql.rows("select * from users").each { row ->\r\n artifact.add("$row.first_name")\r\n}\r\n\r\nreturn artifact\r\n<\/pre>\n