tuesd4y

/**
 * What's a happy number? https://en.wikipedia.org/wiki/Happy_number
 * 
 * Simple brute force solution that just evaluates if the happy number sequence reaches one within [MAX_DEPTH] iterations.
 */
object HappyNumbers {

    const val MAX_DEPTH = 10_000

    @JvmStatic

tuesd4y

# Custom postfix templates useful for postgis functions - created by tuesd4y
# see www.tuesd4y.com

.trans : transform geometry into WG84 (=SRID 4326)
    ANY  ->  ST_TRANSFORM($expr$, 4326)

.transform : transform geometry into another CRS
    ANY -> ST_TRANSFORM($expr$, $NAME#1::4326$)

.trans3 : transform geometry into 3035 lambert azimuthal covering europe

tuesd4y

tuesd4y

CREATE OR REPLACE FUNCTION f(geom geometry, variadic rec anyarray) RETURNS json AS
$$
BEGIN
    RETURN
        json_build_object(
                'type', 'Feature',
                'id',
                'null', -- the GeoJson spec includes an 'id' field, but it is optional. some services still cry if it's not in there, so we leave it empty just for now.
                'geometry', ST_AsGeoJSON(geom)::json,
                'properties', json_build_object(variadic rec)

tuesd4y

package at.triply.backend.eventbackend

import java.io.File
import java.nio.file.Files
import java.nio.file.Paths
import java.nio.file.StandardCopyOption
import java.util.concurrent.TimeUnit

object Main {
    @JvmStatic

tuesd4y

CREATE OR REPLACE PROCEDURE create_hex_grid(source_table_name varchar(30), height numeric = 1000, srid integer = 31287,
                                      geom_column_name varchar(30) = 'geom', target_table_name varchar(30) = 'hexgrid')
    LANGUAGE plpgsql
AS
$$
DECLARE
    _curs  refcursor ;
    _width NUMERIC  := height * 0.866;
    _geom  GEOMETRY;
    _hx    GEOMETRY := ST_GeomFromText(

tuesd4y

package at.triply.backend.test

import org.junit.jupiter.api.extension.ExtensionContext
import org.junit.jupiter.api.extension.TestExecutionExceptionHandler
import java.net.URLEncoder

class TestAdditionalOutputExtension : TestExecutionExceptionHandler {
    override fun handleTestExecutionException(context: ExtensionContext?, throwable: Throwable) {
        println("============================================================================================\n" +
                "Hey, there seems to be something wrong with the test!\n" +

tuesd4y

package at.triply.backend.test

import org.junit.jupiter.api.extension.ExtensionContext
import org.junit.jupiter.api.extension.TestExecutionExceptionHandler
import java.net.URLEncoder

class TestAdditionalOutputExtension : TestExecutionExceptionHandler {
    override fun handleTestExecutionException(context: ExtensionContext?, throwable: Throwable) {
        println("============================================================================================\n" +
                "Hey, there seems to be something wrong with the test!\n" +

tuesd4y

\copy (select cd.name, pv.id as variation_id,
    st_distance_sphere(cd.location, pv.location) as distance,
    cd.city,
    cd.address,
    li.name as product,
    pv.stop as bus_stop,
    ST_X(pv.location) as stopX,
    ST_Y(pv.location) as stopY,
    ST_X(cd.location) as customerX,
    ST_Y(cd.location) as customerY

tuesd4y

dependencies {
    ...
    implementation('org.springframework.boot:spring-boot-starter-security')
    ...
}