Viz Mosart Administrator Guide

Version 3.9 | Published November 04, 2019 ©

Database Maintenance

Normally all changes to the Viz Mosart Template Database after initialization is done via AvAutomation and the Template Editor.

This includes the following operations:

  • Upgrading the database

  • Adding and removing galleries

  • Adding and removing template sets

  • Adding, removing and editing templates

Upgrading the Database:

Upgrading the database. AvAutomation will automatically upgrade the database when necessary. All upgrades and current database version is stored in the db_database table. Note that automatic upgrades shall never delete or modify any content in the database. I.e. the database should be kept backward compatible at all times. Upgrades normally adds new functionality to the database.

The following table summerizes the upgrade history of the Viz Mosart Template Database:

Version

Date

Version

Description

0.1.0

01.06.2012

3.2

Initial version

1.0.0

01.12.2012

3.2

First version of automatic upgrade. New table: db_database

1.0.1

01.10.2013

3.2

Added support for sequences. New table: sq_sequence

1.0.2

07.05.2013

3.3

Added templateset properties. New table: tsp_templatesetproperties

1.0.3

27.06.2013

3.3

Verified default transitions: Added initial content to the tr_transition table

1.0.4

05.09.2013

3.5

Added order field in tdfi_connection table. New column: tdfi_order

1.0.5

26.08.2014

3.5

Added scope to ta_templatetypealias table. New column: ta_scope

1.1.0

17.01.2016

4.0

Added support for hierarchical template sets. New columns in ts_templateset table: ts_basedon, ts_hidefromuser

Using Viz Mosart Template Editor

The Viz Mosart Template Editor is normally used to add, delete and modify the Mosart templates. When attached to a Mosart Template database every save operation will push the changes incrementally to the database.

Use the template editor for the following changes:

  • Adding and removing template sets. Note when adding a new template set it is possible to choose whether the template set shall be shared or gallery specific (local). It is not possible to change this afterwards.

  • Adding, removing and editing templates. This is the normal use case of the template editor.

Using TemplateSetEditor (Part of the Mosart Test Suite)

The TemplateSetEditor is a console application that is part of the Mosart Test Suite. This application may be useful for simple maintenance and is currently the only way to remove galleries from the database. The TemplateSetEditor was made as part of adding hierarchical templates to the database.

The TemplateSetEditor is a beta product, used at own risk, and is only estimated to be supported from Mosart 4.0.