public async Task Save(PersonalStoryEntity entity)
{
var table = new TableStorage("userprofile", tableConnection);
if (!storyTableCreated)
{
storyTableCreated = await table.CreateIfNotExists();
}
await table.CreateIfNotExists();
await table.InsertOrReplace(entity);
}
public async Task CreateIfNotExistsAlreadyExists()
{
var table = 'a' + Guid.NewGuid().ToString().ToLowerInvariant().Replace('-', 'a');
var storage = new TableStorage(table, TestHelpers.DevConnectionString);
var created = await storage.CreateIfNotExists();
Assert.IsTrue(created);
created = await storage.CreateIfNotExists();
Assert.IsFalse(created);
await storage.Delete();
}
public async Task ConstructorTableToSql()
{
var c = new ConfigValues()
{
StorageAccountConnection = "UseDevelopmentStorage=true;",
SqlConnection = "Server=localhost;Database=King.BTrak.Data;Trusted_Connection=True;",
SqlTableName = "TableData",
StorageTableName = "sqlserverdata",
Direction = Direction.TableToSql,
};
var tableName = "testsynctabletosql";
var table = new TableStorage(tableName, c.StorageAccountConnection);
await table.CreateIfNotExists();
var entity = new TableEntity
{
PartitionKey = Guid.NewGuid().ToString(),
RowKey = Guid.NewGuid().ToString(),
};
await table.InsertOrReplace(entity);
var s = new Synchronizer(c);
await s.Run();
await table.Delete();
var statement = string.Format("SELECT 1 AS [Exists] FROM [dbo].[TableData] WHERE TableName='{0}' AND PartitionKey = '{1}' AND RowKey = '{2}';", tableName, entity.PartitionKey, entity.RowKey);
var executor = new Executor(new SqlConnection(c.SqlConnection));
var ds = await executor.Query(statement);
var r = ds.Model<DataRow>();
Assert.IsNotNull(r);
Assert.IsTrue(r.Exists);
}
public async Task ConstructorAccount()
{
var name = 'a' + Guid.NewGuid().ToString().ToLowerInvariant().Replace('-', 'a');
var account = CloudStorageAccount.Parse(TestHelpers.DevConnectionString);
var localStorage = new TableStorage(name, account);
var created = await localStorage.CreateIfNotExists();
Assert.IsTrue(created);
}
public async Task Save(Message msg)
{
var table = new TableStorage("messages", tableConnection);
if (!msgTableCreated)
{
msgTableCreated = await table.CreateIfNotExists();
}
await table.InsertOrReplace(msg);
}
public async Task TableNames()
{
var name = 'a' + Guid.NewGuid().ToString().ToLowerInvariant().Replace('-', 'a');
var storage = new TableStorage(name, ConnectionString);
var created = await storage.CreateIfNotExists();
var resources = new AzureStorageResources(ConnectionString);
var tables = resources.TableNames();
Assert.IsTrue(tables.Contains(name));
}
public async Task Tables()
{
var name = 'a' + Guid.NewGuid().ToString().ToLowerInvariant().Replace('-', 'a');
var storage = new TableStorage(name, ConnectionString);
var created = await storage.CreateIfNotExists();
var resources = new AzureStorageResources(ConnectionString);
var tables = resources.Tables();
var exists = (from t in tables
where t.Name == name
select true).FirstOrDefault();
Assert.IsTrue(exists);
}
public async Task ConstructorTableToSql()
{
var c = new ConfigValues()
{
StorageAccountConnection = "UseDevelopmentStorage=true;",
SqlConnection = "Server=localhost;Database=King.BTrak.Data;Trusted_Connection=True;",
SqlTableName = "TableData",
StorageTableName = "sqlserverdata",
Direction = Direction.TableToSql,
};
var tableName = "testsynctabletosql";
var table = new TableStorage(tableName, c.StorageAccountConnection);
await table.CreateIfNotExists();
var entity = new TableEntity
{
PartitionKey = Guid.NewGuid().ToString(),
RowKey = Guid.NewGuid().ToString(),
};
await table.InsertOrReplace(entity);
var s = new Synchronizer(c);
await s.Run();
await table.Delete();
var statement = string.Format("SELECT 1 AS [Exists] FROM [dbo].[TableData] WHERE TableName='{0}' AND PartitionKey = '{1}' AND RowKey = '{2}';", tableName, entity.PartitionKey, entity.RowKey);
var executor = new Executor(new SqlConnection(c.SqlConnection));
var ds = await executor.Query(statement);
var r = ds.Model <DataRow>();
Assert.IsNotNull(r);
Assert.IsTrue(r.Exists);
}
