Welcome to mirror list, hosted at ThFree Co, Russian Federation.

github.com/mono/mono.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
path: root/mcs/class/System.Data.OracleClient/Test/System.Data.OracleClient.jvm/OracleCommand/OracleCommand_ExecuteReader.cs
diff options
context:
space:
mode:
Diffstat (limited to 'mcs/class/System.Data.OracleClient/Test/System.Data.OracleClient.jvm/OracleCommand/OracleCommand_ExecuteReader.cs')
-rwxr-xr-xmcs/class/System.Data.OracleClient/Test/System.Data.OracleClient.jvm/OracleCommand/OracleCommand_ExecuteReader.cs423
1 files changed, 0 insertions, 423 deletions
diff --git a/mcs/class/System.Data.OracleClient/Test/System.Data.OracleClient.jvm/OracleCommand/OracleCommand_ExecuteReader.cs b/mcs/class/System.Data.OracleClient/Test/System.Data.OracleClient.jvm/OracleCommand/OracleCommand_ExecuteReader.cs
deleted file mode 100755
index 74b7ab7161c..00000000000
--- a/mcs/class/System.Data.OracleClient/Test/System.Data.OracleClient.jvm/OracleCommand/OracleCommand_ExecuteReader.cs
+++ /dev/null
@@ -1,423 +0,0 @@
-//
-// Copyright (c) 2006 Mainsoft Co.
-//
-// Permission is hereby granted, free of charge, to any person obtaining
-// a copy of this software and associated documentation files (the
-// "Software"), to deal in the Software without restriction, including
-// without limitation the rights to use, copy, modify, merge, publish,
-// distribute, sublicense, and/or sell copies of the Software, and to
-// permit persons to whom the Software is furnished to do so, subject to
-// the following conditions:
-//
-// The above copyright notice and this permission notice shall be
-// included in all copies or substantial portions of the Software.
-//
-// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
-// EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
-// MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
-// NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
-// LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
-// OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
-// WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
-//
-
-using System;
-using System.Text;
-using System.Data;
-using System.Data.OracleClient ;
-
-using MonoTests.System.Data.Utils;
-
-
-using NUnit.Framework;
-#if DAAB
-using Microsoft.ApplicationBlocks;
-#endif
-
-namespace MonoTests.System.Data.OracleClient
-{
- [TestFixture]
- public class OracleCommand_ExecuteReader : ADONetTesterClass
- {
- OracleConnection con;
- OracleCommand cmd;
-
- [SetUp]
- public void SetUp()
- {
- Exception exp = null;
- BeginCase("Setup");
- try
- {
- con = new OracleConnection(MonoTests.System.Data.Utils.ConnectedDataProvider.ConnectionString);
- cmd = new OracleCommand("", con);
- con.Open();
- this.Pass("Setup.");
- }
- catch(Exception ex) {exp = ex;}
- finally {EndCase(exp); exp = null;}
- }
-
- [TearDown]
- public void TearDown()
- {
- if (con != null)
- {
- if (con.State == ConnectionState.Open) con.Close();
- }
- }
-
- public static void Main()
- {
- OracleCommand_ExecuteReader tc = new OracleCommand_ExecuteReader();
- Exception exp = null;
- try
- {
- tc.BeginTest("OracleCommand_ExecuteReader");
- tc.SetUp();
- tc.run();
- tc.TearDown();
- }
- catch(Exception ex){exp = ex;}
- finally {tc.EndTest(exp);}
- }
-
- [Test]
- public void run()
- {
- Exception exp = null;
- bool RecordsExists = false;
- OracleDataReader rdr =null;
-
-// testBug3965();
-// TestMultipleResultsets();
-// TestCompoundVariable();
-
- cmd.CommandText = "Select FirstName,City From Employees";
- if (con.State != ConnectionState.Open)
- {
- con.Open();
- }
-
- try
- {
- BeginCase("check reader is null");
- rdr = cmd.ExecuteReader();
- Compare(rdr==null, false);
- }
- catch(Exception ex){exp = ex;}
- finally
- {
- if (rdr != null) rdr.Close();
- EndCase(exp);
- exp = null;
- }
-
- try
- {
- BeginCase("check reader.read");
- rdr = cmd.ExecuteReader();
- RecordsExists = rdr.Read();
- Compare(RecordsExists ,true);
- }
- catch(Exception ex){exp = ex;}
- finally
- {
- if (rdr != null) rdr.Close();
- EndCase(exp);
- exp = null;
- }
-
- try
- {
- BeginCase("execute reader again ");
- rdr = cmd.ExecuteReader();
- Compare(rdr==null, false);
- }
- catch(Exception ex){exp = ex;}
- finally
- {
- if (rdr != null) rdr.Close();
- EndCase(exp);
- exp = null;
- }
-
- try
- {
- BeginCase("Test compound SQL statement");
- //Build a compund SQL command.
- string[] sqlStatements = new string[] {
- "INSERT INTO Categories (CategoryName, Description) VALUES('__TEST_RECORD__', 'Inserted')",
- "UPDATE Categories SET Description='Updated' WHERE CategoryName='__TEST_RECORD__'",
- "DELETE FROM Categories WHERE CategoryName='__TEST_RECORD__'" ,
- };
- cmd.CommandText = CreateCompundSqlStatement(sqlStatements, ConnectedDataProvider.GetDbType());
- rdr = cmd.ExecuteReader();
- Compare(rdr.Read(), false);
- }
- catch(Exception ex){exp = ex;}
- finally
- {
- if (rdr != null) rdr.Close();
- EndCase(exp);
- exp = null;
- }
-
-
- if (ConnectedDataProvider.GetDbType() != DataBaseServer.Oracle)
- {
- try
- {
- BeginCase("Check that in a compound SQL statement, resultsets are returned only for SELECT statements. (bug #3358)");
- //prepare db:
- OracleCommand prepare = new OracleCommand("DELETE FROM Categories WHERE CategoryName='__TEST_RECORD__'", con);
- prepare.ExecuteNonQuery();
-
-
- //Test body
- int resultSetCount ;
-
- //Build a compund SQL command that contains only one select statement.
- string[] sqlStatements = new string[] {
- "INSERT INTO Categories (CategoryName, Description) VALUES('__TEST_RECORD__', 'Inserted')",
- "UPDATE Categories SET Description='Updated' WHERE CategoryName='__TEST_RECORD__'",
- "DELETE FROM Categories WHERE CategoryName='__TEST_RECORD__'" ,
- "SELECT * FROM Categories "
- };
- string insertCmdTxt = CreateCompundSqlStatement(sqlStatements, ConnectedDataProvider.GetDbType());
- //this.Log(insertCmdTxt);
- OracleCommand InsertCmd = new OracleCommand(insertCmdTxt, con);
- rdr = InsertCmd.ExecuteReader();
-
- //Count the number of result sets.
- resultSetCount = 0;
- do
- {
- resultSetCount++;
- }while (rdr.NextResult());
-
- //Test that there is only one result set.
- Compare(resultSetCount, 1);
- }
- catch(Exception ex){exp = ex;}
- finally
- {
- if (rdr != null) rdr.Close();
- EndCase(exp);
- exp = null;
- //cleanup db:
- OracleCommand cleanup = new OracleCommand("DELETE FROM Categories WHERE CategoryName='__TEST_RECORD__'", con);
- cleanup.ExecuteNonQuery();
- }
- }
- }
-
-
- //Create the compund sql statement according to the dbserver.
- private string CreateCompundSqlStatement(string[] sqlStatements, DataBaseServer dbServer)
- {
- string beginStatement;
- string endStatement;
- string commandDelimiter;
-
- GetDBSpecificSyntax(dbServer, out beginStatement, out endStatement, out commandDelimiter);
-
- StringBuilder cmdBuilder = new StringBuilder();
- cmdBuilder.Append(beginStatement);
- cmdBuilder.Append(" ");
- foreach (string statement in sqlStatements)
- {
- cmdBuilder.Append(statement);
- cmdBuilder.Append(commandDelimiter);
- cmdBuilder.Append(" ");
- }
- cmdBuilder.Append(endStatement);
-
- return cmdBuilder.ToString();
- }
-
- private void GetDBSpecificSyntax(DataBaseServer dbServer, out string beginStatement, out string endStatement, out string commandDelimiter)
- {
- switch (dbServer)
- {
- case DataBaseServer.SQLServer:
- case DataBaseServer.PostgreSQL:
- beginStatement = "";
- endStatement = "";
- commandDelimiter = ";";
- break;
-
- case DataBaseServer.Sybase:
- beginStatement = "BEGIN";
- endStatement = "END";
- commandDelimiter = "";
- break;
- case DataBaseServer.Oracle:
- beginStatement = "BEGIN";
- endStatement = "END;";
- commandDelimiter = ";";
- break;
-
- case DataBaseServer.DB2:
- beginStatement = "BEGIN ATOMIC";
- endStatement = "END";
- commandDelimiter = ";";
- break;
-
- default:
- this.Fail("Unknown DataBaseServer type");
- throw new ApplicationException("Unknown DataBaseServer type");
- }
- }
-
-
- [Test]
- public void TestMultipleResultsets()
- {
-#if !JAVA
- if (ConnectedDataProvider.GetDbType(con) == DataBaseServer.Oracle)
- {
- //In .NET there is a bug when calling a SP with multiple REFCURSORS, the workaround is to use OracleClient and not Oracle.
- //In GH we are not bug complient in this issue, because there is no workaround (We do not support the OracleClient namespace.
- this.Log("Not testing multi result set Oracle on .NET");
- return;
- }
-
- if (ConnectedDataProvider.GetDbType(con) == DataBaseServer.PostgreSQL)
- {
- // fail to work on .NET OLEDB
- //reader = Microsoft.ApplicationBlocks.Data.PostgresOracleHelper.ADOExecuteReader(cmd1);
- this.Log("Not testing PostgreSQL CommandType.StoredProcedure which return SETOF");
- return;
- }
-#endif
-
- Exception exp = null;
- BeginCase("Test multi result set from stored procedure");
-
-
- OracleDataReader reader = null;
- OracleTransaction tr = null;
-
- try
- {
- //Check SP with the structre : insert Select + update Select + delete Select
- if (con.State != ConnectionState.Open)
- {
- con.Open();
- }
-
- // transaction use was add for PostgreSQL
- tr = con.BeginTransaction();
- OracleCommand cmd1 = new OracleCommand("GHSP_TYPES_SIMPLE_4", con, tr);
- cmd1.CommandType = CommandType.StoredProcedure;
-
- OracleParameter param = new OracleParameter();
- param.ParameterName = "ID1";
- param.Value = string.Format("13268_{0}", this.TestCaseNumber);
- param.OracleType = OracleType.VarChar;
- cmd1.Parameters.Add(param);
- cmd1.Parameters.Add(new OracleParameter("RESULT", OracleType.Cursor)).Direction = ParameterDirection.Output;
- cmd1.Parameters.Add(new OracleParameter("RESULT1", OracleType.Cursor)).Direction = ParameterDirection.Output;
- cmd1.Parameters.Add(new OracleParameter("RESULT2", OracleType.Cursor)).Direction = ParameterDirection.Output;
-
-
- reader = cmd1.ExecuteReader();
-
- //Count the number of result sets.
- int resultSetCount = 0;
- //Count the number of the records
- int recordCounter=0;
-
- do
- {
- //this.Log(string.Format("resultSetCount:{0}",resultSetCount));
- while (reader.Read())
- {
- recordCounter++;
- }
- //this.Log(string.Format("recordCounter:{0}",recordCounter));
- if (resultSetCount != 2)
- {
- Compare(recordCounter,1); //Insert + update
- }
- else
- {
- Compare(recordCounter,0); //Delete
- }
-
- recordCounter=0;
- resultSetCount++;
- }while (reader.NextResult());
-
- Compare(resultSetCount,3);
- }
- catch (Exception ex)
- {
- exp=ex;
- }
- finally
- {
- EndCase(exp);
- if (reader != null) reader.Close();
- tr.Commit();
- con.Close();
- }
- }
- [Test]
- public void TestCompoundVariable()
- {
- OracleDataReader rdr = null;
- if (ConnectedDataProvider.GetDbType(con) == DataBaseServer.PostgreSQL)
- {
- this.Log("not testing PostgreSQL");
- return;
- }
-
- Exception exp = null;
- try
- {
- BeginCase("Check sql statement that declares a local variable and uses it.");
-
- if (con.State != ConnectionState.Open)
- {
- con.Open();
- }
-
- string sqlTxt = "";
- switch (ConnectedDataProvider.GetDbType(cmd.Connection))
- {
- case DataBaseServer.SQLServer:
- sqlTxt = "declare @var int; select @var=1;";
- break;
- case DataBaseServer.Sybase:
- sqlTxt = "declare @var int select @var=1";
- break;
- case DataBaseServer.Oracle:
- sqlTxt = "declare var int;begin var:=1;end;";
- break;
- case DataBaseServer.DB2:
- sqlTxt = "begin atomic declare var integer; set var = 1; end";
- break;
- case DataBaseServer.PostgreSQL:
- // we don't know how the heck to do this in PostgreSQL
- sqlTxt = "";
- break;
- default:
- throw new ApplicationException(string.Format("GHT: Unknown DataBaseServer '{0}'", ConnectedDataProvider.GetDbType(cmd.Connection)));
- }
- cmd.CommandText = sqlTxt;
- rdr = cmd.ExecuteReader();
- Compare(rdr.Read(), false);
- }
- catch(Exception ex){exp = ex;}
- finally
- {
- if (rdr != null) rdr.Close();
- EndCase(exp);
- exp = null;
- }
- }
- }
-
-} \ No newline at end of file
generated by cgit v1.2.3 (git 2.25.1) at 2024-07-28 11:27:16 +0300