public void ExecuteUpdateWithOldValuesException () { SqlPoker sql = new SqlPoker (); sql.ConnectionString = "Data Source=fake\\SQLEXPRESS;Initial Catalog=Northwind;User ID=sa"; sql.ProviderName = "System.Data.SqlClient"; CustomSqlDataSourceView view = new CustomSqlDataSourceView (sql, "TestView", null); view.SelectCommandType = SqlDataSourceCommandType.Text; view.SelectCommand = "SELECT * FROM products WHERE ProductID = @ProductID;"; view.UpdateCommandType = SqlDataSourceCommandType.Text; view.UpdateCommand = "UPDATE Table1 SET UserName = @UserName WHERE UserId = @UserId"; view.OldValuesParameterFormatString = "origin_{0}"; view.ConflictDetection = ConflictOptions.CompareAllValues; view.Updating += new SqlDataSourceCommandEventHandler (view_Updating); view.UpdateParameters.Add (new Parameter ("UserName", TypeCode.String, "TestUser")); view.UpdateParameters.Add (new Parameter ("UserId", TypeCode.Int32, "1")); view.Update (null, null, null); }
public void ExecuteDeleteWithOldValuesException () { SqlPoker sql = new SqlPoker (); sql.ConnectionString = "Data Source=fake\\SQLEXPRESS;Initial Catalog=Northwind;User ID=sa"; sql.ProviderName = "System.Data.SqlClient"; CustomSqlDataSourceView view = new CustomSqlDataSourceView (sql, "TestView", null); view.SelectCommandType = SqlDataSourceCommandType.Text; view.SelectCommand = "SELECT * FROM products WHERE ProductID = @ProductID;"; view.DeleteCommandType = SqlDataSourceCommandType.Text; view.DeleteCommand = "DELETE * FROM products WHERE ProductID = @ProductID;"; view.DeleteParameters.Add (new Parameter ("ProductId", TypeCode.Int32, "15")); view.OldValuesParameterFormatString = "origin_{0}"; view.ConflictDetection = ConflictOptions.CompareAllValues; view.Deleting += new SqlDataSourceCommandEventHandler (view_Deleting); Hashtable oldvalue = new Hashtable (); oldvalue.Add ("ProductID", 10); view.Delete (null, null); }
public void ExecuteDeleteException () { SqlPoker sql = new SqlPoker (); sql.ConnectionString = "Data Source=fake\\SQLEXPRESS;Initial Catalog=Northwind;User ID=sa"; sql.ProviderName = "System.Data.SqlClient"; CustomSqlDataSourceView view = new CustomSqlDataSourceView (sql, "TestView", null); view.Delete (null, null); }
public void ExecuteInsertException () { SqlPoker sql = new SqlPoker (); sql.ConnectionString = "Data Source=fake\\SQLEXPRESS;Initial Catalog=Northwind;User ID=sa"; sql.ProviderName = "System.Data.SqlClient"; CustomSqlDataSourceView view = new CustomSqlDataSourceView (sql, "TestView", null); view.SelectCommandType = SqlDataSourceCommandType.Text; view.SelectCommand = "SELECT * FROM products WHERE ProductID = @ProductID;"; view.Insert (null); }
public void ExecuteUpdate_KeysValuesAndOldValues_CompareAllValues () { SqlPoker sql = new SqlPoker (); sql.ConnectionString = "Data Source=fake\\SQLEXPRESS;Initial Catalog=Northwind;User ID=sa"; sql.ProviderName = "System.Data.SqlClient"; CustomSqlDataSourceView view = new CustomSqlDataSourceView (sql, "TestView", null); IDictionary keys; IDictionary values; IDictionary oldValues; InitializeView (view, out keys, out values, out oldValues); view.ConflictDetection = ConflictOptions.CompareAllValues; view.Update (keys, values, oldValues); Assert.IsNotNull (CustomEventParameterCollection, "ExecuteUpdate_KeysValuesAndOldValues_CompareAllValues"); string [] expectedParams = new string [] { "String:@ProductID=n_10", "String:@Name=n_ColorTV", "String:@Description=n_Beautifull", "String:@origin_ProductID=ov_10", "String:@origin_Name=ov_ColorTV", "String:@origin_Description=ov_Beautifull", }; string [] actualValues = PassedParameters.Split (new string [] { ", " }, StringSplitOptions.RemoveEmptyEntries); Assert.AreEqual (expectedParams.Length, actualValues.Length, "ExecuteDelete_KeysAndOldValues_CompareAllValues2 Params count"); ValidatePassedParams (expectedParams, actualValues, "ExecuteDelete_KeysAndOldValues_CompareAllValues2 expecte '{0}'"); }
public void SqlDataSource_DataSourceViewChanged () { SqlPoker sql = new SqlPoker (); ((IDataSource) sql).DataSourceChanged += new EventHandler (SqlDataSourceTest_DataSourceChanged); sql.DoRaiseDataSourceChangedEvent (); eventAssert.IsTrue ("SqlDataSourceView"); // Assert include counter the first is zero sql.CacheKeyDependency = "hi"; eventAssert.IsFalse ("SqlDataSourceView"); sql.CancelSelectOnNullParameter = false; eventAssert.IsFalse ("SqlDataSourceView"); sql.ConflictDetection = ConflictOptions.CompareAllValues; eventAssert.IsFalse ("SqlDataSourceView"); sql.DeleteCommandType = SqlDataSourceCommandType.StoredProcedure; eventAssert.IsFalse ("SqlDataSourceView"); sql.InsertCommandType = SqlDataSourceCommandType.StoredProcedure; eventAssert.IsFalse ("SqlDataSourceView"); sql.SelectCommandType = SqlDataSourceCommandType.StoredProcedure; eventAssert.IsFalse ("SqlDataSourceView"); sql.UpdateCommandType = SqlDataSourceCommandType.StoredProcedure; eventAssert.IsFalse ("SqlDataSourceView"); sql.OldValuesParameterFormatString = "{1}"; eventAssert.IsFalse ("SqlDataSourceView"); sql.SqlCacheDependency = "hi"; eventAssert.IsFalse ("SqlDataSourceView"); sql.SortParameterName = "hi"; eventAssert.IsFalse ("SqlDataSourceView"); sql.CacheDuration = 1; eventAssert.IsFalse ("SqlDataSourceView"); sql.CacheExpirationPolicy = DataSourceCacheExpiry.Sliding; eventAssert.IsFalse ("SqlDataSourceView"); sql.EnableCaching = true; eventAssert.IsFalse ("SqlDataSourceView"); sql.DataSourceMode = SqlDataSourceMode.DataReader; eventAssert.IsTrue ("SqlDataSourceView"); sql.DeleteCommand = "DELETE foo"; eventAssert.IsFalse ("SqlDataSourceView"); sql.InsertCommand = "INSERT foo"; eventAssert.IsFalse ("SqlDataSourceView"); sql.SelectCommand = "SELECT foo"; eventAssert.IsFalse ("SqlDataSourceView"); sql.UpdateCommand = "UPDATE foo"; eventAssert.IsFalse ("SqlDataSourceView"); sql.FilterExpression = "hi"; eventAssert.IsFalse ("SqlDataSourceView"); }
public void ExecuteDelete_KeysAndOldValues_OverwriteChanges () { SqlPoker sql = new SqlPoker (); sql.ConnectionString = "Data Source=fake\\SQLEXPRESS;Initial Catalog=Northwind;User ID=sa"; sql.ProviderName = "System.Data.SqlClient"; CustomSqlDataSourceView view = new CustomSqlDataSourceView (sql, "TestView", null); IDictionary keys; IDictionary values; IDictionary oldValues; InitializeView (view, out keys, out values, out oldValues); view.ConflictDetection = ConflictOptions.OverwriteChanges; view.Delete (keys, oldValues); Assert.IsNotNull (CustomEventParameterCollection, "KeysAndOldValues_OverwriteChanges"); Assert.AreEqual ("String:@origin_ProductID=k_10", PassedParameters, "KeysAndOldValues_OverwriteChanges Values"); }
public void ExecuteUpdateWithMargeParameters () { SqlPoker sql = new SqlPoker (); sql.ConnectionString = "Data Source=fake\\SQLEXPRESS;Initial Catalog=Northwind;User ID=sa"; sql.ProviderName = "System.Data.SqlClient"; CustomSqlDataSourceView view = new CustomSqlDataSourceView (sql, "TestView", null); view.SelectCommandType = SqlDataSourceCommandType.Text; view.SelectCommand = "SELECT * FROM products WHERE ProductID = @ProductID;"; view.UpdateCommandType = SqlDataSourceCommandType.Text; view.UpdateCommand = "UPDATE Table1 SET UserName = @UserName WHERE UserId = @UserId"; view.OldValuesParameterFormatString = "origin_{0}"; view.ConflictDetection = ConflictOptions.OverwriteChanges; view.Updating += new SqlDataSourceCommandEventHandler (view_Updating); view.UpdateParameters.Add (new Parameter ("UserName", TypeCode.String, "TestUser")); view.UpdateParameters.Add (new Parameter ("UserId", TypeCode.Int32, "1")); Hashtable value = new Hashtable (); value.Add ("UserLName", "TestLName"); view.Update (null, value, null); Assert.IsNotNull (CustomEventParameterCollection, "Update event not fired"); Assert.AreEqual (3, CustomEventParameterCollection.Count, "Parameter count"); Assert.AreEqual ("@UserName", CustomEventParameterCollection[0].ParameterName, "Parameter name#1"); Assert.AreEqual ("TestUser", CustomEventParameterCollection[0].Value, "Parameter value#1"); Assert.AreEqual ("@UserId", CustomEventParameterCollection[1].ParameterName, "Parameter name#2"); Assert.AreEqual (1, CustomEventParameterCollection[1].Value, "Parameter value#2"); Assert.AreEqual ("@UserLName", CustomEventParameterCollection[2].ParameterName, "Parameter name#3"); Assert.AreEqual ("TestLName", CustomEventParameterCollection[2].Value, "Parameter value#3"); }
public void ExecuteDeleteWithMergedValues () { SqlPoker sql = new SqlPoker (); sql.ConnectionString = "Data Source=fake\\SQLEXPRESS;Initial Catalog=Northwind;User ID=sa"; sql.ProviderName = "System.Data.SqlClient"; CustomSqlDataSourceView view = new CustomSqlDataSourceView (sql, "TestView", null); view.SelectCommandType = SqlDataSourceCommandType.Text; view.SelectCommand = "SELECT * FROM products WHERE ProductID = @ProductID;"; view.DeleteCommandType = SqlDataSourceCommandType.Text; view.DeleteCommand = "DELETE * FROM products WHERE ProductID = @ProductID;"; view.DeleteParameters.Add (new Parameter ("ProductId", TypeCode.Int32, "15")); view.OldValuesParameterFormatString = "origin_{0}"; view.Deleting += new SqlDataSourceCommandEventHandler (view_Deleting); Hashtable value = new Hashtable (); value.Add ("Desc", "Description"); view.Delete (value, null); Assert.IsNotNull (CustomEventParameterCollection, "Delete event not fired"); Assert.AreEqual (2, CustomEventParameterCollection.Count, "Parameter count"); Assert.AreEqual ("@ProductId", CustomEventParameterCollection[0].ParameterName, "Parameter name#1"); Assert.AreEqual (15, CustomEventParameterCollection[0].Value, "Parameter value#1"); Assert.AreEqual ("@origin_Desc", CustomEventParameterCollection[1].ParameterName, "Parameter name#2"); Assert.AreEqual ("Description", CustomEventParameterCollection[1].Value, "Parameter value#2"); }
public void ExecuteInsertWithCollection () { SqlPoker sql = new SqlPoker (); sql.ConnectionString = "Data Source=fake\\SQLEXPRESS;Initial Catalog=Northwind;User ID=sa"; sql.ProviderName = "System.Data.SqlClient"; CustomSqlDataSourceView view = new CustomSqlDataSourceView (sql, "TestView", null); view.SelectCommandType = SqlDataSourceCommandType.Text; view.SelectCommand = "SELECT * FROM products WHERE ProductID = @ProductID;"; view.InsertCommandType = SqlDataSourceCommandType.Text; view.InsertCommand = "INSERT INTO products (UserId, UserName) VALUES ({0},{1})"; view.InsertParameters.Add (new Parameter ("UserId", TypeCode.Int32, "15")); view.InsertParameters.Add (new Parameter ("UserName", TypeCode.String, "newuser")); view.OldValuesParameterFormatString = "origin_{0}"; view.Inserting += new SqlDataSourceCommandEventHandler (view_Inserting); Hashtable value = new Hashtable (); value.Add ("Description", "TestDescription"); view.Insert (value); Assert.IsNotNull (CustomEventParameterCollection, "Insert event not fired"); Assert.AreEqual (3, CustomEventParameterCollection.Count, "Parameter count"); Assert.AreEqual ("@UserId", CustomEventParameterCollection[0].ParameterName, "Parameter name#1"); Assert.AreEqual (15, CustomEventParameterCollection[0].Value, "Parameter value#1"); Assert.AreEqual ("@UserName", CustomEventParameterCollection[1].ParameterName, "Parameter name#2"); Assert.AreEqual ("newuser", CustomEventParameterCollection[1].Value, "Parameter value#2"); Assert.AreEqual ("@Description", CustomEventParameterCollection[2].ParameterName, "Parameter name#3"); Assert.AreEqual ("TestDescription", CustomEventParameterCollection[2].Value, "Parameter value#3"); }
public void ExecuteSelect2 () { SqlPoker sql = new SqlPoker (); sql.ConnectionString = "Data Source=fake\\SQLEXPRESS;Initial Catalog=Northwind;User ID=sa"; sql.ProviderName = "System.Data.SqlClient"; sql.DataSourceMode = SqlDataSourceMode.DataReader; CustomSqlDataSourceView view = new CustomSqlDataSourceView (sql, "TestView", null); view.SelectCommandType = SqlDataSourceCommandType.Text; view.SelectCommand = "SELECT * FROM products WHERE ProductID = @ProductID;"; view.OldValuesParameterFormatString = "origin_{0}"; view.SelectParameters.Add (new Parameter ("ProductID", TypeCode.Int32, "10")); view.Selecting += new SqlDataSourceSelectingEventHandler (view_Selecting); view.Select (new DataSourceSelectArguments ()); Assert.IsNotNull (CustomEventParameterCollection, "Select event not fired"); Assert.AreEqual (1, CustomEventParameterCollection.Count, "Parameter count"); Assert.AreEqual ("@ProductID", CustomEventParameterCollection [0].ParameterName, "Parameter name"); Assert.AreEqual (10, CustomEventParameterCollection [0].Value, "Parameter value"); }
public void ViewState () { SqlPoker sql = new SqlPoker (); sql.CacheKeyDependency = "hi"; sql.CancelSelectOnNullParameter = false; sql.ConflictDetection = ConflictOptions.CompareAllValues; sql.DeleteCommandType = SqlDataSourceCommandType.StoredProcedure; sql.InsertCommandType = SqlDataSourceCommandType.StoredProcedure; sql.SelectCommandType = SqlDataSourceCommandType.StoredProcedure; sql.UpdateCommandType = SqlDataSourceCommandType.StoredProcedure; sql.OldValuesParameterFormatString = "{1}"; sql.SqlCacheDependency = "hi"; sql.SortParameterName = "hi"; sql.CacheDuration = 1; sql.CacheExpirationPolicy = DataSourceCacheExpiry.Sliding; sql.EnableCaching = true; sql.DataSourceMode = SqlDataSourceMode.DataReader; sql.DeleteCommand = "DELETE foo"; sql.InsertCommand = "INSERT foo"; sql.SelectCommand = "SELECT foo"; sql.UpdateCommand = "UPDATE foo"; sql.FilterExpression = "hi"; Assert.AreEqual ("hi", sql.CacheKeyDependency, "A1"); Assert.IsFalse (sql.CancelSelectOnNullParameter, "A2"); Assert.AreEqual (ConflictOptions.CompareAllValues, sql.ConflictDetection, "A3"); Assert.AreEqual (SqlDataSourceCommandType.StoredProcedure, sql.DeleteCommandType, "A4"); Assert.AreEqual (SqlDataSourceCommandType.StoredProcedure, sql.InsertCommandType, "A5"); Assert.AreEqual (SqlDataSourceCommandType.StoredProcedure, sql.SelectCommandType, "A6"); Assert.AreEqual (SqlDataSourceCommandType.StoredProcedure, sql.UpdateCommandType, "A7"); Assert.AreEqual ("{1}", sql.OldValuesParameterFormatString, "A8"); Assert.AreEqual ("hi", sql.SqlCacheDependency, "A9"); Assert.AreEqual ("hi", sql.SortParameterName, "A10"); Assert.AreEqual (1, sql.CacheDuration, "A11"); Assert.AreEqual (DataSourceCacheExpiry.Sliding, sql.CacheExpirationPolicy, "A12"); Assert.IsTrue (sql.EnableCaching, "A13"); Assert.AreEqual (SqlDataSourceMode.DataReader, sql.DataSourceMode, "A16"); Assert.AreEqual ("DELETE foo", sql.DeleteCommand, "A17"); Assert.AreEqual ("INSERT foo", sql.InsertCommand, "A20"); Assert.AreEqual ("SELECT foo", sql.SelectCommand, "A22"); Assert.AreEqual ("UPDATE foo", sql.UpdateCommand, "A24"); Assert.AreEqual ("hi", sql.FilterExpression, "A26"); object state = sql.SaveToViewState (); Assert.IsNull (state, "ViewState is null"); sql = new SqlPoker (); sql.LoadFromViewState (state); Assert.AreEqual ("", sql.CacheKeyDependency, "B1"); Assert.IsTrue (sql.CancelSelectOnNullParameter, "B2"); Assert.AreEqual (ConflictOptions.OverwriteChanges, sql.ConflictDetection, "B3"); Assert.AreEqual (SqlDataSourceCommandType.Text, sql.DeleteCommandType, "B4"); Assert.AreEqual (SqlDataSourceCommandType.Text, sql.InsertCommandType, "B5"); Assert.AreEqual (SqlDataSourceCommandType.Text, sql.SelectCommandType, "B6"); Assert.AreEqual (SqlDataSourceCommandType.Text, sql.UpdateCommandType, "B7"); Assert.AreEqual ("{0}", sql.OldValuesParameterFormatString, "B8"); Assert.AreEqual ("", sql.SqlCacheDependency, "B9"); Assert.AreEqual ("", sql.SortParameterName, "B10"); Assert.AreEqual (0, sql.CacheDuration, "B11"); Assert.AreEqual (DataSourceCacheExpiry.Absolute, sql.CacheExpirationPolicy, "B12"); Assert.IsFalse (sql.EnableCaching, "B13"); Assert.AreEqual (SqlDataSourceMode.DataSet, sql.DataSourceMode, "B16"); Assert.AreEqual ("", sql.DeleteCommand, "B17"); Assert.IsNotNull (sql.DeleteParameters, "B18"); Assert.AreEqual (0, sql.DeleteParameters.Count, "B18.1"); Assert.IsNotNull (sql.FilterParameters, "B19"); Assert.AreEqual (0, sql.FilterParameters.Count, "B19.1"); Assert.AreEqual ("", sql.InsertCommand, "B20"); Assert.IsNotNull (sql.InsertParameters, "B21"); Assert.AreEqual (0, sql.InsertParameters.Count, "B21.1"); Assert.AreEqual ("", sql.SelectCommand, "B22"); Assert.IsNotNull (sql.SelectParameters, "B23"); Assert.AreEqual (0, sql.SelectParameters.Count, "B23.1"); Assert.AreEqual ("", sql.UpdateCommand, "B24"); Assert.IsNotNull (sql.UpdateParameters, "B25"); Assert.AreEqual (0, sql.UpdateParameters.Count, "B25.1"); Assert.AreEqual ("", sql.FilterExpression, "B26"); }
public void Defaults () { SqlPoker sql = new SqlPoker (); Assert.AreEqual ("", sql.CacheKeyDependency, "A1"); Assert.IsTrue (sql.CancelSelectOnNullParameter, "A2"); Assert.AreEqual (ConflictOptions.OverwriteChanges, sql.ConflictDetection, "A3"); Assert.AreEqual (SqlDataSourceCommandType.Text, sql.DeleteCommandType, "A4"); Assert.AreEqual (SqlDataSourceCommandType.Text, sql.InsertCommandType, "A5"); Assert.AreEqual (SqlDataSourceCommandType.Text, sql.SelectCommandType, "A6"); Assert.AreEqual (SqlDataSourceCommandType.Text, sql.UpdateCommandType, "A7"); Assert.AreEqual ("{0}", sql.OldValuesParameterFormatString, "A8"); Assert.AreEqual ("", sql.SqlCacheDependency, "A9"); Assert.AreEqual ("", sql.SortParameterName, "A10"); Assert.AreEqual (0, sql.CacheDuration, "A11"); Assert.AreEqual (DataSourceCacheExpiry.Absolute, sql.CacheExpirationPolicy, "A12"); Assert.IsFalse (sql.EnableCaching, "A13"); Assert.AreEqual ("", sql.ProviderName, "A14"); Assert.AreEqual ("", sql.ConnectionString, "A15"); Assert.AreEqual (SqlDataSourceMode.DataSet, sql.DataSourceMode, "A16"); Assert.AreEqual ("", sql.DeleteCommand, "A17"); Assert.IsNotNull (sql.DeleteParameters, "A18"); Assert.AreEqual (0, sql.DeleteParameters.Count, "A18.1"); Assert.IsNotNull (sql.FilterParameters, "A19"); Assert.AreEqual (0, sql.FilterParameters.Count, "A19.1"); Assert.AreEqual ("", sql.InsertCommand, "A20"); Assert.IsNotNull (sql.InsertParameters, "A21"); Assert.AreEqual (0, sql.InsertParameters.Count, "A21.1"); Assert.AreEqual ("", sql.SelectCommand, "A22"); Assert.IsNotNull (sql.SelectParameters, "A23"); Assert.AreEqual (0, sql.SelectParameters.Count, "A23.1"); Assert.AreEqual ("", sql.UpdateCommand, "A24"); Assert.IsNotNull (sql.UpdateParameters, "A25"); Assert.AreEqual (0, sql.UpdateParameters.Count, "A25.1"); Assert.AreEqual ("", sql.FilterExpression, "A26"); }