Databases
StackOverflow2013
Postsdbo
POPython bottle : return JSON and @route attributes related
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPython bottle : return JSON and @route attributes related
    primarykey
    data
    text
    <p>I am trying to write a WSGI app using Python bottle. I installed bottle and now I run it together with Apache's mod_wsgi module, as it is described here : <a href="http://code.google.com/p/modwsgi/wiki/QuickConfigurationGuide" rel="nofollow">http://code.google.com/p/modwsgi/wiki/QuickConfigurationGuide</a></p> <p>What I would like to do is to return a JSON file depending on the URL (request). I managed to do that but I think it is not the right way as it is full of workarounds. What I mean is that <a href="http://code.google.com/p/modwsgi/wiki/QuickConfigurationGuide" rel="nofollow">1</a> I cannot return a JSON variable, because Apache complains about</p> <pre><code>RuntimeError: response has not been started </code></pre> <p><a href="http://webpython.codepoint.net/wsgi_application_interface" rel="nofollow">2</a> mod_wsgi requires my callable object to named like "application" and takes 2 arguments, meaning that I cannot use the "@route" attributes, as it is described here : <a href="http://webpython.codepoint.net/wsgi_application_interface" rel="nofollow">http://webpython.codepoint.net/wsgi_application_interface</a></p> <p>So, for <a href="http://code.google.com/p/modwsgi/wiki/QuickConfigurationGuide" rel="nofollow">1</a> I used the json.dumps method and for <a href="http://webpython.codepoint.net/wsgi_application_interface" rel="nofollow">2</a> I take the route as an environment variable. Could you please enlighten me on how to use the "@route" attribute and the best practices of Python bottle in this case ? How I deal with these 2 issues appears below :</p> <pre><code>#!/usr/bin/python import sys, os, time import json import MySQLdb import bottle import cgi os.chdir( os.path.dirname( __file__ ) ) bottle.debug( True ) application = bottle.default_app( ) @bottle.route( '/wsgi/&lt;parameter&gt;' ) def application( environ, start_response ) : # URL = bottle.request.method URL = environ["PATH_INFO"] status = '200 OK' response_headers = [('Content-type', 'application/json')] start_response( status, response_headers ) demo = { 'status':'online', 'servertime':time.time(), 'url':URL } demo = json.dumps( demo ) return demo </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USuser690182
    1. USuser690182
    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. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COYou are not writing a bottle application here. Your code looks like a bare WSGI application with a bottle decorator in front of it (which makes no sense). You should have a look at the bottle documentation.
      singulars
      1. POPython bottle : return JSON and @route attributes related
      1. USdefnull
    2. CO: thank you defnull for your response, do you know what i am doing wrong regarding the routes ?
      singulars
      1. POPython bottle : return JSON and @route attributes related
      1. USuser690182
 

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