[H2-commits] r1138 - humano2/tests/fill

[<sv...@de...>]

Author: marijn
Date: 2005-05-24 16:00:27 -0400 (Tue, 24 May 2005)
New Revision: 1138

Modified:
   humano2/tests/fill/Makefile
   humano2/tests/fill/fill.cs
Log:
 * showing error.


Modified: humano2/tests/fill/Makefile
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- humano2/tests/fill/Makefile	2005-05-24 18:55:20 UTC (rev 1137)
+++ humano2/tests/fill/Makefile	2005-05-24 20:00:27 UTC (rev 1138)
@@ -10,5 +10,7 @@
 #
 # $Id$
=20
-all:
-	mcs /r:System,System.Data,Npgsql fill.cs
+all: fill.exe
+
+fill.exe: fill2.cs
+	mcs /r:System,System.Data,Npgsql fill2.cs

Modified: humano2/tests/fill/fill.cs
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- humano2/tests/fill/fill.cs	2005-05-24 18:55:20 UTC (rev 1137)
+++ humano2/tests/fill/fill.cs	2005-05-24 20:00:27 UTC (rev 1138)
@@ -19,28 +19,47 @@
 {
 	public class Runner=20
 	{
-		public static void Main() {
-			string query =3D @" ; select ""to"".id_entity,""to"".""domainName""  =
   from ""entity"" as owner, ""domain"" as ""to""   	where owner.""domain=
Id"" =3D ""to"".id_entity and	owner.id_entity =3D 10003
- ; select ""to"".id_entity,""to"".""name""     from ""entity"" as owner,=
 ""class"" as ""to""   	where owner.""class"" =3D ""to"".id_entity and ow=
ner.id_entity =3D 10003=20
- ; select ""delDate""     from ""entity""	where   ""id_entity"" =3D 1000=
3
- ; select ""status""     from ""entity""	where   ""id_entity"" =3D 10003
- ; select ""createDate""     from ""entity""	where   ""id_entity"" =3D 1=
0003
- ; select ""modDate""     from ""entity""	where   ""id_entity"" =3D 1000=
3
- ; select ""columns""     from ""view""	where   ""id_entity"" =3D 10003
- ; select ""where""     from ""view""	where   ""id_entity"" =3D 10003
- ; select ""groupby""     from ""view""	where   ""id_entity"" =3D 10003
- ; select ""having""     from ""view""	where   ""id_entity"" =3D 10003
- ; select ""order""     from ""view""	where   ""id_entity"" =3D 10003
- ; select ""to"".id_entity,""to"".""name""     from ""view"" as owner,""=
class"" as ""to""   	where owner.""idClassView"" =3D ""to"".id_entity and=
 owner.id_entity =3D 10003
- ; select ""viewName""     from ""view""	where   ""id_entity"" =3D 10003=
";
+		public static void Main()=20
+		{
+			TestOkay();
=20
+			TestError();
+		}
+
+		public static void TestOkay()
+		{
+			string query =3D "";
+//			query +=3D @"select ""to"".id_entity,""to"".""domainName""     from=
 ""entity"" as owner, ""domain"" as ""to""   	where owner.""domainId"" =3D=
 ""to"".id_entity and	owner.id_entity =3D 10003;" + "\n";
+//			query +=3D @"select ""to"".id_entity,""to"".""name""     from ""ent=
ity"" as owner, ""class"" as ""to""   	where owner.""class"" =3D ""to"".i=
d_entity and owner.id_entity =3D 10003;" + "\n";
+ 			query +=3D @"select ""delDate""     from ""entity""	where   ""id_ent=
ity"" =3D 10003;" + "\n";
+			query +=3D @"select ""status""     from ""entity""	where   ""id_entit=
y"" =3D 10003;" + "\n";
+ 			query +=3D @"select ""createDate""     from ""entity""	where   ""id_=
entity"" =3D 10003;" + "\n";
+ 			query +=3D @"select ""modDate""     from ""entity""	where   ""id_ent=
ity"" =3D 10003;" + "\n";
+ 			query +=3D @"select ""columns""     from ""view""	where   ""id_entit=
y"" =3D 10003;" + "\n";
+ 			query +=3D @"select ""where""     from ""view""	where   ""id_entity"=
" =3D 10003;" + "\n";
+ 			query +=3D @"select ""groupby""     from ""view""	where   ""id_entit=
y"" =3D 10003;" + "\n";
+ 			query +=3D @"select ""having""     from ""view""	where   ""id_entity=
"" =3D 10003;" + "\n";
+ 			query +=3D @"select ""order""     from ""view""	where   ""id_entity"=
" =3D 10003;" + "\n";
+ 			query +=3D @"select ""to"".id_entity,""to"".""name""     from ""view=
"" as owner,""class"" as ""to""   	where owner.""idClassView"" =3D ""to""=
.id_entity and owner.id_entity =3D 10003;" + "\n";
+ 			query +=3D @"select ""viewName""     from ""view""	where   ""id_enti=
ty"" =3D 10003";
+
 			FillTest fillTest =3D new FillTest();
+			fillTest.Connect();
+			fillTest.doSelect(query, new DataSet());
+		}
=20
+		public static void TestError()
+		{
+			string query =3D "";
+			query +=3D @"select 'b', 'a';";
+			query +=3D @"select 'a';";
+
+			FillTest fillTest =3D new FillTest();
 			fillTest.Connect();
-	=09
 			fillTest.doSelect(query, new DataSet());
 		}
=20
+
 	}
=20
 	class FillTest=20
@@ -48,13 +67,10 @@
 		protected IDbConnection dbCon =3D null;
 		string ConnectionString =3D "Server=3D10.1.11.106;Database=3Dh2_marijn=
;User ID=3Dh2_dbase;Password=3Dh2_dbase!";
=20
-		public IDbConnection Connect()
+		public void Connect()
 		{
 			IDbConnection c =3D new NpgsqlConnection( ConnectionString );
-			c.Open( );
-			c.Close( );
 			dbCon =3D c;
-			return c;
 		}
=20
 		public DataSet doSelect(string query,DataSet ds)
@@ -64,17 +80,17 @@
 =09
 			NpgsqlDataAdapter da =3D new NpgsqlDataAdapter(query,conn);
 			try
-				{
-					da.Fill(ds);
-				}
+			{
+				da.Fill(ds);
+			}
 			catch(Exception ex)
 			{
 				dbCon.Close();
 				throw new Exception("Error executing query:\r\n" + query + "\n\r" +e=
x.Message,ex.InnerException);
 			}
-			da.Dispose();
=20
-			dbCon.Close();
+			Console.WriteLine("No ERROR");
+
 			return ds;
 =09
 		}