Manuais
PHC GO Funções SDK - Database
 

Database

This class contains functions that allow you to get information about the database.
 
 

GetSize

 

Description

Gets information about the occupied space in database
 

Return Function

A single value that indicates the size occupied by all existing tables in the database.
 

Parameters


value Description Type
refresh A boolean value that indicates if the function will recalculate the occupied space in database.

This parameter is optional and the default value is false.

A false value indicates that the function will return the last calculated value (usage of cache).
Boolean
 

Example


Dim infoDBRecords as Decimal = SDK.Database.GetSize() 

 

GetDetailSize

 

Description

Gets information about the occupied space per table in database
 

Return Function

A list that contains information about occupied space per table in the database. Each item of this list will be an object of type TableSizeVO.
 

Parameters


value Description Type
refresh A boolean value that indicates if the function will recalculate the occupied space in database.

This parameter is optional and the default value is false.

A false value indicates that the function will return the last calculated value (usage of cache).
Boolean
 

Example


Dim infoDBRecordPerTable as List(Of TableSizeVO) = SDK.Database.GetDetailSize() 

 

SendBillingSize

 

Description

Sends the occupied space in the database to be used for the next billing
 

Return Function

n/a
 

Parameters

n/a
 

Example


SDK.Database.SendBillingSize()