31:[] 2f:{"title":"V3 Document Manager","cells":[{"id":0,"value":"md`# V3 Document Manager`","pinned":false,"hidden":false,"mode":"ojs"},{"id":19,"value":"md`## Select Database`","pinned":false,"hidden":false,"mode":"ojs"},{"id":12,"value":"viewof database = Select(Client.databases(), {format: a => a.label, valueof: a => a.id, label: 'select databse'})","pinned":false,"hidden":false,"mode":"ojs"},{"id":141,"value":"md`## Add Document`","pinned":false,"hidden":false,"mode":"ojs"},{"id":66,"value":"viewof doctype = Select(doctypes, {format: a => a.label['@value'], valueof: a => a.doctype, label: 'select doctype'})","pinned":false,"hidden":false,"mode":"ojs"},{"id":151,"value":"viewof newDoc = {\n return form(html``)\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":306,"value":"viewof addDocument = Button(`add document`, {value: '', reduce: async () => {\n return await postDocument(newDoc, doctype)\n}})","pinned":false,"hidden":false,"mode":"ojs"},{"id":318,"value":"addDocument","pinned":false,"hidden":false,"mode":"ojs"},{"id":479,"value":"md`## Search and Select`","pinned":false,"hidden":false,"mode":"ojs"},{"id":477,"value":"viewof searchTerm = Text({placeholder: \"search term\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":484,"value":"viewof results = Table(searchResults)","pinned":false,"hidden":false,"mode":"ojs"},{"id":526,"value":"md`## Delete Documents\n\nsearch and select for documents to delete above`","pinned":true,"hidden":false,"mode":"ojs"},{"id":515,"value":"viewof deleteDocumentsButton = Button(`delete ${results.length} document${results.length === 1 ? '' : 's'}`, {value: '', reduce: async () => {\n return await deleteDocuments(results)\n}})","pinned":false,"hidden":false,"mode":"ojs"},{"id":536,"value":"deleteDocumentsButton","pinned":false,"hidden":false,"mode":"ojs"},{"id":546,"value":"md`## Helpers and Methods`","pinned":false,"hidden":false,"mode":"ojs"},{"id":27,"value":"doctypes = {\n Client.db(database)\n const res = await query(WOQL\n .quad('v:doctype', 'type', 'owl:Class', 'schema/main')\n .quad('v:doctype', 'label', 'v:label', 'schema/main')\n )\n return res.bindings\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":340,"value":"props = {\n Client.db(database)\n const res = await query(WOQL\n .quad('v:id', 'type', 'v:type', 'schema/main')\n .or(\n WOQL.eq('v:type', 'owl:DatatypeProperty'),\n WOQL.eq('v:type', 'owl:ObjectProperty'),\n )\n .select('v:id', WOQL\n .or(\n WOQL\n .quad('v:id', 'rdfs:domain', doctype, 'schema/main'),\n WOQL\n .from(\"schema/*\", WOQL.path(doctype,\"rdfs:subClassOf+\", \"v:parent\", \"v:path\"))\n .quad('v:id', 'rdfs:domain', 'v:parent', 'schema/main')\n .not().eq(\"v:parent\", \"system:Document\")\n )\n )\n .quad('v:id', 'label', 'v:label', 'schema/main')\n .quad('v:id', 'rdfs:range', 'v:range', 'schema/main')\n )\n return flattenBindings(res.bindings)\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":235,"value":"objectPropOptions = {\n const promises = await props\n .filter(prop => prop.type === 'owl:ObjectProperty') // only object props\n .filter((p1, i, all) => all.findIndex(p2 => p1.range === p2.range) === i) // only props w/ distinct ranges\n .map(async prop => {\n return [\n prop.range,\n await getDocumentsOfType(prop.range)\n ]\n })\n const res = await Promise.all(promises).then(r => r)\n return Object.fromEntries(res)\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":249,"value":"async function getDocumentsOfType (doctype) {\n const res = await query(WOQL\n .triple('v:id', 'type', doctype)\n .triple('v:id', 'label', 'v:label')\n )\n return flattenBindings(res.bindings)\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":309,"value":"async function postDocument (doc, doctype) {\n const cleanDoc = Object.fromEntries(\n Object.entries(doc).filter(entry => entry[1] !== \"\")\n ) // remove empty (\"\") props\n if (cleanDoc.id == null) return \"❌ required field `id` missing\"\n cleanDoc.type = doctype\n return await query(\n WOQL.insert_data(cleanDoc)\n )\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":98,"value":"flattenBindings = (bindings) => {\n if (bindings == null) return []\n return bindings.map(b => {\n return Object.fromEntries(Object.keys(b).map(key => {\n const value = b[key]['@value'] != null ? b[key]['@value'] : b[key]\n return [key, replacePrefixes(value)]\n }))\n })\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":112,"value":"replacePrefixes = (value) => {\n prefixes.forEach(prefix => {\n if (typeof value === 'string') {\n value = value.replace(prefix[1], `${prefix[0]}:`)\n }\n })\n return value\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":118,"value":"prefixes = {\n Client.db(database)\n Client._load_db_prefixes()\n const info = Client.databaseInfo()\n return Object.entries({ ...info.prefix_pairs, ...info.jsonld_context })\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":222,"value":"search = async (term, doctype = null) => {\n Client.db(database)\n const res = await query(WOQL.and(\n WOQL\n .select('v:label', 'v:id', 'v:doctype', 'v:dist')\n .limit(10)\n .order_by('v:dist', 'desc')\n .and(\n WOQL.triple('v:id', 'rdfs:label', 'v:label'),\n WOQL.triple('v:id', 'rdf:type', doctype || 'v:doctype'),\n WOQL.like(term, 'v:label', 'v:dist'),\n WOQL.greater('v:dist', 0.5)\n )\n ))\n return flattenBindings(res.bindings)\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":493,"value":"searchResults = await search(searchTerm)","pinned":false,"hidden":false,"mode":"ojs"},{"id":520,"value":"async function deleteDocuments (docs) {\n Client.db(database)\n const res = await query(WOQL\n .and(\n ...docs.map(doc => WOQL.delete_object(doc.id))\n )\n )\n return res\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":158,"value":"md`## UI Constructors`","pinned":false,"hidden":false,"mode":"ojs"},{"id":202,"value":"function input (prop) {\n switch (prop.type) {\n case 'owl:DatatypeProperty':\n return `\n ${prop.label}\n \n `\n case 'owl:ObjectProperty':\n return `\n ${prop.label}\n \n `\n default:\n return ``\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":144,"value":"md`## Imports`","pinned":false,"hidden":false,"mode":"ojs"},{"id":4,"value":"import { Client, query, WOQL } from '@fidelthomet/terminusdb-utils'","pinned":false,"hidden":false,"mode":"ojs"},{"id":8,"value":"import {Button, Text, Table, Select} from '@observablehq/inputs'","pinned":false,"hidden":false,"mode":"ojs"},{"id":147,"value":"import {form} from '@mbostock/form-input'","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}