Databases
StackOverflow2013
Postsdbo
POParsing dictionary-like URL parameters in Python
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POParsing dictionary-like URL parameters in Python
    primarykey
    data
    text
    <p>I'm working on implementing server-side filtering to serve KendoUI's Grid component, using Python.</p> <p>The problem I'm facing is that the AJAX call that it generates by default seems to be incompatible with both Flask's built-in URL parser and Python's <code>urlparse</code> module.</p> <p>Here's a contrived sample of the type of query string I'm having trouble with: <code>a=b&amp;c=d&amp;foo[bar]=baz&amp;foo[baz]=qis&amp;foo[qis]=bar</code></p> <p>Here's the result I'm going for:</p> <pre><code>{ 'a': 'b', 'c': 'd', 'foo': { 'bar': 'baz', 'baz': 'qis', 'qis': bar' } } </code></pre> <p>Unfortunately, here's the <code>request.args</code> you get from this, if passed to a Flask endpoint:</p> <pre><code>{ 'a': 'b', 'c': 'd', 'foo[bar]': 'baz' 'foo[baz]': 'qis' 'foo[qis]': 'bar' } </code></pre> <p>Worse yet, in practice, the structure can be several layers deep. A basic call where you're filtering the column <code>foo</code> to only rows where the value is equal to <code>'bar'</code> will produce the following:</p> <pre><code>{ 'filter[logic]': 'and', 'filter[filters][0][value]': 'bar', 'filter[filters][0][field]': 'foo', 'filter[filters][0][operator]': 'eq' } </code></pre> <p>I checked the RFC, and it requires that the query string contain only "non-hierarchical" data. While I believe it's referring to the object the URI represents, there is no provision for this type of data structure in the specification that I can find.</p> <p>I begin to write a function that would take a dictionary of params and return the nested construct they represented, but I soon realized that it was nuanced problem, and that surely someone out there has had this trouble before.</p> <p>Is anyone aware of either a module that will parse these parameters in the way I'm wanting, or an elegant way to parse them that I've perhaps overlooked?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USLyndsy Simon
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POParsing dictionary-like URL parameters in Python
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POParsing dictionary-like URL parameters in Python
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POParsing dictionary-like URL parameters in Python
      1. This table or related slice is empty.
      1. VTUpMod
    1. COMust be GET parameters only? A JSON format is not good?
      singulars
      1. POParsing dictionary-like URL parameters in Python
      1. USJimmy Kane
    2. COPossible duplicate of http://stackoverflow.com/questions/7940085/getting-the-array-of-get-params-in-python
      singulars
      1. POParsing dictionary-like URL parameters in Python
      1. USNick ODell
    3. COWell, kendoUI's Grid tries to use a GET param by default, for one. You might be able to override that, but it also seems to break the RESTful paradigm as well - sending JSON would require a POST, and you're not updating anything, only getting a list of items. (I could be WAY off base, so feel free to correct me)
      singulars
      1. POParsing dictionary-like URL parameters in Python
      1. USLyndsy Simon
 

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