Skip to content

Instantly share code, notes, and snippets.

View Querela's full-sized avatar

Erik Körner Querela

View GitHub Profile
@Querela
Querela / split-to-ranges.java
Created November 17, 2023 14:02
Split String on markers and transform to hit ranges
String value = "fdkslaöfjs fdskla öfjs{{{{}}}}fjdslkajfs{{{{}}}} fdl söaj {{{{}}}}abc{{{{}}}} fdjksö jk";
String marker = "{{{{}}}}";
String[] parts = value.split(Pattern.quote(marker));
List<Integer> lengths = List.of(parts).stream().map(String::length).collect(Collectors.toList());
int total = 0;
List<Integer> lengths_agg = List.of(parts).stream().map(String::length).map(l -> {total = total + l; return total;}).collect(Collectors.toList());
@Querela
Querela / endpoint.py
Last active November 17, 2023 11:08
Simple static FCS endpoint
import logging
import os.path
from dataclasses import dataclass
from typing import Dict, List, Optional
from clarin.sru.constants import SRUDiagnostics, SRUResultCountPrecision, SRUVersion
from clarin.sru.diagnostic import SRUDiagnostic, SRUDiagnosticList
from clarin.sru.exception import SRUException
from clarin.sru.fcs.constants import FCS_NS, FCSQueryType
from clarin.sru.fcs.queryparser import FCSQuery
@Querela
Querela / CQLToSolrConverter.java
Last active November 17, 2023 12:56
Query Translation: FCS Queries to Solr
import org.apache.logging.log4j.LogManager;
import org.apache.logging.log4j.Logger;
import org.z3950.zing.cql.CQLAndNode;
import org.z3950.zing.cql.CQLBooleanNode;
import org.z3950.zing.cql.CQLNode;
import org.z3950.zing.cql.CQLOrNode;
import org.z3950.zing.cql.CQLTermNode;
import eu.clarin.sru.server.SRUConstants;
import eu.clarin.sru.server.SRUException;
@Querela
Querela / dedup.py
Last active June 15, 2023 12:03
[python] TLSH Vantage Point Trees
import os
import json
import numpy as np
import tlsh # from `py-tlsh`
from joblib import Parallel, delayed, parallel_backend
from sklearn.metrics import pairwise_distances_chunked
from tqdm import tqdm
from vpt import VantagePointTree
@Querela
Querela / Application.Java
Created September 14, 2022 11:11 — forked from aweiland/Application.Java
CORS in Dropwizard
private void configureCors(Environment environment) {
final FilterRegistration.Dynamic cors =
environment.servlets().addFilter("CORS", CrossOriginFilter.class);
// Configure CORS parameters
cors.setInitParameter(CrossOriginFilter.ALLOWED_ORIGINS_PARAM, "*");
cors.setInitParameter(CrossOriginFilter.ALLOWED_HEADERS_PARAM, "X-Requested-With,Content-Type,Accept,Origin,Authorization");
cors.setInitParameter(CrossOriginFilter.ALLOWED_METHODS_PARAM, "OPTIONS,GET,PUT,POST,DELETE,HEAD");
cors.setInitParameter(CrossOriginFilter.ALLOW_CREDENTIALS_PARAM, "true");
@Querela
Querela / grabVideoGenshinImpactCanvas.js
Created January 7, 2022 20:39
[JS] Save Genshin Impact Version Announcement Animated Canvas Video (Figures etc.)
// ex. https://webstatic-sea.mihoyo.com/ys/event/e20211227-pre/index.html?...
// get link from ingame messages (seem to contains some cookie/timestamp-key for which the URL is valid)
// credits to:
// - https://developers.google.com/web/updates/2016/10/capture-stream#demos
// - https://stackoverflow.com/a/34259326/9360161
// --- steps ---
// 1. open url/page normally
// 2. open dev tools
@Querela
Querela / idea.md
Created November 21, 2021 10:05 — forked from motorailgun/idea.md
Installing Windows and Linux into the same partition

Installing Windows and Linux into the same partition

But WHY?

There was a reddit post about installing Arch on NTFS3 partition. Since Windows and Linux doesn't have directories with same names under the /(C:\), I thought it's possible, and turned out it was actually possible.
If you are not familiar to Linux, for example you've searched on Google "how to dualboot Linux and Windos" or brbrbr... you mustn't try this. This is not practical.

Pre-requirements

  • UEFI system
  • Any Linux live-boot CD/DVD/USB... with Linux kernel newer than 5.15
  • Windows installer USB
@Querela
Querela / strsplit.sql
Created August 12, 2020 20:15 — forked from paulochf/strsplit.sql
MySQL split function: get nth splitted term from string separated value
-- Retrieved from http://dev.mysql.com/doc/refman/5.6/en/string-functions.html at 2015-feb-10 18:16
-- Working on MySQL version 5.6.19-0ubuntu0.14.04.1 (Ubuntu)
--
-- Posted by Chris Stubben on August 21 2008 3:49pm
-- Split delimited strings
CREATE FUNCTION
strSplit(x VARCHAR(255), delim VARCHAR(12), pos INT) RETURNS VARCHAR(255)
return
REPLACE(SUBSTRING(SUBSTRING_INDEX(x, delim, pos),
@Querela
Querela / gist:4e16d944ad6ad8a91c98da7a50902e60
Created August 12, 2020 19:24 — forked from zzzeek/gist:a3bccad40610b9b69803531cc71a79b1
how to do CIDR overlapping in SQL with SQLite / MySQL / SQLAlchemy
from sqlalchemy import event
from sqlalchemy import DDL
def _mysql_cidr_overlap(metadata):
@event.listens_for(metadata, "after_create")
def _create_mysql_proc(target, connection, **kw):
if connection.engine.name != 'mysql':
return
@Querela
Querela / readme.md
Created May 7, 2020 11:47
VSCode LatexWorkshop on WSL with MikTex for XeLaTeX

VSCode remote in WSL

  • with Latex Workshop
  • compiling XeLaTeX using MikTex

MikTex installation:

  • /mnt/c/miktex-portable/texmfs

Fonts in Windows

  • for use in WSL, but with MikTex on Windows, it is not really required :-/
  • see file: ~/.config/fontconfig/fonts.conf