Robert Nasarek rnsrk
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # $SERVER_URL=http://http://example.com/rdf4j-server/ | |
| # $REPO_ID=example-repo | |
| # curl -X PUT -H "Content-Type: text/turtle" --data-binary @repo-config.ttl $SERVER_URL/repositories/$REPO_ID | |
| @prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>. | |
| @prefix rep: <http://www.openrdf.org/config/repository#>. | |
| @prefix sr: <http://www.openrdf.org/config/repository/sail#>. | |
| @prefix sail: <http://www.openrdf.org/config/sail#>. | |
| @prefix ms: <http://www.openrdf.org/config/sail/memory#>. |
rnsrk
/ gist:93779848b4150ed40ddd423370ebc2c9
Created
August 2, 2023 07:15
Blazegraph n-quad export command
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Replace <namespace> with your namespace. | |
| curl -X POST "http://localhost:9999/bigdata/namespace/<namespace>/sparql?GETSTMTS&includeInferred=false" > data.nq |
rnsrk
/ fixSolrIndex.bash
Last active
June 7, 2023 07:01
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| # Repairs corrupt Solr index | |
| java -cp /opt/solr/server/solr-webapp/webapp/WEB-INF/lib/lucene-core-8.11.1.jar -ea:org.apache.lucene... org.apache.lucene.index.CheckIndex /var/solr/data/objektkatalogneu/data/index -exorcise |
rnsrk
/ selectMutlipleEIDsFromWisski_salz_id2uri.sql
Last active
January 4, 2024 18:07
Select multiple EID in wisski_salz_id2uri
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # SELECT SQL STATEMENT (SAVE RESULT) | |
| SELECT t1.eid | |
| FROM wisski_salz_id2uri t1 | |
| INNER JOIN ( | |
| SELECT uri, count(eid), adapter_id, rid | |
| FROM wisski_salz_id2uri | |
| GROUP BY uri, adapter_id | |
| HAVING | |
| COUNT(eid) > 1 | |
| AND adapter_id = "boehler_backend") AS t2 |
rnsrk
/ example_wisski_odbc_import_script.xml
Created
April 1, 2022 06:56
Template for ODBC import script, used at Manage > Configure > WissKI ODBC Import (WissKI section). Please set url, database, port, user, password, table name, bundle id and field id to your needs. Check the delimiter as well!
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <server> | |
| <url>localhost</url> | |
| <database>DATABASE_NAME</database> | |
| <port>3306</port> | |
| <user>DATABASE_USER</user> | |
| <password>DATABASE_PASSWORD</password> | |
| <table> | |
| <select>*</select> | |
| <name>TABLE_NAME_IN_DATABASE</name> | |
| <append></append> |
rnsrk
/ form[actions]
Created
February 18, 2022 09:53
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| if ($this->batchStateStaticRevisions) { | |
| $form['actions']['eraseBatch'] = [ | |
| '#type' => 'submit', | |
| '#value' => $this->t('Reset batch state'), | |
| '#button_type' => 'danger', | |
| '#submit' => [[$this->configFactory->getEditable(static::INDIVIDUALS_IN_BATCH), | |
| 'delete', | |
| ], | |
| ], | |
| ]; |
rnsrk
/ ContentEntity.php
Last active
December 7, 2023 22:14
For Search API version 8.x-1.30: Since Search API assumes, that it operates on sql tables, we have to alter some parts of the ContentEntity class at modules\contrib\search_api\src\Plugin\search_api\datasource\ContentEntity.php.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| namespace Drupal\search_api\Plugin\search_api\datasource; | |
| use Drupal\Component\Utility\Crypt; | |
| use Drupal\Core\Access\AccessResult; | |
| use Drupal\Core\Cache\Cache; | |
| use Drupal\Core\Cache\CacheBackendInterface; | |
| use Drupal\Core\Config\ConfigFactoryInterface; | |
| use Drupal\Core\Database\Connection; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| PREFIX ontology_1: <http://ontology_1/> | |
| PREFIX ontology_2: <http://ontology_2/> | |
| PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> | |
| select distinct ?aNote ?bNote ?cNote where { | |
| { | |
| service <https://graphdb.nasarek.org/repositories/Adapter_1> | |
| { | |
| ?A rdf:type ontology_1:E21_Person . | |
| OPTIONAL { | |
| ?A ontology_1:P1_is_identified_by ?a . |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| PREFIX ontology_1: <http://ontology_1/> | |
| PREFIX ontology_2: <http://ontology_2/> | |
| PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> | |
| select distinct ?aNote ?bNote ?cNote where { | |
| { | |
| service <https://graphdb.nasarek.org/repositories/Adapter_1> | |
| { | |
| ?A rdf:type ontology_1:E21_Person ; | |
| ontology_1:P1_is_identified_by ?a ; | |
| ontology_1:P2_has_type ?b . |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| PREFIX ontology_1: <http://ontology_1/> | |
| PREFIX ontology_2: <http://ontology_2/> | |
| PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> | |
| select distinct ?c where { | |
| { | |
| service <https://graphdb.nasarek.org/repositories/Adapter_1> | |
| { | |
| ?a rdf:type ontology_1:E21_Person ; | |
| ontology_1:P1_is_identified_by ?b. | |
| ?b ontology_1:P3_has_note ?c. |
NewerOlder