Tests.kt 9.33 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
        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"),
Jonas Waeber's avatar
Jonas Waeber committed
52 53
            Pair("/memobase/test_record_set_5", "20190906_Brandt_Metadaten.xlsx"),
            Pair("/memobase/test_record_set_6", "Export_Bilder_der_Arbeit_8.csv")
Jonas Waeber's avatar
Jonas Waeber committed
54
        )
Jonas Waeber's avatar
Jonas Waeber committed
55 56 57 58

        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
59 60 61 62 63 64 65 66 67 68 69 70 71
    }

    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
72
        consumer.subscribe(listOf("sftp-reader-p1-j1", "sftp-reader-p1-j1-reporting", "p1-reporting"))
Jonas Waeber's avatar
Jonas Waeber committed
73 74 75 76
    }

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

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

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

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

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

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

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

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