[GRASS-dev] [GRASS GIS] #2049: Alternative vertical output for v.db.select

[GRASS GIS]

#2049: Alternative vertical output for v.db.select
------------------------------------------------------+---------------------
 Reporter:  nikosa                                    |       Owner:  grass-dev@…              
     Type:  enhancement                               |      Status:  new                      
 Priority:  minor                                     |   Milestone:  7.0.0                    
Component:  Database                                  |     Version:  svn-trunk                
 Keywords:  v.db.select, output, vertical, separator  |    Platform:  Unspecified              
      Cpu:  Unspecified                               |  
------------------------------------------------------+---------------------
 A request to add an(other) alternative output format in v.db.select
 [http://lists.osgeo.org/pipermail/grass-dev/2013-June/064167.html as
 discussed previously in the mailing list (solution suggested by Moritz
 Lennert)]?

 For example,


 {{{
 v.db.select hospitals col=cat vs=,
 }}}

 should return


 {{{
 cat
 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160
 }}}


 From the discussion in the mailing-list:

 Moritz Lennert: ''I think what Nikos is trying to get as a result would
 rather need a change such as this:''


 {{{
 Index: main.c
 ===================================================================
 --- main.c      (révision 56597)
 +++ main.c      (copie de travail)
 @@ -264,7 +264,10 @@
         }
         else {
             if (!v_flag->answer)
 -               fprintf(stdout, "\n");
 +                if(vs)
 +                    fprintf(stdout, "%s", vs);
 +                else
 +                    fprintf(stdout, "\n");
             else if (vs)
                 fprintf(stdout, "%s\n", vs);
         }
 }}}


 ''which gives you:''


 {{{
 v.db.select hospitals col=cat vs=,
 cat
 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,
 }}}

 ''Just needs some cleanup to get rid of the last ',' at the end.''

-- 
Ticket URL: <http://trac.osgeo.org/grass/ticket/2049>
GRASS GIS <http://grass.osgeo.org>