[H2-commits] r1116 - in humano2/trunk/core: db/pgsql schema/pgsql

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

Author: marijn
Date: 2005-05-20 16:18:52 -0400 (Fri, 20 May 2005)
New Revision: 1116

Modified:
   humano2/trunk/core/db/pgsql/pgsqlComplex.cs
   humano2/trunk/core/db/pgsql/pgsqlCrud.cs
   humano2/trunk/core/schema/pgsql/pgsql-1-metadata.sql
   humano2/trunk/core/schema/pgsql/pgsql-4-extendedAttributes.sql
Log:
 * Removing datatypes that are not correctly defined yet by marking them =
"isHidden"
 * Adding information about what to change to get these functions.


Modified: humano2/trunk/core/db/pgsql/pgsqlComplex.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/trunk/core/db/pgsql/pgsqlComplex.cs	2005-05-20 17:21:06 UTC (=
rev 1115)
+++ humano2/trunk/core/db/pgsql/pgsqlComplex.cs	2005-05-20 20:18:52 UTC (=
rev 1116)
@@ -432,9 +432,7 @@
 				name =3D var[0];
 				name =3D name.Substring(name.IndexOf(".")+1);
 				if ((loop > 0) && (name =3D=3D "id_entity")) name =3D name + loop.To=
String();
-				//name =3D var[0].Replace(".","_");
-				//name =3D name.Replace("\"","");
-				//name =3D "\"" + name + "\"";
+				//FIXME: This "AttributeTypeMapping" needs to change to support dyna=
mic derived types in view.
 				type =3D core.Crud.AttributeTypeMapping(var[2].ToString());
 				if (type =3D=3D null) type =3D var[2].ToString();
 				table.Append(name + " " + type + ",");

Modified: humano2/trunk/core/db/pgsql/pgsqlCrud.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/trunk/core/db/pgsql/pgsqlCrud.cs	2005-05-20 17:21:06 UTC (rev=
 1115)
+++ humano2/trunk/core/db/pgsql/pgsqlCrud.cs	2005-05-20 20:18:52 UTC (rev=
 1116)
@@ -46,6 +46,9 @@
 			map.Add( "numeric", "numeric" );
 			map.Add( "boolean", "boolean" );
 			map.Add( "dateTime", "timestamp" );
+
+			//map.Add( "file", "varchar" ); // does not work anyway.
+			//map.Add( "image", "varchar" ); // don't work anyway.
 			return map;
 		}
 	=09

Modified: humano2/trunk/core/schema/pgsql/pgsql-1-metadata.sql
=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/trunk/core/schema/pgsql/pgsql-1-metadata.sql	2005-05-20 17:21=
:06 UTC (rev 1115)
+++ humano2/trunk/core/schema/pgsql/pgsql-1-metadata.sql	2005-05-20 20:18=
:52 UTC (rev 1116)
@@ -245,7 +245,7 @@
 INSERT INTO "class"  ("id_entity","classType","sysName","name","parentId=
","isAbstract", "isHidden")  VALUES (14,1,'inheritance','inheritance',5,'=
f', 't');
 INSERT INTO "class"  ("id_entity","classType","sysName","name","parentId=
","isAbstract", "isHidden")  VALUES (15,1,'choice','choice',81,'f', 't');
 INSERT INTO "class"  ("id_entity","classType","sysName","name","parentId=
","isAbstract", "isHidden")  VALUES (26,27,'user_domain','user_domain',3,=
'f', 'f');
-INSERT INTO "class"  ("id_entity","classType","sysName","name","parentId=
","isAbstract", "isHidden")  VALUES (39,1,'file','file',5,'f', 'f');
+INSERT INTO "class"  ("id_entity","classType","sysName","name","parentId=
","isAbstract", "isHidden")  VALUES (39,1,'file','file',5,'f', 't');
 INSERT INTO "class"  ("id_entity","classType","sysName","name","parentId=
","isAbstract", "isHidden")  VALUES (80,1, 'option','option',3,'f', 'f');
 INSERT INTO "class"  ("id_entity","classType","sysName","name","parentId=
","isAbstract", "isHidden")  VALUES (81,1,'pertinence','pertinence',5,'f'=
, 'f');
 INSERT INTO "class"  ("id_entity","classType","sysName","name","parentId=
","isAbstract", "isHidden")  VALUES (82,1,'boolean','boolean',5,'f', 'f')=
;

Modified: humano2/trunk/core/schema/pgsql/pgsql-4-extendedAttributes.sql
=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/trunk/core/schema/pgsql/pgsql-4-extendedAttributes.sql	2005-0=
5-20 17:21:06 UTC (rev 1115)
+++ humano2/trunk/core/schema/pgsql/pgsql-4-extendedAttributes.sql	2005-0=
5-20 20:18:52 UTC (rev 1116)
@@ -76,13 +76,13 @@
 Alter table "image" add  foreign key ("id_entity") references "attribute=
" ("id_entity") on update restrict on delete cascade;
=20
=20
-INSERT INTO "class"  ("id_entity","classType","sysName","name","parentId=
","isAbstract")  VALUES (94,27,'email','email',8,'f');
-INSERT INTO "class"  ("id_entity","classType","sysName","name","parentId=
","isAbstract")  VALUES (87,27,'currency','currency',9,'f');
-INSERT INTO "class"  ("id_entity","classType","sysName","name","parentId=
","isAbstract")  VALUES (500,27, 'password','password',8,'f');
-INSERT INTO "class"  ("id_entity","classType","sysName","name","parentId=
","isAbstract")  VALUES (502,27, 'HTML','HTML',13,'f');
-INSERT INTO "class"  ("id_entity","classType","sysName","name","parentId=
","isAbstract")  VALUES (503,27, 'RUT','RUT',8,'f');
-INSERT INTO "class"  ("id_entity","classType","sysName","name","parentId=
","isAbstract")  VALUES (504,27, 'URL','URL',8,'f');
-INSERT INTO "class"  ("id_entity","classType","sysName","name","parentId=
","isAbstract")  VALUES (506,27, 'image','image',39,'f');
+INSERT INTO "class"  ("id_entity","classType","sysName","name","parentId=
","isAbstract","isHidden")  VALUES (94,27,'email','email',8,'f','t');
+INSERT INTO "class"  ("id_entity","classType","sysName","name","parentId=
","isAbstract","isHidden")  VALUES (87,27,'currency','currency',9,'f','t'=
);
+INSERT INTO "class"  ("id_entity","classType","sysName","name","parentId=
","isAbstract","isHidden")  VALUES (500,27, 'password','password',8,'f','=
t');
+INSERT INTO "class"  ("id_entity","classType","sysName","name","parentId=
","isAbstract","isHidden")  VALUES (502,27, 'HTML','HTML',13,'f','t');
+INSERT INTO "class"  ("id_entity","classType","sysName","name","parentId=
","isAbstract","isHidden")  VALUES (503,27, 'RUT','RUT',8,'f','t');
+INSERT INTO "class"  ("id_entity","classType","sysName","name","parentId=
","isAbstract","isHidden")  VALUES (504,27, 'URL','URL',8,'f','t');
+INSERT INTO "class"  ("id_entity","classType","sysName","name","parentId=
","isAbstract","isHidden")  VALUES (506,27, 'image','image',39,'f','t');
=20
=20
 INSERT INTO "entity"  ("id_entity","domainId","class","delDate","status"=
)  VALUES (87,10,2,NULL,NULL);