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); }