Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>When a domain object is persisted in MongoDB, it is stored as a document with an <a href="http://docs.mongodb.org/manual/reference/object-id/" rel="nofollow">ObjectId</a> as a unique 12 bytes BSON primary key. For example, if you have a domain object <code>Product</code> like</p> <pre><code>import org.bson.types.ObjectId class Product { ObjectId id String name static mapWith = "mongo" } </code></pre> <p>then the persisted entity in MongoDB would look like below if you save with a name as "TestProduct".</p> <pre><code>//db.product.find() in mongodb { "_id" : ObjectId("51bd047c892c8bf0b3a58b21"), "name" : "TestProduct", "version" : 0 } </code></pre> <p>The <code>_id</code> becomes your primary key for that document. To <code>get</code> this document you need the primary key ObjectId. Speaking from a RESTful context, you atleast need the 12 bytes hexcode <code>51bd047c892c8bf0b3a58b21</code> as part of the request.</p> <p>So in the above case, you can fetch that particular document by doing something like</p> <pre><code>Product.get(new ObjectId("51bd047c892c8bf0b3a58b21")) Product.findById(new ObjectId("51bd047c892c8bf0b3a58b21")) </code></pre> <p>Have a look at the <a href="http://api.mongodb.org/java/2.0/org/bson/types/ObjectId.html" rel="nofollow">API for ObjectId</a> which would make clear how to retrieve a document.</p> <p>When you retrieve the document as JSON, then it just shows the ObjectId class with its elements.</p> <pre><code>{ "class": "com.example.Product", "id": { "class": "org.bson.types.ObjectId", "inc": -1280996575, "machine": -1993569296, "new": false, "time": 1371341948000, "timeSecond": 1371341948 }, "name": "TestProduct" } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POGORM get/find resource by ID using MongoDB in Grails
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USdmahapatro
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POGORM get/find resource by ID using MongoDB in Grails
      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. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COKnowing that the ID should be the 12-byte hex BSON key got me pointed in the right direction. It turns out to be quite easy to generate ID strings from ObjectIDs... just use `.toString()`. And then you can pass the ID string directly to `.get()` as long as the ID string is formatted correctly (`[0-9a-f]{24}`).
      singulars
      1. PO
      1. USDem Pilafian
 

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