1 package de.dlr.shepard.data.spatialdata.repositories;
2
3 import static org.junit.jupiter.api.Assertions.assertEquals;
4
5 import org.junit.jupiter.api.Test;
6
7 public class NativeInsertStatementBuilderTest {
8
9 @Test
10 public void build_addOneLineOfValues_success() {
11 NativeInsertStatementBuilder builder = new NativeInsertStatementBuilder();
12 builder.insert("table_name", new String[] { "column1", "column2" }).addValues("value1, value2");
13 String result = builder.build();
14 assertEquals("INSERT INTO table_name (column1, column2) VALUES (value1, value2);", result);
15 }
16
17 @Test
18 public void build_multipleValuesAdded_success() {
19 NativeInsertStatementBuilder builder = new NativeInsertStatementBuilder();
20 builder
21 .insert("table_name", new String[] { "column1", "column2" })
22 .addValues("value1, value2")
23 .addValues("value3, value4");
24 String result = builder.build();
25 assertEquals("INSERT INTO table_name (column1, column2) VALUES (value1, value2),(value3, value4);", result);
26 }
27 }