Opened 9 years ago

Last modified 4 years ago

#2049 new enhancement

Alternative vertical output for v.db.select

Reported by: Nikos Alexandris Owned by: grass-dev@…
Priority: minor Milestone: 7.6.2
Component: Database Version: svn-trunk
Keywords: v.db.select, output, vertical, separator Cc:
CPU: Unspecified Platform: Unspecified

Description

A request to add an(other) alternative output format in v.db.select 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.

Change History (8)

comment:1 by martinl, 6 years ago

Milestone: 7.0.07.0.5

comment:2 by martinl, 6 years ago

Milestone: 7.0.57.3.0

comment:3 by martinl, 6 years ago

Milestone: 7.3.07.4.0

Milestone renamed

comment:4 by neteler, 5 years ago

Milestone: 7.4.07.4.1

Ticket retargeted after milestone closed

comment:5 by neteler, 4 years ago

Milestone: 7.4.17.4.2

comment:6 by martinl, 4 years ago

Milestone: 7.4.27.6.0

All enhancement tickets should be assigned to 7.6 milestone.

comment:7 by martinl, 4 years ago

Milestone: 7.6.07.6.1

Ticket retargeted after milestone closed

comment:8 by martinl, 4 years ago

Milestone: 7.6.17.6.2

Ticket retargeted after milestone closed

Note: See TracTickets for help on using tickets.