Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I would use <a href="https://github.com/clojure/data.zip" rel="nofollow noreferrer">data.zip</a> (Formerly clojure.contrib.zip-filter). It provides a lot of xml-parsing power and it's easily capable of performing xpath like expressions. The README describes it as a <em>System for filtering trees, and XML trees in particular</em>.</p> <p>Below I have some sample code for creating a "row" for the CSV file. The row is a map of the column name to the attribute value.</p> <pre><code>(ns work (:require [clojure.xml :as xml] [clojure.zip :as zip] [clojure.contrib.zip-filter.xml :as zf])) ; create a zip from the xml file (def zip (zip/xml-zip (xml/parse "data.xml"))) ; pulls out a list of all of the root "Id" attribute values (zf/xml-&gt; zip (zf/attr :Id)) (defn value [xvar-zip] "Finds the id and value for a particular element" (let [id (-&gt; xvar-zip zip/node :attrs :Id) ; manual access value (zf/xml1-&gt; xvar-zip ; use xpath like expression to pull value out :Row ; need the row element :Col ; then the column element (zf/attr :Value))] ; and finally pull the Value out {id value})) ; gets the "column-value" pair for a single column (zf/xml1-&gt; zip (zf/attr= :Id "cdx9") ; filter on id "cdx9" :XVar ; filter on XVars under it (zf/attr= :Id "TrancheAnalysis.IndexDuration") ; filter on id value) ; apply the value function on the result of above ; creates a map of every column key to it's corresponding value (apply merge (zf/xml-&gt; zip (zf/attr= :Id "cdx9") :XVar value)) </code></pre> <p>I'm not sure how the xml would work with multiple Dictionary XVars, as it is a root element. If you need to, one of the other functions which is useful for this type of work is <code>mapcat</code>, which <code>cat</code>s all of the values returned from the mapping function.</p> <p>There are some more examples in the <a href="https://github.com/clojure/data.zip/blob/master/src/test/clojure/clojure/data/zip/xml_test.clj" rel="nofollow noreferrer">test source</a> as well.</p> <p>One other big recommendation I have is to make sure you use a lot of small functions. You'll find things much easier to debug, test, and work with.</p>
    singulars
    1. This table or related slice is empty.
    1. POparsing XML in clojure
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USDaniel Canas
    1. USdeterb
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POparsing XML in clojure
      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. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThis answer should be updated to reflect the change to data.zip: https://github.com/clojure/data.zip/
      singulars
      1. PO
      1. USdgorissen
 

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