public void Initialize()
{
_target = new PgDatabaseClient(false);
_target.ConnectionString = "Host=localhost;Database=product_build;Username=dbsafe;Password=dbsafe";
var deleteDataCommand = @"
DELETE FROM public.product;
DELETE FROM public.category;
DELETE FROM public.supplier;
";
_target.ExecuteCommand(deleteDataCommand);
}
public void Connection_Is_Reused_When_Configured()
{
var client = new PgDatabaseClient(true)
{
ConnectionString = connectionString
};
client.ExecuteCommand(createTempTableCommand);
Action action = () => client.ExecuteCommand(verifyIfTempTableExistsQuery);
action.Should().NotThrow();
}
public void Connection_Is_Not_Reused()
{
var client = new PgDatabaseClient(false)
{
ConnectionString = connectionString
};
client.ExecuteCommand(createTempTableCommand);
Action action = () => client.ExecuteCommand(verifyIfTempTableExistsQuery);
action.Should().Throw <PostgresException>();
}
public void Write_Read_And_Compare_Results()
{
var client = new PgDatabaseClient(false)
{
ConnectionString = connectionString
};
var deleteCmd = @"
DELETE FROM public.product;
DELETE FROM public.category;
DELETE FROM public.supplier;
";
client.ExecuteCommand(deleteCmd);
var expectedDatasetJson = @"
{
""name"": ""suppliers"",
""table"": ""Supplier"",
""rows"": [
{
""columns"": [
{
""name"": ""id"",
""value"": ""1""
},
{
""name"": ""name"",
""value"": ""supplier-1""
},
{
""name"": ""contact_name"",
""value"": ""contact-name-1""
},
{
""name"": ""contact_phone"",
""value"": ""100-200-0001""
},
{
""name"": ""contact_email"",
""value"": ""*****@*****.**""
}
]
},
{
""columns"": [
{
""name"": ""id"",
""value"": ""2""
},
{
""name"": ""name"",
""value"": ""supplier-2""
},
{
""name"": ""contact_name"",
""value"": ""contact-name-2""
},
{
""name"": ""contact_phone"",
""value"": ""100-200-0002""
},
{
""name"": ""contact_email"",
""value"": ""*****@*****.**""
}
]
},
{
""columns"": [
{
""name"": ""id"",
""value"": ""3""
},
{
""name"": ""name"",
""value"": ""supplier-3""
},
{
""name"": ""contact_name"",
""value"": ""contact-name-3""
},
{
""name"": ""contact_phone"",
""value"": ""100-200-0003""
},
{
""name"": ""contact_email"",
""value"": ""*****@*****.**""
}
]
}
]
}
";
var jsonDoc = JsonDocument.Parse(expectedDatasetJson);
var expectedDataset = Dataset.Parse(jsonDoc.RootElement);
client.InsertTableData(expectedDataset);
var formatterManager = new FormatterManager();
var selectQuery = "SELECT * FROM public.supplier;";
var actualDataset = client.ReadTableData(selectQuery, formatterManager);
expectedDataset.Rows.Should().BeEquivalentTo(actualDataset.Rows);
}
