public bool CreateBooks(bool testForExistence = false)
{
bool created = true;
if (testForExistence)
{
created = client.CreateTableIfNotExist(Book.TableName);
}
else
{
client.CreateTable(Book.TableName);
}
return(created);
}
private static bool CreateTable(string tableName)
{
CloudTableClient tc = account.CreateCloudTableClient();
DateTime retryUntil = DateTime.Now + s_retryTimeout;
while (!tc.DoesTableExist(tableName))
{
try
{
tc.CreateTable(tableName);
WriteInFile(filename, tableName + " was created");
return(true);
}
catch (StorageClientException e)
{
if (e.ErrorCode == StorageErrorCode.ResourceAlreadyExists &&
e.StatusCode == HttpStatusCode.Conflict &&
DateTime.Now < retryUntil)
{
Console.WriteLine("Retrying {0}...", tableName);
Thread.Sleep(s_retryWaitTime);
}
else
{
throw;
}
}
}
WriteInFile(filename, tableName + " already created");
return(false);
}
private void DeleteRecreateTable()
{
CloudTableClient client = AzureHelper.StorageAccount.CreateCloudTableClient();
client.RetryPolicy = RetryPolicies.Retry(int.MaxValue, TimeSpan.FromSeconds(5));
client.DeleteTable(WorkerStatsTableName);
client.CreateTable(WorkerStatsTableName);
}
public static void Create(string account, string key, string tableName)
{
if (string.IsNullOrEmpty(tableName))
{
return;
}
CloudTableClient tableClient = Client.GetTableClient(account, key);
tableClient.CreateTable(tableName);
}
// Create Table.
// Return true on success, false if already exists, throw exception on error.
public bool CreateTable(string tableName)
{
try
{
TableClient.CreateTable(tableName);
return(true);
}
catch (StorageClientException ex)
{
if ((int)ex.StatusCode == 409)
{
return(false);
}
throw;
}
}
static void DoTables(CloudStorageAccount account)
{
Console.WriteLine("=======================TABLE==========================");
CloudTableClient tableClient = new CloudTableClient(account.TableEndpoint.AbsoluteUri, account.Credentials);
TableServiceContext context = tableClient.GetDataServiceContext();
Console.WriteLine("Clearning container...");
tableClient.DeleteTableIfExist("AzureStorageTestTableFrom");
tableClient.DeleteTableIfExist("AzureStorageTestTableTo");
Console.WriteLine("Creating container...");
while (true)
{
try
{
tableClient.CreateTable("AzureStorageTestTableFrom");
break;
}
catch (Exception)
{
Thread.Sleep(1000);
}
}
while (true)
{
try
{
tableClient.CreateTable("AzureStorageTestTableTo");
break;
}
catch (Exception)
{
Thread.Sleep(1000);
}
}
Console.WriteLine("Uploading data...");
for (int i = 0; i < 30; i++)
{
SquareRow row = new SquareRow()
{
Number = i,
Squared = i * i,
PartitionKey = "0",
RowKey = Guid.NewGuid().ToString(),
};
context.AddObject("AzureStorageTestTableFrom", row);
}
context.SaveChanges();
Console.WriteLine("Checking data...");
var query =
from row in context.CreateQuery <SquareRow>("AzureStorageTestTableFrom")
where row.Number < 10
select row;
foreach (var square in query)
{
DoubleRow row = new DoubleRow()
{
Number = square.Squared,
Doubled = square.Squared * 2,
PartitionKey = "0",
RowKey = Guid.NewGuid().ToString(),
};
context.AddObject("AzureStorageTestTableTo", row);
}
context.SaveChanges();
}
private void Create()
{
try
{
// create the blob containers
if (chkRequiredContainers.Checked)
{
foreach (var c in containerList)
{
var container = new CloudBlobContainer(c, cbc);
try
{
container.Create();
container.SetPermissions(
new BlobContainerPermissions()
{
PublicAccess = BlobContainerPublicAccessType.Blob
});
this.Invoke((Action)(() => lbStatus.Items.Add(String.Format("Created container '{0}'", c))));
}
catch (StorageClientException sce)
{
this.Invoke((Action)(() => lbStatus.Items.Add(String.Format("{0} [container: {1}]", sce.Message, c))));
}
}
}
// create the tables
if (chkRequiredTables.Checked)
{
foreach (var t in tableList)
{
try
{
ctc.CreateTable(t);
this.Invoke((Action)(() => lbStatus.Items.Add(String.Format("Created table '{0}'", t))));
}
catch (StorageClientException sce)
{
this.Invoke((Action)(() => lbStatus.Items.Add(String.Format("{0} [table: {1}]", sce.Message, t))));
}
}
}
// create the queues
if (chkRequiredQueues.Checked)
{
foreach (var q in queueList)
{
var queue = cqc.GetQueueReference(q);
try
{
queue.Create();
queue.Metadata["PoisonThreshold"] = QUEUE_POISONTHRESHOLD;
queue.Metadata["DefaultTimeout"] = QUEUE_INVISIBILITYTIMEOUT;
queue.SetMetadata();
this.Invoke((Action)(() => lbStatus.Items.Add(String.Format("Created queue '{0}'", q))));
}
catch (StorageClientException sce)
{
this.Invoke((Action)(() => lbStatus.Items.Add(String.Format("{0} [queue: {1}]", sce.Message, q))));
}
}
}
}
catch (Exception)
{
throw;
}
finally
{
this.Invoke((Action)(() => lbStatus.Items.Add("**** CREATE COMPLETED ****")));
}
}
