public async Task StoreNoPK()
{
var rows = new List <IDictionary <string, object> >();
var row = new Dictionary <string, object>();
rows.Add(row);
var data = new TableSqlData()
{
PrimaryKeyColumns = null,
Rows = rows,
TableName = Guid.NewGuid().ToString(),
};
var tables = new List <TableSqlData>();
tables.Add(data);
var table = Substitute.For <ITableStorage>();
table.InsertOrReplace(row);
var writer = new TableStorageWriter(table);
await writer.Store(tables);
Assert.AreEqual(data.TableName, row[TableStorage.PartitionKey]);
Assert.IsNotNull(row[TableStorage.RowKey]);
Assert.AreNotEqual(Guid.Empty, Guid.Parse((string)row[TableStorage.RowKey]));
table.Received().InsertOrReplace(row);
}
static void Main(string[] args)
{
Console.WriteLine("Enter the connection string:");
var connStr = Console.ReadLine();
CloudStorageAccount storageAccount = null;
try
{
storageAccount = CloudStorageAccount.Parse(connStr);
}
catch (Exception ex)
{
Console.WriteLine("Invalid connection string : " + connStr + ex.Message);
return;
}
Console.WriteLine("Enter the table name:");
var tableName = Console.ReadLine();
TableStorageWriter tableWriter = new TableStorageWriter(connStr, tableName);
var entities = tableWriter.GetAllEntities();
foreach (var entity in entities)
{
tableWriter.Delete(entity);
}
tableWriter.Execute();
Console.WriteLine("The azure table {0} has been cleared.", tableName)
}
public async Task StoreNoPK()
{
var rows = new List<IDictionary<string, object>>();
var row = new Dictionary<string, object>();
rows.Add(row);
var data = new TableSqlData()
{
PrimaryKeyColumns = null,
Rows = rows,
TableName = Guid.NewGuid().ToString(),
};
var tables = new List<TableSqlData>();
tables.Add(data);
var table = Substitute.For<ITableStorage>();
table.InsertOrReplace(row);
var writer = new TableStorageWriter(table);
await writer.Store(tables);
Assert.AreEqual(data.TableName, row[TableStorage.PartitionKey]);
Assert.IsNotNull(row[TableStorage.RowKey]);
Assert.AreNotEqual(Guid.Empty, Guid.Parse((string)row[TableStorage.RowKey]));
table.Received().InsertOrReplace(row);
}
public async Task Initialize()
{
var table = Substitute.For<ITableStorage>();
table.CreateIfNotExists().Returns(Task.FromResult(true));
var writer = new TableStorageWriter(table);
var result = await writer.Initialize();
Assert.IsTrue(result);
table.Received().CreateIfNotExists();
}
public async Task Initialize()
{
var table = Substitute.For <ITableStorage>();
table.CreateIfNotExists().Returns(Task.FromResult(true));
var writer = new TableStorageWriter(table);
var result = await writer.Initialize();
Assert.IsTrue(result);
table.Received().CreateIfNotExists();
}
public async Task StoreMultiplePks()
{
var pks = new List <string>();
pks.Add(Guid.NewGuid().ToString());
pks.Add(Guid.NewGuid().ToString());
var rows = new List <IDictionary <string, object> >();
var row = new Dictionary <string, object>();
row.Add(pks.ElementAt(0), Guid.NewGuid());
row.Add(pks.ElementAt(1), Guid.NewGuid());
rows.Add(row);
var data = new TableSqlData()
{
PrimaryKeyColumns = pks,
Rows = rows,
TableName = Guid.NewGuid().ToString(),
};
var tables = new List <TableSqlData>();
tables.Add(data);
var table = Substitute.For <ITableStorage>();
table.InsertOrReplace(row);
var writer = new TableStorageWriter(table);
await writer.Store(tables);
Assert.AreEqual(data.TableName, row[TableStorage.PartitionKey]);
var pk = string.Format("{0}_{1}", row.Values.ElementAt(0), row.Values.ElementAt(1));
var rowKey = row[TableStorage.RowKey];
Assert.AreEqual(pk, rowKey);
table.Received().InsertOrReplace(row);
}
public async Task Store()
{
var pks = new List<string>();
var pkName = Guid.NewGuid().ToString();
pks.Add(pkName);
var pk = Guid.NewGuid().ToString();
var rows = new List<IDictionary<string, object>>();
var row = new Dictionary<string, object>();
row.Add(pkName, pk);
rows.Add(row);
var data = new TableSqlData()
{
PrimaryKeyColumns = pks,
Rows = rows,
TableName = Guid.NewGuid().ToString(),
};
var tables = new List<TableSqlData>();
tables.Add(data);
var table = Substitute.For<ITableStorage>();
table.InsertOrReplace(row);
var writer = new TableStorageWriter(table);
await writer.Store(tables);
Assert.AreEqual(data.TableName, row[TableStorage.PartitionKey]);
Assert.AreEqual(pk, row[TableStorage.RowKey]);
table.Received().InsertOrReplace(row);
}