Skip to content

Instantly share code, notes, and snippets.

View yawnston's full-sized avatar
🕴️
oh hi mark

Daniel Crha yawnston

🕴️
oh hi mark
View GitHub Profile
library(data.table)
cry.A = read.table('cry-A.csv', header = FALSE, sep = ';', col.names = c("id", "class", "null"))
cry.A$null = NULL
cry.A = data.table(cry.A)
cry.B = fread("cry-B.csv", header = F, sep = ";", select = c(1,2), col.names = c("id", "class"))
setkey(cry.A, "id")
setkey(cry.B, "id")
  • licenci API netreba resit
  • let registrovat jen autentikovany clen klubu, letat muze kdokoliv
  • co registrovat za info:
    • cas vzletu a pristani
    • kdo leti
    • co za letadlo
    • imatrikulace
    • ukol (libovolny retezec, typicky cisla)
  • cele to je pro jedno letiste
  • fakturacni udaje pro lidi co nezname!
  • licenci API netreba resit
  • let registrovat jen autentikovany clen klubu, letat muze kdokoliv
  • co registrovat za info:
    • cas vzletu a pristani
    • kdo leti
    • co za letadlo
    • imatrikulace
    • ukol (libovolny retezec, typicky cisla)
  • cele to je pro jedno letiste
  • fakturacni udaje pro lidi co nezname!
https://drive.google.com/file/d/16yQ_rqU_lCw_IHEFlwE48XbHZc0Rt_9l/view?usp=sharing
@yawnston
yawnston / wsl.vbs
Created September 21, 2020 20:53
Launch WSL2 X server + WM
' This script is meant to be launched from the Windows side, to start up a decorationless
' VcXsrv container for the environment.
Set vcxsrvShell = CreateObject("WScript.Shell")
vcxsrvShell.Run """C:\Program Files\VcXsrv\vcxsrv.exe"" -nodecoration -wgl -ac -clipboard -lesspointer"
Set vcxsrvShell = Nothing
Set wslShell = CreateObject("WScript.Shell")
wslShell.Run "wsl ~/.scripts/wlaunch", 0
Set wslShell = Nothing
// TEST CASE 1
interface IA
{
}
interface IB
{
}
class ComponentA extends ComponentBase implements IA
@yawnston
yawnston / opendata-invalid-response-query.sparql
Created November 22, 2021 19:11
opendata-invalid-response-query.sparql
SELECT *
WHERE {
{
SELECT DISTINCT ?x ?pDomain (if(( ?pRangeLiteral = "" ), ?ppRange, ?pRangeLiteral) AS ?pRange)
WHERE {{
SELECT DISTINCT ?x ?pDomain ?ppRange (if(isLiteral(?o), <http://hypergraphql.org/schema/Literal>, "") AS ?pRangeLiteral)
WHERE{
?s ?x ?o
OPTIONAL { ?o a ?ppRange }
OPTIONAL { ?s a ?pDomain }

Research notes

Timestamping

We can use the NOW() function to timestamp the schema. Later we can do something like create a max age for the schema, at which point we will discard old parts of the schema and get them again.

The NOW() function does not give timezone info, but it should be consistent between calls on the same SPARQL endpoint. Therefore should not be an issue.

@yawnston
yawnston / master-thesis-notes.md
Last active November 13, 2022 16:02
master-thesis-notes
  • behem implementace : kdyz narazim na vice variant reseni, napsat si bohate poznamky -> z toho udelat neco do finalniho textu
  • do diplomky je zajimava i diskuse -> kdyz mam 5 napadu, vybrat ten nejlepsi a probrat proc je nejlepsi
  • swaggerui/vaadin
  • client-server
  1. v dashboardu mit moznost pridatat dalsi DB systemy
  2. read only pracovat se semantickou kategorii (klikat dotazy)
  • MM-cat
  1. konstrukce dotazu nebo textova forma (overit aby SPARQL se dal pouzivat na semantickou kategorii)
  • vyhoda kategorie = skladani cesty -> misto slozitych cest lze dlouhe sipky