2 // Tests for System.Web.UI.WebControls.SqlDataSource
5 // Chris Toshok (toshok@novell.com)
9 // Copyright (C) 2005 Novell, Inc (http://www.novell.com)
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:
19 // The above copyright notice and this permission notice shall be
20 // included in all copies or substantial portions of the Software.
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.
33 using NUnit.Framework;
35 using System.Configuration;
36 using System.Data.Common;
38 using System.Globalization;
41 using System.Web.UI.WebControls;
43 namespace MonoTests.System.Web.UI.WebControls
45 class SqlPoker : SqlDataSource {
51 public object SaveToViewState ()
53 return SaveViewState ();
56 public void LoadFromViewState (object savedState)
58 LoadViewState (savedState);
63 public class SqlDataSourceTest {
65 public void Defaults ()
67 SqlPoker sql = new SqlPoker ();
69 Assert.AreEqual ("", sql.CacheKeyDependency, "A1");
70 Assert.IsTrue (sql.CancelSelectOnNullParameter, "A2");
71 Assert.AreEqual (ConflictOptions.OverwriteChanges, sql.ConflictDetection, "A3");
72 Assert.AreEqual (SqlDataSourceCommandType.StoredProcedure, sql.DeleteCommandType, "A4");
73 Assert.AreEqual (SqlDataSourceCommandType.StoredProcedure, sql.InsertCommandType, "A5");
74 Assert.AreEqual (SqlDataSourceCommandType.StoredProcedure, sql.SelectCommandType, "A6");
75 Assert.AreEqual (SqlDataSourceCommandType.StoredProcedure, sql.UpdateCommandType, "A7");
76 Assert.AreEqual ("{0}", sql.OldValuesParameterFormatString, "A8");
77 Assert.AreEqual ("", sql.SqlCacheDependency, "A9");
78 Assert.AreEqual ("", sql.SortParameterName, "A10");
79 Assert.AreEqual (0, sql.CacheDuration, "A11");
80 Assert.AreEqual (DataSourceCacheExpiry.Absolute, sql.CacheExpirationPolicy, "A12");
81 Assert.IsFalse (sql.EnableCaching, "A13");
82 Assert.AreEqual ("", sql.ProviderName, "A14");
83 Assert.AreEqual ("", sql.ConnectionString, "A15");
84 Assert.AreEqual (SqlDataSourceMode.DataSet, sql.DataSourceMode, "A16");
85 Assert.AreEqual ("", sql.DeleteCommand, "A17");
86 Assert.IsNotNull (sql.DeleteParameters, "A18");
87 Assert.AreEqual (0, sql.DeleteParameters.Count, "A18.1");
88 Assert.IsNotNull (sql.FilterParameters, "A19");
89 Assert.AreEqual (0, sql.FilterParameters.Count, "A19.1");
90 Assert.AreEqual ("", sql.InsertCommand, "A20");
91 Assert.IsNotNull (sql.InsertParameters, "A21");
92 Assert.AreEqual (0, sql.InsertParameters.Count, "A21.1");
93 Assert.AreEqual ("", sql.SelectCommand, "A22");
94 Assert.IsNotNull (sql.SelectParameters, "A23");
95 Assert.AreEqual (0, sql.SelectParameters.Count, "A23.1");
96 Assert.AreEqual ("", sql.UpdateCommand, "A24");
97 Assert.IsNotNull (sql.UpdateParameters, "A25");
98 Assert.AreEqual (0, sql.UpdateParameters.Count, "A25.1");
99 Assert.AreEqual ("", sql.FilterExpression, "A26");
102 // WARNING!!!!!! This information will be saved into viewstate only in mono implementation .
105 [Category ("NotWorking")]
106 public void ViewState ()
108 SqlPoker sql = new SqlPoker ();
110 sql.CacheKeyDependency = "hi";
111 sql.CancelSelectOnNullParameter = false;
112 sql.ConflictDetection = ConflictOptions.CompareAllValues;
113 sql.DeleteCommandType = SqlDataSourceCommandType.Text;
114 sql.InsertCommandType = SqlDataSourceCommandType.Text;
115 sql.SelectCommandType = SqlDataSourceCommandType.Text;
116 sql.UpdateCommandType = SqlDataSourceCommandType.Text;
117 sql.OldValuesParameterFormatString = "{1}";
118 sql.SqlCacheDependency = "hi";
119 sql.SortParameterName = "hi";
120 sql.CacheDuration = 1;
121 sql.CacheExpirationPolicy = DataSourceCacheExpiry.Sliding;
122 sql.EnableCaching = true;
123 sql.DataSourceMode = SqlDataSourceMode.DataReader;
124 sql.DeleteCommand = "DELETE foo";
125 sql.InsertCommand = "INSERT foo";
126 sql.SelectCommand = "SELECT foo";
127 sql.UpdateCommand = "UPDATE foo";
128 sql.FilterExpression = "hi";
130 Assert.AreEqual ("hi", sql.CacheKeyDependency, "A1");
131 Assert.IsFalse (sql.CancelSelectOnNullParameter, "A2");
132 Assert.AreEqual (ConflictOptions.CompareAllValues, sql.ConflictDetection, "A3");
133 Assert.AreEqual (SqlDataSourceCommandType.Text, sql.DeleteCommandType, "A4");
134 Assert.AreEqual (SqlDataSourceCommandType.Text, sql.InsertCommandType, "A5");
135 Assert.AreEqual (SqlDataSourceCommandType.Text, sql.SelectCommandType, "A6");
136 Assert.AreEqual (SqlDataSourceCommandType.Text, sql.UpdateCommandType, "A7");
137 Assert.AreEqual ("{1}", sql.OldValuesParameterFormatString, "A8");
138 Assert.AreEqual ("hi", sql.SqlCacheDependency, "A9");
139 Assert.AreEqual ("hi", sql.SortParameterName, "A10");
140 Assert.AreEqual (1, sql.CacheDuration, "A11");
141 Assert.AreEqual (DataSourceCacheExpiry.Sliding, sql.CacheExpirationPolicy, "A12");
142 Assert.IsTrue (sql.EnableCaching, "A13");
143 Assert.AreEqual (SqlDataSourceMode.DataReader, sql.DataSourceMode, "A16");
144 Assert.AreEqual ("DELETE foo", sql.DeleteCommand, "A17");
145 Assert.AreEqual ("INSERT foo", sql.InsertCommand, "A20");
146 Assert.AreEqual ("SELECT foo", sql.SelectCommand, "A22");
147 Assert.AreEqual ("UPDATE foo", sql.UpdateCommand, "A24");
148 Assert.AreEqual ("hi", sql.FilterExpression, "A26");
150 object state = sql.SaveToViewState();
152 sql = new SqlPoker ();
153 sql.LoadFromViewState (state);
155 Assert.AreEqual ("hi", sql.CacheKeyDependency, "B1");
156 Assert.IsFalse (sql.CancelSelectOnNullParameter, "B2");
157 Assert.AreEqual (ConflictOptions.CompareAllValues, sql.ConflictDetection, "B3");
158 Assert.AreEqual (SqlDataSourceCommandType.Text, sql.DeleteCommandType, "B4");
159 Assert.AreEqual (SqlDataSourceCommandType.Text, sql.InsertCommandType, "B5");
160 Assert.AreEqual (SqlDataSourceCommandType.Text, sql.SelectCommandType, "B6");
161 Assert.AreEqual (SqlDataSourceCommandType.Text, sql.UpdateCommandType, "B7");
162 Assert.AreEqual ("{1}", sql.OldValuesParameterFormatString, "B8");
163 Assert.AreEqual ("hi", sql.SqlCacheDependency, "B9");
164 Assert.AreEqual ("hi", sql.SortParameterName, "B10");
165 Assert.AreEqual (1, sql.CacheDuration, "B11");
166 Assert.AreEqual (DataSourceCacheExpiry.Sliding, sql.CacheExpirationPolicy, "B12");
167 Assert.IsTrue (sql.EnableCaching, "B13");
168 Assert.AreEqual (SqlDataSourceMode.DataReader, sql.DataSourceMode, "B16");
169 Assert.AreEqual ("DELETE foo", sql.DeleteCommand, "B17");
170 Assert.AreEqual ("INSERT foo", sql.InsertCommand, "B20");
171 Assert.AreEqual ("SELECT foo", sql.SelectCommand, "B22");
172 Assert.AreEqual ("UPDATE foo", sql.UpdateCommand, "B24");
173 Assert.AreEqual ("hi", sql.FilterExpression, "B26");