public async Task Blah()
{
Marker("Started");
using (var sqlServer = new SqlServerViaDockerSlow("sqlserver-prepped"))
{
await sqlServer.Start();
using (var db = new SqlConnection($"Server={sqlServer.Host},{sqlServer.Port};User Id=sa;Password=Wibble123!"))
{
await db.OpenAsync();
await db.ExecuteAsync(@"
INSERT INTO Camels
VALUES
('Clarence', 12),
('Cassandra', 10),
('Cuthbert', 8)
");
var camels = await db.QueryAsync("SELECT * FROM Camels");
Assert.That(camels.Count(), Is.EqualTo(3));
}
}
}
public async Task Normal()
{
Marker("Starting");
using (var sqlServer = new SqlServerViaDockerSlow("sqlservr-camels"))
{
await sqlServer.Start();
Marker("Started");
using (var db = new SqlConnection($"Server={sqlServer.Host},{sqlServer.Port};Database=CamelsRUs;User Id=sa;Password=Wibble123!"))
{
await db.OpenAsync();
Marker("Opened");
var ranchId = await db.CreateRanch(name : "Jason's Camel Ranch");
var camelId1 = await db.CreateCamel(name : "Claude", species : "Dromedary", age : 7);
await db.PlaceCamel(ranchId, camelId1);
var camelId2 = await db.CreateCamel(name : "Claudette", species : "Persian", age : 14);
await db.PlaceCamel(ranchId, camelId2);
var camels = await db.QueryAsync("SELECT * FROM Camels WHERE Species IN ('Bactrian', 'Wild Bactrian', 'Dromedary')");
Assert.That(camels.Count(), Is.EqualTo(1));
}
Marker("Finished");
}
}
public async Task Available_AfterStart()
{
using (var sql = new SqlServerViaDockerSlow("sqlservr-tracking"))
{
await sql.Start(CancellationToken.None);
var connectionString =
$"Server={sql.ServerUri.Host},{sql.ServerUri.Port};Database=electio_tracking;User Id=sa;Password=Wibble123!;Encrypt=False;Connection Timeout=30;MultipleActiveResultSets=True";
using (var connection = new SqlConnection(connectionString))
{
await connection.OpenAsync();
}
}
}
public async Task Blah()
{
Marker("Start");
using (var sqlServer = new SqlServerViaDockerSlow("sqlserver-simple"))
{
await sqlServer.Start();
Marker("SqlServer ready");
using (var db = new SqlConnection($"Server={sqlServer.Host},{sqlServer.Port};User Id=sa;Password=Wibble123!"))
{
await db.OpenAsync();
Marker("Connected");
await db.ExecuteAsync(@"
CREATE DATABASE Demo;
CREATE TABLE Camels (
Name nvarchar(50),
Age int
);
INSERT INTO Camels
VALUES
('Clarence', 12),
('Cassandra', 10),
('Cuthbert', 8)
");
Marker("Created");
var camels = await db.QueryAsync("SELECT * FROM Camels");
Assert.That(camels.Count(), Is.EqualTo(3));
}
Marker("Done!");
}
}