Azure Table

Função que permite executar operações para o banco de dados Azure Table.

Métodos#

Find#

Função que permite buscar todos os registros no banco de dados Azure Table.

const AzureTableService = require("@devapi/engine/azuretable");

const connection = {
  url: "connectionString",
  account: "account",
  accountKey: "accountKey",
  table: "tableName",
};

const dataTable = new AzureTableService(connection);

const result = dataTable.find();

Find One#

Função que permite buscar apenas um registro no banco de dados Azure Table.

const AzureTableService = require("@devapi/engine/azuretable");

const params = {
  partitionKey: "partitionKey", // Partition Key Azure Table
  sku: 110057,
};

const connection = {
  url: "connectionString",
  account: "account",
  accountKey: "accountKey",
  table: "tableName",
};

const dataTable = new AzureTableService(connection);

const result = await dataTable.findOne(params);

Insert#

Função que permite inserir novo registro no banco de dados Azure Table.

const AzureTableService = require("@devapi/engine/azuretable");

const entity = {
  PartitionKey: "PartitionKey",
  RowKey: "RowKey",
  name: "Contact",
  email: "contact@email.com",
};

const connection = {
  url: "connectionString",
  account: "account",
  accountKey: "accountKey",
  table: "tableName",
};

const dataTable = new AzureTableService(connection);

const result = await dataTable.insert(entity);

Update#

Função que permite atualizar um registro no banco de dados Azure Table.

const AzureTableService = require("@devapi/engine/azuretable");

const entity = {
  PartitionKey: "PartitionKey",
  RowKey: "RowKey",
  name: "Contact",
  email: "contact@email.com",
};

const connection = {
  url: "connectionString",
  account: "account",
  accountKey: "accountKey",
  table: "tableName",
};

const dataTable = new AzureTableService(connection);

const result = await dataTable.update(entity);

Delete#

Função que permite excluir um registro no banco de dados Azure Table.

const AzureTableService = require("@devapi/engine/azuretable");

const params = {
  partitionKey: "partitionKey",
  rowKey: "rowKey",
};

const connection = {
  url: "connectionString",
  account: "account",
  accountKey: "accountKey",
  table: "tableName",
};

const dataTable = new AzureTableService(connection);

const result = await dataTable.delete(params);