public void PerformQuery_AsteriksSymbolWithCondition_ShouldReturnValidRecords(string query)
{
var database = new Database();
new CreateService(database).PerformQuery("CREATE TABLE users (email text, phoneNumber int, isAdult boolean);");
new InsertService(database).PerformQuery("INSERT INTO users (email, phoneNumber, isAdult) VALUES (\"[email protected]\", 703503, true);");
new InsertService(database).PerformQuery("INSERT INTO users (isAdult, email, phoneNumber ) VALUES (false, \"[email protected]\", 141505);");
var actual = new SelectService(database).PerformQuery(query);
var expected = new Models.Table.Record[] {
new Models.Table.Record(new List <string>()
{
"email", "phoneNumber", "isAdult"
}, new List <object>()
{
"*****@*****.**", 703503, true
})
};
for (var i = 0; i < actual.Length; i++)
{
Assert.Equal(actual[0].ColumnNames, expected[0].ColumnNames);
Assert.Equal(actual[0].Values, expected[0].Values);
}
}
public void PerformQuery_ShouldAddRowInTheTable(string query)
{
var database = new Database();
new CreateService(database).PerformQuery("CREATE TABLE users (email text, phoneNumber int, isAdult boolean);");
new InsertService(database).PerformQuery(query);
var id = database.GetTable("users").IdList[0];
var actual = database.GetTable("users").GetRecordById(id);
var expected = new Models.Table.Record(new List <string>()
{
"email",
"phoneNumber",
"isAdult"
}, new List <object>()
{
"*****@*****.**",
703503,
true
});
Assert.Equal(expected.ColumnNames, actual.ColumnNames);
Assert.Equal(expected.Values, actual.Values);
}
