Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>There are two parts to doing this, at least in my solution, however you will need this function (thanks to the guys at cl-prevalence for this (<strong>warn LLGPL</strong>)</p> <pre><code>(defun get-slots (object) ;; thanks to cl-prevalence #+openmcl (mapcar #'ccl:slot-definition-name (#-openmcl-native-threads ccl:class-instance-slots #+openmcl-native-threads ccl:class-slots (class-of object))) #+cmu (mapcar #'pcl:slot-definition-name (pcl:class-slots (class-of object))) #+sbcl (mapcar #'sb-pcl:slot-definition-name (sb-pcl:class-slots (class-of object))) #+lispworks (mapcar #'hcl:slot-definition-name (hcl:class-slots (class-of object))) #+allegro (mapcar #'mop:slot-definition-name (mop:class-slots (class-of object))) #+sbcl (mapcar #'sb-mop:slot-definition-name (sb-mop:class-slots (class-of object))) #+clisp (mapcar #'clos:slot-definition-name (clos:class-slots (class-of object))) #-(or openmcl cmu lispworks allegro sbcl clisp) (error "not yet implemented")) </code></pre> <p>Then, for reading you will need to run this piece of code, which sets up 1/2 of the syntax which is <code>{ type-of-object ((slot-name . slot-value) (slot-name . slot-value) ...)</code> </p> <pre><code>(set-macro-character #\{ #'(lambda (str char) (declare (ignore char)) (let ((list (read-delimited-list #\} str t))) (let ((type (first list)) (list (second list))) (let ((class (allocate-instance (find-class type)))) (loop for i in list do (setf (slot-value class (car i)) (cdr i))) class))))) </code></pre> <p>For printing, use</p> <pre><code>(defmethod print-object ((object standard-object) stream) (format stream "{ ~s ~s}" (type-of object) (loop for i in (get-slots object) collect (cons i (slot-value object i))))) </code></pre> <p>A <code>*print-readably*</code> is highly recommended when using all these methods. Also, note that circular relationships are untested </p>
    singulars
    1. This table or related slice is empty.
    1. POMake clos objects printable in lisp
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USkrzysz00
    1. USkrzysz00
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POMake clos objects printable in lisp
      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. COyou should have a balanced external representation. Currently you have an opening character, but no corresponding closing character. For reading then see for example READ-DELIMITED-LIST. See the example at http://www.lispworks.com/documentation/lw50/CLHS/Body/f_rd_del.htm .
      singulars
      1. PO
      1. USRainer Joswig
    2. COmaybe you're right, but it serves well for my purposes as there **must** be **exactly** two objects after the {
      singulars
      1. PO
      1. USkrzysz00
    3. COyes, but it will confuse all editors. s-expressions should be balanced. It's a simple change anyway.
      singulars
      1. PO
      1. USRainer Joswig
 

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