Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I would suggest using one of the many template languages available for python, for example the one <a href="https://docs.djangoproject.com/en/dev/topics/templates/" rel="noreferrer">built into Django</a> (you don't have to use the rest of Django to use its templating engine) - a google query should give you plenty of other alternative template implementations.</p> <p>I find that learning a template library helps in so many ways - whenever you need to generate an e-mail, HTML page, text file or similar, you just write a template, load it with your template library, then let the template code create the finished product. </p> <p>Here's some simple code to get you started:</p> <pre><code>#!/usr/bin/env python from django.template import Template, Context from django.conf import settings settings.configure() # We have to do this to use django templates standalone - see # http://stackoverflow.com/questions/98135/how-do-i-use-django-templates-without-the-rest-of-django # Our template. Could just as easily be stored in a separate file template = """ &lt;html&gt; &lt;head&gt; &lt;title&gt;Template {{ title }}&lt;/title&gt; &lt;/head&gt; &lt;body&gt; Body with {{ mystring }}. &lt;/body&gt; &lt;/html&gt; """ t = Template(template) c = Context({"title": "title from code", "mystring":"string from code"}) print t.render(c) </code></pre> <p>It's even simpler if you have templates on disk - check out the <a href="https://docs.djangoproject.com/en/dev/ref/templates/api/#the-render-to-string-shortcut" rel="noreferrer">render_to_string</a> function that can load templates from disk from a predefined list of search paths, fill with data from a dictory and render to a string - all in one function call.</p>
    singulars
    1. This table or related slice is empty.
    1. POGenerating HTML documents in python
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USErik Forsberg
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    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. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI thought of this, but I don't think it's exactly what the OP is asking for. It sounds like they want to build up the HTML itself programmatically, whereas a template assumes you already have the HTML but just need to fill in some variables.
      singulars
      1. PO
      1. USDaniel Roseman
    2. COIt sounds more like they have the content ready, and then need to paste html around the content. This is exactly what a templating engine is for.
      singulars
      1. PO
      1. USWilduck
    3. COAlso, if you want a templating engine like the one in Django, use Jinja2. It's faster, more powerful, and is a standalone project. http://jinja.pocoo.org/docs/
      singulars
      1. PO
      1. USWilduck
 

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