IRubricator.Truncate

Fore Syntax

Truncate;

Fore.NET Syntax

Truncate();

Description

The Truncate method clears the time series database.

Comments

On executing the method:

Tables with data of the time series database are cleared.
Sequences of tables are reset. If the time series database has its own sequence, it is reset; and if it does not have its own, it is not reset.
Indexes in tables are rebuilt.

Fore Example

Executing the example requires that the repository contains a time series database with the OBJ153 identifier. Add links to the Metabase, Cubes system assemblies.

Sub UserProc;
    Var
        mb: IMetabase;
        rub: IRubricator;
    Begin
        mb := MetabaseClass.Active;
        rub := mb.ItemById("OBJ153").Bind As IRubricator;
        rub.Truncate;
End Sub UserProc;

After execution the time series database with OBJ153 identifier will be cleared.

Fore.NET Example

Executing the example requires that the repository contains a time series database with the OBJ153 identifier. Add a link to the Cubes system assembly.

Imports Prognoz.Platform.Interop.Cubes;

...

Public Shared Sub Main(Params: StartParams);
     Var
        mb: IMetabase;
        rub: IRubricator;
    Begin
        mb := Params.Metabase;
        rub := mb.ItemById["OBJ29153"].Bind() As IRubricator;
        rub.Truncate();
End Sub;

The result of the example execution matches with that in the Fore example.