mcs/class/System.Web/Test/System.Web.UI.WebControls/SqlDataSourceViewTest.cs

   1 //
   2 // Tests for System.Web.UI.WebControls.SqlDataSourceView
   3 //
   4 // Author:
   5 //      Chris Toshok (toshok@novell.com)
   6 //
   7
   8 //
   9 // Copyright (C) 2006 Novell, Inc (http://www.novell.com)
  10 //
  11 // Permission is hereby granted, free of charge, to any person obtaining
  12 // a copy of this software and associated documentation files (the
  13 // "Software"), to deal in the Software without restriction, including
  14 // without limitation the rights to use, copy, modify, merge, publish,
  15 // distribute, sublicense, and/or sell copies of the Software, and to
  16 // permit persons to whom the Software is furnished to do so, subject to
  17 // the following conditions:
  18 //
  19 // The above copyright notice and this permission notice shall be
  20 // included in all copies or substantial portions of the Software.
  21 //
  22 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
  23 // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
  24 // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
  25 // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
  26 // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
  27 // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
  28 // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
  29 //
  30
  31 #if NET_2_0
  32
  33 using NUnit.Framework;
  34 using System;
  35 using System.Configuration;
  36 using System.Data.Common;
  37 using System.IO;
  38 using System.Globalization;
  39 using System.Web;
  40 using System.Web.UI;
  41 using System.Web.UI.WebControls;
  42
  43 namespace MonoTests.System.Web.UI.WebControls
  44 {
  45         class SqlViewPoker : SqlDataSourceView {
  46                 public SqlViewPoker (SqlDataSource ds, string name, HttpContext context)
  47                         : base (ds, name, context)
  48                 {
  49                         TrackViewState ();
  50                 }
  51
  52                 public object SaveToViewState ()
  53                 {
  54                         return SaveViewState ();
  55                 }
  56
  57                 public void LoadFromViewState (object savedState)
  58                 {
  59                         LoadViewState (savedState);
  60                 }
  61         }
  62
  63         [TestFixture]
  64         public class SqlDataSourceViewTest
  65         {
  66                 [Test]
  67                 public void Defaults ()
  68                 {
  69                         SqlDataSource ds = new SqlDataSource ();
  70                         SqlViewPoker sql = new SqlViewPoker (ds, "DefaultView", null);
  71
  72                         Assert.IsTrue (sql.CancelSelectOnNullParameter, "A1");
  73                         Assert.IsFalse (sql.CanDelete,"A2");
  74                         Assert.IsFalse (sql.CanInsert,"A3");
  75                         Assert.IsFalse (sql.CanPage,"A4");
  76                         Assert.IsFalse (sql.CanRetrieveTotalRowCount,"A5");
  77                         Assert.IsTrue (sql.CanSort,"A6");
  78                         Assert.IsFalse (sql.CanUpdate,"A7");
  79                         Assert.AreEqual (ConflictOptions.OverwriteChanges, sql.ConflictDetection, "A8");
  80                         Assert.AreEqual ("", sql.DeleteCommand, "A9");
  81                         Assert.AreEqual (SqlDataSourceCommandType.Text, sql.DeleteCommandType, "A10");
  82                         Assert.IsNotNull (sql.DeleteParameters, "A11");
  83                         Assert.AreEqual (0, sql.DeleteParameters.Count, "A12");
  84                         Assert.AreEqual ("", sql.FilterExpression, "A13");
  85                         Assert.IsNotNull (sql.FilterParameters, "A14");
  86                         Assert.AreEqual (0, sql.FilterParameters.Count, "A15");
  87                         Assert.AreEqual ("", sql.InsertCommand, "A16");
  88                         Assert.AreEqual (SqlDataSourceCommandType.Text, sql.InsertCommandType, "A17");
  89                         Assert.IsNotNull (sql.InsertParameters, "A18");
  90                         Assert.AreEqual (0, sql.InsertParameters.Count, "A19");
  91                         Assert.AreEqual ("{0}", sql.OldValuesParameterFormatString, "A20");
  92                         Assert.AreEqual ("", sql.SelectCommand, "A21");
  93                         Assert.AreEqual (SqlDataSourceCommandType.Text, sql.SelectCommandType, "A22");
  94                         Assert.IsNotNull (sql.SelectParameters, "A23");
  95                         Assert.AreEqual (0, sql.SelectParameters.Count, "A24");
  96                         Assert.AreEqual ("", sql.SortParameterName, "A25");
  97                         Assert.AreEqual ("", sql.UpdateCommand, "A26");
  98                         Assert.AreEqual (SqlDataSourceCommandType.Text, sql.UpdateCommandType, "A27");
  99                         Assert.IsNotNull (sql.UpdateParameters, "A28");
 100                         Assert.AreEqual (0, sql.UpdateParameters.Count, "A29");
 101                 }
 102
 103                 [Test]
 104                 public void ViewStateSupport ()
 105                 {
 106                         SqlDataSource ds = new SqlDataSource ();
 107                         SqlViewPoker view = new SqlViewPoker (ds, "DefaultView", null);
 108
 109                         ds.ID = "SqlDataSource1";
 110                         ds.SelectCommand = "Select";
 111
 112                         Parameter p1 = new Parameter ("test", TypeCode.String);
 113
 114                         Assert.IsTrue (((IStateManager) view).IsTrackingViewState, "IsTrackingViewState");
 115                         Assert.IsTrue (((IStateManager) view.FilterParameters).IsTrackingViewState, "FilterParameters.IsTrackingViewState");
 116                         Assert.IsTrue (((IStateManager) view.SelectParameters).IsTrackingViewState, "SelecteParameters.IsTrackingViewState");
 117                         Assert.IsFalse (((IStateManager) view.DeleteParameters).IsTrackingViewState, "DeleteParameters.IsTrackingViewState");
 118                         Assert.IsFalse (((IStateManager) view.InsertParameters).IsTrackingViewState, "InsertParameters.IsTrackingViewState");
 119                         Assert.IsFalse (((IStateManager) view.UpdateParameters).IsTrackingViewState, "UpdateParameters.IsTrackingViewState");
 120
 121                         object state = ((IStateManager) view).SaveViewState ();
 122                         Assert.IsNull (state, "view ViewState not null");
 123
 124                         view.DeleteParameters.Add (p1);
 125                         view.InsertParameters.Add (p1);
 126                         //view.UpdateParameters.Add (p1);
 127
 128                         state = ((IStateManager) view).SaveViewState ();
 129                         Assert.IsNull (state, "view ViewState not null");
 130
 131                         view.FilterParameters.Add (p1);
 132                         //view.SelectParameters.Add (p1);
 133
 134                         state = ((IStateManager) view).SaveViewState ();
 135                         Assert.IsNotNull (state, "view ViewState not null");
 136
 137                         state = ((IStateManager) view.FilterParameters).SaveViewState ();
 138                         Assert.IsNotNull (state, "FilterParamenters ViewState not null");
 139                         state = ((IStateManager) view.SelectParameters).SaveViewState ();
 140                         Assert.IsNull (state, "SelectParameters ViewState not null");
 141
 142                         state = ((IStateManager) view.DeleteParameters).SaveViewState ();
 143                         Assert.IsNotNull (state, "DeleteParameters ViewState not null");
 144                         state = ((IStateManager) view.InsertParameters).SaveViewState ();
 145                         Assert.IsNotNull (state, "InsertParameters ViewState not null");
 146                         state = ((IStateManager) view.UpdateParameters).SaveViewState ();
 147                         Assert.IsNull (state, "UpdateParameters ViewState not null");
 148                 }
 149
 150                 [Test]
 151         public void ViewState ()
 152                 {
 153                         SqlDataSource ds = new SqlDataSource ();
 154                         SqlViewPoker sql = new SqlViewPoker (ds, "DefaultView", null);
 155
 156                         /* XXX test parameters */
 157
 158                         sql.CancelSelectOnNullParameter = false;
 159                         sql.ConflictDetection = ConflictOptions.CompareAllValues;
 160                         sql.DeleteCommandType = SqlDataSourceCommandType.Text;
 161                         sql.DeleteCommand = "delete command";
 162                         sql.FilterExpression = "filter expression";
 163                         sql.InsertCommand = "insert command";
 164                         sql.InsertCommandType = SqlDataSourceCommandType.Text;
 165                         sql.OldValuesParameterFormatString = "{1}";
 166                         sql.SelectCommand = "select command";
 167                         sql.SelectCommandType = SqlDataSourceCommandType.Text;
 168                         sql.SortParameterName = "sort parameter";
 169                         sql.UpdateCommand = "update command";
 170                         sql.UpdateCommandType = SqlDataSourceCommandType.Text;
 171
 172                         Assert.IsFalse (sql.CancelSelectOnNullParameter, "A1");
 173                         Assert.AreEqual (ConflictOptions.CompareAllValues, sql.ConflictDetection, "A2");
 174                         Assert.AreEqual ("delete command", sql.DeleteCommand, "A3");
 175                         Assert.AreEqual (SqlDataSourceCommandType.Text, sql.DeleteCommandType, "A4");
 176                         Assert.AreEqual ("filter expression", sql.FilterExpression, "A5");
 177                         Assert.AreEqual ("insert command", sql.InsertCommand, "A6");
 178                         Assert.AreEqual (SqlDataSourceCommandType.Text, sql.InsertCommandType, "A7");
 179                         Assert.AreEqual ("{1}", sql.OldValuesParameterFormatString, "A8");
 180                         Assert.AreEqual ("select command", sql.SelectCommand, "A9");
 181                         Assert.AreEqual (SqlDataSourceCommandType.Text, sql.SelectCommandType, "A10");
 182                         Assert.AreEqual ("sort parameter", sql.SortParameterName, "A11");
 183                         Assert.AreEqual ("update command", sql.UpdateCommand, "A12");
 184                         Assert.AreEqual (SqlDataSourceCommandType.Text, sql.UpdateCommandType, "A13");
 185
 186                         object state = sql.SaveToViewState();
 187                         Assert.IsNull (state, "ViewState is null");
 188
 189                         sql = new SqlViewPoker (ds, "DefaultView", null);
 190                         sql.LoadFromViewState (state);
 191
 192             Assert.IsTrue(sql.CancelSelectOnNullParameter, "B1");
 193             Assert.IsFalse(sql.CanDelete, "B2");
 194             Assert.IsFalse(sql.CanInsert, "B3");
 195             Assert.IsFalse(sql.CanPage, "B4");
 196             Assert.IsFalse(sql.CanRetrieveTotalRowCount, "B5");
 197             Assert.IsTrue(sql.CanSort, "B6");
 198             Assert.IsFalse(sql.CanUpdate, "B7");
 199                         Assert.AreEqual (ConflictOptions.OverwriteChanges, sql.ConflictDetection, "B8");
 200                         Assert.AreEqual ("", sql.DeleteCommand, "B9");
 201             Assert.AreEqual(SqlDataSourceCommandType.Text, sql.DeleteCommandType, "B10");
 202             Assert.IsNotNull(sql.DeleteParameters, "B11");
 203             Assert.AreEqual(0, sql.DeleteParameters.Count, "B12");
 204                         Assert.AreEqual ("", sql.FilterExpression, "B13");
 205             Assert.IsNotNull(sql.FilterParameters, "B14");
 206             Assert.AreEqual(0, sql.FilterParameters.Count, "B15");
 207                         Assert.AreEqual ("", sql.InsertCommand, "B16");
 208             Assert.AreEqual(SqlDataSourceCommandType.Text, sql.InsertCommandType, "B17");
 209             Assert.IsNotNull(sql.InsertParameters, "B18");
 210             Assert.AreEqual(0, sql.InsertParameters.Count, "B19");
 211                         Assert.AreEqual ("{0}", sql.OldValuesParameterFormatString, "B20");
 212                         Assert.AreEqual ("", sql.SelectCommand, "B21");
 213             Assert.AreEqual(SqlDataSourceCommandType.Text, sql.SelectCommandType, "B22");
 214             Assert.IsNotNull(sql.SelectParameters, "B23");
 215             Assert.AreEqual(0, sql.SelectParameters.Count, "B24");
 216                         Assert.AreEqual ("", sql.SortParameterName, "B25");
 217                         Assert.AreEqual ("", sql.UpdateCommand, "B26");
 218             Assert.AreEqual(SqlDataSourceCommandType.Text, sql.UpdateCommandType, "B27");
 219             Assert.IsNotNull(sql.UpdateParameters, "B28");
 220             Assert.AreEqual(0, sql.UpdateParameters.Count, "B29");
 221                 }
 222
 223                 [Test]
 224                 public void CanDelete ()
 225                 {
 226                         SqlDataSource ds = new SqlDataSource ();
 227                         SqlViewPoker sql = new SqlViewPoker (ds, "DefaultView", null);
 228
 229                         sql.DeleteCommand = "DELETE from foo";
 230                         Assert.IsTrue (sql.CanDelete, "A1");
 231
 232                         sql.DeleteCommand = "";
 233                         Assert.IsFalse (sql.CanDelete, "A2");
 234
 235                         sql.DeleteCommand = null;
 236                         Assert.IsFalse (sql.CanDelete, "A3");
 237                 }
 238
 239                 [Test]
 240                 public void CanInsert ()
 241                 {
 242                         SqlDataSource ds = new SqlDataSource ();
 243                         SqlViewPoker sql = new SqlViewPoker (ds, "DefaultView", null);
 244
 245                         sql.InsertCommand = "INSERT into foo";
 246                         Assert.IsTrue (sql.CanInsert, "A1");
 247
 248                         sql.InsertCommand = "";
 249                         Assert.IsFalse (sql.CanInsert, "A2");
 250
 251                         sql.InsertCommand = null;
 252                         Assert.IsFalse (sql.CanInsert, "A3");
 253                 }
 254
 255                 [Test]
 256                 public void CanUpdate ()
 257                 {
 258                         SqlDataSource ds = new SqlDataSource ();
 259                         SqlViewPoker sql = new SqlViewPoker (ds, "DefaultView", null);
 260
 261                         sql.UpdateCommand = "UPDATE foo";
 262                         Assert.IsTrue (sql.CanUpdate, "A1");
 263
 264                         sql.UpdateCommand = "";
 265                         Assert.IsFalse (sql.CanUpdate, "A2");
 266
 267                         sql.UpdateCommand = null;
 268                         Assert.IsFalse (sql.CanUpdate, "A3");
 269                 }
 270
 271                 [Test]
 272                 public void CanSort ()
 273                 {
 274                         SqlDataSource ds = new SqlDataSource ();
 275                         SqlViewPoker sql = new SqlViewPoker (ds, "DefaultView", null);
 276
 277                         sql.SortParameterName = "foo";
 278                         Assert.IsTrue (sql.CanSort, "A1");
 279
 280                         sql.SortParameterName = null;
 281                         Assert.IsTrue (sql.CanSort, "A2");
 282
 283                         sql.SortParameterName = "";
 284                         Assert.IsTrue (sql.CanSort, "A3");
 285
 286                         sql.SortParameterName = "foo";
 287
 288                         ds.DataSourceMode = SqlDataSourceMode.DataReader;
 289                         Assert.IsTrue (sql.CanSort, "A4");
 290
 291                         ds.DataSourceMode = SqlDataSourceMode.DataSet;
 292                         Assert.IsTrue (sql.CanSort, "A5");
 293
 294                         sql.SortParameterName = "";
 295
 296                         ds.DataSourceMode = SqlDataSourceMode.DataReader;
 297                         Assert.IsFalse (sql.CanSort, "A6");
 298
 299                         ds.DataSourceMode = SqlDataSourceMode.DataSet;
 300                         Assert.IsTrue (sql.CanSort, "A7");
 301                 }
 302
 303                 [Test]
 304                 public void OldValuesParameterFormatString ()
 305                 {
 306                         SqlDataSource ds = new SqlDataSource ();
 307
 308                         Assert.AreEqual ("{0}", ds.OldValuesParameterFormatString, "A1");
 309
 310                         ds.OldValuesParameterFormatString = "hi {0}";
 311
 312                         SqlViewPoker sql = new SqlViewPoker (ds, "DefaultView", null);
 313
 314                         Assert.AreEqual ("{0}", sql.OldValuesParameterFormatString, "A2");
 315
 316                         ds.OldValuesParameterFormatString = "hi {0}";
 317
 318                         Assert.AreEqual ("{0}", sql.OldValuesParameterFormatString, "A3");
 319
 320                         ds.OldValuesParameterFormatString = "{0}";
 321                         sql.OldValuesParameterFormatString = "hi {0}";
 322
 323                         Assert.AreEqual ("{0}", ds.OldValuesParameterFormatString, "A4");
 324                 }
 325
 326                 [Test]
 327                 public void CancelSelectOnNullParameter ()
 328                 {
 329                         SqlDataSource ds = new SqlDataSource ();
 330
 331                         ds.CancelSelectOnNullParameter = false;
 332
 333                         SqlViewPoker sql = new SqlViewPoker (ds, "DefaultView", null);
 334
 335                         Assert.IsTrue (sql.CancelSelectOnNullParameter, "A1");
 336
 337                         ds.CancelSelectOnNullParameter = true;
 338                         sql.CancelSelectOnNullParameter = false;
 339
 340                         Assert.IsTrue (ds.CancelSelectOnNullParameter, "A2");
 341
 342                         sql.CancelSelectOnNullParameter = false;
 343                         ds.CancelSelectOnNullParameter = true;
 344                         Assert.IsFalse (sql.CancelSelectOnNullParameter, "A3");
 345                 }
 346         }
 347
 348 }
 349
 350 #endif