Tests.kt 8.42 KB
Newer Older
Jonas Waeber's avatar
Jonas Waeber committed
1
/*
Jonas Waeber's avatar
Jonas Waeber committed
2
 * sftp-reader
Jonas Waeber's avatar
Jonas Waeber committed
3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
 * Copyright (C) 2019  Memobase
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU Affero General Public License for more details.
 *
 * You should have received a copy of the GNU Affero General Public License
 * along with this program.  If not, see <https://www.gnu.org/licenses/>.
 */
18
package org.memobase
Jonas Waeber's avatar
Jonas Waeber committed
19

Jonas Waeber's avatar
Jonas Waeber committed
20 21
import com.beust.klaxon.Klaxon
import java.io.FileInputStream
Jonas Waeber's avatar
Jonas Waeber committed
22
import java.nio.file.Paths
Jonas Waeber's avatar
Jonas Waeber committed
23 24 25 26
import java.time.Duration
import java.util.Properties
import java.util.stream.Stream
import org.apache.kafka.clients.consumer.ConsumerConfig
Jonas Waeber's avatar
Jonas Waeber committed
27
import org.apache.kafka.clients.consumer.ConsumerRecord
Jonas Waeber's avatar
Jonas Waeber committed
28 29
import org.apache.kafka.clients.consumer.KafkaConsumer
import org.apache.kafka.common.serialization.StringDeserializer
Jonas Waeber's avatar
Jonas Waeber committed
30
import org.apache.logging.log4j.LogManager
Jonas Waeber's avatar
Jonas Waeber committed
31
import org.assertj.core.api.Assertions.assertThat
Jonas Waeber's avatar
Jonas Waeber committed
32
import org.junit.jupiter.api.TestInstance
33
import org.junit.jupiter.api.extension.ExtendWith
Jonas Waeber's avatar
Jonas Waeber committed
34 35
import org.junit.jupiter.params.ParameterizedTest
import org.junit.jupiter.params.provider.MethodSource
Jonas Waeber's avatar
Jonas Waeber committed
36 37
import org.memobase.testing.EmbeddedKafkaExtension
import org.memobase.testing.EmbeddedSftpServer
Jonas Waeber's avatar
Jonas Waeber committed
38

Jonas Waeber's avatar
Jonas Waeber committed
39
@ExtendWith(EmbeddedKafkaExtension::class)
Jonas Waeber's avatar
Jonas Waeber committed
40
@TestInstance(TestInstance.Lifecycle.PER_CLASS)
Jonas Waeber's avatar
Jonas Waeber committed
41
class Tests {
Jonas Waeber's avatar
Jonas Waeber committed
42
    private val log = LogManager.getLogger("LocalTestsLogger")
Jonas Waeber's avatar
Jonas Waeber committed
43

Jonas Waeber's avatar
Jonas Waeber committed
44 45 46
    private val sftpServer = EmbeddedSftpServer(22000, "user", "password")

    init {
Jonas Waeber's avatar
Jonas Waeber committed
47 48 49 50 51 52
        val files = listOf(
            Pair("/memobase/test_record_set_1", "brandt.csv"),
            Pair("/memobase/test_record_set_2", "bauGAZH_metadaten.csv"),
            Pair("/memobase/test_record_set_3", "invalid.csv"),
            Pair("/memobase/test_record_set_4", "file.txt"),
            Pair("/memobase/test_record_set_5", "20190906_Brandt_Metadaten.xlsx")
Jonas Waeber's avatar
Jonas Waeber committed
53
        )
Jonas Waeber's avatar
Jonas Waeber committed
54 55 56 57

        for (pair in files) {
            sftpServer.putFile(Paths.get(pair.first, pair.second).toString(), FileInputStream(Paths.get("src/test/resources/data", pair.second).toFile()))
        }
Jonas Waeber's avatar
Jonas Waeber committed
58 59 60 61 62 63 64 65 66 67 68 69 70
    }

    private val consumer: KafkaConsumer<String, String>

    init {
        val props = Properties()
        props.setProperty(ConsumerConfig.BOOTSTRAP_SERVERS_CONFIG, "localhost:12345")
        props.setProperty(ConsumerConfig.CLIENT_ID_CONFIG, "test-group-1")
        props.setProperty(ConsumerConfig.GROUP_ID_CONFIG, "test-group-1")
        props.setProperty(ConsumerConfig.KEY_DESERIALIZER_CLASS_CONFIG, StringDeserializer::class.qualifiedName)
        props.setProperty(ConsumerConfig.VALUE_DESERIALIZER_CLASS_CONFIG, StringDeserializer::class.qualifiedName)
        props.setProperty(ConsumerConfig.AUTO_OFFSET_RESET_CONFIG, "earliest")
        consumer = KafkaConsumer(props)
Jonas Waeber's avatar
Jonas Waeber committed
71
        consumer.subscribe(listOf("sftp-reader-p1-j1", "sftp-reader-p1-j1-reporting", "p1-reporting"))
Jonas Waeber's avatar
Jonas Waeber committed
72 73 74 75
    }

    @ParameterizedTest
    @MethodSource("directoryReaderTests")
Jonas Waeber's avatar
Jonas Waeber committed
76
    fun `read files from sftp`(params: TestParams) {
77 78
        val service = Service(params.configFile)
        service.run()
Jonas Waeber's avatar
Jonas Waeber committed
79

80 81 82
        val topic = service.settings.outputTopic
        val reportingTopic = service.settings.outputTopic + "-reporting"
        val processReportingTopic = service.settings.processReportTopic
Jonas Waeber's avatar
Jonas Waeber committed
83

Jonas Waeber's avatar
Jonas Waeber committed
84 85
        val totalConsumerRecords = mutableListOf<ConsumerRecord<String, String>>()

Jonas Waeber's avatar
Jonas Waeber committed
86
        var result = consumer.poll(Duration.ofMillis(10))
Jonas Waeber's avatar
Jonas Waeber committed
87 88 89 90 91
        while (totalConsumerRecords.size != 3) {
            if (result.count() > 0) {
                totalConsumerRecords.addAll(result.asIterable())
            }
            log.error(result.count())
Jonas Waeber's avatar
Jonas Waeber committed
92 93 94
            result = consumer.poll(Duration.ofMillis(10))
        }

Jonas Waeber's avatar
Jonas Waeber committed
95
        assertThat(totalConsumerRecords.find { value -> value.topic() == topic })
96 97 98
            .describedAs("Message Test")
            .hasFieldOrPropertyWithValue("key", params.expectedKey)
            .hasFieldOrPropertyWithValue("value", params.expectedValue)
Jonas Waeber's avatar
Jonas Waeber committed
99

Jonas Waeber's avatar
Jonas Waeber committed
100
        assertThat(totalConsumerRecords.find { value -> value.topic() == reportingTopic })
101 102 103
            .describedAs("Report Test")
            .hasFieldOrPropertyWithValue("key", params.expectedKey)
            .hasFieldOrPropertyWithValue("value", params.expectedReportValue)
Jonas Waeber's avatar
Jonas Waeber committed
104

Jonas Waeber's avatar
Jonas Waeber committed
105
        assertThat(totalConsumerRecords.find { value -> value.topic() == processReportingTopic })
106 107 108
            .describedAs("Process Report Test")
            .hasFieldOrPropertyWithValue("key", params.expectedProcessReport.id)
            .hasFieldOrPropertyWithValue("value", Klaxon().toJsonString(params.expectedProcessReport))
Jonas Waeber's avatar
Jonas Waeber committed
109
    }
Jonas Waeber's avatar
Jonas Waeber committed
110 111

    private fun directoryReaderTests() = Stream.of(
112 113 114
        TestParams(
            "test1.yml",
            expectedKey = "brandt.csv",
Jonas Waeber's avatar
Jonas Waeber committed
115
            expectedValue = "{\"format\" : \"CSV\", \"path\" : \"/memobase/test_record_set_1/brandt.csv\"}",
116 117 118 119
            expectedReportValue = Klaxon().toJsonString(
                Report(
                    id = "brandt.csv",
                    status = "SUCCESS",
Jonas Waeber's avatar
Jonas Waeber committed
120
                    message = "Validated file at path /memobase/test_record_set_1/brandt.csv with format CSV."
121
                )
Jonas Waeber's avatar
Jonas Waeber committed
122
            ),
123
            expectedProcessReport = Report(
Jonas Waeber's avatar
Jonas Waeber committed
124
                id = "text-file-validation",
125 126 127 128 129 130 131
                status = "SUCCESS",
                message = "Successfully validated 1 files."
            )
        ),
        TestParams(
            "test2.yml",
            expectedKey = "bauGAZH_metadaten.csv",
Jonas Waeber's avatar
Jonas Waeber committed
132
            expectedValue = "{\"format\" : \"CSV\", \"path\" : \"/memobase/test_record_set_2/bauGAZH_metadaten.csv\"}",
133 134 135 136
            expectedReportValue = Klaxon().toJsonString(
                Report(
                    id = "bauGAZH_metadaten.csv",
                    status = "SUCCESS",
Jonas Waeber's avatar
Jonas Waeber committed
137
                    message = "Validated file at path /memobase/test_record_set_2/bauGAZH_metadaten.csv with format CSV."
138 139
                )
            ),
140
            expectedProcessReport = Report(
Jonas Waeber's avatar
Jonas Waeber committed
141
                id = "text-file-validation",
142 143 144 145 146 147 148
                status = "SUCCESS",
                message = "Successfully validated 1 files."
            )
        ),
        TestParams(
            "test3.yml",
            expectedKey = "invalid.csv",
Jonas Waeber's avatar
Jonas Waeber committed
149
            expectedValue = "{\"format\" : \"ERROR\", \"path\" : \"/memobase/test_record_set_3/invalid.csv\"}",
150 151 152
            expectedReportValue = Klaxon().toJsonString(
                Report(
                    id = "invalid.csv",
153
                    status = "FAILURE",
Jonas Waeber's avatar
Jonas Waeber committed
154
                    message = "CSV ERROR: Fields num seems to be 4 on each row, but on 2th csv row, fields num is 6. for file /memobase/test_record_set_3/invalid.csv."
155 156
                )
            ),
157
            expectedProcessReport = Report(
Jonas Waeber's avatar
Jonas Waeber committed
158
                id = "text-file-validation",
159 160 161 162 163 164 165
                status = "FAILURE",
                message = "Failed to validate 1 of 1 files."
            )
        ),
        TestParams(
            "test4.yml",
            expectedKey = "file.txt",
Jonas Waeber's avatar
Jonas Waeber committed
166
            expectedValue = "{\"format\" : \"ERROR\", \"path\" : \"/memobase/test_record_set_4/file.txt\"}",
167 168 169
            expectedReportValue = Klaxon().toJsonString(
                Report(
                    id = "file.txt",
170
                    status = "FAILURE",
171
                    message = "File Extension Error: Not a valid file extension: file.txt."
172
                )
173 174
            ),
            expectedProcessReport = Report(
Jonas Waeber's avatar
Jonas Waeber committed
175
                id = "text-file-validation",
176 177
                status = "FAILURE",
                message = "Failed to validate 1 of 1 files."
Jonas Waeber's avatar
Jonas Waeber committed
178
            )
179 180 181
        ),
        TestParams(
            "test5.yml",
Jonas Waeber's avatar
Jonas Waeber committed
182 183
            expectedKey = "20190906_Brandt_Metadaten.xlsx",
            expectedValue = "{\"format\" : \"XLSX\", \"path\" : \"/memobase/test_record_set_5/20190906_Brandt_Metadaten.xlsx\"}",
184 185
            expectedReportValue = Klaxon().toJsonString(
                Report(
Jonas Waeber's avatar
Jonas Waeber committed
186
                    id = "20190906_Brandt_Metadaten.xlsx",
187
                    status = "SUCCESS",
Jonas Waeber's avatar
Jonas Waeber committed
188
                    message = "Validated file at path /memobase/test_record_set_5/20190906_Brandt_Metadaten.xlsx with format XLSX."
189 190 191
                )
            ),
            expectedProcessReport = Report(
Jonas Waeber's avatar
Jonas Waeber committed
192
                id = "text-file-validation",
193 194 195 196
                status = "SUCCESS",
                message = "Successfully validated 1 files."
            )
        )
Jonas Waeber's avatar
Jonas Waeber committed
197
    )
Jonas Waeber's avatar
Jonas Waeber committed
198
}