28:null 29:["$","title",null,{"children":"V3 Document Manager | fidel | Observable"}] 2e:[] 2c:{"id":"5dc44202854bd482","slug":"v3-document-manager","title":"V3 Document Manager","thumbnail":"a360f209624d83ebb8badd5ee7725ee23e0737cf2eeeaef4e78b85a559993173","access_level":"public","create_time":"$D2021-04-26T13:09:38.602Z","update_time":"$D2021-07-19T15:36:05.588Z","view_time":null,"first_public_time":"$D2021-04-28T09:18:46.764Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"8611c7650cb0e350","login":"fidel","name":"fidel","avatar_url":"https://avatars-next.observableusercontent.com/909b72f472080f40fc914af43bed4f59fb217b8f3820d0ef803c7eae943c6a94","tier":"starter_2024"},"version":549,"publish_version":549,"role":null,"authored":false,"authors":[{"type":"individual","id":"78ac84bfdcd0eea1","login":"fidel","name":"fidel","avatar_url":"https://avatars-next.observableusercontent.com/909b72f472080f40fc914af43bed4f59fb217b8f3820d0ef803c7eae943c6a94","tier":null}],"members":[{"type":"individual","id":"78ac84bfdcd0eea1","login":"fidel","name":"fidel","avatar_url":"https://avatars-next.observableusercontent.com/909b72f472080f40fc914af43bed4f59fb217b8f3820d0ef803c7eae943c6a94","tier":null,"role":"editor"},{"type":"individual","id":"acca1e7ec5960d3d","login":"nadiz","name":"nadia zeissig","avatar_url":"https://avatars-next.observableusercontent.com/c93330a118661ef6a90de4c99f6c058e47c20afcd7079aebfad2fe27c4aff302","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":{"id":"1812fd9f4388106d","slug":"v3","title":"V3","owner":{"id":"8611c7650cb0e350","login":"fidel","name":"fidel"}},"type":"notebook","body":{"title":"V3 Document Manager","cells":[{"id":0,"value":"md`# V3 Document Manager`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":19,"value":"md`## Select Database`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":141,"value":"md`## Add Document`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":151,"value":"viewof newDoc = {\n return form(html``)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":306,"value":"viewof addDocument = Button(`add document`, {value: '', reduce: async () => {\n return await postDocument(newDoc, doctype)\n}})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":318,"value":"addDocument","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":479,"value":"md`## Search and Select`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":477,"value":"viewof searchTerm = Text({placeholder: \"search term\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":484,"value":"viewof results = Table(searchResults)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":526,"value":"md`## Delete Documents\n\nsearch and select for documents to delete above`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":536,"value":"deleteDocumentsButton","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":546,"value":"md`## Helpers and Methods`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":493,"value":"searchResults = await search(searchTerm)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":158,"value":"md`## UI Constructors`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":144,"value":"md`## Imports`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"import { Client, query, WOQL } from '@fidelthomet/terminusdb-utils'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":8,"value":"import {Button, Text, Table, Select} from '@observablehq/inputs'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":147,"value":"import {form} from '@mbostock/form-input'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W2e","stdlib":"1","titling":"auto"}} 2d:"$2c:body"