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