Skip to content

Instantly share code, notes, and snippets.

View danielhmills's full-sized avatar

Daniel Heward-Mills danielhmills

2 followers · 5 following
View GitHub Profile
@danielhmills
danielhmills / Items.csv
Created August 23, 2019 14:52 — forked from Pablissimo/Items.csv
An extract of the items in Minecraft and recipes to craft them, and the script to do the extract (to be run in Chrome Developer Tools) from http://minecraftsavant.weebly.com
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
Item
Wooden Plank
Stick
Torch
Crafting Table
Furnace
Chest
Wood Pickaxe
Stone Pickaxe
Iron Pickaxe
@danielhmills
danielhmills / pyodbc_with_dsn.py
Created February 16, 2021 21:48
import pyodbc as db
#Define Connection
cnxn = db.connect("DSN=Local Virtuoso;UID=username;PWD=password")
#Define Cursor
cursor = cnxn.cursor()
#Execute Query
cursor.execute('status()')
@danielhmills
danielhmills / pyodbc_with_cnxn_parameters.py
Created February 16, 2021 22:03
import pyodbc as db
cnxn = db.connect("DRIVER=OpenLink Virtuoso ODBC Driver; SERVER=localhost:1111;UID=username;PWD=password;WideAsUTF16=yes")
cursor = cnxn.cursor()
cursor.execute('status()')
row = cursor.fetchall()
if row:
print(row)
@danielhmills
danielhmills / pyodbc_virtuoso_sparql.py
Created February 16, 2021 22:05
import pyodbc as db
cnxn = db.connect("DRIVER=OpenLink Virtuoso ODBC Driver; SERVER=localhost:1111;UID=username;PWD=password;WideAsUTF16=yes")
cursor = cnxn.cursor()
cursor.execute('SPARQL SELECT * WHERE {?s ?p ?o} LIMIT 5')
row = cursor.fetchall()
if row:
print(row)
@danielhmills
danielhmills / sparql_fed_dbpedia.sql
Last active February 17, 2021 17:46
PREFIX dbr: <http://dbpedia.org/resource/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
prefix ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX dbo: <http://dbpedia.org/ontology/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT DISTINCT
?actor
@danielhmills
danielhmills / sparql_fed_dbpedia_and_wikidata.txt
Last active February 17, 2021 19:37
PREFIX dbr: <http://dbpedia.org/resource/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
prefix ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX dbo: <http://dbpedia.org/ontology/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT DISTINCT
?actor
@danielhmills
danielhmills / sparql_to_cypher_via_jdbc.cypher
Last active February 24, 2021 20:10
//Declare JDBC Connection URL and SPARQL-Within-SQL (SPASQL) Payload
WITH 'jdbc:openlink://ODBC/DSN=demo_db/UID=vdb/PWD=vdb' AS c,
"
SELECT * FROM demo.dbpedia_wikidata.query
" AS q
CALL apoc.load.jdbc(c,q) YIELD row
//Create Node for RDJ
@danielhmills
danielhmills / spasql_view.sql
Last active February 19, 2021 06:01
CREATE VIEW demo.dbpedia_wikidata.query
AS
(
SPARQL
PREFIX dbr: <http://dbpedia.org/resource/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
prefix ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX dbo: <http://dbpedia.org/ontology/>
@danielhmills
danielhmills / spasql_view_dbpedia_query.txt
Created February 24, 2021 14:17
SELECT *
WHERE
{
?company dbp:type <http://dbpedia.org/resource/Public_company>;
rdfs:label ?companyName;
dbo:industry dbr:Automobile;
dbo:product/rdfs:label ?product.
FILTER(lang(?companyName)= 'en' && lang(?product) = 'en').
}
@danielhmills
danielhmills / spasql_view_dbpedia.txt
Created February 24, 2021 14:31
CREATE VIEW demo.dbpedia.company
AS
(
SPARQL
PREFIX dbr: <http://dbpedia.org/resource/>
PREFIX dbp: <http://dbpedia.org/property/>
PREFIX dbo: <http://dbpedia.org/ontology/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT *