Skip to content

Latest commit

 

History

History
55 lines (50 loc) · 1.41 KB

database_example.md

File metadata and controls

55 lines (50 loc) · 1.41 KB
Raw

Database example

This is an example of what the database "schema" could look like:

Databases:

  • maintenance-thing
    • Contains everything!
    • document IDs like: Thing:cbc39c8d-b65e-435b-ba84-532f06be7a82 (supports partitioning)
      • Thing -> Thing:
      • ThingLink -> ThingLink:

ThingLink here:

{
  "_id": "myid",
  "_rev": "...",
  "data": {
    "type": "thinkLink",
    "data": {
      "thingA": {
        "uuid": "..."
      },
      "thingB": {
        "uuid": "..."
      },
      "data": {
        "type": "container"
      }
    }
  }
}

View for thinglinks: (using https://docs.couchdb.org/en/stable/ddocs/views/joins.html)

function(doc) {
    var type = doc.data.type;
    if (type === "thing") {
        emit([doc._id, 1], null);
    } else if (type === "thing_link") {
        var things = [, doc.data.data.thingB];
        // emit things
        // using the sorting token of 20 represents that this is needed when querying for a certain UUID, but doesn't represent the value of that UUID
        emit([doc.data.data.thingA.uuid, 2], { _id: doc.data.data.thingB.uuid });
        emit([doc.data.data.thingB.uuid, 2], { _id: doc.data.data.thingA.uuid });
        
        // emit thing links
        emit([doc.data.data.thingA.uuid, 3], null);
        emit([doc.data.data.thingB.uuid, 3], null);
    }
}

Then do a query ...?key=<my thing UUID>

  • Find the Thing
  • Find all its