MindLake.DataLake
1. query() Method
Execute a SQL query or command.
const result = await mindLake.dataLake.query(statement);
Parameters
statement
-string
: the SQL statement used to query Mind Lake, such asSELECT, INSERT, UPDATE, and CREATE
.
Returns
An object of Promise<
>
. For more information.
result
-QueryResult
: The result of query execution.type QueryResult = { data: Array<Array<any>>, columnList: Array<string> }
data
-Array<Array<any>>
: The query data result is presented as a 2D array, with rows and columns.columnList
-Array<string>
: the column names in the specific order in which they appear.
Example
const selectSql = `select * from wallet_balance`;
const res = await dataLake.query(selectSql);
if(res.code !== 0) {
console.error(res.message);
return
}
const columnList = res.result.columnList;
for (const row of res.result.data) {
for (const idx in row) {
console.log(`${columnList[idx]} >>>`, row[idx])
}
}
2. createTable() Method
Create a table in the user's own account in Mind Lake.
const result = await mindLake.dataLake.createTable(tableName, columns, primaryKey)
Parameters
tableName
-string
: the name of the table to be created.columns
-Array<
Column
>
: defines the columns in the table. Each column should be defined as aMindLake.DataLake.Column
object.primaryKey
(Optional) -Array<string>|undefined
: defines the table's primary key by specifying one or more columns. Each column in the primary key should be identified by its column name. If theprimaryKey
parameter is omitted, no primary key will be defined for the table.
Returns
An object of Promise<
>
. For more information.
Example
const dataLake = mindLake.dataLake;
const res = await dataLake.createTable("wallet_balance", [{columnName: 'WalletAddress', type: DataType.text, encrypt: false}, {columnName: 'Name', type: DataType.text, encrypt: true}, {columnName: 'Balance', type: DataType.float4, encrypt: true}], ["id"]);
if(res.code !==0) {
console.error(res.message);
return
}
3. MindLake.DataLake.Column
Column
type is used to represent a single column in a table. Each Column
instance encapsulates properties about the column, including its name, data type, and encryption status. By creating a Column
object, you can define the properties of a table column and use it to construct a table schema.
Fields
columnName
-string
: The name of the column.type
-MindLake.DataType
: The data type of the column, which should be define asMindLake.DataType
encrypt
-boolean
: A flag that indicates whether the column should be encrypted or not.
Example
const column = {columnName: 'WalletAddress', type: MindLake.DataType.text, encrypt: false}
4. listTablesByCocoon() Method
Retrieve a list of names for the tables that belong to the user invoking the method, or in the specified cocoon.
await dataLake.listTableByCocoon(cocoonName)
Parameters
cocoonName
(Optional) -string
: specifies the name of the cocoon for which a list of tables should be returned. If thecocoonName
parameter is omitted, all the tables that belong to the method caller will be listed.
Returns
An object of Promise<
>
. For more information.
result
-Array<string>
: a list of names for the tables that belong to the user invoking the method, or in the specified cocoon.
Example
const result = await mindLake.dataLake.listTableByCocoon("cocoonName");
5. createCocoon() Method
Create a Cocoon in Mind Lake. Tables can be categorized into cocoons for classification purposes.
await mindLake.dataLake.createCocoon(cocooName)
Parameters
cocoonName
-string
: the name of the cocoon to be created.
Returns
An object of Promise<
>
. For more information.
Example
const result = await mindLake.dataLake.createCocoon("cocoonName");
6. listCocoon() Method
Retrieve a list of names for the cocoons that belong to the user invoking the method.
await mindLake.dataLake.listCocoon()
Returns
An object of Promise<
>
. For more information.
result
-Array<string>
: a list of names for the cocoons that belong to the user invoking the method.
Example
const result = await mindLake.dataLake.listCocoon();
7. linkTableToCocoon() Method
Assign the specified cocoon tag to the table.
await mindLake.dataLake.linkTableToCocoon(tableName, cocoonName)
Parameters
tableName
-string
: the name of the table to be tagged with.cocoonName
-string
: specifies the name of the cocoon for which the table should be tagged with.
Returns
An object of Promise<
>
. For more information.
Example
const result = await mindLake.dataLake.linkTableToCocoon("tableName", "cocoonName");
8. dropCocoon() Method
Delete a Cocoon in Mind Lake.
await mindLake.dataLake.dropCocoon(cocoonName)
Parameters
cocoonName
-string
: the name of the cocoon to be dropped.
Returns
An object of Promise<
>
. For more information.
Example
const result = await mindLake.dataLake.dropCocoon("cocoonName");
9. dropTable() Method
Drop a table in the user's own account in Mind Lake.
await mindLake.dataLake.dropTable(tableName)
Parameters
tableName
-string
: the name of the table to be dropped.
Returns
An object of Promise<
>
. For more information.
Example
const result = await mindLake.dataLake.dropTable("tableName");
Last updated