public void Gen_Delete_Test_Keyless() { TestClass T = new TestClass() { DateColumn = DateTime.Parse("1/1/2021"), FloatColumn = 12.12, IntegerColumn = 123, ScalarColumn = 1, TextColumn = "Tomato" }; SqlDeleteGenerator delr = new SqlDeleteGenerator(); try { var command = delr.Generate(T, new Func <TestClass, IEnumerable <KeyValuePair <string, object> > >(x => { return(new List <KeyValuePair <string, object> >()); })); } catch { Assert.Pass(); } Assert.Fail(); }
private void ButtonGenerateDelete_Click(object sender, RoutedEventArgs e) { if (lstSelectedTables.SelectedItems.Count > 0) { string output = string.Empty; foreach (var item in lstSelectedTables.SelectedItems) { if (item is TSqlObject table) { SqlDeleteGenerator gen = new SqlDeleteGenerator(GeneratorSettings, table, true); output += gen.Generate(); } } txtOutput.Text = output; } }
public void Gen_Delete_For_TestClass() { TestClass T = new TestClass() { DateColumn = DateTime.Parse("1/1/2021"), FloatColumn = 12.12, IntegerColumn = 123, ScalarColumn = 1, TextColumn = "Tomato" }; SqlDeleteGenerator delr = new SqlDeleteGenerator(); var command = delr.Generate(T); Assert.AreEqual(command, correctStr); }
public void Gen_Delete_Custom_Keys() { string correctStatement = "DELETE FROM TestClass WHERE TextColumn = 'Blah' AND ScalarColumn = 1"; TestClass T = new TestClass() { DateColumn = DateTime.Parse("1/1/2021"), FloatColumn = 12.12, IntegerColumn = 123, ScalarColumn = 1, TextColumn = "Tomato" }; SqlDeleteGenerator delr = new SqlDeleteGenerator(); var statement = delr.Generate(T, new Func <TestClass, IEnumerable <KeyValuePair <string, object> > >(x => { return(new List <KeyValuePair <string, object> >() { new KeyValuePair <string, object>("TextColumn", "Blah"), new KeyValuePair <string, object>("ScalarColumn", 1) }); })); Assert.AreEqual(correctStatement, statement); }