public void Returns_Valid_Select_Query()
{
// Arrange
var schema = Rnd.Str;
var name = Rnd.Str;
var table = new DbName(schema, name);
var c0Name = Rnd.Str;
var c0Alias = Rnd.Str;
var c0 = new Column(table, c0Name, Helpers.CreateInfoFromAlias(c0Alias));
var c1Name = Rnd.Str;
var c1Alias = Rnd.Str;
var c1 = new Column(table, c1Name, Helpers.CreateInfoFromAlias(c1Alias));
var c2Name = Rnd.Str;
var c2Alias = Rnd.Str;
var c2Property = Substitute.ForPartsOf <PropertyInfo>();
c2Property.Name.Returns(c2Alias);
var c2 = new Column(table, c2Name, c2Property);
var list = new ColumnList(new[] { c0, c1 });
var client = new PostgreSqlDbClient();
var id = Rnd.Lng;
var expected = "SELECT" +
$" {c0Name} AS \"{c0Alias}\"," +
$" {c1Name} AS \"{c1Alias}\"" +
$" FROM {schema}.{name}" +
$" WHERE {c2Name} = {id};";
// Act
var result = client.GetRetrieveQueryTest(table, list, c2, id);
// Assert
Assert.Equal(expected, result);
}