public async Task ConstructorSqlToTable()
{
var c = new ConfigValues()
{
StorageAccountConnection = "UseDevelopmentStorage=true;",
SqlConnection = "Server=localhost;Database=King.BTrak.Data;Trusted_Connection=True;",
SqlTableName = "TableData",
StorageTableName = "sqlserverdata",
Direction = Direction.SqlToTable,
};
var id = Guid.NewGuid();
var data = Guid.NewGuid();
var statement = string.Format("INSERT INTO [dbo].[TestSqlToTable] ([Id], [Data]) VALUES ('{0}', '{1}');", id, data);
var executor = new Executor(new SqlConnection(c.SqlConnection));
await executor.NonQuery(statement);
var s = new Synchronizer(c);
await s.Run();
await executor.NonQuery("TRUNCATE TABLE [dbo].[TestSqlToTable]");
var table = new TableStorage(c.StorageTableName, c.StorageAccountConnection);
var e = await table.QueryByPartitionAndRow("[dbo].[TestSqlToTable]", id.ToString());
Assert.IsNotNull(e);
Assert.AreEqual(data, e["Data"]);
}
public async Task InsertCommand()
{
var random = new Random();
var sproc = new dboSimulatedInsertStatement()
{
TestInt = random.Next(),
};
using (var con = new SqlConnection(connectionString))
{
var executor = new Executor(con);
var results = await executor.NonQuery(sproc.Build(con));
Assert.AreEqual(1, results);
}
}
public async Task InsertConnectitonHandedOff()
{
var random = new Random();
var executor = new Executor(new SqlConnection(connectionString));
for (var i = 0; i < random.Next(1000, 2000); i++)
{
var sproc = new dboSimulatedInsertStatement()
{
TestInt = random.Next(),
};
var results = await executor.NonQuery(sproc);
Assert.AreEqual(1, results);
}
}
public async Task NonQueryStatementNull()
{
var connection = new SqlConnection();
var e = new Executor(connection);
await e.NonQuery((string)null);
}
public async Task NonQueryCommandNull()
{
var connection = new SqlConnection();
var e = new Executor(connection);
await e.NonQuery((SqlCommand)null);
}
public async Task NonQuerySprocNull()
{
var connection = new SqlConnection();
var e = new Executor(connection);
await e.NonQuery((IStoredProcedure)null);
}
public async Task InsertStatement()
{
var random = new Random();
var statement = string.Format("EXECUTE [dbo].[SimulatedInsertStatement] @TestInt={0};", random.Next());
using (var con = new SqlConnection(connectionString))
{
var executor = new Executor(con);
var results = await executor.NonQuery(statement);
Assert.AreEqual(1, results);
}
}