4.0.0 com.atlassian.bamboo atlassian-bamboo 8.2.0-m079 atlassian-bamboo-wired-test atlassian-plugin Atlassian Bamboo Wired Tests This is the module for wired tests for Atlassian Bamboo. ${project.groupId}.${project.artifactId} test localhost ${test.host} bamboo bamboo com.atlassian.bamboo atlassian-bamboo-core provided com.atlassian.bamboo atlassian-bamboo-deployments-api provided com.atlassian.bamboo atlassian-bamboo-deployments provided com.atlassian.bamboo atlassian-bamboo-rest-model provided com.atlassian.bamboo atlassian-bamboo-test-utils provided com.atlassian.selenium atlassian-pageobjects-elements com.atlassian.bamboo.plugins atlassian-bamboo-plugin-test-utils provided com.atlassian.functest functest-plugin provided com.atlassian.plugin atlassian-spring-scanner-annotation provided com.atlassian.plugins.rest atlassian-rest-common provided org.glassfish.jaxb jaxb-runtime provided junit junit provided org.apache.httpcomponents httpmime provided org.hamcrest hamcrest-all provided org.mockito mockito-core compile org.opentest4j opentest4j 1.2.0 com.atlassian.plugin atlassian-spring-scanner-maven-plugin com.atlassian.maven.plugins bamboo-maven-plugin ${amps.containerId} ${basedir}/src/test/resources/generated-test-resources.zip ${atlassian.plugin.key} * !com.sun.security.auth*, junit.framework;version="${junit.version}";resolution:=optional, net.bytebuddy.jar.asm.tree;resolution:=optional, !oracle*, !org.jboss.resource.adapter.jdbc*, org.junit*;version="${junit.version}";resolution:=optional, org.hamcrest*;version="${hamcrest.version}", !org.objectweb.asm*, !org.osgi.service.jdbc, !org.newsclub.net.unix, sun.misc;resolution:="optional", !sun.security*, !waffle.windows.auth*, org.hibernate, * com.atlassian.bamboo.plugins atlassian-bamboo-plugin-test-utils com.atlassian.functest functest-plugin true resolveDeps mysql MySQL ${db.name} 3306 localhost root root bamboo-functest utf8 com.mysql.cj.jdbc.Driver jdbc:mysql://${db.host}:${db.port} ${dbms.url}/${db.instance}?useUnicode=true&characterEncoding=utf8&useSSL=false&allowPublicKeyRetrieval=true ${dbms.url}/${db.instance}?useUnicode=true&characterEncoding=utf8&useSSL=false&allowPublicKeyRetrieval=true org.hibernate.dialect.MySQL57InnoDBDialect mysql mysql-connector-java ${mysql.driver.version} db-mysql.properties org.codehaus.mojo sql-maven-plugin ${db.admin.username} ${db.admin.password} ${dbms.url} ${jdbc.driver} drop-database clean execute true DROP DATABASE `${db.instance}`; DROP USER '${db.username}'@'${db.host}'; continue create-database clean execute true CREATE DATABASE `${db.instance}` CHARACTER SET ${mysql.encoding} COLLATE ${mysql.encoding}_bin; CREATE USER '${db.username}'@'${db.host}' IDENTIFIED BY '${db.password}'; GRANT ALL ON `${db.instance}`.* TO '${db.username}'@'${db.host}'; abort mysql-ec2 root pgsql PostgreSQL 5432 bamboo-functest postgres jdbc:postgresql://${db.host}:${db.port}/postgres jdbc:postgresql://${db.host}:${db.port}/${db.instance} com.atlassian.bamboo.hibernate.postgresql.PostgreSQL10TextClobDialect org.postgresql postgresql ${postgresql.driver.version} org.postgresql.Driver db-postgresql.properties org.codehaus.mojo sql-maven-plugin ${db.admin.username} ${db.admin.password} ${dbms.url} ${jdbc.driver} drop-database clean execute true DROP DATABASE IF EXISTS "${db.instance}"; DROP ROLE IF EXISTS "${db.username}"; continue create-database clean execute true UPDATE pg_database SET datistemplate = FALSE WHERE datname = 'template1'; DROP DATABASE template1; CREATE DATABASE template1 WITH template = template0 encoding = 'UTF8'; CREATE ROLE "${db.username}" NOSUPERUSER NOCREATEDB NOCREATEROLE LOGIN ENCRYPTED PASSWORD '${db.password}'; CREATE DATABASE "${db.instance}" WITH OWNER "${db.username}" ENCODING 'UTF8'; abort pgsql-ec2 postgres oracle Oracle 1521 XE oracle oracle jdbc:oracle:thin:@${db.host}:${db.port}:${db.instance} ${jdbc.databaseUrl} org.hibernate.dialect.Oracle12cDialect com.oracle ojdbc8-atlassian-hosted ${oracle.driver.version} oracle.jdbc.OracleDriver db-oracle12c.properties org.codehaus.mojo sql-maven-plugin ${db.admin.username} ${db.admin.password} ${dbms.url} ${jdbc.driver} drop-database clean execute true DROP USER ${db.username} CASCADE; continue create-database clean execute true CREATE USER ${db.username} identified by ${db.password}; GRANT ALL PRIVILEGES TO ${db.username} WITH ADMIN OPTION; GRANT SELECT ANY DICTIONARY TO ${db.username}; abort mssql 1433 ${mssql.db.instance} sa sa Ighu0jie ${mssql.db.host} jdbc:sqlserver://${db.host}:${db.port} jdbc:sqlserver://${db.host}:${db.port};databaseName=${db.instance} com.microsoft.sqlserver mssql-jdbc ${sqlServer.driver.version} com.microsoft.sqlserver.jdbc.SQLServerDriver db-mssql.properties SELECT @@version; CREATE DATABASE "${db.instance}" CONTAINMENT = PARTIAL COLLATE Latin1_General_CS_AS; CREATE USER ${db.username} WITH PASSWORD = '${db.password}'; org.codehaus.mojo sql-maven-plugin ${db.admin.username} ${db.admin.password} ${dbms.url} ${jdbc.driver} true drop-database clean execute DROP DATABASE "${db.instance}"; ${sqlDropUser} continue create-database clean execute ${sqlCreateDb} abort post-create-database clean execute ALTER DATABASE "${db.instance}" SET READ_COMMITTED_SNAPSHOT ON WITH ROLLBACK IMMEDIATE; USE "${db.instance}"; ${sqlCreateUser} EXEC sp_addrolemember 'db_owner', '${db.username}';' abort