Altın Konu Microsoft Azure - Tablolar

$StorageAccountName = "mystorageaccount"
$StorageAccountKey = "mystoragekey"
$Ctx = New-AzureStorageContext $StorageAccountName - StorageAccountKey
$StorageAccountKey

$tabName = "Mytablename"
New-AzureStorageTable Name $tabName Context $Ctx

turkmmo.table.core.windows.net/Book

$tabName = "Book"
Get-AzureStorageTable Name $tabName Context $Ctx

$tabName = "Kitap"
Remove-AzureStorageTable Name $tabName Context $Ctx

function Add-Entity() {
   [CmdletBinding()]
    
   param(
      $table,
      [String]$partitionKey,
      [String]$rowKey,
      [String]$title,
      [Int]$id,
      [String]$publisher,
      [String]$author
   ) 
  
   $entity = New-Object -TypeName Microsoft.WindowsAzure.Storage.Table.DynamicTableEntity
      -ArgumentList $partitionKey, $rowKey
        
   $entity.Properties.Add("Title", $title)
   $entity.Properties.Add("ID", $id)
   $entity.Properties.Add("Publisher", $publisher)
   $entity.Properties.Add("Author", $author)
  
  
   $result = $table.CloudTable.Execute(
      [Microsoft.WindowsAzure.Storage.Table.TableOperation]
      ::Insert($entity))
}
 
$StorageAccountName = "turkmmo"
$StorageAccountKey = Get-AzureStorageKey -StorageAccountName $StorageAccountName
$Ctx = New-AzureStorageContext $StorageAccountName - StorageAccountKey
   $StorageAccountKey.Primary 

$TableName = "Book"
 
$table = Get-AzureStorageTable Name $TableName -Context $Ctx -ErrorAction Ignore
 
#Add multiple entities to a table.
Add-Entity -Table $table -PartitionKey Partition1 -RowKey Row1 -Title .Net -Id 1
   -Publisher abc -Author abc
Add-Entity -Table $table -PartitionKey Partition2 -RowKey Row2 -Title JAVA -Id 2
   -Publisher abc -Author abc
Add-Entity -Table $table -PartitionKey Partition3 -RowKey Row3 -Title PHP -Id 3
   -Publisher xyz -Author xyz
Add-Entity -Table $table -PartitionKey Partition4 -RowKey Row4 -Title SQL -Id 4
   -Publisher xyz -Author xyz

$StorageAccountName = "turkmmo"
$StorageAccountKey = Get-AzureStorageKey - StorageAccountName $StorageAccountName
$Ctx = New-AzureStorageContext  StorageAccountName $StorageAccountName -
   StorageAccountKey $StorageAccountKey.Primary;

$TableName = "Book"
 
#Get a reference to a table.
$table = Get-AzureStorageTable Name $TableName -Context $Ctx 

#Create a table query.
$query = New-Object Microsoft.WindowsAzure.Storage.Table.TableQuery

#Define columns to select.
$list = New-Object System.Collections.Generic.List[string]
$list.Add("RowKey")
$list.Add("ID")
$list.Add("Title")
$list.Add("Publisher")
$list.Add("Author")
 
#Set query details.
$query.FilterString = "ID gt 0"
$query.SelectColumns = $list
$query.TakeCount = 20
 
#Execute the query.
$entities = $table.CloudTable.ExecuteQuery($query)

#Display entity properties with the table format.

$entities  | Format-Table PartitionKey, RowKey, @{ Label = "Title";
Expression={$_.Properties["Title"].StringValue}}, @{ Label = "ID";
Expression={$_.Properties[ID].Int32Value}}, @{ Label = "Publisher";
Expression={$_.Properties[Publisher].StringValue}}, @{ Label = "Author";
Expression={$_.Properties[Author].StringValue}} -AutoSize

$StorageAccountName = "turkmmo"
 
$StorageAccountKey = Get-AzureStorageKey - StorageAccountName $StorageAccountName
$Ctx = New-AzureStorageContext  StorageAccountName $StorageAccountName -
   StorageAccountKey $StorageAccountKey.Primary 

#Retrieve the table.
$TableName = "Book"
$table = Get-AzureStorageTable -Name $TableName -Context $Ctx -ErrorAction
Ignore

#If the table exists, start deleting its entities.
if ($table -ne $null) {
   #Together the PartitionKey and RowKey uniquely identify every   
   #entity within a table.
    
   $tableResult = $table.CloudTable.Execute(
      [Microsoft.WindowsAzure.Storage.Table.TableOperation]
      ::Retrieve(Partition1, "Row1"))
        
   $entity = $tableResult.Result;
    
   if ($entity -ne $null) {
      $table.CloudTable.Execute(
         [Microsoft.WindowsAzure.Storage.Table.TableOperation]
         ::Delete($entity))
   }
}