[Andro-hacker] SF.net SVN: andro:[974] trunk/andro/application/androBuild.php

[<ken...@us...>]

Revision: 974
          http://andro.svn.sourceforge.net/andro/?rev=974&view=rev
Author:   kendowns
Date:     2008-12-21 02:07:58 +0000 (Sun, 21 Dec 2008)

Log Message:
-----------
1) Corrected glitch in PHP dd generation that was not putting projection column in order

2) Amazing nifty feature: you can now put projections into configapp_extra, and they will be put over into configapp.  This lets us use the "onerow" x6 profile for application configuration.

Modified Paths:
--------------
    trunk/andro/application/androBuild.php

Modified: trunk/andro/application/androBuild.php
===================================================================
--- trunk/andro/application/androBuild.php	2008-12-19 14:55:22 UTC (rev 973)
+++ trunk/andro/application/androBuild.php	2008-12-21 02:07:58 UTC (rev 974)
@@ -1948,7 +1948,20 @@
                             WHERE x.table_id = 'configapp'
                               AND x.column_id= zdd.tabflat.column_id)"
     );
+    $this->SQL("
+        insert into zdd.tabproj (projection,table_id) 
+         select projection,'configapp'
+           from zdd.tabproj
+           where zdd.tabproj.table_id = 'configapp_extra'"
+    );
+    $this->SQL("
+        insert into zdd.tabprojcols (projection,table_id,column_id) 
+         select projection,'configapp',column_id
+           from zdd.tabprojcols
+           where zdd.tabprojcols.table_id = 'configapp_extra'"
+    );
 
+    
     #  Define the sql
     $sq="INSERT INTO zdd.tabflat (table_id,$colslist)
          SELECT '*TABLEDEST*',$colslist
@@ -8743,7 +8756,7 @@
 			" FROM zdd.tabprojcols p ".
 			" JOIN zdd.tabflat f ON p.table_id=f.table_id AND p.column_id = f.column_id ".
 			" WHERE p.table_id = '$table_id' ".
-			" ORDER BY p.uicolseq ");
+			" ORDER BY f.uicolseq ");
 		while ($row = pg_fetch_array($results)) {
 			$p = trim($row["projection"]);
 			if (!isset($table["projections"][$p])) $table["projections"][$p]="";


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.