Alternative vertical output for v.db.select

[landam]

Reported by nikosa on 29 Jul 2013 13:20 UTC 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      (rvision 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.''

GRASS GIS version and provenance

svn-trunk

Migrated-From: https://trac.osgeo.org/grass/ticket/2049

[landam]

Modified by @landam on 12 May 2016 06:44 UTC

[landam]

Modified by @landam on 25 Aug 2016 15:51 UTC

[landam]

Comment by @landam on 27 Aug 2016 13:42 UTC Milestone renamed

[landam]

Comment by neteler on 26 Jan 2018 11:40 UTC Ticket retargeted after milestone closed

[landam]

Modified by neteler on 12 Jun 2018 20:48 UTC

[landam]

Comment by @landam on 25 Sep 2018 16:53 UTC All enhancement tickets should be assigned to 7.6 milestone.

[landam]

Comment by @landam on 25 Jan 2019 21:08 UTC Ticket retargeted after milestone closed