For more information about the Flyway tool, see this blog post:
http://javing.blogspot.com/2019/01/database-migrations-using-flyway.html

public class NoSqlAddressInsertAdapter implements CreateService {
private final MongoClient mongoClient;
@Inject
public NoSqlAddressInsertAdapter(MongoClient mongoClient) {
this.mongoClient = mongoClient;
}
@Override
public void create(Address address) {
DBCollection collection = mongoClient.getDB("radadata").getCollection("address");
collection.insert(toNoSqlAddress(address));
}
private AddressNoSql toNoSqlAddress(Address address) {
AddressNoSql addressNoSql = new AddressNoSql();
addressNoSql.append("firstline", address.getFirstLine());
addressNoSql.append("secondline", address.getSecondLine());
addressNoSql.append("postcode", address.getPostcode());
addressNoSql.append("persons", address.getPersons().stream().map(toNoSqlPersons()).collect(toList()));
return addressNoSql;
}
private Function<Person, PersonNoSql> toNoSqlPersons() {
return person -> {
PersonNoSql personNoSql = new PersonNoSql();
personNoSql.append("firstname", person.getFirstName());
personNoSql.append("secondname", person.getSecondName());
return personNoSql;
};
}
}
public class SqlAddressInsertAdapter implements CreateService {
@Inject
public SqlAddressInsertAdapter() {
}
private static SessionFactory getSessionFactory() {
return HibernateUtil.getSessionFactory();
}
private Session session;
@Override
public void create(Address address) {
session = SqlAddressInsertAdapter.getSessionFactory().getCurrentSession();
session.beginTransaction();
Set<ORMPerson> ormPersons = address.getPersons().stream().map(toOrmPersons()).collect(toSet());
ORMAddress ormAddress = new ORMAddress();
ormAddress.setFirstLine(address.getFirstLine());
ormAddress.setSecondLine(address.getSecondLine());
ormAddress.setPostcode(address.getPostcode());
ormAddress.setOrmPersons(ormPersons);
session.save(ormAddress);
session.getTransaction().commit();
}
@Override
public void create(Person person) {
//
}
private Function<Person, ORMPerson> toOrmPersons() {
return person -> new ORMPerson(person.getFirstName(),person.getSecondName());
}
}
@Service
@Path("insertperson")
public class InsertAddressResource {
private final services.nosqlcrud.CreateService noSqlcreateService;
private final services.sqlcrud.CreateService sqlCreateService;
@Inject
public InsertAddressResource(services.nosqlcrud.CreateService noSqlcreateService,
services.sqlcrud.CreateService sqlCreateService) {
this.noSqlcreateService = noSqlcreateService;
this.sqlCreateService = sqlCreateService;
}
@POST
@Consumes({"application/json"})
public void insert(Address address) {
noSqlcreateService.create(address);
sqlCreateService.create(address);
}
/*
A Sample Json to POST:
URL: http://localhost:9998/insertperson
Content Type: application/json
{
"firstline": "street bla bla",
"secondline": "town of bla bla",
"postcode": "ble ble ble",
"persons": [
{"firstname":"Armin","secondname":"Josef"},
{"firstname":"Johan","secondname":"Uhgler"}
]
}
*/
}
@Test
public void whenAddingANewUserTheUserIsSavedToTheDatabase() {
//Tell hibernate to add this user to the database
ormAdapter.add(userFactory("djordje", "123"));
//Find the user and check its values
User savedValueInDatabase = adapter.find("djordje");
assertThat(savedValueInDatabase.getName(),is("djordje"));
assertThat(savedValueInDatabase.getPassword(),is("123"));
//Delete the test data
ormAdapter.delete(savedValueInDatabase.getName());
}
@Test
public void loginTest() {
PersonManagementAdapterORM adapterORM = mock(PersonManagementAdapterORM.class);
when(adapterORM.find("djordje","123")).thenReturn(new Person("djordje","123"));
LoginService service = new LoginServiceImpl(adapterORM);
boolean authorized = service.login("djordje","123");
verify(adapterORM).find("djordje","123");
assertThat(authorized,is(true));
}
Explanation:
1: import java.sql.Connection; 2: import java.sql.DriverManager; 3: import java.sql.ResultSet; 4: import java.sql.SQLException; 5: import java.sql.Statement; 6: public class DB { 7: public void dbConnect() { 8: Connection con = null; 9: Statement stmt = null; 10: ResultSet rs = null; 11: String connectionURL = "jdbc:sqlserver://127.0.0.1;databaseName=forJDBC;user=george;password=george;"; 12: try { 13: Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); 14: con = DriverManager.getConnection(connectionURL); 15: System.out.println("Connected!"); 16: String SQL = "SELECT * FROM Samples"; 17: stmt = con.createStatement(); 18: rs = stmt.executeQuery(SQL); 19: while (rs.next()) { 20: System.out.println(); 21: System.out.println(rs.getString(1) + "-" + rs.getString(2)); 22: } 23: } catch (SQLException e) { 24: e.printStackTrace(); 25: } catch (ClassNotFoundException e) { 26: e.printStackTrace(); 27: } finally { 28: if (rs != null) { 29: try { 30: rs.close(); 31: } catch (Exception e2) { 32: e2.printStackTrace(); 33: } 34: if (stmt != null) { 35: try { 36: rs.close(); 37: } catch (Exception e2) { 38: e2.printStackTrace(); 39: } 40: } 41: if (con != null) { 42: try { 43: rs.close(); 44: } catch (Exception e2) { 45: e2.printStackTrace(); 46: } 47: } 48: } 49: } 50: } 51: }

1: String connectionURL = "jdbc:sqlserver://127.0.0.1;databaseName=forJDBC;user=djoleP;password=djoleP;";
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
con = DriverManager.getConnection(connectionURL);
System.out.println("Connected!");
1: String SQL = "SELECT * FROM Samples";
2: stmt = con.createStatement();
3: rs = stmt.executeQuery(SQL);
1: while (rs.next()) {
2: System.out.println();
3: System.out.println(rs.getString(1) + "-" + rs.getString(2));
4: }
1: finally {
2: if (rs != null) {
3: try {
4: rs.close();
5: } catch (Exception e2) {
6: e2.printStackTrace();
7: }
8: if (stmt != null) {
9: try {
10: rs.close();
11: } catch (Exception e2) {
12: e2.printStackTrace();
13: }
14: }
15: if (con != null) {
16: try {
17: rs.close();
18: } catch (Exception e2) {
19: e2.printStackTrace();
20: }
21: }
22: }