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 / faq_demo.ttl
Created July 8, 2022 19:43
### TURTLE START ###
PREFIX : <https://help.twitter.com/en/using-twitter/cotweets#>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
:cotweet
a schema:Question;
rdfs:label """What’s a CoTweet?"""^^xsd:string;
schema:acceptedAnswer :cotweet-answer.
@danielhmills
danielhmills / rdf_collection_demo_1.ttl
Last active June 8, 2022 19:31
RDF Collection Demo: Trip
## Turtle Start ##
@prefix: <#>.
:A :route ([:to :B; :distance 50] );
:route ([:to :C; :distance 50]);
:route ([:to :D; :distance 20]).
:C a :Place;
:route ([:to :E; :distance 20] ).
@danielhmills
danielhmills / gist:45cf502a5929c8268e094837dfa0505a
Created July 30, 2021 05:04
Cleansing Date Column w/ DATATYPE()
SELECT *
WHERE
{
?s dbp:birthDate ?birth.
FILTER(DATATYPE(?birth) = xsd:date)
}
LIMIT 10
@danielhmills
danielhmills / virtuoso_logstash_jdbc_plugin_example
Created May 21, 2021 03:16
input {
jdbc {
jdbc_driver_library => "/path_to_virtuoso_jdbc_driver/virtjdbc4.jar"
jdbc_driver_class => "Java::virtuoso.jdbc4.Driver"
jdbc_connection_string => "jdbc:virtuoso://localhost:1111"
jdbc_user => "{Username}"
jdbc_password => "{Password}"
#SPARQL-Within-SQL Example
statement => "SELECT CAST(X.s as varchar) AS test FROM (SPARQL SELECT ?s WHERE {?s ?p ?o} LIMIT 10) as X"
@danielhmills
danielhmills / odbc-dsn-creation.txt
Created March 10, 2021 19:42
[Local Virtuoso Demo PyODBC]
Driver = /opt/virtuoso/lib/virtodbcu_r.so
Address = localhost:21118
PWDClearText = 0
LastUser = dba
DayLight = Yes
RoundRobin = No
NoSystemTables = No
TreatViewsAsTables = No
WideAsUTF16 = Yes
@danielhmills
danielhmills / virtuoso-aws-neptune-test-query
Created March 8, 2021 16:57
SPARQL
SELECT *
WHERE
{
SERVICE <https://yyour-neptune-instance.ct2pgivua9wd.us-east-1.neptune.amazonaws.com:8182/sparql>
{
?s ?p ?o
}
}
LIMIT 1
@danielhmills
danielhmills / sql_view_pyodbc.py
Created February 25, 2021 02:42
import pyodbc as db
q = "SELECT * FROM demo..company"
cnxn = db.connect("DSN=Demo DB;UID=vdb;PWD=vdb")
cursor=cnxn.cursor()
cursor.execute(q)
row=cursor.fetchall()
if row:
print(row)
@danielhmills
danielhmills / spasql_view_select.sql
Created February 24, 2021 14:50
SELECT * FROM demo.dbpedia.company
@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 *
@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').
}