Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I don't think there's a general, cross-platform way to "get the width of the terminal" -- <strong>most definitely NOT</strong> "look at the COLUMNS environment variable" (see my comment on the question). On Linux and Mac OS X (and I expect all modern Unix versions),</p> <pre><code>curses.wrapper(lambda _: curses.tigetnum('cols')) </code></pre> <p>returns the number of columns; but I don't know if <a href="http://code.google.com/p/wcurses/" rel="nofollow noreferrer">wcurses</a> supports this in Windows.</p> <p>Once you do have (from os.environ['COLUMNS'] if you insist, or via curses, or from an oracle, or defaulted to 80, or any other way you like) the desired output width, the rest is quite feasible. It's finnicky work, with many chances for off-by-one kinds of errors, and very vulnerable to a lot of detailed specs that you don't make entirely clear, such as: which column gets cut to avoid wrapping -- it it always the last one, or...? How come you're showing 3 columns in the sample output when according to your question only two are passed in...? what is supposed to happen if not all rows have the same number of columns? must all entries in table be strings? and many, many other mysteries of this ilk.</p> <p>So, taking somewhat-arbitrary guesses for all the specs that you don't express, one approach might be something like...:</p> <pre><code>import sys def colprint(totwidth, table): numcols = max(len(row) for row in table) # ensure all rows have &gt;= numcols columns, maybe empty padded = [row+numcols*('',) for row in table] # compute col widths, including separating space (except for last one) widths = [ 1 + max(len(x) for x in column) for column in zip(*padded)] widths[-1] -= 1 # drop or truncate columns from the right in order to fit while sum(widths) &gt; totwidth: mustlose = sum(widths) - totwidth if widths[-1] &lt;= mustlose: del widths[-1] else: widths[-1] -= mustlose break # and finally, the output phase! for row in padded: for w, i in zip(widths, row): sys.stdout.write('%*s' % (-w, i[:w])) sys.stdout.write('\n') </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POapt like column output - python library
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USmartineau
    1. USAlex Martelli
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POapt like column output - python library
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COAs for the assumptions, generally speaking ... the output will be similar to 'aptitude search' in that 1) only the last column (which is the only column with the longest string in a row) is to be trimmed, 2) there are typically 2-4 columns only, but the last column ("description") is expected to take at least half the terminal width. 3) all rows contain equal number of columns, 4) all entries are strings only
      singulars
      1. PO
      1. USSridhar Ratnakumar
    2. COYou may want to **format** the code which is appearing without line breaks and indentation.
      singulars
      1. PO
      1. USSridhar Ratnakumar
    3. CO@Sridhar, tx for the heads-up on formatting (I fixed by editing the response as soon as I saw your comment 2 hrs ago). My code should meet all the specs you now give, btw -- they were roughly my guesses; try it out.
      singulars
      1. PO
      1. USAlex Martelli
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload