Changeset 3d69c4d in tol

Timestamp:

Mar 12, 2009, 8:25:00 PM (18 years ago)

Author:

Víctor de Buen <vdebuen@…>

Branches:

1941-docker-image-to-test, devel, master

Children:

7cdaf52

Parents:

374ca56

Message:

New engine Teradata

git-svn-id: ​https://www.tol-project.org/svn/tolp/trunk@758 be4846ae-f051-483a-831f-b64e7d08527f

Location:

tol/stdlib/data/db/engine

Files:

• _constants.tol (added)
• _ini_engine.tol (modified) (2 diffs)
• _sql.tol (modified) (5 diffs)
• _sqlred.tol (added)

tol/stdlib/data/db/engine/_ini_engine.tol

@@ -10 +10 @@
   Set _SqlEngine =
   [[
+    Set Include("_constants.tol");
     Set Include("_sqltools.tol");
     Set Include("_sqlpos.tol");
@@ -15 +16 @@
     Set Include("_sqlmic.tol");
     Set Include("_sqlmys.tol");
+    Set Include("_sqlred.tol");
     Set Include("_sqlter.tol");
     //Set Include("_sqlacc.tol");

tol/stdlib/data/db/engine/_sql.tol

@@ -85 +85 @@
 };
 
-//////////////////////////////////////////////////////////////////////////////
-// CONSTANTS
-//////////////////////////////////////////////////////////////////////////////
-Real GesMic = 0;
-Real GesOra = 1;
-Real GesMys = 2;
-Real GesAcc = 3;
-Real GesPos = 4;
-Real GesTer = 5;
 
 //////////////////////////////////////////////////////////////////////////////
@@ -181 +172 @@
     EQ(gestor, GesOra), [[ "", "||" ]],
     EQ(gestor, GesMys), [[ "concat", "," ]],
+    EQ(gestor, GesRed), [[ "concat", "," ]],
     EQ(gestor, GesPos), [[ "", "||" ]], 
     EQ(gestor, GesAcc), [[ "", "&" ]]
@@ -200 +192 @@
     EQ(gestor, GesOra), "nvl",
     EQ(gestor, GesMys), "IfNull", 
+    EQ(gestor, GesRed), "IfNull", 
     EQ(gestor, GesPos), "coalesce",
     EQ(gestor, GesTer), "coalesce",
@@ -443 +436 @@
     EQ(gestor, GesPos), "cast("+ txt +" as char varying)",
     EQ(gestor, GesTer), "rtrim(cast("+ txt +" as char(255)))",    
+    EQ(gestor, GesRed), "trim(string("+ txt +"))",    
     EQ(gestor, GesAcc), "SqlConvertText. Access. Opción por implementar."
   );
@@ -578 +572 @@
     EQ(gestor, GesPos), "Pos",
     EQ(gestor, GesTer), "Ter",
+    EQ(gestor, GesRed), "Red",
     True, ""
   );