SQL Server Database

SQL Server Database Starter and Migration

Module Dependency

Add module dependency to your pom file.

<dependency>
    <groupId>org.archmix</groupId>
    <artifactId>legolas-sqlserver</artifactId>
    <version>${legolasVersion}</version>
</dependency>

Starter

This module provides an SQL Server Starter as a managed container. The behavior may vary depends on the Runtime Environment you set.

Runtime Environment	Starter Behavior
LOCAL	A managed docker container will be created. The same container will be used for every execution, unless you destroy container by command line.
TEST	A managed docker container will be created and destroyed since test finishs.
SERVER	None container will be created or used.

Database Properties

Property	Value
Host	localhost
Port	1433
User	$(whoami)
Password	$qlS3rver
Database	$(whoami) lower case

User and Database properties

If your O.S. user name "$(whoami)" has any character out from A-Z a-z 0-9, so those chars will be replaced by underline (_) char. For instance, if the user name is "user.name" so the resulting value will be "user_name"

Running Instance Configuration

In order to get all the configurations through the code, you should do:

import legolas.sqlserver.interfaces.SQLServerServiceId;
import legolas.sqlserver.interfaces.SQLServerEntry;
import legolas.config.api.interfaces.Configuration;

RunningEnvironment environment = ...;
Optional<RunningInstance> foundInstance = environment.get(SQLServerServiceId.INSTANCE);
foundInstance.ifPresent(instance ->{
    Configuration configuration = instance.configuration();
    configuration.getString(SQLServerEntry.URL); //jdbc url
    configuration.getString(SQLServerEntry.HOST); //docker host
    configuration.getString(SQLServerEntry.PORT); //docker exposed port
    configuration.getString(SQLServerEntry.DATABASE); //docker exposed port   
    configuration.getString(SQLServerEntry.DRIVER); //jdbc driver class name        
    configuration.getString(SQLServerEntry.USERNAME); //database username        
    configuration.getString(SQLServerEntry.PASSWORD); //database password
    //TODO: do your stuff
});

Migration

Migration will be running on every Runtime Environment unless you put no files in the target folder. The target folder is src/main/resources/services/sqlserver/migration. The file name should obey the following standard: V999_Description_of_what_this_file_do.sql. All the statements should be ended with ;

Example

Imagine you want to create a table called table_name with id and name columns. In order to do this you should create a file with the following path and name:

src/main/resources/services/sqlserver/migration/V001_Create_Table_Name.sql

CREATE TABLE table_name (
    id INTEGER NOT NULL,
    name VARCHAR(100) NOT NULL
);

INSERT INTO table_name(id, name) VALUES (1, 'Some name');