Store

Object which stores data (Database)

BrowseName
Store
SuperType
Object(BaseObjectType)

Properties

Name BrowseName DataType Description
Max column name length MaxColumnNameLength UInt32 Maximum length of column names
Max columns count MaxColumnCount UInt32 Max columns count
Data type compatibility map DataTypeCompatibilityMap NodeId Map of the compatibility for the column data type
Status Status Store status Database connectivity status
Tables Tables Table Database tables

Methods

Add table

BrowseName
AddTable

Add a table to the store

Table 1. InputArguments
Name DataType Description
Name String Name of the new table

Remove table

BrowseName
RemoveTable

Remove a table from the store

Table 2. InputArguments
Name DataType Description
Name String Name of table to be removed

Rename table

BrowseName
RenameTable

Rename a Database table

Table 3. InputArguments
Name DataType Description
OldName String Name of table to be renamed
NewName String New name for the table

Query

BrowseName
Query

ANSI SQL query

Table 4. InputArguments
Name DataType Description
Query String ANSI SQL query
Table 5. OutputArguments
Name DataType Description
Header String Query column header
ResultSet BaseDataType Query result set

Open query

BrowseName
QueryOpen

Open paged query

Table 6. InputArguments
Name DataType Description
Query String ANSI SQL query
Table 7. OutputArguments
Name DataType Description
QueryHandle Guid Handle that represents the open query
Header String Query column header
Count UInt64 Count of the elements resulting from the query

Query page

BrowseName
QueryPage

Query a specific page of an already opened paged query

Table 8. InputArguments
Name DataType Description
QueryHandle Guid Handle that represents the open query
Offset UInt32 Paged query offset
Size UInt32 Size of the page returned from the store
Table 9. OutputArguments
Name DataType Description
ResultSet BaseDataType Query result set

Close query

BrowseName
QueryClose

Close paged query

Table 10. InputArguments
Name DataType Description
QueryHandle Guid Handle that represents the open query

Add column

BrowseName
AddColumn

Add a new column to the store

Table 11. InputArguments
Name DataType Description
TableName String Table name
Name String Column name
DataType NodeId Column DataType

Remove column

BrowseName
RemoveColumn

Remove this column from the store

Table 12. InputArguments
Name DataType Description
TableName String Table name
Name String Name of the column to be removed

Rename column

BrowseName
RenameColumn

Name of the column to be renamed

Table 13. InputArguments
Name DataType Description
TableName String Table name
OldName String Name of column to be renamed
NewName String The new column name

Insert

BrowseName
Insert

Isert data to the store

Table 14. InputArguments
Name DataType Description
TableName String Table name
ColumnNames String Column names for insert
Values BaseDataType List of records to be inserted