Codeunit/FormEvent/InstanceCreator

What is it

The instance creator lets you build new TS application instances from a template, that is a MYSQL dump of an existing database.

So you will need

• Template for the context file
• Shared TempusServa.war file
• MySQL dump files
  • tsbase
  • tslive
  • tstest

context template

The context template path must be configured in InstanceCreator.contextTemplateFile

 <?xml version="1.0" encoding="UTF-8"?>
 <Context docBase="@DOCBASE@" swallowOutput="true">
 <Resource name="jdbc/TempusServaLive" auth="Container" type="javax.sql.DataSource"
               maxActive="80" maxIdle="30" maxWait="2000"
               removeAbandoned="true" removeAbandonedTimeout="60" logAbandoned="true"
               username="@USERNAME@" password="@PASSWORD@" driverClassName="com.mysql.jdbc.Driver"
               url="jdbc:mysql://localhost:3306/@DBLIVE@?autoReconnect=true"
 />
 <Resource name="jdbc/TempusServaTest" auth="Container" type="javax.sql.DataSource"
               maxActive="5" maxIdle="3" maxWait="10000"
               logAbandoned="true"
               username="@USERNAME@" password="@PASSWORD@" driverClassName="com.mysql.jdbc.Driver"
               url="jdbc:mysql://localhost:3306/@DBTEST@?autoReconnect=true"
 />
 </Context>

The following tags are required

• @DBLIVE@
• @DBTEST@

The following tags are recommended

• @USERNAME@
• @PASSWORD@

The following tags are optional

• @DOCBASE@
• @APPLICATION@

Database template

From the baseline system build dump copies of the databases.

You will need to use strict naming of the files:

• base.sql
• live.sql
• test.sql

We recommend dumping the files using mysqldump

  mysqldump --skip-add-locks -uroot -pPASSWORD demobase > /mnt/sda/template/base.sql
  mysqldump --skip-add-locks -uroot -pPASSWORD demolive > /mnt/sda/template/live.sql
  mysqldump --skip-add-locks -uroot -pPASSWORD demotest > /mnt/sda/template/test.sql

After dumping the files you can clean out unwanted dato in an editor

Configuration

In the form attatch the following codeunit

  dk.tempusserva.solution.creator.InstanceCreator

Now setup

• locations of the templates
  • InstanceCreator.sqlTemplateFolder: Folder of base.sql live.sql and test.sql
  • InstanceCreator.contextTemplateFile: Position of the context template
• mapped field names
  • InstanceCreator.fieldSolutionName
  • InstanceCreator.fieldAdminName
  • InstanceCreator.fieldAdminEmail
  • InstanceCreator.fieldAdminPassword
• status references
  • InstanceCreator.StatusCreateNow
  • InstanceCreator.StatusCompleted: Must be accessible from StatusCreateNow
  • InstanceCreator.StatusFailSetup: Must be accessible from StatusCreateNow

Usage

Using the attuned form will create a new instance.

The requirement is that the intance information is there AND status is in create (as defined per StatusCreateNow)

• instance name
• admin name
• admin email

After an instance is created and status will now be either

• succes (as defined per StatusCompleted)
• error (as defined per StatusFailSetup)

If the operation succeds you instance will be available in a minute or two.