Open alex-vo opened 2 years ago
rmdir .\.db\
.\gradlew clean :lhmxg-msp-billing-migration-tools:shadowJar
java -D"db.url=jdbc:h2:file:./.db/data/dev" -D"db.username=sa" -jar .\lhmxg-msp-billing-migration-tools\build\libs\lhmxg-msp-billing-migration-tools-${PROJECT_VERSION}.jar
@SqlGroup(
Sql(scripts = ["classpath:testData.sql"], executionPhase = Sql.ExecutionPhase.BEFORE_TEST_METHOD),
Sql(scripts = ["classpath:dropAll.sql"], executionPhase = Sql.ExecutionPhase.AFTER_TEST_METHOD),
)
SELECT d.data.value('(/a/bla/bla1)[1]', 'varchar(max)'), *
from MSP_CASE_DETAILS d;
Network Protocols (at least TCP/IP to HTTP, TLS) Comparing SQL and NoSQL databases (advantages and trade-offs, areas of applicability) Distributed Tracing Requirements management Requirements types and their impact on architecture Requirements lifecycle Requirements management tools
ftp://waws-prod-am2-351.ftp.azurewebsites.windows.net/site/wwwroot
ftps://waws-prod-am2-351.ftp.azurewebsites.windows.net/site/wwwroot
ftps://waws-prod-am2-351.ftp.azurewebsites.windows.net/site/wwwroot msp-datahub-dev\$msp-datahub-dev 9j8PD1YRc6XRwZEsgmD9tGeP3MlewcZHybENdrG1BbZoGWDGcTysfRmp86sX
datahubuser D4t4hubPa55word! ftp://waws-prod-am2-351.ftp.azurewebsites.windows.net/site/wwwroot msp-datahub-dev\datahubuser
buildscript {
dependencies {
classpath("com.github.spotbugs.snom:spotbugs-gradle-plugin:5.0.13")
}
}
plugins {
java
id("org.springframework.boot") version "3.0.1"
id("io.spring.dependency-management") version "1.1.0"
war
`maven-publish`
id("com.gorylenko.gradle-git-properties") version "2.4.1"
jacoco
id("com.github.spotbugs") version "5.0.13"
}
group = "com.swissre.msp.swirl"
version = "0.0.5-SNAPSHOT"
repositories {
maven("https://artifact.swissre.com/external")
}
dependencies {
implementation("org.springframework.boot:spring-boot-starter-web")
implementation("org.springframework.boot:spring-boot-starter-actuator")
implementation("org.springframework.boot:spring-boot-starter-data-jpa")
implementation("org.springframework.boot:spring-boot-starter-security")
implementation("org.springframework.boot:spring-boot-starter-validation")
implementation("org.liquibase:liquibase-core")
implementation("com.microsoft.sqlserver:mssql-jdbc")
implementation("net.sf.saxon:Saxon-HE:11.4")
compileOnly("org.projectlombok:lombok")
annotationProcessor("org.projectlombok:lombok")
implementation("org.apache.commons:commons-lang3")
testImplementation("com.h2database:h2")
testImplementation("org.springframework.boot:spring-boot-starter-test")
testImplementation("org.testcontainers:testcontainers:1.17.2")
testImplementation("org.testcontainers:mssqlserver:1.17.2")
testImplementation("com.fasterxml.jackson.datatype:jackson-datatype-jsr310")
}
sourceSets {
create("unitTest") {
compileClasspath += sourceSets.main.get().output + sourceSets.test.get().output
runtimeClasspath += sourceSets.main.get().output + sourceSets.test.get().output
}
create("integrationTest") {
compileClasspath += sourceSets.main.get().output + sourceSets.test.get().output + sourceSets.getByName("unitTest").output
runtimeClasspath += sourceSets.main.get().output + sourceSets.test.get().output + sourceSets.getByName("unitTest").output
}
create("microserviceTest") {
compileClasspath += sourceSets.main.get().output + sourceSets.test.get().output
runtimeClasspath += sourceSets.main.get().output + sourceSets.test.get().output
}
}
configurations["unitTestImplementation"].extendsFrom(configurations.testImplementation.get())
configurations["integrationTestImplementation"].extendsFrom(configurations.testImplementation.get())
configurations["microserviceTestImplementation"].extendsFrom(configurations.testImplementation.get())
java.sourceSets["unitTest"].apply {
java.srcDir("src/test/unitTest/java")
resources.srcDir("src/test/unitTest/resources")
}
java.sourceSets["integrationTest"].apply {
java.srcDir("src/test/integrationTest/java")
resources.srcDir("src/test/integrationTest/resources")
}
java.sourceSets["microserviceTest"].apply {
java.srcDir("src/test/microserviceTest/java")
resources.srcDir("src/test/microserviceTest/resources")
}
val unitTest = task<Test>("unitTest") {
group = "verification"
testClassesDirs = sourceSets["unitTest"].output.classesDirs
classpath = sourceSets["unitTest"].runtimeClasspath
}
val integrationTest = task<Test>("integrationTest") {
group = "verification"
testClassesDirs = sourceSets["integrationTest"].output.classesDirs
classpath = sourceSets["integrationTest"].runtimeClasspath
mustRunAfter(unitTest)
}
val microserviceTest = task<Test>("microserviceTest") {
doFirst {
systemProperty("http.proxyHost", "gate-zrh.swissre.com")
systemProperty("http.proxyPort", "8080")
systemProperty("https.proxyHost", "gate-zrh.swissre.com")
systemProperty("https.proxyPort", "8080")
systemProperty(
"http.nonProxyHosts",
"*.cloud.swissre.com|artifact.swissre.com|*.ac.swissre.com|*.ac-np.swissre.com|localhost"
)
}
group = "verification"
testClassesDirs = sourceSets["microserviceTest"].output.classesDirs
classpath = sourceSets["microserviceTest"].runtimeClasspath
mustRunAfter(integrationTest)
}
tasks.test {
dependsOn(unitTest, integrationTest, microserviceTest)
}
tasks.withType<Test> {
useJUnitPlatform()
}
tasks.getByName("war").enabled = false
tasks.test {
finalizedBy(tasks.jacocoTestReport, tasks.jacocoTestCoverageVerification)
}
val jacocoExcludeClasses = listOf(
"com/swissre/msp/swirl/domain/*",
"com/swissre/msp/swirl/config/DBTypeConversionConfig.class",
"com/swissre/msp/swirl/config/SecurityConfig.class"
)
tasks.jacocoTestReport {
dependsOn(unitTest)
additionalSourceDirs.setFrom(files(sourceSets.main.get().allSource.srcDirs))
sourceDirectories.setFrom(files(sourceSets.main.get().allSource.srcDirs))
classDirectories.setFrom(files(sourceSets.main.get().output))
executionData.setFrom(fileTree(project.projectDir) {
setIncludes(setOf("build/jacoco/*.exec"))
})
classDirectories.setFrom(sourceSets.main.get().output.asFileTree.matching {
jacocoExcludeClasses.forEach {
exclude(it)
}
})
reports {
xml.required.set(true)
html.required.set(true)
}
}
tasks.jacocoTestCoverageVerification {
executionData.setFrom(fileTree(project.projectDir) {
setIncludes(setOf("build/jacoco/*.exec"))
})
classDirectories.setFrom(sourceSets.main.get().output.asFileTree.matching {
jacocoExcludeClasses.forEach {
exclude(it)
}
})
violationRules {
rule {
limit {
counter = "LINE"
minimum = "0.9".toBigDecimal()
}
}
}
}
jacoco {
toolVersion = "0.8.8"
reportsDirectory.set(layout.buildDirectory.dir("jacocoReportDir"))
}
tasks.spotbugsMain {
excludeFilter.set(file("${rootProject.projectDir}/gradle/static-code-analysis/spotbugs/excludeFilter.xml"))
reports.create("sarif") {
required.set(true)
outputLocation.set(file("$buildDir/reports/spotbugs.sarif"))
}
reports.create("html") {
required.set(true)
outputLocation.set(file("$buildDir/reports/spotbugs.html"))
}
}
listOf(
"spotbugsTest", "spotbugsUnitTest", "spotbugsIntegrationTest", "spotbugsMicroserviceTest"
).forEach {
tasks.getByName(it) {
enabled = false
}
}
fun main() {
val client = HttpClient.newBuilder().build();
val request = HttpRequest.newBuilder()
.uri(URI.create("https://mxg-biz-dhtest.biz.magnumxg.azure-dev.sre/v1/submissions"))
.header("Authorization", "Basic MDB1MTB4djJ6b3VIQkRsVnMwaDg6YWJjMTIz")
.build();
val response = client.send(request, HttpResponse.BodyHandlers.ofString());
println(response.body())
}
class RepositoryTestInitializer implements ApplicationContextInitializer<ConfigurableApplicationContext> {
@Override
public void initialize(ConfigurableApplicationContext applicationContext) {
System.setProperty("http.proxyHost", "gate-zrh.swissre.com");
System.setProperty("http.proxyPort", "8080");
System.setProperty("https.proxyHost", "gate-zrh.swissre.com");
System.setProperty("https.proxyPort", "8080");
System.setProperty(
"http.nonProxyHosts",
"*.cloud.swissre.com|artifact.swissre.com|*.ac.swissre.com|*.ac-np.swissre.com|localhost"
);
MSSQLServerContainer<?> dbContainer = new MSSQLServerContainer<>(
DockerImageName.parse("mxgjaguaracr.azurecr.io/mssql-server")
.asCompatibleSubstituteFor("mcr.microsoft.com/mssql/server:2022-latest")
);
dbContainer.acceptLicense();
dbContainer.withInitScript("db/init.sql");
dbContainer.waitingFor(Wait.forListeningPort().withStartupTimeout(Duration.ofSeconds(20)));
dbContainer.addExposedPort(1433);
dbContainer.start();
TestPropertyValues.of(
"spring.datasource.url=" + dbContainer.getJdbcUrl() + ";databaseName=mspswirl;SelectMethod=cursor",
"spring.datasource.username=" + dbContainer.getUsername(),
"spring.datasource.password=" + dbContainer.getPassword()
).applyTo(applicationContext.getEnvironment());
}
}
@DataJpaTest
@ContextConfiguration(initializers = {RepositoryTestInitializer.class})
@AutoConfigureTestDatabase(replace = AutoConfigureTestDatabase.Replace.NONE)
@SqlGroup({
@Sql(scripts = "classpath:db/initIntegrationTestData.sql", executionPhase = Sql.ExecutionPhase.BEFORE_TEST_METHOD),
@Sql(scripts = "classpath:db/clearIntegrationTestData.sql", executionPhase = Sql.ExecutionPhase.AFTER_TEST_METHOD),
})
@Import(IRIXTargetTableRepository.class)
public class BaseRepositoryTest {
}
@SpringBootTest
@AutoConfigureMockMvc
@ActiveProfiles("test")
@ContextConfiguration(initializers = [MicroserviceTestInitializer::class])
[ERROR] Failed to execute goal com.samaxes.maven:minify-maven-plugin:1.7.6:minify (default-minify) on project dflow-web: Execution default-minify of goal com.samaxes.maven:minify-maven-plugin:1.7.6:minify failed: A required class was missing while executing com.samaxes.maven:minify-maven-plugin:1.7.6:minify: org/codehaus/plexus/util/DirectoryScanner
public class MainClass { public static final int FIVE_SECONDS = 120_000;
public static void main(String... args) throws Exception {
Robot robot = new Robot();
while (true) {
robot.mouseMove(200, 200);
Thread.sleep(FIVE_SECONDS);
robot.mouseMove(200, 400);
Thread.sleep(FIVE_SECONDS);
}
}
}
dev-devland05.corp.docupace.com
java.lang.IllegalArgumentException: Could not resolve placeholder 'integration.envestnet.proposal.documentTypesToDownload' in value "${integration.envestnet.proposal.documentTypesToDownload}"
test-tmh4fe1lq9ed@example.com
Could not find agent library instrument on the library path, with error: The specified procedure could not be found
Error occurred during initialization of VM Could not find agent library instrument on the library path, with error: The specified procedure could not be found Module java.instrument may be missing from runtime image.
sfdx source deploy -p force-app/main/default/lwc/docupaceWorkItemList/
@startuml
participant User
participant Portal
participant "SMS/Authy"
User -> Portal: Create Configured Token (with cert)
activate Portal
Portal -> "SMS/Authy": Trigger Confirmation
activate "SMS/Authy"
"SMS/Authy" --> Portal: ok
deactivate "SMS/Authy"
Portal --> User: ok
deactivate Portal
"SMS/Authy" -> User: Confirmation Code
User -> Portal: Confirm SMS/Authy
activate Portal
Portal -> Portal: Activate cert
Portal --> User: ok
deactivate Portal
@enduml
@startuml
participant CRM
participant API
CRM -> API: Initiate Request
activate API
API --> CRM: ok
deactivate API
CRM -> API: Signed Confirmation Request
activate API
API -> API: Find User cert
API -> API: Verify signature
API -> API: Find initiated request
API -> API: Process request
API --> CRM: ok
deactivate API
@enduml