Mercurial > hg > dbutils / changeset

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/Makefile	Sat Dec 07 18:56:37 2024 +0100
@@ -0,0 +1,72 @@
+#
+# DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
+#
+# Copyright 2011 Olaf Wintermann. All rights reserved.
+#
+# Redistribution and use in source and binary forms, with or without
+# modification, are permitted provided that the following conditions are met:
+#
+#   1. Redistributions of source code must retain the above copyright
+#      notice, this list of conditions and the following disclaimer.
+#
+#   2. Redistributions in binary form must reproduce the above copyright
+#      notice, this list of conditions and the following disclaimer in the
+#      documentation and/or other materials provided with the distribution.
+#
+# THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
+# AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
+# IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
+# ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE
+# LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
+# CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
+# SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
+# INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
+# CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
+# ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
+# POSSIBILITY OF SUCH DAMAGE.
+#
+
+all: config.mk build/bin build/lib build/ucx build/test build/dbutils ucx dbutils test
+
+ucx: build/ucx build/lib FORCE
+	cd ucx; $(MAKE) all
+
+dbutils: build/lib build/dbutils FORCE
+	cd dbutils; $(MAKE) all
+
+test: build/bin build/lib build/test FORCE
+	cd test; $(MAKE) all
+
+build/bin:
+	mkdir -p build/bin
+
+build/lib:
+	mkdir -p build/lib
+
+build/dbutils:
+	mkdir -p build/dbutils
+
+build/ucx:
+	mkdir -p build/ucx
+
+build/test:
+	mkdir -p build/test
+
+config.mk:
+	@echo "create config"
+	./configure
+
+clean:
+	@echo "clean"
+	rm -f -R build
+
+cleanall:
+	@echo "clean all"
+	rm -f -R build
+	rm -f config.mk
+
+install: all
+	
+
+FORCE:
+

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/config.mk	Sat Dec 07 18:56:37 2024 +0100
@@ -0,0 +1,44 @@
+prefix=/usr
+exec_prefix=/usr
+bindir=${exec_prefix}/bin
+sbindir=${exec_prefix}/sbin
+libdir=${exec_prefix}/lib64
+libexecdir=${exec_prefix}/libexec
+datarootdir=${prefix}/share
+datadir=${datarootdir}
+sysconfdir=/etc
+sharedstatedir=/var
+localstatedir=/var
+runstatedir=${localstatedir}/run
+includedir=${prefix}/include
+infodir=${datarootdir}/info
+mandir=${datarootdir}/man
+localedir=${datarootdir}/locale
+# toolchain
+CC = gcc
+
+#
+# gcc toolchain config
+#
+
+CFLAGS =
+CXXFLAGS =
+DEBUG_CC_FLAGS = -g
+DEBUG_CXX_FLAGS = -g
+RELEASE_CC_FLAGS = -O3 -DNDEBUG
+RELEASE_CXX_FLAGS = -O3 -DNDEBUG
+LDFLAGS =
+
+SHLIB_CFLAGS = -fPIC
+SHLIB_LDFLAGS = -shared
+
+
+# general flags
+
+# flags for target dbu
+DBU_CFLAGS  +=   -DDBU_SQLITE  -DDBU_POSTGRESQL
+DBU_CFLAGS += ${DEBUG_CC_FLAGS}
+DBU_LDFLAGS +=  -lsqlite3 -lpq
+
+OBJ_EXT = .o
+LIB_EXT = .a

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/configure	Sat Dec 07 18:56:37 2024 +0100
@@ -0,0 +1,496 @@
+#!/bin/sh
+
+
+# some utility functions
+isplatform()
+{
+    for p in $PLATFORM
+    do
+        if [ "$p" = "$1" ]; then
+            return 0
+        fi
+    done
+    return 1
+}
+notisplatform()
+{
+    for p in $PLATFORM
+    do
+        if [ "$p" = "$1" ]; then
+            return 1
+        fi
+    done
+    return 0
+}
+istoolchain()
+{
+    for t in $TOOLCHAIN
+    do
+        if [ "$t" = "$1" ]; then
+            return 0
+        fi
+    done
+    return 1
+}
+notistoolchain()
+{
+    for t in $TOOLCHAIN
+    do
+        if [ "$t" = "$1" ]; then
+            return 1
+        fi
+    done
+    return 0
+}
+
+# clean abort
+abort_configure()
+{
+    rm -Rf "$TEMP_DIR"
+    exit 1
+}
+
+# Test for availability of pkg-config
+PKG_CONFIG=`command -v pkg-config`
+: ${PKG_CONFIG:="false"}
+
+# Simple uname based platform detection
+# $PLATFORM is used for platform dependent dependency selection
+OS=`uname -s`
+OS_VERSION=`uname -r`
+printf "detect platform... "
+if [ "$OS" = "SunOS" ]; then
+    PLATFORM="solaris sunos unix svr4"
+elif [ "$OS" = "Linux" ]; then
+    PLATFORM="linux unix"
+elif [ "$OS" = "FreeBSD" ]; then
+    PLATFORM="freebsd bsd unix"
+elif [ "$OS" = "OpenBSD" ]; then
+    PLATFORM="openbsd bsd unix"
+elif [ "$OS" = "NetBSD" ]; then
+    PLATFORM="netbsd bsd unix"
+elif [ "$OS" = "Darwin" ]; then
+    PLATFORM="macos osx bsd unix"
+elif echo "$OS" | grep -i "MINGW" > /dev/null; then
+    PLATFORM="windows mingw"
+fi
+: ${PLATFORM:="unix"}
+
+PLATFORM_NAME=`echo "$PLATFORM" | cut -f1 -d' ' -`
+echo "$PLATFORM_NAME"
+
+
+# help text
+printhelp()
+{
+    echo "Usage: $0 [OPTIONS]..."
+    cat << __EOF__
+Installation directories:
+  --prefix=PREFIX         path prefix for architecture-independent files
+                          [$prefix]
+  --exec-prefix=EPREFIX   path prefix for architecture-dependent files
+                          [PREFIX]
+
+  --bindir=DIR            user executables [EPREFIX/bin]
+  --sbindir=DIR           system admin executables [EPREFIX/sbin]
+  --libexecdir=DIR        program executables [EPREFIX/libexec]
+  --sysconfdir=DIR        system configuration files [PREFIX/etc]
+  --sharedstatedir=DIR    modifiable architecture-independent data [PREFIX/com]
+  --localstatedir=DIR     modifiable single-machine data [PREFIX/var]
+  --runstatedir=DIR       run-time variable data [LOCALSTATEDIR/run]
+  --libdir=DIR            object code libraries [EPREFIX/lib]
+  --includedir=DIR        C header files [PREFIX/include]
+  --datarootdir=DIR       read-only arch.-independent data root [PREFIX/share]
+  --datadir=DIR           read-only architecture-independent data [DATAROOTDIR]
+  --infodir=DIR           info documentation [DATAROOTDIR/info]
+  --mandir=DIR            man documentation [DATAROOTDIR/man]
+  --localedir=DIR         locale-dependent data [DATAROOTDIR/locale]
+
+Optional Features:
+  --disable-sqlite
+  --disable-postgresql
+
+__EOF__
+}
+
+# create temporary directory
+TEMP_DIR=".tmp-`uname -n`"
+rm -Rf "$TEMP_DIR"
+if mkdir -p "$TEMP_DIR"; then
+    :
+else
+    echo "Cannot create tmp dir $TEMP_DIR"
+    echo "Abort"
+    exit 1
+fi
+touch "$TEMP_DIR/options"
+touch "$TEMP_DIR/features"
+
+# define standard variables
+# also define standard prefix (this is where we will search for config.site)
+prefix=/usr
+exec_prefix=
+bindir=
+sbindir=
+libdir=
+libexecdir=
+datarootdir=
+datadir=
+sysconfdir=
+sharedstatedir=
+localstatedir=
+runstatedir=
+includedir=
+infodir=
+localedir=
+mandir=
+
+# custom variables
+
+# features
+FEATURE_SQLITE=auto
+FEATURE_POSTGRESQL=auto
+
+#
+# parse arguments
+#
+BUILD_TYPE="default"
+for ARG in "$@"
+do
+    case "$ARG" in
+        "--prefix="*)         prefix=${ARG#--prefix=} ;;
+        "--exec-prefix="*)    exec_prefix=${ARG#--exec-prefix=} ;;
+        "--bindir="*)         bindir=${ARG#----bindir=} ;;
+        "--sbindir="*)        sbindir=${ARG#--sbindir=} ;;
+        "--libdir="*)         libdir=${ARG#--libdir=} ;;
+        "--libexecdir="*)     libexecdir=${ARG#--libexecdir=} ;;
+        "--datarootdir="*)    datarootdir=${ARG#--datarootdir=} ;;
+        "--datadir="*)        datadir=${ARG#--datadir=} ;;
+        "--sysconfdir="*)     sysconfdir=${ARG#--sysconfdir=} ;;
+        "--sharedstatedir="*) sharedstatedir=${ARG#--sharedstatedir=} ;;
+        "--localstatedir="*)  localstatedir=${ARG#--localstatedir=} ;;
+        "--includedir="*)     includedir=${ARG#--includedir=} ;;
+        "--infodir="*)        infodir=${ARG#--infodir=} ;;
+        "--mandir"*)          mandir=${ARG#--mandir} ;;
+        "--localedir"*)       localedir=${ARG#--localedir} ;;
+        "--help"*) printhelp; abort_configure ;;
+        "--debug")           BUILD_TYPE="debug" ;;
+        "--release")         BUILD_TYPE="release" ;;
+        "--enable-sqlite") FEATURE_SQLITE=on ;;
+        "--disable-sqlite") unset FEATURE_SQLITE ;;
+        "--enable-postgresql") FEATURE_POSTGRESQL=on ;;
+        "--disable-postgresql") unset FEATURE_POSTGRESQL ;;
+        "-"*) echo "unknown option: $ARG"; abort_configure ;;
+    esac
+done
+
+
+
+# set defaults for dir variables
+: ${exec_prefix:="$prefix"}
+: ${bindir:='${exec_prefix}/bin'}
+: ${sbindir:='${exec_prefix}/sbin'}
+: ${libdir:='${exec_prefix}/lib'}
+: ${libexecdir:='${exec_prefix}/libexec'}
+: ${datarootdir:='${prefix}/share'}
+: ${datadir:='${datarootdir}'}
+: ${sysconfdir:='${prefix}/etc'}
+: ${sharedstatedir:='${prefix}/com'}
+: ${localstatedir:='${prefix}/var'}
+: ${runstatedir:='${localstatedir}/run'}
+: ${includedir:='${prefix}/include'}
+: ${infodir:='${datarootdir}/info'}
+: ${mandir:='${datarootdir}/man'}
+: ${localedir:='${datarootdir}/locale'}
+
+# check if a config.site exists and load it
+if [ -n "$CONFIG_SITE" ]; then
+    # CONFIG_SITE may contain space separated file names
+    for cs in $CONFIG_SITE; do
+        printf "loading defaults from $cs... "
+        . "$cs"
+        echo ok
+    done
+elif [ -f "$prefix/share/config.site" ]; then
+    printf "loading site defaults... "
+    . "$prefix/share/config.site"
+    echo ok
+elif [ -f "$prefix/etc/config.site" ]; then
+    printf "loading site defaults... "
+    . "$prefix/etc/config.site"
+    echo ok
+fi
+
+
+# generate vars.mk
+cat > "$TEMP_DIR/vars.mk" << __EOF__
+prefix=$prefix
+exec_prefix=$exec_prefix
+bindir=$bindir
+sbindir=$sbindir
+libdir=$libdir
+libexecdir=$libexecdir
+datarootdir=$datarootdir
+datadir=$datadir
+sysconfdir=$sysconfdir
+sharedstatedir=$sharedstatedir
+localstatedir=$localstatedir
+runstatedir=$runstatedir
+includedir=$includedir
+infodir=$infodir
+mandir=$mandir
+localedir=$localedir
+__EOF__
+
+# toolchain detection utilities
+. make/toolchain.sh
+
+#
+# DEPENDENCIES
+#
+
+# check languages
+lang_c=
+lang_cpp=
+if detect_c_compiler ; then
+    lang_c=1
+fi
+
+# create buffer for make variables required by dependencies
+echo > "$TEMP_DIR/make.mk"
+
+test_pkg_config()
+{
+    if "$PKG_CONFIG" --exists "$1" ; then :
+    else return 1 ; fi
+    if [ -z "$2" ] || "$PKG_CONFIG" --atleast-version="$2" "$1" ; then :
+    else return 1 ; fi
+    if [ -z "$3" ] || "$PKG_CONFIG" --exact-version="$3" "$1" ; then :
+    else return 1 ; fi
+    if [ -z "$4" ] || "$PKG_CONFIG" --max-version="$4" "$1" ; then :
+    else return 1 ; fi
+    return 0
+}
+
+print_check_msg()
+{
+    if [ -z "$1" ]; then
+        shift
+        printf "$@"
+    fi
+}
+
+dependency_error_postgresql()
+{
+    print_check_msg "$dep_checked_postgresql" "checking for postgresql... "
+    # dependency postgresql
+    while true
+    do
+        if [ -z "$PKG_CONFIG" ]; then
+            break
+        fi
+        if test_pkg_config "libpq" "" "" "" ; then
+            TEMP_CFLAGS="$TEMP_CFLAGS `"$PKG_CONFIG" --cflags libpq`"
+            TEMP_LDFLAGS="$TEMP_LDFLAGS `"$PKG_CONFIG" --libs libpq`"
+        else
+            break
+        fi
+        TEMP_CFLAGS="$TEMP_CFLAGS -DDBU_POSTGRESQL"
+        print_check_msg "$dep_checked_postgresql" "yes\n"
+        dep_checked_postgresql=1
+        return 1
+    done
+
+    print_check_msg "$dep_checked_postgresql" "no\n"
+    dep_checked_postgresql=1
+    return 0
+}
+dependency_error_sqlite()
+{
+    print_check_msg "$dep_checked_sqlite" "checking for sqlite... "
+    # dependency sqlite
+    while true
+    do
+        if [ -z "$PKG_CONFIG" ]; then
+            break
+        fi
+        if test_pkg_config "sqlite3" "" "" "" ; then
+            TEMP_CFLAGS="$TEMP_CFLAGS `"$PKG_CONFIG" --cflags sqlite3`"
+            TEMP_LDFLAGS="$TEMP_LDFLAGS `"$PKG_CONFIG" --libs sqlite3`"
+        else
+            break
+        fi
+        TEMP_CFLAGS="$TEMP_CFLAGS -DDBU_SQLITE"
+        print_check_msg "$dep_checked_sqlite" "yes\n"
+        dep_checked_sqlite=1
+        return 1
+    done
+
+    print_check_msg "$dep_checked_sqlite" "no\n"
+    dep_checked_sqlite=1
+    return 0
+}
+
+# start collecting dependency information
+echo > "$TEMP_DIR/flags.mk"
+
+DEPENDENCIES_FAILED=
+ERROR=0
+# unnamed dependencies
+TEMP_CFLAGS=
+TEMP_CXXFLAGS=
+TEMP_LDFLAGS=
+while true
+do
+    while true
+    do
+        if [ -z "$lang_c" ] ; then
+            ERROR=1
+            break
+        fi
+
+        break
+    done
+    break
+done
+while true
+do
+    if notisplatform "unix"; then
+        break
+    fi
+    while true
+    do
+
+        cat >> "$TEMP_DIR/make.mk" << __EOF__
+OBJ_EXT = .o
+LIB_EXT = .a
+__EOF__
+        break
+    done
+    break
+done
+
+# add general dependency flags to flags.mk
+echo "# general flags" >> "$TEMP_DIR/flags.mk"
+if [ -n "${TEMP_CFLAGS}" ] && [ -n "$lang_c" ]; then
+    echo "CFLAGS += $TEMP_CFLAGS" >> "$TEMP_DIR/flags.mk"
+fi
+if [ -n "${TEMP_CXXFLAGS}" ] && [ -n "$lang_cpp" ]; then
+    echo "CXXFLAGS += $TEMP_CXXFLAGS" >> "$TEMP_DIR/flags.mk"
+fi
+if [ -n "${TEMP_LDFLAGS}" ]; then
+    echo "LDFLAGS += $TEMP_LDFLAGS" >> "$TEMP_DIR/flags.mk"
+fi
+
+#
+# OPTION VALUES
+#
+
+#
+# TARGETS
+#
+
+echo >> "$TEMP_DIR/flags.mk"
+echo "configuring target: dbu"
+echo "# flags for target dbu" >> "$TEMP_DIR/flags.mk"
+TEMP_CFLAGS=
+TEMP_CXXFLAGS=
+TEMP_LDFLAGS=
+
+
+# Features
+if [ -n "$FEATURE_SQLITE" ]; then
+    # check dependency
+    if dependency_error_sqlite ; then
+        # "auto" features can fail and are just disabled in this case
+        if [ "$FEATURE_SQLITE" = "auto" ]; then
+            DISABLE_FEATURE_SQLITE=1
+        else
+            DEPENDENCIES_FAILED="$DEPENDENCIES_FAILED sqlite "
+            ERROR=1
+        fi
+    fi
+    if [ -n "$DISABLE_FEATURE_SQLITE" ]; then
+        unset FEATURE_SQLITE
+    fi
+fi
+if [ -n "$FEATURE_POSTGRESQL" ]; then
+    # check dependency
+    if dependency_error_postgresql ; then
+        # "auto" features can fail and are just disabled in this case
+        if [ "$FEATURE_POSTGRESQL" = "auto" ]; then
+            DISABLE_FEATURE_POSTGRESQL=1
+        else
+            DEPENDENCIES_FAILED="$DEPENDENCIES_FAILED postgresql "
+            ERROR=1
+        fi
+    fi
+    if [ -n "$DISABLE_FEATURE_POSTGRESQL" ]; then
+        unset FEATURE_POSTGRESQL
+    fi
+fi
+
+
+if [ -n "${TEMP_CFLAGS}" ] && [ -n "$lang_c" ]; then
+    echo "DBU_CFLAGS  += $TEMP_CFLAGS" >> "$TEMP_DIR/flags.mk"
+fi
+if [ -n "${TEMP_CXXFLAGS}" ] && [ -n "$lang_cpp" ]; then
+    echo "DBU_CXXFLAGS  += $TEMP_CXXFLAGS" >> "$TEMP_DIR/flags.mk"
+fi
+if [ "$BUILD_TYPE" = "debug" ]; then
+    if [ -n "$lang_c" ]; then
+        echo 'DBU_CFLAGS += ${DEBUG_CC_FLAGS}' >> "$TEMP_DIR/flags.mk"
+    fi
+    if [ -n "$lang_cpp" ]; then
+        echo 'DBU_CXXFLAGS += ${DEBUG_CXX_FLAGS}' >> "$TEMP_DIR/flags.mk"
+    fi
+fi
+if [ "$BUILD_TYPE" = "release" ]; then
+    if [ -n "$lang_c" ]; then
+        echo 'DBU_CFLAGS += ${RELEASE_CC_FLAGS}' >> "$TEMP_DIR/flags.mk"
+    fi
+    if [ -n "$lang_cpp" ]; then
+        echo 'DBU_CXXFLAGS += ${RELEASE_CXX_FLAGS}' >> "$TEMP_DIR/flags.mk"
+    fi
+fi
+if [ -n "${TEMP_LDFLAGS}" ]; then
+    echo "DBU_LDFLAGS += $TEMP_LDFLAGS" >> "$TEMP_DIR/flags.mk"
+fi
+
+
+# final result
+if [ $ERROR -ne 0 ]; then
+    echo
+    echo "Error: Unresolved dependencies"
+    echo "$DEPENDENCIES_FAILED"
+    abort_configure
+fi
+
+echo "configure finished"
+echo
+echo "Build Config:"
+echo "  PREFIX:      $prefix"
+echo "  TOOLCHAIN:   $TOOLCHAIN_NAME"
+echo "Features:"
+if [ -n "$FEATURE_SQLITE" ]; then
+echo "  sqlite: on"
+else
+echo "  sqlite: off"
+fi
+if [ -n "$FEATURE_POSTGRESQL" ]; then
+echo "  postgresql: on"
+else
+echo "  postgresql: off"
+fi
+echo
+
+# generate the config.mk file
+cat > "$TEMP_DIR/config.mk" << __EOF__
+#
+# config.mk generated by configure
+#
+
+__EOF__
+write_toolchain_defaults "$TEMP_DIR/toolchain.mk"
+cat "$TEMP_DIR/vars.mk" "$TEMP_DIR/toolchain.mk" "$TEMP_DIR/flags.mk" "$TEMP_DIR/make.mk" > config.mk
+rm -Rf "$TEMP_DIR"

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/dbutils/Makefile	Sat Dec 07 18:56:37 2024 +0100
@@ -0,0 +1,53 @@
+#
+# DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
+#
+# Copyright 2018 Olaf Wintermann. All rights reserved.
+#
+# Redistribution and use in source and binary forms, with or without
+# modification, are permitted provided that the following conditions are met:
+#
+#   1. Redistributions of source code must retain the above copyright
+#      notice, this list of conditions and the following disclaimer.
+#
+#   2. Redistributions in binary form must reproduce the above copyright
+#      notice, this list of conditions and the following disclaimer in the
+#      documentation and/or other materials provided with the distribution.
+#
+# THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
+# AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
+# IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
+# ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE
+# LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
+# CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
+# SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
+# INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
+# CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
+# ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
+# POSSIBILITY OF SUCH DAMAGE.
+#
+
+include ../config.mk
+
+# list of source files
+SRC  = dbutils.c
+SRC += class.c
+SRC += field.c
+SRC += db.c
+SRC += sqlite.c
+
+OBJ = $(SRC:%.c=../build/dbutils/%$(OBJ_EXT))
+
+LIBDBUTILS = ../build/lib/libdbutils$(LIB_EXT)
+
+all: ../build/ucx $(LIBDBUTILS)
+
+$(LIBDBUTILS): $(OBJ)
+	$(AR) $(ARFLAGS) $(AOFLAGS)$@ $(OBJ)
+
+../build/dbutils/%$(OBJ_EXT): %.c
+	$(CC) -I../ucx $(CFLAGS) $(DBU_CFLAGS) -c -o $@ $<
+
+../build/ucx:
+	test -d '$@'
+
+

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/dbutils/class.c	Sat Dec 07 18:56:37 2024 +0100
@@ -0,0 +1,91 @@
+/*
+ * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
+ *
+ * Copyright 2024 Olaf Wintermann. All rights reserved.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ *
+ *   1. Redistributions of source code must retain the above copyright
+ *      notice, this list of conditions and the following disclaimer.
+ *
+ *   2. Redistributions in binary form must reproduce the above copyright
+ *      notice, this list of conditions and the following disclaimer in the
+ *      documentation and/or other materials provided with the distribution.
+ *
+ * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
+ * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
+ * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
+ * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE
+ * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
+ * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
+ * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
+ * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
+ * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
+ * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
+ * POSSIBILITY OF SUCH DAMAGE.
+ */
+
+#include "class.h"
+#include "field.h"
+
+#include <string.h>
+#include <stdlib.h>
+
+#include <cx/hash_map.h>
+
+DBUClass* dbuClassCreate(const char *name) {
+    DBUClass *cls = malloc(sizeof(DBUClass));
+    memset(cls, 0, sizeof(DBUClass));
+    
+    cls->name = cx_strdup(cx_str(name));
+    cls->fields = cxHashMapCreateSimple(CX_STORE_POINTERS);
+    
+    return cls;
+}
+
+void dbuClassFree(DBUClass *cls) {
+    // TODO
+}
+
+void dbuClassAddField(DBUClass *cls, const char *name, DBUField *field) {
+    cxMapPut(cls->fields, name, field);
+}
+
+
+
+void dbuClassSetPrimaryKeyInt32(DBUClass *cls, const char *column_name, off_t offset) {
+    cls->primary_key_column = cx_strdup(cx_str(column_name));
+    cls->primary_key = dbuFieldCreateInt32(offset);
+    dbuClassAddField(cls, column_name, cls->primary_key);
+}
+
+void dbuClassSetPrimaryKeyUInt32(DBUClass *cls, const char *column_name, off_t offset) {
+    cls->primary_key_column = cx_strdup(cx_str(column_name));
+    cls->primary_key = dbuFieldCreateUInt32(offset);
+    dbuClassAddField(cls, column_name, cls->primary_key);
+}
+
+void dbuClassSetPrimaryKeyInt64(DBUClass *cls, const char *column_name, off_t offset) {
+    cls->primary_key_column = cx_strdup(cx_str(column_name));
+    cls->primary_key = dbuFieldCreateInt64(offset);
+    dbuClassAddField(cls, column_name, cls->primary_key);
+}
+
+void dbuClassSetPrimaryKeyUInt64(DBUClass *cls, const char *column_name, off_t offset) {
+    cls->primary_key_column = cx_strdup(cx_str(column_name));
+    cls->primary_key = dbuFieldCreateInt64(offset);
+    dbuClassAddField(cls, column_name, cls->primary_key);
+}
+
+void dbuClassSetPrimaryKeyString(DBUClass *cls, const char *column_name, off_t offset) {
+    cls->primary_key_column = cx_strdup(cx_str(column_name));
+    cls->primary_key = dbuFieldCreateString(offset);
+    dbuClassAddField(cls, column_name, cls->primary_key);
+}
+
+void dbuClassSetPrimaryKeyCxMutStr(DBUClass *cls, const char *column_name, off_t offset) {
+    cls->primary_key_column = cx_strdup(cx_str(column_name));
+    cls->primary_key = dbuFieldCreateCxMutStr(offset);
+    dbuClassAddField(cls, column_name, cls->primary_key);
+}

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/dbutils/class.h	Sat Dec 07 18:56:37 2024 +0100
@@ -0,0 +1,46 @@
+/*
+ * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
+ *
+ * Copyright 2024 Olaf Wintermann. All rights reserved.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ *
+ *   1. Redistributions of source code must retain the above copyright
+ *      notice, this list of conditions and the following disclaimer.
+ *
+ *   2. Redistributions in binary form must reproduce the above copyright
+ *      notice, this list of conditions and the following disclaimer in the
+ *      documentation and/or other materials provided with the distribution.
+ *
+ * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
+ * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
+ * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
+ * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE
+ * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
+ * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
+ * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
+ * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
+ * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
+ * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
+ * POSSIBILITY OF SUCH DAMAGE.
+ */
+
+#ifndef DBU_CLASS_H
+#define DBU_CLASS_H
+
+#include "dbutils/dbutils.h"
+
+#ifdef __cplusplus
+extern "C" {
+#endif
+
+void dbuClassFree(DBUClass *cls);
+
+
+#ifdef __cplusplus
+}
+#endif
+
+#endif /* DBU_CLASS_H */
+

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/dbutils/db.c	Sat Dec 07 18:56:37 2024 +0100
@@ -0,0 +1,30 @@
+/*
+ * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
+ *
+ * Copyright 2024 Olaf Wintermann. All rights reserved.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ *
+ *   1. Redistributions of source code must retain the above copyright
+ *      notice, this list of conditions and the following disclaimer.
+ *
+ *   2. Redistributions in binary form must reproduce the above copyright
+ *      notice, this list of conditions and the following disclaimer in the
+ *      documentation and/or other materials provided with the distribution.
+ *
+ * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
+ * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
+ * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
+ * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE
+ * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
+ * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
+ * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
+ * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
+ * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
+ * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
+ * POSSIBILITY OF SUCH DAMAGE.
+ */
+
+#include "db.h"
+

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/dbutils/db.h	Sat Dec 07 18:56:37 2024 +0100
@@ -0,0 +1,49 @@
+/*
+ * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
+ *
+ * Copyright 2024 Olaf Wintermann. All rights reserved.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ *
+ *   1. Redistributions of source code must retain the above copyright
+ *      notice, this list of conditions and the following disclaimer.
+ *
+ *   2. Redistributions in binary form must reproduce the above copyright
+ *      notice, this list of conditions and the following disclaimer in the
+ *      documentation and/or other materials provided with the distribution.
+ *
+ * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
+ * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
+ * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
+ * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE
+ * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
+ * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
+ * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
+ * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
+ * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
+ * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
+ * POSSIBILITY OF SUCH DAMAGE.
+ */
+
+#ifndef DBU_DB_H
+#define DBU_DB_H
+
+#include "dbutils/dbutils.h"
+
+#ifdef __cplusplus
+extern "C" {
+#endif
+
+typedef struct DBUFieldMapping {
+    DBUField *field;
+    int result_index;
+} DBUFieldMapping;
+
+
+#ifdef __cplusplus
+}
+#endif
+
+#endif /* DBU_DB_H */
+

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/dbutils/dbutils.c	Sat Dec 07 18:56:37 2024 +0100
@@ -0,0 +1,130 @@
+/*
+ * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
+ *
+ * Copyright 2024 Olaf Wintermann. All rights reserved.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ *
+ *   1. Redistributions of source code must retain the above copyright
+ *      notice, this list of conditions and the following disclaimer.
+ *
+ *   2. Redistributions in binary form must reproduce the above copyright
+ *      notice, this list of conditions and the following disclaimer in the
+ *      documentation and/or other materials provided with the distribution.
+ *
+ * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
+ * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
+ * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
+ * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE
+ * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
+ * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
+ * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
+ * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
+ * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
+ * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
+ * POSSIBILITY OF SUCH DAMAGE.
+ */
+
+#include "dbutils/dbutils.h"
+#include "class.h"
+#include "field.h"
+
+#include <cx/hash_map.h>
+
+DBUContext* dbuContextCreate(void) {
+    DBUContext *ctx = malloc(sizeof(DBUContext));
+    ctx->classes = cxHashMapCreateSimple(CX_STORE_POINTERS);
+    ctx->classes->collection.simple_destructor = (cx_destructor_func)dbuClassFree;
+    return ctx;
+}
+
+void dbuContextFree(DBUContext *context) {
+    cxMapDestroy(context->classes);
+    free(context);
+}
+
+
+DBUClass* dbuRegisterClassWithPrimaryKeyInt32(
+        DBUContext *context,
+        const char *name,
+        size_t obj_size,
+        const char *primary_key_column,
+        off_t primary_key_offset)
+{
+    DBUClass *cls = dbuClassCreate(name);
+    cls->obj_size = obj_size;
+    dbuClassSetPrimaryKeyInt32(cls, primary_key_column, primary_key_offset);
+    cxMapPut(context->classes, name, cls);
+    return cls;
+}
+
+DBUClass* dbuRegisterClassWithPrimaryKeyUInt32(
+        DBUContext *context,
+        const char *name,
+        size_t obj_size,
+        const char *primary_key_column,
+        off_t primary_key_offset)
+{
+    DBUClass *cls = dbuClassCreate(name);
+    cls->obj_size = obj_size;
+    dbuClassSetPrimaryKeyUInt32(cls, primary_key_column, primary_key_offset);
+    cxMapPut(context->classes, name, cls);
+    return cls;
+}
+
+DBUClass* dbuRegisterClassWithPrimaryKeyInt64(
+        DBUContext *context,
+        const char *name,
+        size_t obj_size,
+        const char *primary_key_column,
+        off_t primary_key_offset)
+{
+    DBUClass *cls = dbuClassCreate(name);
+    cls->obj_size = obj_size;
+    dbuClassSetPrimaryKeyInt64(cls, primary_key_column, primary_key_offset);
+    cxMapPut(context->classes, name, cls);
+    return cls;
+}
+
+DBUClass* dbuRegisterClassWithPrimaryKeyUInt64(
+        DBUContext *context,
+        const char *name,
+        size_t obj_size,
+        const char *primary_key_column,
+        off_t primary_key_offset)
+{
+    DBUClass *cls = dbuClassCreate(name);
+    cls->obj_size = obj_size;
+    dbuClassSetPrimaryKeyUInt64(cls, primary_key_column, primary_key_offset);
+    cxMapPut(context->classes, name, cls);
+    return cls;
+}
+
+DBUClass* dbuRegisterClassWithPrimaryKeyString(
+        DBUContext *context,
+        const char *name,
+        size_t obj_size,
+        const char *primary_key_column,
+        off_t primary_key_offset)
+{
+    DBUClass *cls = dbuClassCreate(name);
+    cls->obj_size = obj_size;
+    dbuClassSetPrimaryKeyString(cls, primary_key_column, primary_key_offset);
+    cxMapPut(context->classes, name, cls);
+    return cls;
+}
+
+DBUClass* dbuRegisterClassWithPrimaryKeyCxMutStr(
+        DBUContext *context,
+        const char *name,
+        size_t obj_size,
+        const char *primary_key_column,
+        off_t primary_key_offset)
+{
+    DBUClass *cls = dbuClassCreate(name);
+    cls->obj_size = obj_size;
+    dbuClassSetPrimaryKeyCxMutStr(cls, primary_key_column, primary_key_offset);
+    cxMapPut(context->classes, name, cls);
+    return cls;
+}

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/dbutils/dbutils/dbutils.h	Sat Dec 07 18:56:37 2024 +0100
@@ -0,0 +1,251 @@
+/*
+ * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
+ *
+ * Copyright 2024 Olaf Wintermann. All rights reserved.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ *
+ *   1. Redistributions of source code must retain the above copyright
+ *      notice, this list of conditions and the following disclaimer.
+ *
+ *   2. Redistributions in binary form must reproduce the above copyright
+ *      notice, this list of conditions and the following disclaimer in the
+ *      documentation and/or other materials provided with the distribution.
+ *
+ * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
+ * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
+ * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
+ * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE
+ * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
+ * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
+ * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
+ * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
+ * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
+ * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
+ * POSSIBILITY OF SUCH DAMAGE.
+ */
+
+#ifndef LIB_DBU_H
+#define LIB_DBU_H
+
+#include <stdbool.h>
+#include <stdlib.h>
+#include <inttypes.h>
+#include <sys/types.h>
+
+#include <cx/allocator.h>
+#include <cx/string.h>
+#include <cx/list.h>
+#include <cx/map.h>
+
+#ifdef __cplusplus
+extern "C" {
+#endif
+
+typedef struct DBUContext DBUContext;
+typedef struct DBUClass   DBUClass;
+typedef struct DBUField   DBUField;
+
+typedef char* DBUObject;
+
+typedef int(*DBUFieldDefInitFunc)(DBUField *f, const CxAllocator *a, DBUObject obj);
+typedef int(*DBUFieldInitFunc)(DBUField *f, const CxAllocator *a, DBUObject obj, const char *value, size_t length);
+
+struct DBUContext {
+    /*
+     * key: class name
+     * value: DBUClass*
+     */
+    CxMap *classes;
+};
+
+struct DBUClass {
+    /*
+     * class/table name
+     */
+    cxmutstr name;
+    
+    /*
+     * primary key column name
+     */
+    cxmutstr primary_key_column;
+    
+    /*
+     * primary key struct member initializer
+     */
+    DBUField *primary_key;
+    
+    /*
+     * class fields
+     * 
+     * key: field name
+     * value: DBUField*
+     */
+    CxMap *fields;
+    
+    /*
+     * sizeof the struct
+     * 
+     * Must be specified, if no constructor function is registered
+     */
+    size_t obj_size;
+    
+    /*
+     * optional constructor function
+     * 
+     * If no constructor is specified, the object is created with
+     * malloc(obj_size) + memset to 0
+     */
+    void* (*constructor)(const CxAllocator *a);
+};
+
+/*
+ * abstract field
+ */
+struct DBUField {
+    /*
+     * called, if the field is null
+     */
+    int (*initDefaultValue)(DBUField *f, const CxAllocator *a, DBUObject obj);
+    
+    /*
+     * init primitve type
+     */
+    int (*initValue)(DBUField *f, const CxAllocator *a, DBUObject obj, const char *value, size_t length);
+    
+    
+    bool nonnull;
+    bool query_length;
+};
+
+DBUContext* dbuContextCreate(void);
+void dbuContextFree(DBUContext *context);
+void dbuContextAddClass(DBUContext *context, DBUClass *cls);
+
+/*
+ * incomplete constructor for a DBUClass
+ * 
+ * To complete the class definition, either obj_size or constructor must be set.
+ */
+DBUClass* dbuClassCreate(const char *name);
+
+
+
+#define dbuRegisterClass(context, name, type, primarykey) \
+    dbuRegisterClassWithPKName(context, name, type, primarykey, #primarykey)
+#define dbuRegisterClassWithPKName(context, name, type, primarykey, column) \
+    _Generic(((type*)0)->primarykey, \
+    int32_t:  dbuRegisterClassWithPrimaryKeyInt32,    \
+    uint32_t: dbuRegisterClassWithPrimaryKeyUInt32,   \
+    int64_t:  dbuRegisterClassWithPrimaryKeyInt64,    \
+    uint64_t: dbuRegisterClassWithPrimaryKeyUInt64,   \
+    char*:    dbuRegisterClassWithPrimaryKeyString,   \
+    cxmutstr: dbuRegisterClassWithPrimaryKeyCxMutStr) \
+    (context, name, sizeof(type), column, offsetof(type, primarykey))
+
+DBUClass* dbuRegisterClassWithPrimaryKeyInt32(
+        DBUContext *context,
+        const char *name,
+        size_t obj_size,
+        const char *primary_key_column,
+        off_t primary_key_offset);
+DBUClass* dbuRegisterClassWithPrimaryKeyUInt32(
+        DBUContext *context,
+        const char *name,
+        size_t obj_size,
+        const char *primary_key_column,
+        off_t primary_key_offset);
+DBUClass* dbuRegisterClassWithPrimaryKeyInt64(
+        DBUContext *context,
+        const char *name,
+        size_t obj_size,
+        const char *primary_key_column,
+        off_t primary_key_offset);
+DBUClass* dbuRegisterClassWithPrimaryKeyUInt64(
+        DBUContext *context,
+        const char *name,
+        size_t obj_size,
+        const char *primary_key_column,
+        off_t primary_key_offset);
+DBUClass* dbuRegisterClassWithPrimaryKeyString(
+        DBUContext *context,
+        const char *name,
+        size_t obj_size,
+        const char *primary_key_column,
+        off_t primary_key_offset);
+DBUClass* dbuRegisterClassWithPrimaryKeyCxMutStr(
+        DBUContext *context,
+        const char *name,
+        size_t obj_size,
+        const char *primary_key_column,
+        off_t primary_key_offset);
+
+void dbuClassSetPrimaryKeyInt32(DBUClass *cls, const char *column_name, off_t offset);
+void dbuClassSetPrimaryKeyUInt32(DBUClass *cls, const char *column_name, off_t offset);
+void dbuClassSetPrimaryKeyInt64(DBUClass *cls, const char *column_name, off_t offset);
+void dbuClassSetPrimaryKeyUInt64(DBUClass *cls, const char *column_name, off_t offset);
+void dbuClassSetPrimaryKeyString(DBUClass *cls, const char *column_name, off_t offset);
+void dbuClassSetPrimaryKeyCxMutStr(DBUClass *cls, const char *column_name, off_t offset);
+
+void dbuClassAddField(DBUClass *cls, const char *name, DBUField *field);
+
+#define dbuClassAdd(cls, type, member) \
+    dbuClassAddWithName(cls, type, member, #member)
+#define dbuClassAddWithName(cls, type, member, member_name) \
+    _Generic(((type*)0)->member, \
+    int8_t:       dbuClassAddInt8,     \
+    uint8_t:      dbuClassAddUInt8,    \
+    int16_t:      dbuClassAddInt16,    \
+    uint16_t:     dbuClassAddUInt16,   \
+    int32_t:      dbuClassAddInt32,    \
+    uint32_t:     dbuClassAddUInt32,   \
+    int64_t:      dbuClassAddInt64,    \
+    uint64_t:     dbuClassAddUInt64,   \
+    bool:         dbuClassAddBool,     \
+    float:        dbuClassAddFloat,    \
+    double:       dbuClassAddDouble,   \
+    char*:        dbuClassAddString,   \
+    cxmutstr:     dbuClassAddCXMutStr) \
+    (cls, member_name, offsetof(type, member), 0)
+
+void dbuClassAddInt(DBUClass *cls, const char *name, off_t offset, bool nonnull);
+void dbuClassAddUInt(DBUClass *cls, const char *name, off_t offset, bool nonnull);
+void dbuClassAddInt8(DBUClass *cls, const char *name, off_t offset, bool nonnull);
+void dbuClassAddUInt8(DBUClass *cls, const char *name, off_t offset, bool nonnull);
+void dbuClassAddInt16(DBUClass *cls, const char *name, off_t offset, bool nonnull);
+void dbuClassAddUInt16(DBUClass *cls, const char *name, off_t offset, bool nonnull);
+void dbuClassAddInt32(DBUClass *cls, const char *name, off_t offset, bool nonnull);
+void dbuClassAddUInt32(DBUClass *cls, const char *name, off_t offset, bool nonnull);
+void dbuClassAddInt64(DBUClass *cls, const char *name, off_t offset, bool nonnull);
+void dbuClassAddUInt64(DBUClass *cls, const char *name, off_t offset, bool nonnull);
+void dbuClassAddSize(DBUClass *cls, const char *name, off_t offset, bool nonnull);
+void dbuClassAddSSize(DBUClass *cls, const char *name, off_t offset, bool nonnull);
+void dbuClassAddBool(DBUClass *cls, const char *name, off_t offset, bool nonnull);
+void dbuClassAddFloat(DBUClass *cls, const char *name, off_t offset, bool nonnull);
+void dbuClassAddDouble(DBUClass *cls, const char *name, off_t offset, bool nonnull);
+void dbuClassAddString(DBUClass *cls, const char *name, off_t offset, bool nonnull);
+void dbuClassAddCXMutStr(DBUClass *cls, const char *name, off_t offset, bool nonnull);
+void dbuClassAddStringSize(DBUClass *cls, const char *name, off_t offset, off_t size_offset, bool nonnull);
+void dbuClassAddStringIntLen(DBUClass *cls, const char *name, off_t offset, off_t int_offset, bool nonnull);
+void dbuClassAddBuf(DBUClass *cls, const char *name, off_t offset, off_t size_offset, bool nonnull);
+void dbuClassAddBufIntLen(DBUClass *cls, const char *name, off_t offset, off_t int_offset, bool nonnull);
+
+void dbuClassAddIntDef(DBUClass *cls, const char *name, off_t offset, int def);
+void dbuClassAddUIntDef(DBUClass *cls, const char *name, off_t offset, unsigned int def);
+void dbuClassAddInt16Def(DBUClass *cls, const char *name, off_t offset, int16_t def);
+void dbuClassAddUInt16Def(DBUClass *cls, const char *name, off_t offset, uint16_t def);
+void dbuClassAddInt32Def(DBUClass *cls, const char *name, off_t offset, int32_t def);
+void dbuClassAddUInt32Def(DBUClass *cls, const char *name, off_t offset, uint32_t def);
+void dbuClassAddInt64Def(DBUClass *cls, const char *name, off_t offset, int64_t def);
+void dbuClassAddUInt64Def(DBUClass *cls, const char *name, off_t offset, uint64_t def);
+void dbuClassAddSizeDef(DBUClass *cls, const char *name, off_t offset, size_t def);
+void dbuClassAddSSizeDef(DBUClass *cls, const char *name, off_t offset, ssize_t def);
+void dbuClassAddFloatDef(DBUClass *cls, const char *name, off_t offset, float def);
+void dbuClassAddDoubleDef(DBUClass *cls, const char *name, off_t offset, double def);
+
+#ifdef __cplusplus
+}
+#endif
+
+#endif /* LIB_DBU_H */

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/dbutils/dbutils/sqlite.h	Sat Dec 07 18:56:37 2024 +0100
@@ -0,0 +1,48 @@
+/*
+ * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
+ *
+ * Copyright 2024 Olaf Wintermann. All rights reserved.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ *
+ *   1. Redistributions of source code must retain the above copyright
+ *      notice, this list of conditions and the following disclaimer.
+ *
+ *   2. Redistributions in binary form must reproduce the above copyright
+ *      notice, this list of conditions and the following disclaimer in the
+ *      documentation and/or other materials provided with the distribution.
+ *
+ * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
+ * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
+ * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
+ * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE
+ * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
+ * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
+ * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
+ * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
+ * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
+ * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
+ * POSSIBILITY OF SUCH DAMAGE.
+ */
+
+#ifndef LIBDBU_SQLITE_H
+#define LIBDBU_SQLITE_H
+
+#include "dbutils.h"
+
+#include <sqlite3.h>
+
+#ifdef __cplusplus
+extern "C" {
+#endif
+
+CxList *dbuSQLiteQuerySingleTable(DBUContext *ctx, sqlite3 *db, const char *type, const char *sql);
+
+
+#ifdef __cplusplus
+}
+#endif
+
+#endif /* LIBDBU_SQLITE_H */
+

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/dbutils/field.c	Sat Dec 07 18:56:37 2024 +0100
@@ -0,0 +1,977 @@
+/*
+ * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
+ *
+ * Copyright 2024 Olaf Wintermann. All rights reserved.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ *
+ *   1. Redistributions of source code must retain the above copyright
+ *      notice, this list of conditions and the following disclaimer.
+ *
+ *   2. Redistributions in binary form must reproduce the above copyright
+ *      notice, this list of conditions and the followign disclaimer in the
+ *      documentation and/or other materials provided with the distribution.
+ *
+ * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
+ * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
+ * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
+ * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE
+ * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
+ * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
+ * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
+ * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
+ * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
+ * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
+ * POSSIBILITY OF SUCH DAMAGE.
+ */
+
+#include <stdbool.h>
+#include <stdlib.h>
+#include <string.h>
+#include <limits.h>
+
+#include "field.h"
+
+/* -------------------- Default Initializer Functions -------------------- */
+
+static int field_def_init_int(DBUOffsetField *f, const CxAllocator *a, DBUObject obj) {
+    *(int*)(obj+f->offset) = (int)f->def.def;
+    return 0;
+}
+
+static int field_def_init_uint(DBUOffsetField *f, const CxAllocator *a, DBUObject obj) {
+    *(unsigned int*)(obj+f->offset) = (unsigned int)f->def.udef;
+    return 0;
+}
+
+static int field_def_init_int16(DBUOffsetField *f, const CxAllocator *a, DBUObject obj) {
+    *(int16_t*)(obj+f->offset) = (int16_t)f->def.def;
+    return 0;
+}
+
+static int field_def_init_uint16(DBUOffsetField *f, const CxAllocator *a, DBUObject obj) {
+    *(uint16_t*)(obj+f->offset) = (uint16_t)f->def.udef;
+    return 0;
+}
+
+static int field_def_init_int32(DBUOffsetField *f, const CxAllocator *a, DBUObject obj) {
+    *(int32_t*)(obj+f->offset) = (int32_t)f->def.def;
+    return 0;
+}
+
+static int field_def_init_uint32(DBUOffsetField *f, const CxAllocator *a, DBUObject obj) {
+    *(uint32_t*)(obj+f->offset) = (int32_t)f->def.udef;
+    return 0;
+}
+
+static int field_def_init_int64(DBUOffsetField *f, const CxAllocator *a, DBUObject obj) {
+    *(int64_t*)(obj+f->offset) = f->def.def;
+    return 0;
+}
+
+static int field_def_init_uint64(DBUOffsetField *f, const CxAllocator *a, DBUObject obj) {
+    *(uint64_t*)(obj+f->offset) = (uint64_t)f->def.udef;
+    return 0;
+}
+
+static int field_def_init_size(DBUOffsetField *f, const CxAllocator *a, DBUObject obj) {
+    *(size_t*)(obj+f->offset) = (size_t)f->def.udef;
+    return 0;
+}
+
+static int field_def_init_ssize(DBUOffsetField *f, const CxAllocator *a, DBUObject obj) {
+    *(ssize_t*)(obj+f->offset) = (ssize_t)f->def.def;
+    return 0;
+}
+
+static int field_def_init_float(DBUOffsetField *f, const CxAllocator *a, DBUObject obj) {
+    *(float*)(obj+f->offset) = (float)f->def.fdef;
+    return 0;
+}
+
+static int field_def_init_double(DBUOffsetField *f, const CxAllocator *a, DBUObject obj) {
+    *(double*)(obj+f->offset) = (double)f->def.ddef;
+    return 0;
+}
+
+
+/* --------------------     Initializer Functions     -------------------- */
+
+static int str2int(const char *str, int64_t *i) {
+    if(!str || *str == 0) {
+        return 0;
+    }
+    
+    char *endptr;
+    long long v = strtoll(str, &endptr, 10);
+    *i = v;
+    return *endptr == 0;
+}
+
+static int str2uint(const char *str, uint64_t *u) {
+    if(!str || *str == 0) {
+        return 0;
+    }
+    
+    char *endptr;
+    unsigned long long v = strtoull(str, &endptr, 10);
+    *u = v;
+    return *endptr == 0;
+}
+
+static int field_init_int(
+        DBUOffsetField *f,
+        const CxAllocator *a,
+        DBUObject obj,
+        const char *value,
+        size_t length)
+{
+    int64_t i;
+    if(!str2int(value, &i)) {
+        return 1;
+    }
+    if(i < INT_MIN || i > INT_MAX) {
+        return 1;
+    }
+    *(int*)(obj+f->offset) = (int)i;
+    return 0;
+}
+
+static int field_init_uint(
+        DBUOffsetField *f,
+        const CxAllocator *a,
+        DBUObject obj,
+        const char *value,
+        size_t length)
+{
+    uint64_t i;
+    if(!str2uint(value, &i)) {
+        return 1;
+    }
+    if(i > UINT_MAX) {
+        return 1;
+    }
+    *(unsigned int*)(obj+f->offset) = (unsigned int)i;
+    return 0;
+}
+
+static int field_init_int8(
+        DBUOffsetField *f,
+        const CxAllocator *a,
+        DBUObject obj,
+        const char *value,
+        size_t length)
+{
+    int64_t i;
+    if(!str2int(value, &i)) {
+        return 1;
+    }
+    if(i < INT8_MIN || i > INT8_MAX) {
+        return 1;
+    }
+    *(int8_t*)(obj+f->offset) = (int8_t)i;
+    return 0;
+}
+
+static int field_init_uint8(
+        DBUOffsetField *f,
+        const CxAllocator *a,
+        DBUObject obj,
+        const char *value,
+        size_t length)
+{
+    uint64_t i;
+    if(!str2uint(value, &i)) {
+        return 1;
+    }
+    if(i > UINT8_MAX) {
+        return 1;
+    }
+    *(uint8_t*)(obj+f->offset) = (uint8_t)i;
+    return 0;
+}
+
+static int field_init_int16(
+        DBUOffsetField *f,
+        const CxAllocator *a,
+        DBUObject obj,
+        const char *value,
+        size_t length)
+{
+    int64_t i;
+    if(!str2int(value, &i)) {
+        return 1;
+    }
+    if(i < INT16_MIN || i > INT16_MAX) {
+        return 1;
+    }
+    *(int16_t*)(obj+f->offset) = (int16_t)i;
+    return 0;
+}
+
+static int field_init_uint16(
+        DBUOffsetField *f,
+        const CxAllocator *a,
+        DBUObject obj,
+        const char *value,
+        size_t length)
+{
+    uint64_t i;
+    if(!str2uint(value, &i)) {
+        return 1;
+    }
+    if(i > UINT16_MAX) {
+        return 1;
+    }
+    *(uint16_t*)(obj+f->offset) = (uint16_t)i;
+    return 0;
+}
+
+static int field_init_int32(
+        DBUOffsetField *f,
+        const CxAllocator *a,
+        DBUObject obj,
+        const char *value,
+        size_t length)
+{
+    int64_t i;
+    if(!str2int(value, &i)) {
+        return 1;
+    }
+    if(i < INT32_MIN || i > INT32_MAX) {
+        return 1;
+    }
+    *(int32_t*)(obj+f->offset) = (int32_t)i;
+    return 0;
+}
+
+static int field_init_uint32(
+        DBUOffsetField *f,
+        const CxAllocator *a,
+        DBUObject obj,
+        const char *value,
+        size_t length)
+{
+    uint64_t i;
+    if(!str2uint(value, &i)) {
+        return 1;
+    }
+    if(i > UINT32_MAX) {
+        return 1;
+    }
+    *(uint32_t*)(obj+f->offset) = (uint32_t)i;
+    return 0;
+}
+
+static int field_init_int64(
+        DBUOffsetField *f,
+        const CxAllocator *a,
+        DBUObject obj,
+        const char *value,
+        size_t length)
+{
+    int64_t i;
+    if(!str2int(value, &i)) {
+        return 1;
+    }
+    *(int64_t*)(obj+f->offset) = i;
+    return 0;
+}
+
+static int field_init_uint64(
+        DBUOffsetField *f,
+        const CxAllocator *a,
+        DBUObject obj,
+        const char *value,
+        size_t length)
+{
+    uint64_t i;
+    if(!str2uint(value, &i)) {
+        return 1;
+    }
+    *(uint64_t*)(obj+f->offset) = i;
+    return 0;
+}
+
+static int field_init_size(
+        DBUOffsetField *f,
+        const CxAllocator *a,
+        DBUObject obj,
+        const char *value,
+        size_t length)
+{
+    uint64_t i;
+    if(!str2uint(value, &i)) {
+        return 1;
+    }
+    *(uint64_t*)(obj+f->offset) = i;
+    return 0;
+}
+
+static int field_init_ssize(
+        DBUOffsetField *f,
+        const CxAllocator *a,
+        DBUObject obj,
+        const char *value,
+        size_t length)
+{
+    int64_t i;
+    if(!str2int(value, &i)) {
+        return 1;
+    }
+    *(ssize_t*)(obj+f->offset) = (ssize_t)i;
+    return 0;
+}
+
+static int field_init_bool(
+        DBUOffsetField *f,
+        const CxAllocator *a,
+        DBUObject obj,
+        const char *value,
+        size_t length)
+{
+    bool boolvalue = 0;
+    if(value) {
+        char c = value[0];
+        if(c == 't' || c == 'T' || c == '1') {
+            boolvalue = 1;
+        }
+    }
+    *(bool*)(obj+f->offset) = boolvalue;
+    return 0;
+}
+
+static int field_init_float(
+        DBUOffsetField *f,
+        const CxAllocator *a,
+        DBUObject obj,
+        const char *value,
+        size_t length)
+{
+    char *endptr;
+    float v = strtof(value, &endptr);
+    if(!endptr || *endptr != 0) {
+        return 1;
+    }
+    *(float*)(obj+f->offset) = v;
+    return 0;
+}
+
+static int field_init_double(
+        DBUOffsetField *f,
+        const CxAllocator *a,
+        DBUObject obj,
+        const char *value,
+        size_t length)
+{
+    char *endptr;
+    double v = strtod(value, &endptr);
+    if(!endptr || *endptr != 0) {
+        return 1;
+    }
+    *(double*)(obj+f->offset) = v;
+    return 0;
+}
+
+
+static int field_init_str(
+        DBUOffsetField *f,
+        const CxAllocator *a,
+        DBUObject obj,
+        const char *value,
+        size_t length)
+{
+    cxmutstr m = cx_strdup_a(a, cx_strn(value, length));
+    if(!m.ptr) {
+        return 1;
+    }
+    *(char**)(obj+f->offset) = m.ptr;
+    return 0;
+}
+
+static int field_init_cxmutstr(
+        DBUOffsetField *f,
+        const CxAllocator *a,
+        DBUObject obj,
+        const char *value,
+        size_t length)
+{
+    cxmutstr m = cx_strdup_a(a, cx_strn(value, length));
+    if(!m.ptr) {
+        return 1;
+    }
+    *(cxmutstr*)(obj+f->offset) = m;
+    return 0;
+}
+
+static int field_init_str_size(
+        DBUObjLenField *f,
+        const CxAllocator *a,
+        DBUObject obj,
+        const char *value,
+        size_t length)
+{
+    cxmutstr m = cx_strdup_a(a, cx_strn(value, length));
+    if(!m.ptr) {
+        return 1;
+    }
+    *(char**)(obj+f->offset_obj) = m.ptr;
+    *(size_t*)(obj+f->offset_len) = m.length;
+    return 0;
+}
+
+static int field_init_str_intlen(
+        DBUObjLenField *f,
+        const CxAllocator *a,
+        DBUObject obj,
+        const char *value,
+        size_t length)
+{
+    cxmutstr m = cx_strdup_a(a, cx_strn(value, length));
+    if(!m.ptr) {
+        return 1;
+    }
+    *(char**)(obj+f->offset_obj) = m.ptr;
+    *(int*)(obj+f->offset_len) = (int)m.length;
+    return 0;
+}
+
+static int field_init_bytes_size(
+        DBUObjLenField *f,
+        const CxAllocator *a,
+        DBUObject obj,
+        const char *value,
+        size_t length)
+{
+    char *bytes = cxMalloc(a, length);
+    if(!bytes) {
+        return 1;
+    }
+    memcpy(bytes, value, length);
+    *(char**)(obj+f->offset_obj) = bytes;
+    *(size_t*)(obj+f->offset_len) = length;
+    return 0;
+}
+
+static int field_init_bytes_intlen(
+        DBUObjLenField *f,
+        const CxAllocator *a,
+        DBUObject obj,
+        const char *value,
+        size_t length)
+{
+    char *bytes = cxMalloc(a, length);
+    if(!bytes) {
+        return 1;
+    }
+    memcpy(bytes, value, length);
+    *(char**)(obj+f->offset_obj) = bytes;
+    *(int*)(obj+f->offset_len) = (int)length;
+    return 0;
+}
+
+
+/* --------------------     FIELD CONSTRUCTOR      -------------------- */
+
+static DBUField* create_offset_def_field(
+        off_t offset,
+        DBUFieldDefInitFunc def_init,
+        DBUFieldInitFunc init,
+        bool nonnull, 
+        union DBUDefValue def)
+{
+    DBUOffsetField *field = malloc(sizeof(DBUOffsetField));
+    field->field.initDefaultValue = def_init;
+    field->field.initValue = init;
+    field->field.nonnull = nonnull;
+    field->field.query_length = false;
+    field->offset = offset;
+    field->def = def;
+    return (DBUField*)field;
+}
+
+static void add_offset_def_field(
+        DBUClass *cls, 
+        const char *name, 
+        off_t offset,
+        DBUFieldDefInitFunc def_init,
+        DBUFieldInitFunc init,
+        bool nonnull, 
+        union DBUDefValue def)
+{
+    dbuClassAddField(cls, name, create_offset_def_field(offset, def_init, init, nonnull, def));
+}
+
+static void add_bool(
+        DBUClass *cls, 
+        const char *name, 
+        off_t offset,
+        bool nonnull)
+{
+    DBUOffsetField *field = malloc(sizeof(DBUOffsetField));
+    field->field.initDefaultValue = NULL;
+    field->field.initValue = (DBUFieldInitFunc)field_init_bool;
+    field->field.nonnull = nonnull;
+    field->field.query_length = false;
+    field->offset = offset;
+    field->def.def = 0;
+    dbuClassAddField(cls, name, (DBUField*)field);
+}
+
+static DBUField* create_offset_str_field(
+        DBUFieldInitFunc init,
+        off_t offset,
+        bool nonnull)
+{
+    DBUOffsetField *field = malloc(sizeof(DBUOffsetField));
+    field->field.initDefaultValue = NULL;
+    field->field.initValue = (DBUFieldInitFunc)init;
+    field->field.nonnull = nonnull;
+    field->field.query_length = true;
+    field->offset = offset;
+    field->def.def = 0;
+    return (DBUField*)field;
+}
+
+static void add_offset_str_field(
+        DBUClass *cls, 
+        const char *name,
+        DBUFieldInitFunc init,
+        off_t offset,
+        bool nonnull)
+{
+    DBUOffsetField *field = malloc(sizeof(DBUOffsetField));
+    field->field.initDefaultValue = NULL;
+    field->field.initValue = (DBUFieldInitFunc)init;
+    field->field.nonnull = nonnull;
+    field->field.query_length = true;
+    field->offset = offset;
+    field->def.def = 0;
+    dbuClassAddField(cls, name, create_offset_str_field(init, offset, nonnull));
+}
+
+static void add_objlen_field(
+        DBUClass *cls, 
+        const char *name, 
+        DBUFieldInitFunc init,
+        off_t offset,
+        off_t size_offset,
+        bool nonnull)
+{
+    DBUObjLenField *field = malloc(sizeof(DBUObjLenField));
+    field->field.initDefaultValue = NULL;
+    field->field.initValue = (DBUFieldInitFunc)init;
+    field->field.nonnull = nonnull;
+    field->field.query_length = true;
+    field->offset_obj = offset;
+    field->offset_len = size_offset;
+    dbuClassAddField(cls, name, (DBUField*)field);
+}
+
+
+
+
+DBUField* dbuFieldCreateInt32(off_t offset) {
+    return create_offset_def_field(offset, NULL, (DBUFieldInitFunc)field_init_int32, false, (union DBUDefValue){ 0 });
+}
+
+DBUField* dbuFieldCreateUInt32(off_t offset) {
+    return create_offset_def_field(offset, NULL, (DBUFieldInitFunc)field_init_uint32, false, (union DBUDefValue){ 0 });
+}
+
+DBUField* dbuFieldCreateInt64(off_t offset) {
+    return create_offset_def_field(offset, NULL, (DBUFieldInitFunc)field_init_int64, false, (union DBUDefValue){ 0 });
+}
+
+DBUField* dbuFieldCreateUInt64(off_t offset) {
+    return create_offset_def_field(offset, NULL, (DBUFieldInitFunc)field_init_uint64, false, (union DBUDefValue){ 0 });
+}
+
+DBUField* dbuFieldCreateString(off_t offset) {
+    return create_offset_str_field((DBUFieldInitFunc)field_init_str, offset, false);
+}
+
+DBUField* dbuFieldCreateCxMutStr(off_t offset) {
+    return create_offset_str_field((DBUFieldInitFunc)field_init_cxmutstr, offset, false);
+}
+
+/* --------------------            PUBLIC            -------------------- */
+
+
+void dbuClassAddInt(DBUClass *cls, const char *name, off_t offset, bool nonnull) {
+    add_offset_def_field(
+            cls,
+            name,
+            offset,
+            NULL,
+            (DBUFieldInitFunc)field_init_int,
+            nonnull,
+            (union DBUDefValue){ 0 });
+}
+
+void dbuClassAddUInt(DBUClass *cls, const char *name, off_t offset, bool nonnull) {
+    add_offset_def_field(
+            cls,
+            name,
+            offset,
+            NULL,
+            (DBUFieldInitFunc)field_init_uint,
+            nonnull,
+            (union DBUDefValue){ 0 });
+}
+
+void dbuClassAddInt8(DBUClass *cls, const char *name, off_t offset, bool nonnull) {
+    add_offset_def_field(
+            cls,
+            name,
+            offset,
+            NULL,
+            (DBUFieldInitFunc)field_init_int8,
+            nonnull,
+            (union DBUDefValue){ 0 });
+}
+
+void dbuClassAddUInt8(DBUClass *cls, const char *name, off_t offset, bool nonnull) {
+    add_offset_def_field(
+            cls,
+            name,
+            offset,
+            NULL,
+            (DBUFieldInitFunc)field_init_uint8,
+            nonnull,
+            (union DBUDefValue){ 0 });
+}
+
+void dbuClassAddInt16(DBUClass *cls, const char *name, off_t offset, bool nonnull) {
+    add_offset_def_field(
+            cls,
+            name,
+            offset,
+            NULL,
+            (DBUFieldInitFunc)field_init_int16,
+            nonnull,
+            (union DBUDefValue){ 0 });
+}
+
+void dbuClassAddUInt16(DBUClass *cls, const char *name, off_t offset, bool nonnull) {
+    add_offset_def_field(
+            cls,
+            name,
+            offset,
+            NULL,
+            (DBUFieldInitFunc)field_init_uint16,
+            nonnull,
+            (union DBUDefValue){ 0 });
+}
+
+void dbuClassAddInt32(DBUClass *cls, const char *name, off_t offset, bool nonnull) {
+    add_offset_def_field(
+            cls,
+            name,
+            offset,
+            NULL,
+            (DBUFieldInitFunc)field_init_int32,
+            nonnull,
+            (union DBUDefValue){ 0 });
+}
+
+void dbuClassAddUInt32(DBUClass *cls, const char *name, off_t offset, bool nonnull) {
+    add_offset_def_field(
+            cls,
+            name,
+            offset,
+            NULL,
+            (DBUFieldInitFunc)field_init_uint32,
+            nonnull,
+            (union DBUDefValue){ 0 });
+}
+
+void dbuClassAddInt64(DBUClass *cls, const char *name, off_t offset, bool nonnull) {
+    add_offset_def_field(
+            cls,
+            name,
+            offset,
+            NULL,
+            (DBUFieldInitFunc)field_init_int64,
+            nonnull,
+            (union DBUDefValue){ 0 });
+}
+
+void dbuClassAddUInt64(DBUClass *cls, const char *name, off_t offset, bool nonnull) {
+    add_offset_def_field(
+            cls,
+            name,
+            offset,
+            NULL,
+            (DBUFieldInitFunc)field_init_uint64,
+            nonnull,
+            (union DBUDefValue){ 0 });
+}
+
+void dbuClassAddSize(DBUClass *cls, const char *name, off_t offset, bool nonnull) {
+    add_offset_def_field(
+            cls,
+            name,
+            offset,
+            NULL,
+            (DBUFieldInitFunc)field_init_size,
+            nonnull,
+            (union DBUDefValue){ 0 });
+}
+
+void dbuClassAddSSize(DBUClass *cls, const char *name, off_t offset, bool nonnull) {
+    add_offset_def_field(
+            cls,
+            name,
+            offset,
+            NULL,
+            (DBUFieldInitFunc)field_init_ssize,
+            nonnull,
+            (union DBUDefValue){ 0 });
+}
+
+void dbuClassAddBool(DBUClass *cls, const char *name, off_t offset, bool nonnull) {
+    add_bool(
+            cls, 
+            name, 
+            offset,
+            nonnull);
+}
+
+void dbuClassAddFloat(DBUClass *cls, const char *name, off_t offset, bool nonnull) {
+    add_offset_def_field(
+            cls,
+            name,
+            offset,
+            NULL,
+            (DBUFieldInitFunc)field_init_float,
+            nonnull,
+            (union DBUDefValue){ 0 });
+}
+
+void dbuClassAddDouble(DBUClass *cls, const char *name, off_t offset, bool nonnull) {
+    add_offset_def_field(
+            cls,
+            name,
+            offset,
+            NULL,
+            (DBUFieldInitFunc)field_init_double,
+            nonnull,
+            (union DBUDefValue){ 0 });
+}
+
+void dbuClassAddString(DBUClass *cls, const char *name, off_t offset, bool nonnull) {
+    add_offset_str_field(
+            cls, 
+            name,
+            (DBUFieldInitFunc)field_init_str,
+            offset,
+            nonnull);
+}
+
+void dbuClassAddCXMutStr(DBUClass *cls, const char *name, off_t offset, bool nonnull) {
+    add_offset_str_field(
+            cls, 
+            name,
+            (DBUFieldInitFunc)field_init_cxmutstr,
+            offset,
+            nonnull);
+}
+
+void dbuClassAddStringSize(DBUClass *cls, const char *name, off_t offset, off_t size_offset, bool nonnull) {
+    add_objlen_field(
+            cls, 
+            name, 
+            (DBUFieldInitFunc)field_init_str_size,
+            offset,
+            size_offset,
+            nonnull);
+}
+
+void dbuClassAddStringIntLen(DBUClass *cls, const char *name, off_t offset, off_t int_offset, bool nonnull) {
+    add_objlen_field(
+            cls, 
+            name, 
+            (DBUFieldInitFunc)field_init_str_intlen,
+            offset,
+            int_offset,
+            nonnull);
+}
+
+void dbuClassAddBuf(DBUClass *cls, const char *name, off_t offset, off_t size_offset, bool nonnull) {
+    add_objlen_field(
+            cls, 
+            name, 
+            (DBUFieldInitFunc)field_init_bytes_size,
+            offset,
+            size_offset,
+            nonnull);
+}
+
+void dbuClassAddBufIntLen(DBUClass *cls, const char *name, off_t offset, off_t int_offset, bool nonnull) {
+    add_objlen_field(
+            cls, 
+            name, 
+            (DBUFieldInitFunc)field_init_bytes_intlen,
+            offset,
+            int_offset,
+            nonnull);
+}
+
+
+void dbuClassAddIntDef(DBUClass *cls, const char *name, off_t offset, int def) {
+    union DBUDefValue defvalue;
+    defvalue.def = def;
+    add_offset_def_field(
+            cls,
+            name,
+            offset,
+            (DBUFieldDefInitFunc)field_def_init_int,
+            (DBUFieldInitFunc)field_init_int,
+            false,
+            (union DBUDefValue){ 0 });
+}
+
+void dbuClassAddUIntDef(DBUClass *cls, const char *name, off_t offset, unsigned int def) {
+    union DBUDefValue defvalue;
+    defvalue.udef = def;
+    add_offset_def_field(
+            cls,
+            name,
+            offset,
+            (DBUFieldDefInitFunc)field_def_init_uint,
+            (DBUFieldInitFunc)field_init_uint,
+            false,
+            (union DBUDefValue){ 0 });
+}
+
+void dbuClassAddInt16Def(DBUClass *cls, const char *name, off_t offset, int16_t def) {
+    union DBUDefValue defvalue;
+    defvalue.def = def;
+    add_offset_def_field(
+            cls,
+            name,
+            offset,
+            (DBUFieldDefInitFunc)field_def_init_int16,
+            (DBUFieldInitFunc)field_init_int16,
+            false,
+            (union DBUDefValue){ 0 });
+}
+
+void dbuClassAddUInt16Def(DBUClass *cls, const char *name, off_t offset, uint16_t def) {
+    union DBUDefValue defvalue;
+    defvalue.udef = def;
+    add_offset_def_field(
+            cls,
+            name,
+            offset,
+            (DBUFieldDefInitFunc)field_def_init_uint16,
+            (DBUFieldInitFunc)field_init_uint16,
+            false,
+            (union DBUDefValue){ 0 });
+}
+
+void dbuClassAddInt32Def(DBUClass *cls, const char *name, off_t offset, int32_t def) {
+    union DBUDefValue defvalue;
+    defvalue.def = def;
+    add_offset_def_field(
+            cls,
+            name,
+            offset,
+            (DBUFieldDefInitFunc)field_def_init_int32,
+            (DBUFieldInitFunc)field_init_int32,
+            false,
+            (union DBUDefValue){ 0 });
+}
+
+void dbuClassAddUInt32Def(DBUClass *cls, const char *name, off_t offset, uint32_t def) {
+    union DBUDefValue defvalue;
+    defvalue.udef = def;
+    add_offset_def_field(
+            cls,
+            name,
+            offset,
+            (DBUFieldDefInitFunc)field_def_init_uint32,
+            (DBUFieldInitFunc)field_init_uint32,
+            false,
+            (union DBUDefValue){ 0 });
+}
+
+void dbuClassAddInt64Def(DBUClass *cls, const char *name, off_t offset, int64_t def) {
+    union DBUDefValue defvalue;
+    defvalue.def = def;
+    add_offset_def_field(
+            cls,
+            name,
+            offset,
+            (DBUFieldDefInitFunc)field_def_init_int64,
+            (DBUFieldInitFunc)field_init_int64,
+            false,
+            (union DBUDefValue){ 0 });
+}
+
+void dbuClassAddUInt64Def(DBUClass *cls, const char *name, off_t offset, uint64_t def) {
+    union DBUDefValue defvalue;
+    defvalue.def = def;
+    add_offset_def_field(
+            cls,
+            name,
+            offset,
+            (DBUFieldDefInitFunc)field_def_init_uint64,
+            (DBUFieldInitFunc)field_init_uint64,
+            false,
+            (union DBUDefValue){ 0 });
+}
+
+void dbuClassAddSizeDef(DBUClass *cls, const char *name, off_t offset, size_t def) {
+    union DBUDefValue defvalue;
+    defvalue.udef = def;
+    add_offset_def_field(
+            cls,
+            name,
+            offset,
+            (DBUFieldDefInitFunc)field_def_init_size,
+            (DBUFieldInitFunc)field_init_size,
+            false,
+            (union DBUDefValue){ 0 });
+}
+
+void dbuClassAddSSizeDef(DBUClass *cls, const char *name, off_t offset, ssize_t def) {
+    union DBUDefValue defvalue;
+    defvalue.def = def;
+    add_offset_def_field(
+            cls,
+            name,
+            offset,
+            (DBUFieldDefInitFunc)field_def_init_ssize,
+            (DBUFieldInitFunc)field_init_ssize,
+            false,
+            (union DBUDefValue){ 0 });
+}
+
+void dbuClassAddFloatDef(DBUClass *cls, const char *name, off_t offset, float def) {
+    union DBUDefValue defvalue;
+    defvalue.fdef = def;
+    add_offset_def_field(
+            cls,
+            name,
+            offset,
+            (DBUFieldDefInitFunc)field_def_init_float,
+            (DBUFieldInitFunc)field_init_float,
+            false,
+            (union DBUDefValue){ 0 });
+}
+
+void dbuClassAddDoubleDef(DBUClass *cls, const char *name, off_t offset, double def) {
+    union DBUDefValue defvalue;
+    defvalue.ddef = def;
+    add_offset_def_field(
+            cls,
+            name,
+            offset,
+            (DBUFieldDefInitFunc)field_def_init_double,
+            (DBUFieldInitFunc)field_init_double,
+            false,
+            (union DBUDefValue){ 0 });
+}

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/dbutils/field.h	Sat Dec 07 18:56:37 2024 +0100
@@ -0,0 +1,82 @@
+/*
+ * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
+ *
+ * Copyright 2024 Olaf Wintermann. All rights reserved.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ *
+ *   1. Redistributions of source code must retain the above copyright
+ *      notice, this list of conditions and the following disclaimer.
+ *
+ *   2. Redistributions in binary form must reproduce the above copyright
+ *      notice, this list of conditions and the following disclaimer in the
+ *      documentation and/or other materials provided with the distribution.
+ *
+ * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
+ * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
+ * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
+ * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE
+ * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
+ * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
+ * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
+ * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
+ * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
+ * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
+ * POSSIBILITY OF SUCH DAMAGE.
+ */
+
+#ifndef DBU_FIELD_H
+#define DBU_FIELD_H
+
+#include "dbutils/dbutils.h"
+
+#ifdef __cplusplus
+extern "C" {
+#endif
+
+union DBUDefValue {
+    int64_t def;
+    uint64_t udef;
+    float fdef;
+    double ddef;
+};
+    
+/*
+ * used in most cases, when there is exactly one struct member
+ */
+typedef struct DBUOffsetField {
+    DBUField field;
+    off_t offset;
+    union DBUDefValue def;
+} DBUOffsetField;
+
+/*
+ * fields with 2 struct members: a obj pointer and length 
+ */
+typedef struct DBUObjLenField {
+    DBUField field;
+    off_t offset_obj;
+    off_t offset_len;
+} DBUObjLenField;
+
+
+DBUField* dbuFieldCreateInt32(off_t offset);
+
+DBUField* dbuFieldCreateUInt32(off_t offset);
+
+DBUField* dbuFieldCreateInt64(off_t offset);
+
+DBUField* dbuFieldCreateUInt64(off_t offset);
+
+DBUField* dbuFieldCreateString(off_t offset);
+
+DBUField* dbuFieldCreateCxMutStr(off_t offset);
+
+
+#ifdef __cplusplus
+}
+#endif
+
+#endif /* DBU_FIELD_H */
+

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/dbutils/sqlite.c	Sat Dec 07 18:56:37 2024 +0100
@@ -0,0 +1,112 @@
+/*
+ * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
+ *
+ * Copyright 2024 Olaf Wintermann. All rights reserved.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ *
+ *   1. Redistributions of source code must retain the above copyright
+ *      notice, this list of conditions and the following disclaimer.
+ *
+ *   2. Redistributions in binary form must reproduce the above copyright
+ *      notice, this list of conditions and the following disclaimer in the
+ *      documentation and/or other materials provided with the distribution.
+ *
+ * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
+ * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
+ * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
+ * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE
+ * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
+ * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
+ * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
+ * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
+ * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
+ * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
+ * POSSIBILITY OF SUCH DAMAGE.
+ */
+
+#ifdef DBU_SQLITE
+
+#include "sqlite.h"
+#include "db.h"
+
+#include <string.h>
+#include <stdlib.h>
+#include <cx/array_list.h>
+
+
+CxList *dbuSQLiteQuerySingleTable(DBUContext *ctx, sqlite3 *db, const char *type, const char *sql) {
+    DBUClass *cls = cxMapGet(ctx->classes, type);
+    if(!cls) {
+        return NULL;
+    }
+    
+    // execute sql
+    sqlite3_stmt *stmt;
+    int rc = sqlite3_prepare_v2(db, sql, -1, &stmt, 0);
+    if(rc != SQLITE_OK) {
+        return NULL;
+    }
+    
+    // prepare list
+    CxList *list = cxArrayListCreateSimple(CX_STORE_POINTERS, 16);
+    if(!list) {
+        sqlite3_finalize(stmt);
+        return NULL;
+    }
+    
+    // map result to class fields
+    int numcols = sqlite3_column_count(stmt);
+    DBUFieldMapping *fields = calloc(numcols, sizeof(DBUFieldMapping));
+    if(!fields) {
+        sqlite3_finalize(stmt);
+        cxListDestroy(list);
+        return NULL;
+    }
+    int numfields = 0;
+    for(int i=0;i<numcols;i++) {
+        DBUField *field = cxMapGet(cls->fields, sqlite3_column_name(stmt, i));
+        if(field) {
+            DBUFieldMapping mapping;
+            mapping.field = field;
+            mapping.result_index = i;
+            fields[numfields++] = mapping;
+        }
+    }
+    
+    const CxAllocator *a = cxDefaultAllocator;
+    
+    // get result
+    while(sqlite3_step(stmt) == SQLITE_ROW) {
+        void *obj = malloc(cls->obj_size);
+        if(!obj) {
+            break;
+        }
+        memset(obj, 0, sizeof(cls->obj_size));
+        
+        for(int i=0;i<numfields;i++) {
+            DBUFieldMapping field = fields[i];
+            int isnull = sqlite3_column_type(stmt, field.result_index) == SQLITE_NULL;
+            
+            if(isnull) {
+                field.field->initDefaultValue(field.field, a, obj);
+            } else {
+                const char *text = (const char *)sqlite3_column_text(stmt, i);
+                int length = 0;
+                if(field.field->query_length) {
+                    length = sqlite3_column_bytes(stmt, field.result_index);
+                }
+                
+                field.field->initValue(field.field, a, obj, text, length);
+            }
+        }
+        
+        cxListAdd(list, obj);
+    }
+    sqlite3_finalize(stmt);
+    return list;
+}
+
+
+#endif /* DBU_SQLITE */

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/dbutils/sqlite.h	Sat Dec 07 18:56:37 2024 +0100
@@ -0,0 +1,49 @@
+/*
+ * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
+ *
+ * Copyright 2024 Olaf Wintermann. All rights reserved.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ *
+ *   1. Redistributions of source code must retain the above copyright
+ *      notice, this list of conditions and the following disclaimer.
+ *
+ *   2. Redistributions in binary form must reproduce the above copyright
+ *      notice, this list of conditions and the following disclaimer in the
+ *      documentation and/or other materials provided with the distribution.
+ *
+ * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
+ * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
+ * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
+ * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE
+ * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
+ * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
+ * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
+ * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
+ * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
+ * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
+ * POSSIBILITY OF SUCH DAMAGE.
+ */
+
+#ifdef DBU_SQLITE
+
+#ifndef DBU_SQLITE_H
+#define DBU_SQLITE_H
+
+#include "dbutils/sqlite.h"
+
+#ifdef __cplusplus
+extern "C" {
+#endif
+
+
+
+
+#ifdef __cplusplus
+}
+#endif
+
+#endif /* DBU_SQLITE_H */
+
+#endif /* DBU_SQLITE */

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/make/cc.mk	Sat Dec 07 18:56:37 2024 +0100
@@ -0,0 +1,14 @@
+#
+# cc toolchain config
+#
+
+CFLAGS =
+CXXFLAGS =
+DEBUG_CC_FLAGS = -g
+DEBUG_CXX_FLAGS = -g
+RELEASE_CC_FLAGS = -O3 -DNDEBUG
+RELEASE_CXX_FLAGS = -O3 -DNDEBUG
+LDFLAGS =
+
+SHLIB_CFLAGS = -fPIC
+SHLIB_LDFLAGS = -shared
\ No newline at end of file

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/make/clang.mk	Sat Dec 07 18:56:37 2024 +0100
@@ -0,0 +1,14 @@
+#
+# clang toolchain config
+#
+
+CFLAGS =
+CXXFLAGS =
+DEBUG_CC_FLAGS = -g
+DEBUG_CXX_FLAGS = -g
+RELEASE_CC_FLAGS = -O3 -DNDEBUG
+RELEASE_CXX_FLAGS = -O3 -DNDEBUG
+LDFLAGS =
+
+SHLIB_CFLAGS = -fPIC
+SHLIB_LDFLAGS = -shared

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/make/configure.vm	Sat Dec 07 18:56:37 2024 +0100
@@ -0,0 +1,687 @@
+#!/bin/sh
+
+#set( $D = '$' )
+#[[
+# some utility functions
+isplatform()
+{
+    for p in $PLATFORM
+    do
+        if [ "$p" = "$1" ]; then
+            return 0
+        fi
+    done
+    return 1
+}
+notisplatform()
+{
+    for p in $PLATFORM
+    do
+        if [ "$p" = "$1" ]; then
+            return 1
+        fi
+    done
+    return 0
+}
+istoolchain()
+{
+    for t in $TOOLCHAIN
+    do
+        if [ "$t" = "$1" ]; then
+            return 0
+        fi
+    done
+    return 1
+}
+notistoolchain()
+{
+    for t in $TOOLCHAIN
+    do
+        if [ "$t" = "$1" ]; then
+            return 1
+        fi
+    done
+    return 0
+}
+
+# clean abort
+abort_configure()
+{
+    rm -Rf "$TEMP_DIR"
+    exit 1
+}
+
+# Test for availability of pkg-config
+PKG_CONFIG=`command -v pkg-config`
+: ${PKG_CONFIG:="false"}
+
+# Simple uname based platform detection
+# $PLATFORM is used for platform dependent dependency selection
+OS=`uname -s`
+OS_VERSION=`uname -r`
+printf "detect platform... "
+if [ "$OS" = "SunOS" ]; then
+    PLATFORM="solaris sunos unix svr4"
+elif [ "$OS" = "Linux" ]; then
+    PLATFORM="linux unix"
+elif [ "$OS" = "FreeBSD" ]; then
+    PLATFORM="freebsd bsd unix"
+elif [ "$OS" = "OpenBSD" ]; then
+    PLATFORM="openbsd bsd unix"
+elif [ "$OS" = "NetBSD" ]; then
+    PLATFORM="netbsd bsd unix"
+elif [ "$OS" = "Darwin" ]; then
+    PLATFORM="macos osx bsd unix"
+elif echo "$OS" | grep -i "MINGW" > /dev/null; then
+    PLATFORM="windows mingw"
+fi
+: ${PLATFORM:="unix"}
+
+PLATFORM_NAME=`echo "$PLATFORM" | cut -f1 -d' ' -`
+echo "$PLATFORM_NAME"
+]]#
+
+# help text
+printhelp()
+{
+    echo "Usage: $0 [OPTIONS]..."
+    cat << __EOF__
+Installation directories:
+  --prefix=PREFIX         path prefix for architecture-independent files
+                          [${D}prefix]
+  --exec-prefix=EPREFIX   path prefix for architecture-dependent files
+                          [PREFIX]
+
+  --bindir=DIR            user executables [EPREFIX/bin]
+  --sbindir=DIR           system admin executables [EPREFIX/sbin]
+  --libexecdir=DIR        program executables [EPREFIX/libexec]
+  --sysconfdir=DIR        system configuration files [PREFIX/etc]
+  --sharedstatedir=DIR    modifiable architecture-independent data [PREFIX/com]
+  --localstatedir=DIR     modifiable single-machine data [PREFIX/var]
+  --runstatedir=DIR       run-time variable data [LOCALSTATEDIR/run]
+  --libdir=DIR            object code libraries [EPREFIX/lib]
+  --includedir=DIR        C header files [PREFIX/include]
+  --datarootdir=DIR       read-only arch.-independent data root [PREFIX/share]
+  --datadir=DIR           read-only architecture-independent data [DATAROOTDIR]
+  --infodir=DIR           info documentation [DATAROOTDIR/info]
+  --mandir=DIR            man documentation [DATAROOTDIR/man]
+  --localedir=DIR         locale-dependent data [DATAROOTDIR/locale]
+
+#if( $options.size() > 0 )
+Options:
+  --debug                 add extra compile flags for debug builds
+  --release               add extra compile flags for release builds
+#foreach( $opt in $options )
+  --${opt.argument}=${opt.valuesString}
+#end
+
+#end
+#if( $features.size() > 0 )
+Optional Features:
+#foreach( $feature in $features )
+${feature.helpText}
+#end
+
+#end
+__EOF__
+}
+
+# create temporary directory
+TEMP_DIR=".tmp-`uname -n`"
+rm -Rf "$TEMP_DIR"
+if mkdir -p "$TEMP_DIR"; then
+    :
+else
+    echo "Cannot create tmp dir $TEMP_DIR"
+    echo "Abort"
+    exit 1
+fi
+touch "$TEMP_DIR/options"
+touch "$TEMP_DIR/features"
+
+# define standard variables
+# also define standard prefix (this is where we will search for config.site)
+prefix=/usr
+exec_prefix=
+bindir=
+sbindir=
+libdir=
+libexecdir=
+datarootdir=
+datadir=
+sysconfdir=
+sharedstatedir=
+localstatedir=
+runstatedir=
+includedir=
+infodir=
+localedir=
+mandir=
+
+# custom variables
+#foreach( $cfg in $config )
+if true \
+#if( $cfg.platform )
+    && isplatform "${cfg.platform}" \
+#end
+#foreach( $np in $cfg.notList )
+      && notisplatform "${np}" \
+#end
+      ; then
+    #foreach( $var in $cfg.vars )
+    #if( $var.exec )
+    ${var.varName}=`${var.value}`
+    #else
+    ${var.varName}="${var.value}"
+    #end
+    #end
+fi
+#end
+
+# features
+#foreach( $feature in $features )
+#if( ${feature.auto} )
+${feature.varName}=auto
+#end
+#end
+
+#
+# parse arguments
+#
+BUILD_TYPE="default"
+for ARG in "$@"
+do
+    case "$ARG" in
+        "--prefix="*)         prefix=${D}{ARG#--prefix=} ;;
+        "--exec-prefix="*)    exec_prefix=${D}{ARG#--exec-prefix=} ;;
+        "--bindir="*)         bindir=${D}{ARG#----bindir=} ;;
+        "--sbindir="*)        sbindir=${D}{ARG#--sbindir=} ;;
+        "--libdir="*)         libdir=${D}{ARG#--libdir=} ;;
+        "--libexecdir="*)     libexecdir=${D}{ARG#--libexecdir=} ;;
+        "--datarootdir="*)    datarootdir=${D}{ARG#--datarootdir=} ;;
+        "--datadir="*)        datadir=${D}{ARG#--datadir=} ;;
+        "--sysconfdir="*)     sysconfdir=${D}{ARG#--sysconfdir=} ;;
+        "--sharedstatedir="*) sharedstatedir=${D}{ARG#--sharedstatedir=} ;;
+        "--localstatedir="*)  localstatedir=${D}{ARG#--localstatedir=} ;;
+        "--includedir="*)     includedir=${D}{ARG#--includedir=} ;;
+        "--infodir="*)        infodir=${D}{ARG#--infodir=} ;;
+        "--mandir"*)          mandir=${D}{ARG#--mandir} ;;
+        "--localedir"*)       localedir=${D}{ARG#--localedir} ;;
+        "--help"*) printhelp; abort_configure ;;
+        "--debug")           BUILD_TYPE="debug" ;;
+        "--release")         BUILD_TYPE="release" ;;
+    #foreach( $opt in $options )
+        "--${opt.argument}="*) ${opt.varName}=${D}{ARG#--${opt.argument}=} ;;
+    #end
+    #foreach( $feature in $features )
+        "--enable-${feature.arg}") ${feature.varName}=on ;;
+        "--disable-${feature.arg}") unset ${feature.varName} ;;
+    #end
+        "-"*) echo "unknown option: $ARG"; abort_configure ;;
+    esac
+done
+
+## Begin unparsed content. **
+#[[
+
+# set defaults for dir variables
+: ${exec_prefix:="$prefix"}
+: ${bindir:='${exec_prefix}/bin'}
+: ${sbindir:='${exec_prefix}/sbin'}
+: ${libdir:='${exec_prefix}/lib'}
+: ${libexecdir:='${exec_prefix}/libexec'}
+: ${datarootdir:='${prefix}/share'}
+: ${datadir:='${datarootdir}'}
+: ${sysconfdir:='${prefix}/etc'}
+: ${sharedstatedir:='${prefix}/com'}
+: ${localstatedir:='${prefix}/var'}
+: ${runstatedir:='${localstatedir}/run'}
+: ${includedir:='${prefix}/include'}
+: ${infodir:='${datarootdir}/info'}
+: ${mandir:='${datarootdir}/man'}
+: ${localedir:='${datarootdir}/locale'}
+
+# check if a config.site exists and load it
+if [ -n "$CONFIG_SITE" ]; then
+    # CONFIG_SITE may contain space separated file names
+    for cs in $CONFIG_SITE; do
+        printf "loading defaults from $cs... "
+        . "$cs"
+        echo ok
+    done
+elif [ -f "$prefix/share/config.site" ]; then
+    printf "loading site defaults... "
+    . "$prefix/share/config.site"
+    echo ok
+elif [ -f "$prefix/etc/config.site" ]; then
+    printf "loading site defaults... "
+    . "$prefix/etc/config.site"
+    echo ok
+fi
+]]#
+## End of unparsed content **
+
+# generate vars.mk
+cat > "$TEMP_DIR/vars.mk" << __EOF__
+prefix=$prefix
+exec_prefix=$exec_prefix
+bindir=$bindir
+sbindir=$sbindir
+libdir=$libdir
+libexecdir=$libexecdir
+datarootdir=$datarootdir
+datadir=$datadir
+sysconfdir=$sysconfdir
+sharedstatedir=$sharedstatedir
+localstatedir=$localstatedir
+runstatedir=$runstatedir
+includedir=$includedir
+infodir=$infodir
+mandir=$mandir
+localedir=$localedir
+#foreach( $var in $vars )
+${var.varName}=${D}${var.varName}
+#end
+__EOF__
+
+# toolchain detection utilities
+. make/toolchain.sh
+
+#
+# DEPENDENCIES
+#
+
+# check languages
+lang_c=
+lang_cpp=
+#foreach( $lang in $languages )
+if detect_${lang}_compiler ; then
+    lang_${lang}=1
+fi
+#end
+
+# create buffer for make variables required by dependencies
+echo > "$TEMP_DIR/make.mk"
+
+test_pkg_config()
+{
+    if "$PKG_CONFIG" --exists "$1" ; then :
+    else return 1 ; fi
+    if [ -z "$2" ] || "$PKG_CONFIG" --atleast-version="$2" "$1" ; then :
+    else return 1 ; fi
+    if [ -z "$3" ] || "$PKG_CONFIG" --exact-version="$3" "$1" ; then :
+    else return 1 ; fi
+    if [ -z "$4" ] || "$PKG_CONFIG" --max-version="$4" "$1" ; then :
+    else return 1 ; fi
+    return 0
+}
+
+print_check_msg()
+{
+    if [ -z "$1" ]; then
+        shift
+        printf "$@"
+    fi
+}
+
+#foreach( $dependency in $namedDependencies )
+dependency_error_${dependency.id}()
+{
+    print_check_msg "${D}dep_checked_${dependency.id}" "checking for ${dependency.name}... "
+    #foreach( $sub in $dependency.subdependencies )
+    # dependency $sub.fullName
+    while true
+    do
+        #if( $sub.platform )
+        if notisplatform "${sub.platform}"; then
+            break
+        fi
+        #end
+        #if( $sub.toolchain )
+        if notistoolchain "${sub.toolchain}"; then
+            break
+        fi
+        #end
+        #foreach( $np in $sub.notList )
+        if isplatform "${np}" || istoolchain "${np}"; then
+            break
+        fi
+        #end
+        #foreach( $lang in $sub.lang )
+        if [ -z "$lang_${lang}" ] ; then
+            break
+        fi
+        #end
+        #if( $sub.pkgconfig.size() > 0 )
+        if [ -z "$PKG_CONFIG" ]; then
+            break
+        fi
+        #end
+        #foreach( $test in $sub.tests )
+        if $test > /dev/null ; then
+            :
+        else
+            break
+        fi
+        #end
+        #foreach( $pkg in $sub.pkgconfig )
+        if test_pkg_config "$pkg.name" "$pkg.atleast" "$pkg.exact" "$pkg.max" ; then
+            TEMP_CFLAGS="$TEMP_CFLAGS `"$PKG_CONFIG" --cflags $pkg.name`"
+            TEMP_LDFLAGS="$TEMP_LDFLAGS `"$PKG_CONFIG" --libs $pkg.name`"
+        else
+            break
+        fi
+        #end
+        #foreach( $flags in $sub.flags )
+        #if( $flags.exec )
+        if tmp_flags=`$flags.value` ; then
+            TEMP_$flags.varName="$TEMP_$flags.varName $tmp_flags"
+        else
+            break
+        fi
+        #else
+        TEMP_$flags.varName="$TEMP_$flags.varName $flags.value"
+        #end
+        #end
+        #if ( $sub.make.length() > 0 )
+        cat >> $TEMP_DIR/make.mk << __EOF__
+# Dependency: $dependency.name
+$sub.make
+__EOF__
+        #end
+        print_check_msg "${D}dep_checked_${dependency.id}" "yes\n"
+        dep_checked_${dependency.id}=1
+        return 1
+    done
+
+    #end
+    print_check_msg "${D}dep_checked_${dependency.id}" "no\n"
+    dep_checked_${dependency.id}=1
+    return 0
+}
+#end
+
+# start collecting dependency information
+echo > "$TEMP_DIR/flags.mk"
+
+DEPENDENCIES_FAILED=
+ERROR=0
+#if( $dependencies.size() > 0 )
+# unnamed dependencies
+TEMP_CFLAGS=
+TEMP_CXXFLAGS=
+TEMP_LDFLAGS=
+#foreach( $dependency in $dependencies )
+while true
+do
+    #if( $dependency.platform )
+    if notisplatform "${dependency.platform}"; then
+        break
+    fi
+    #end
+    #if( $dependency.toolchain )
+    if notistoolchain "${dependency.toolchain}"; then
+        break
+    fi
+    #end
+    #foreach( $np in $dependency.notList )
+    if isplatform "${np}" || istoolchain "${np}"; then
+        break
+    fi
+    #end
+    while true
+    do
+        #foreach( $lang in $dependency.lang )
+        if [ -z "$lang_${lang}" ] ; then
+            ERROR=1
+            break
+        fi
+        #end
+        #if( $dependency.pkgconfig.size() > 0 )
+        if [ -z "$PKG_CONFIG" ]; then
+            ERROR=1
+            break
+        fi
+        #end
+        #foreach( $pkg in $dependency.pkgconfig )
+        print_check_msg "${D}dep_pkgconfig_checked_${pkg.id}" "checking for pkg-config package $pkg.name... "
+        if test_pkg_config "$pkg.name" "$pkg.atleast" "$pkg.exact" "$pkg.max" ; then
+            print_check_msg "${D}dep_pkgconfig_checked_${pkg.id}" "yes\n"
+            dep_pkgconfig_checked_${pkg.id}=1
+            TEMP_CFLAGS="$TEMP_CFLAGS `"$PKG_CONFIG" --cflags $pkg.name`"
+            TEMP_LDFLAGS="$TEMP_LDFLAGS `"$PKG_CONFIG" --libs $pkg.name`"
+        else
+            print_check_msg "${D}dep_pkgconfig_checked_${pkg.id}" "no\n"
+            dep_pkgconfig_checked_${pkg.id}=1
+            ERROR=1
+            break
+        fi
+        #end
+
+        #foreach( $flags in $dependency.flags )
+        #if( $flags.exec )
+        $flags.value > /dev/null
+        if tmp_flags=`$flags.value` ; then
+            TEMP_$flags.varName="$TEMP_$flags.varName $tmp_flags"
+        else
+            ERROR=1
+            break
+        fi
+        #else
+        TEMP_$flags.varName="$TEMP_$flags.varName $flags.value"
+        #end
+        #end
+        #if ( $dependency.make.length() > 0 )
+        cat >> "$TEMP_DIR/make.mk" << __EOF__
+$dependency.make
+__EOF__
+        #end
+        break
+    done
+    break
+done
+#end
+
+# add general dependency flags to flags.mk
+echo "# general flags" >> "$TEMP_DIR/flags.mk"
+if [ -n "${TEMP_CFLAGS}" ] && [ -n "$lang_c" ]; then
+    echo "CFLAGS += $TEMP_CFLAGS" >> "$TEMP_DIR/flags.mk"
+fi
+if [ -n "${TEMP_CXXFLAGS}" ] && [ -n "$lang_cpp" ]; then
+    echo "CXXFLAGS += $TEMP_CXXFLAGS" >> "$TEMP_DIR/flags.mk"
+fi
+if [ -n "${TEMP_LDFLAGS}" ]; then
+    echo "LDFLAGS += $TEMP_LDFLAGS" >> "$TEMP_DIR/flags.mk"
+fi
+#end
+
+#
+# OPTION VALUES
+#
+#foreach( $opt in $options )
+#foreach( $val in $opt.values )
+${val.func}()
+{
+    VERR=0
+    #foreach( $dep in $val.dependencies )
+    if dependency_error_$dep ; then
+        VERR=1
+    fi
+    #end
+    if [ $VERR -ne 0 ]; then
+        return 1
+    fi
+    #foreach( $def in $val.defines )
+        TEMP_CFLAGS="$TEMP_CFLAGS ${def.toFlags()}"
+        TEMP_CXXFLAGS="$TEMP_CXXFLAGS ${def.toFlags()}"
+    #end
+    #if( $val.hasMake() )
+    cat >> "$TEMP_DIR/make.mk" << __EOF__
+$val.make
+__EOF__
+    #end
+    return 0
+}
+#end
+#end
+
+#
+# TARGETS
+#
+
+#foreach( $target in $targets )
+echo >> "$TEMP_DIR/flags.mk"
+#if ( $target.name )
+echo "configuring target: $target.name"
+echo "# flags for target $target.name" >> "$TEMP_DIR/flags.mk"
+#else
+echo "configuring global target"
+echo "# flags for unnamed target" >> "$TEMP_DIR/flags.mk"
+#end
+TEMP_CFLAGS=
+TEMP_CXXFLAGS=
+TEMP_LDFLAGS=
+
+#foreach( $dependency in $target.dependencies )
+if dependency_error_$dependency; then
+    DEPENDENCIES_FAILED="$DEPENDENCIES_FAILED ${dependency} "
+    ERROR=1
+fi
+#end
+
+# Features
+#foreach( $feature in $target.features )
+if [ -n "${D}${feature.varName}" ]; then
+#foreach( $dependency in $feature.dependencies )
+    # check dependency
+    if dependency_error_$dependency ; then
+        # "auto" features can fail and are just disabled in this case
+        if [ "${D}${feature.varName}" = "auto" ]; then
+            DISABLE_${feature.varName}=1
+        else
+            DEPENDENCIES_FAILED="$DEPENDENCIES_FAILED ${dependency} "
+            ERROR=1
+        fi
+    fi
+#end
+    if [ -n "$DISABLE_${feature.varName}" ]; then
+        unset ${feature.varName}
+    fi
+fi
+#end
+
+#foreach( $opt in $target.options )
+# Option: --${opt.argument}
+if [ -z "${D}${opt.varName}" ]; then
+    echo "auto-detecting option '${opt.argument}'"
+    SAVED_ERROR="$ERROR"
+    SAVED_DEPENDENCIES_FAILED="$DEPENDENCIES_FAILED"
+    ERROR=1
+    while true
+    do
+        #foreach( $optdef in $opt.defaults )
+        #if( $optdef.platform )
+        if isplatform "$optdef.platform"; then
+        #end
+        if $optdef.func ; then
+            echo "  ${opt.argument}: ${optdef.valueName}" >> "$TEMP_DIR/options"
+            ERROR=0
+            break
+        fi
+        #if( $optdef.platform )
+        fi
+        #end
+        #end
+        break
+    done
+    if [ $ERROR -ne 0 ]; then
+        SAVED_ERROR=1
+        SAVED_DEPENDENCIES_FAILED="option '${opt.argument}' $SAVED_DEPENDENCIES_FAILED"
+    fi
+    ERROR="$SAVED_ERROR"
+    DEPENDENCIES_FAILED="$SAVED_DEPENDENCIES_FAILED"
+else
+    echo "checking option ${opt.argument} = ${D}${opt.varName}"
+    if false; then
+        false
+    #foreach( $optval in $opt.values )
+    elif [ "${D}${opt.varName}" = "${optval.value}" ]; then
+        echo "  ${opt.argument}: ${D}${opt.varName}" >> $TEMP_DIR/options
+        if $optval.func ; then
+            :
+        else
+            ERROR=1
+            DEPENDENCIES_FAILED="option '${opt.argument}' $DEPENDENCIES_FAILED"
+        fi
+    #end
+    fi
+fi
+#end
+
+if [ -n "${TEMP_CFLAGS}" ] && [ -n "$lang_c" ]; then
+    echo "${target.cFlags}  += $TEMP_CFLAGS" >> "$TEMP_DIR/flags.mk"
+fi
+if [ -n "${TEMP_CXXFLAGS}" ] && [ -n "$lang_cpp" ]; then
+    echo "${target.cxxFlags}  += $TEMP_CXXFLAGS" >> "$TEMP_DIR/flags.mk"
+fi
+if [ "$BUILD_TYPE" = "debug" ]; then
+    if [ -n "$lang_c" ]; then
+        echo '${target.cFlags} += ${DEBUG_CC_FLAGS}' >> "$TEMP_DIR/flags.mk"
+    fi
+    if [ -n "$lang_cpp" ]; then
+        echo '${target.cxxFlags} += ${DEBUG_CXX_FLAGS}' >> "$TEMP_DIR/flags.mk"
+    fi
+fi
+if [ "$BUILD_TYPE" = "release" ]; then
+    if [ -n "$lang_c" ]; then
+        echo '${target.cFlags} += ${RELEASE_CC_FLAGS}' >> "$TEMP_DIR/flags.mk"
+    fi
+    if [ -n "$lang_cpp" ]; then
+        echo '${target.cxxFlags} += ${RELEASE_CXX_FLAGS}' >> "$TEMP_DIR/flags.mk"
+    fi
+fi
+if [ -n "${TEMP_LDFLAGS}" ]; then
+    echo "${target.ldFlags} += $TEMP_LDFLAGS" >> "$TEMP_DIR/flags.mk"
+fi
+
+#end
+
+# final result
+if [ $ERROR -ne 0 ]; then
+    echo
+    echo "Error: Unresolved dependencies"
+    echo "$DEPENDENCIES_FAILED"
+    abort_configure
+fi
+
+echo "configure finished"
+echo
+echo "Build Config:"
+echo "  PREFIX:      $prefix"
+echo "  TOOLCHAIN:   $TOOLCHAIN_NAME"
+#if ( $options.size() > 0 )
+echo "Options:"
+cat "$TEMP_DIR/options"
+#end
+#if ( $features.size() > 0 )
+echo "Features:"
+#foreach( $feature in $features )
+if [ -n "${D}${feature.varName}" ]; then
+echo "  $feature.name: on"
+else
+echo "  $feature.name: off"
+fi
+#end
+#end
+echo
+
+# generate the config.mk file
+cat > "$TEMP_DIR/config.mk" << __EOF__
+#
+# config.mk generated by configure
+#
+
+__EOF__
+write_toolchain_defaults "$TEMP_DIR/toolchain.mk"
+cat "$TEMP_DIR/vars.mk" "$TEMP_DIR/toolchain.mk" "$TEMP_DIR/flags.mk" "$TEMP_DIR/make.mk" > config.mk
+rm -Rf "$TEMP_DIR"

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/make/gcc.mk	Sat Dec 07 18:56:37 2024 +0100
@@ -0,0 +1,15 @@
+#
+# gcc toolchain config
+#
+
+CFLAGS =
+CXXFLAGS =
+DEBUG_CC_FLAGS = -g
+DEBUG_CXX_FLAGS = -g
+RELEASE_CC_FLAGS = -O3 -DNDEBUG
+RELEASE_CXX_FLAGS = -O3 -DNDEBUG
+LDFLAGS =
+
+SHLIB_CFLAGS = -fPIC
+SHLIB_LDFLAGS = -shared
+

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/make/project.xml	Sat Dec 07 18:56:37 2024 +0100
@@ -0,0 +1,31 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<project xmlns="http://unixwork.de/uwproj">
+	<dependency>
+		<lang>c</lang>
+	</dependency>
+	
+	<dependency name="sqlite">
+		<pkgconfig>sqlite3</pkgconfig>
+		<cflags>-DDBU_SQLITE</cflags>
+	</dependency>
+	
+	<dependency name="postgresql">
+		<pkgconfig>libpq</pkgconfig>
+		<cflags>-DDBU_POSTGRESQL</cflags>
+	</dependency>
+	
+	<dependency platform="unix">
+		<make>OBJ_EXT = .o</make>
+		<make>LIB_EXT = .a</make>
+	</dependency>
+	
+	<target name="dbu">
+		<feature name="sqlite" default="true">
+			<dependencies>sqlite</dependencies>
+		</feature>
+		<feature name="postgresql" default="true">
+			<dependencies>postgresql</dependencies>
+		</feature>
+	</target>
+</project>
+

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/make/suncc.mk	Sat Dec 07 18:56:37 2024 +0100
@@ -0,0 +1,15 @@
+#
+# suncc toolchain
+#
+
+CFLAGS =
+CXXFLAGS =
+DEBUG_CC_FLAGS = -g
+DEBUG_CXX_FLAGS = -g
+RELEASE_CC_FLAGS = -O3 -DNDEBUG
+RELEASE_CXX_FLAGS = -O3 -DNDEBUG
+LDFLAGS =
+
+SHLIB_CFLAGS = -Kpic
+SHLIB_LDFLAGS = -G
+

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/make/toolchain.sh	Sat Dec 07 18:56:37 2024 +0100
@@ -0,0 +1,200 @@
+#!/bin/sh
+#
+# toolchain detection
+#
+
+if isplatform "bsd" && notisplatform "openbsd"; then
+  C_COMPILERS="clang gcc cc"
+  CPP_COMPILERS="clang++ g++ CC"
+else
+  C_COMPILERS="gcc clang suncc cc"
+  CPP_COMPILERS="g++ clang++ sunCC CC"
+fi
+unset TOOLCHAIN
+unset TOOLCHAIN_NAME
+unset TOOLCHAIN_CC
+unset TOOLCHAIN_CXX
+
+check_c_compiler()
+{
+  cat > "$TEMP_DIR/test.c" << __EOF__
+/* test file */
+#include <stdio.h>
+int main(int argc, char **argv) {
+#if defined(_MSC_VER)
+  printf("msc\n");
+#elif defined(__clang__)
+  printf("clang gnuc\n");
+#elif defined(__GNUC__)
+  printf("gcc gnuc\n");
+#elif defined(__sun)
+  printf("suncc\n");
+#else
+  printf("unknown\n");
+#endif
+  return 0;
+}
+__EOF__
+  rm -f "$TEMP_DIR/checkcc"
+  $1 -o "$TEMP_DIR/checkcc" $CFLAGS $LDFLAGS "$TEMP_DIR/test.c" 2> /dev/null
+}
+
+check_cpp_compiler()
+{
+  cat > "$TEMP_DIR/test.cpp" << __EOF__
+/* test file */
+#include <iostream>
+int main(int argc, char **argv) {
+#if defined(_MSC_VER)
+  std::cout << "msc" << std::endl;
+#elif defined(__clang__)
+  std::cout << "clang gnuc" << std::endl;
+#elif defined(__GNUC__)
+  std::cout << "gcc gnuc" << std::endl;
+#elif defined(__sun)
+  std::cout << "suncc" << std::endl;
+#else
+  std::cout << "cc" << std::endl;
+#endif
+  return 0;
+}
+__EOF__
+  rm -f "$TEMP_DIR/checkcc"
+  $1 -o "$TEMP_DIR/checkcc" $CXXFLAGS $LDFLAGS "$TEMP_DIR/test.cpp" 2> /dev/null
+}
+
+create_libtest_source()
+{
+  # $1: filename
+  # $2: optional include
+  cat > "$TEMP_DIR/$1" << __EOF__
+/* libtest file */
+int main(int argc, char **argv) {
+  return 0;
+}
+__EOF__
+  if [ -n "$2" ]; then
+    echo "#include <$2>" >> "$TEMP_DIR/$1"
+  fi
+}
+
+check_c_lib()
+{
+  # $1: libname
+  # $2: optional include
+  if [ -z "$TOOLCHAIN_CC" ]; then
+    return 1
+  fi
+  create_libtest_source "test.c" "$2"
+  rm -f "$TEMP_DIR/checklib"
+  $TOOLCHAIN_CC -o "$TEMP_DIR/checklib" $CFLAGS $LDFLAGS "-l$1" "$TEMP_DIR/test.c" 2> /dev/null
+}
+
+check_cpp_lib()
+{
+  # $1: libname
+  # $2: optional include
+  if [ -z "$TOOLCHAIN_CXX" ]; then
+    return 1
+  fi
+  create_libtest_source "test.cpp" "$2"
+  rm -f "$TEMP_DIR/checklib"
+  $TOOLCHAIN_CXX -o "$TEMP_DIR/checklib" $CXXFLAGS $LDFLAGS "-l$1" "$TEMP_DIR/test.cpp" 2> /dev/null
+}
+
+check_lib()
+{
+  # $1: libname
+  # $2: optional include
+  if [ -n "$TOOLCHAIN_CC" ]; then
+    check_c_lib "$1" "$2"
+  elif  [ -n "$TOOLCHAIN_CXX" ]; then
+    check_cpp_lib "$1" "$2"
+  fi
+}
+
+detect_c_compiler()
+{
+  if [ -n "$TOOLCHAIN_CC" ]; then
+    return 0
+  fi
+  printf "detect C compiler... "
+  if [ -n "$CC" ]; then
+    if check_c_compiler "$CC"; then
+      TOOLCHAIN_CC=$CC
+      TOOLCHAIN=`"$TEMP_DIR/checkcc"`
+      TOOLCHAIN_NAME=`echo "$TOOLCHAIN" | cut -f1 -d' ' -`
+      echo "$CC"
+      return 0
+    else
+      echo "$CC is not a working C compiler"
+      return 1
+    fi
+  else
+    for COMP in $C_COMPILERS
+    do
+      if check_c_compiler "$COMP"; then
+        TOOLCHAIN_CC=$COMP
+        TOOLCHAIN=`"$TEMP_DIR/checkcc"`
+        TOOLCHAIN_NAME=`echo "$TOOLCHAIN" | cut -f1 -d' ' -`
+        echo "$COMP"
+        return 0
+      fi
+    done
+    echo "not found"
+    return 1
+  fi
+}
+
+detect_cpp_compiler()
+{
+  if [ -n "$TOOLCHAIN_CXX" ]; then
+    return 0
+  fi
+  printf "detect C++ compiler... "
+
+  if [ -n "$CXX" ]; then
+    if check_cpp_compiler "$CXX"; then
+      TOOLCHAIN_CXX=$CXX
+      TOOLCHAIN=`"$TEMP_DIR/checkcc"`
+      TOOLCHAIN_NAME=`echo "$TOOLCHAIN" | cut -f1 -d' ' -`
+      echo "$CXX"
+      return 0
+    else
+      echo "$CXX is not a working C++ compiler"
+      return 1
+    fi
+  else
+    for COMP in $CPP_COMPILERS
+    do
+      if check_cpp_compiler "$COMP"; then
+        TOOLCHAIN_CXX=$COMP
+        TOOLCHAIN=`"$TEMP_DIR/checkcc"`
+        TOOLCHAIN_NAME=`echo "$TOOLCHAIN" | cut -f1 -d' ' -`
+        echo "$COMP"
+        return 0
+      fi
+    done
+    echo "${TOOLCHAIN_CXX:-"not found"}"
+    return 1
+  fi
+}
+
+write_toolchain_defaults()
+{
+  echo "# toolchain" >> "$1"
+  if [ -n "$TOOLCHAIN_CC" ]; then
+    echo "CC = ${TOOLCHAIN_CC}" >> "$1"
+  fi
+  if [ -n "$TOOLCHAIN_CXX" ]; then
+    echo "CXX = ${TOOLCHAIN_CXX}" >> "$1"
+  fi
+  echo >> "$1"
+  if [ -f "make/${TOOLCHAIN_NAME}.mk" ]; then
+    cat "make/${TOOLCHAIN_NAME}.mk" >> "$1"
+  elif [ -f "make/cc.mk" ]; then
+    cat "make/cc.mk" >> "$1"
+  else
+    echo "!!! WARNING !!! Default toolchain flags not found. Configuration might be incomplete."
+  fi
+}

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/make/uwproj.xsd	Sat Dec 07 18:56:37 2024 +0100
@@ -0,0 +1,297 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
+           xmlns="http://unixwork.de/uwproj"
+           targetNamespace="http://unixwork.de/uwproj"
+           elementFormDefault="qualified"
+           version="0.2"
+>
+    <xs:element name="project" type="ProjectType"/>
+
+    <xs:complexType name="ProjectType">
+        <xs:annotation>
+            <xs:documentation>
+                The root element of an uwproj project.
+                Consists of an optional <code>config</code> element
+                and an arbitrary number of <code>dependency</code>
+                and <code>target</code> elements.
+            </xs:documentation>
+        </xs:annotation>
+        <xs:sequence>
+            <xs:element name="config" type="ConfigType" minOccurs="0" maxOccurs="unbounded"/>
+            <xs:element name="dependency" type="DependencyType" minOccurs="0" maxOccurs="unbounded"/>
+            <xs:element name="target" type="TargetType" minOccurs="0" maxOccurs="unbounded"/>
+        </xs:sequence>
+    </xs:complexType>
+
+    <xs:complexType name="ConfigType">
+        <xs:annotation>
+            <xs:documentation>
+                <p>
+                    The configuration section.
+                    Consists of an arbitrary number of <code>var</code> elements.
+                </p>
+                <p>
+                    The optional <code>platform</code> attribute may specify a <em>single</em> platform identifier and
+                    the optional <code>not</code> attribute may specify a comma-separated list of platform identifiers.
+                    The configure script shall skip this config declaration if the detected platform is not matching
+                    the filter specification of these attributes.
+                </p>
+            </xs:documentation>
+        </xs:annotation>
+        <xs:sequence>
+            <xs:element name="var" type="ConfigVarType" minOccurs="0" maxOccurs="unbounded"/>
+        </xs:sequence>
+        <xs:attribute name="platform" type="xs:string"/>
+        <xs:attribute name="not" type="xs:string"/>
+    </xs:complexType>
+
+    <xs:complexType name="ConfigVarType">
+        <xs:annotation>
+            <xs:documentation>
+                The definition of a configuration variable.
+                <p>
+                    Configuration variables are supposed to be used in the configure script and are also
+                    written to the resulting config file (in contrast to make variables, which are only
+                    written to the config file).
+                    The <code>name</code> attribute is mandatory, the value is defined by the text body of the element.
+                    The optional Boolean <code>exec</code> attribute (false by default) controls, whether the entire
+                    definition is automatically executed under command substitution.
+                </p>
+            </xs:documentation>
+        </xs:annotation>
+        <xs:simpleContent>
+            <xs:extension base="xs:string">
+                <xs:attribute name="name" type="xs:string" use="required"/>
+                <xs:attribute name="exec" type="xs:boolean" default="false"/>
+            </xs:extension>
+        </xs:simpleContent>
+    </xs:complexType>
+
+    <xs:complexType name="PkgConfigType">
+        <xs:annotation>
+            <xs:documentation>
+                Instructs configure to invoke <code>pkg-config</code>, if present on the system, to determine
+                compiler and linker flags. The text body of this element defines the package name to search.
+                To constrain the allowed versions, use the attributes <code>atleast, exact, max</code>.
+            </xs:documentation>
+        </xs:annotation>
+        <xs:simpleContent>
+            <xs:extension base="xs:string">
+                <xs:attribute name="atleast" type="xs:string"/>
+                <xs:attribute name="exact" type="xs:string"/>
+                <xs:attribute name="max" type="xs:string"/>
+            </xs:extension>
+        </xs:simpleContent>
+    </xs:complexType>
+
+    <xs:simpleType name="LangType">
+        <xs:annotation>
+            <xs:documentation>
+                Requests a compiler for the specified language. Allowed values are
+                c, cpp.
+            </xs:documentation>
+        </xs:annotation>
+        <xs:restriction base="xs:string">
+            <xs:enumeration value="c"/>
+            <xs:enumeration value="cpp"/>
+        </xs:restriction>
+    </xs:simpleType>
+
+    <xs:complexType name="DependencyType">
+        <xs:annotation>
+            <xs:documentation>
+                Declares a dependency.
+                <p>
+                    If the optional <code>name</code> attribute is omitted, the dependency is global
+                    and must be satisfied, otherwise configuration shall fail.
+                    A <em>named dependency</em> can be referenced by a target (or is implicitly referenced
+                    by the default target, if no targets are specified).
+                    Multiple declarations for the same named dependency may exist, in which case each declaration
+                    is checked one after another, until one block is satisfied. The result of the first satisfied
+                    dependency declaration is supposed to be applied to the config file.
+                </p>
+                <p>
+                    The optional <code>platform</code> attribute may specify a <em>single</em> platform identifier and
+                    the optional <code>toolchain</code> attribute may specify a <em>single</em> toolchain.
+                    The optional <code>not</code> attribute may specify a comma-separated list of platform and/or
+                    toolchain identifiers.
+                    The configure script shall skip this dependency declaration if the detected platform and toolchain
+                    is not matching the filter specification of these attributes.
+                </p>
+            </xs:documentation>
+        </xs:annotation>
+        <xs:choice minOccurs="0" maxOccurs="unbounded">
+            <xs:element name="lang" type="LangType"/>
+            <xs:element name="cflags" type="FlagsType"/>
+            <xs:element name="cxxflags" type="FlagsType"/>
+            <xs:element name="ldflags" type="FlagsType"/>
+            <xs:element name="pkgconfig" type="PkgConfigType"/>
+            <xs:element name="test" type="xs:string">
+                <xs:annotation>
+                    <xs:documentation>
+                        Specifies a custom command that shall be executed to test whether this dependency is satisfied.
+                    </xs:documentation>
+                </xs:annotation>
+            </xs:element>
+            <xs:element name="make" type="MakeVarType"/>
+        </xs:choice>
+        <xs:attribute name="name" type="xs:string"/>
+        <xs:attribute name="platform" type="xs:string"/>
+        <xs:attribute name="toolchain" type="xs:string"/>
+        <xs:attribute name="not" type="xs:string"/>
+    </xs:complexType>
+
+    <xs:complexType name="FlagsType">
+        <xs:annotation>
+            <xs:documentation>
+                Instructs configure to append the contents of the element's body to the respective flags variable.
+                If the optional <code>exec</code> flag is set to <code>true</code>, the contents are supposed to be
+                executed under command substitution <em>at configuration time</em> before they are applied.
+            </xs:documentation>
+        </xs:annotation>
+        <xs:simpleContent>
+            <xs:extension base="xs:string">
+                <xs:attribute name="exec" type="xs:boolean" default="false"/>
+            </xs:extension>
+        </xs:simpleContent>
+    </xs:complexType>
+
+    <xs:complexType name="TargetType">
+        <xs:annotation>
+            <xs:documentation>
+                Declares a build target that is supposed to be configured.
+                <p>
+                    If no build target is declared explicitly, an implicit default
+                    target is generated, which has the <code>alldependencies</code>
+                    flag set.
+                </p>
+                <p>
+                    The optional <code>name</code> attribute is also used to generate a prefix
+                    for the compiler and linker flags variables.
+                    Furthermore, a target may consist of an arbitrary number of <code>feature</code>,
+                    <code>option</code>, and <code>define</code> elements.
+                    Named dependencies can be listed (separated by comma) in the <code>dependencies</code>
+                    element. If this target shall use <em>all</em> available named dependencies, the empty
+                    element <code>alldependencies</code> can be used as a shortcut.
+                </p>
+            </xs:documentation>
+        </xs:annotation>
+        <xs:choice minOccurs="0" maxOccurs="unbounded">
+            <xs:element name="feature" type="FeatureType"/>
+            <xs:element name="option" type="OptionType"/>
+            <xs:element name="define" type="DefineType"/>
+            <xs:element name="dependencies" type="DependenciesType"/>
+            <xs:element name="alldependencies">
+                <xs:complexType/>
+            </xs:element>
+        </xs:choice>
+        <xs:attribute name="name" type="xs:string"/>
+    </xs:complexType>
+
+    <xs:complexType name="FeatureType">
+        <xs:annotation>
+            <xs:documentation>
+                Declares an optional feature, that can be enabled during configuration, if all
+                <code>dependencies</code> are satisfied.
+                If a feature is enabled, all <code>define</code> and <code>make</code> definitions are
+                supposed to be applied to the config file.
+                In case the optional <code>default</code> attribute is set to true, the feature is enabled by default
+                and is supposed to be automatically disabled (without error) when the dependencies are not satisfied.
+                The name that is supposed to be used for the --enable and --disable arguments can be optionally
+                specified with the <code>arg</code> attribute. Otherwise, the <code>name</code> is used by default.
+                Optionally, a description for the help text of the resulting configure script can be specified by
+                adding a <code>desc</code> element.
+            </xs:documentation>
+        </xs:annotation>
+        <xs:choice minOccurs="0" maxOccurs="unbounded">
+            <xs:group ref="TargetDataGroup"/>
+            <xs:element name="desc" type="xs:string"/>
+        </xs:choice>
+        <xs:attribute name="name" type="xs:string" use="required"/>
+        <xs:attribute name="arg" type="xs:string"/>
+        <xs:attribute name="default" type="xs:boolean" default="false"/>
+    </xs:complexType>
+
+    <xs:complexType name="OptionType">
+        <xs:annotation>
+            <xs:documentation>
+                Declares a configuration option.
+                The option argument name is specified with the <code>arg</code> attribute.
+                Then, the children of this element specify possible <code>values</code> by defining the conditions
+                (in terms of dependencies) and effects (in terms of defines and make variables) of each value.
+                Finally, a set of <code>default</code>s is specified which supposed to automagically select the most
+                appropriate value for a specific platform under the available dependencies (in case the option is not
+                explicitly specified by using the command line argument).
+            </xs:documentation>
+        </xs:annotation>
+        <xs:sequence>
+            <xs:element name="value" type="OptionValueType" minOccurs="0" maxOccurs="unbounded"/>
+            <xs:element name="default" type="OptionDefaultType" minOccurs="0" maxOccurs="unbounded"/>
+        </xs:sequence>
+        <xs:attribute name="arg" type="xs:string" use="required"/>
+    </xs:complexType>
+
+    <xs:complexType name="OptionValueType">
+        <xs:annotation>
+            <xs:documentation>
+                Declares a possible value for the option (in the <code>str</code> attribute) and
+                the conditions (<code>dependencies</code>) and effects, the value has.
+            </xs:documentation>
+        </xs:annotation>
+        <xs:choice minOccurs="0" maxOccurs="unbounded">
+            <xs:group ref="TargetDataGroup"/>
+        </xs:choice>
+        <xs:attribute name="str" type="xs:string" use="required"/>
+    </xs:complexType>
+
+    <xs:complexType name="OptionDefaultType">
+        <xs:annotation>
+            <xs:documentation>
+                Specifies a default value for this option. Multiple default values can be specified, in which case
+                they are checked one after another for availability. With the optional <code>platform</code> attribute,
+                the default value can be constrained to a <em>single</em> specific platform and is supposed to be
+                skipped by configure, when this platform is not detected.
+            </xs:documentation>
+        </xs:annotation>
+        <xs:attribute name="value" type="xs:string" use="required"/>
+        <xs:attribute name="platform" type="xs:string"/>
+    </xs:complexType>
+
+    <xs:group name="TargetDataGroup">
+        <xs:choice>
+            <xs:element name="define" type="DefineType" minOccurs="0" maxOccurs="unbounded"/>
+            <xs:element name="dependencies" type="DependenciesType" minOccurs="0" maxOccurs="unbounded"/>
+            <xs:element name="make" type="MakeVarType" minOccurs="0" maxOccurs="unbounded"/>
+        </xs:choice>
+    </xs:group>
+
+    <xs:complexType name="DefineType">
+        <xs:annotation>
+            <xs:documentation>
+                Specifies C/C++ pre-processor definitions that are supposed to
+                be appended to the compiler flags, if supported.
+                (Note: for example, Fortran also supports C/C++ style pre-processor definitions under
+                certain circumstances)
+            </xs:documentation>
+        </xs:annotation>
+        <xs:attribute name="name" type="xs:string" use="required"/>
+        <xs:attribute name="value" type="xs:string"/>
+    </xs:complexType>
+
+    <xs:simpleType name="DependenciesType">
+        <xs:annotation>
+            <xs:documentation>A comma-separated list of named dependencies.</xs:documentation>
+        </xs:annotation>
+        <xs:restriction base="xs:string"/>
+    </xs:simpleType>
+
+    <xs:simpleType name="MakeVarType">
+        <xs:annotation>
+            <xs:documentation>
+                The text contents in the body of this element are supposed to be appended literally
+                to the config file without prior processing.
+            </xs:documentation>
+        </xs:annotation>
+        <xs:restriction base="xs:string"/>
+    </xs:simpleType>
+</xs:schema>