diff --git a/compile_commands.json b/compile_commands.json
deleted file mode 100644
index b1f6938..0000000
--- a/compile_commands.json
+++ /dev/null
-[
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "cmake_object_order_depends_target_pqxx",
- "output": "cmake_object_order_depends_target_koivuhaka"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "/usr/bin/c++ -DASIO_STANDALONE -I/home/wisdurm/repos/koivuhaka/build/_deps/crow-src/include -I/home/wisdurm/repos/koivuhaka/build/build-pqxx/include -I/home/wisdurm/repos/koivuhaka/deps/libpqxx/include -isystem /home/wisdurm/repos/koivuhaka/build/vcpkg_installed/x64-linux/include -std=gnu++23 -MD -MT CMakeFiles/koivuhaka.dir/src/main.cpp.o -MF CMakeFiles/koivuhaka.dir/src/main.cpp.o.d -o CMakeFiles/koivuhaka.dir/src/main.cpp.o -c /home/wisdurm/repos/koivuhaka/src/main.cpp",
- "file": "/home/wisdurm/repos/koivuhaka/src/main.cpp",
- "output": "CMakeFiles/koivuhaka.dir/src/main.cpp.o"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": ": && /usr/bin/c++ -Wl,--dependency-file=CMakeFiles/koivuhaka.dir/link.d CMakeFiles/koivuhaka.dir/src/main.cpp.o -o koivuhaka build-pqxx/src/libpqxx-7.10.a /usr/lib/x86_64-linux-gnu/libpq.so && :",
- "file": "CMakeFiles/koivuhaka.dir/src/main.cpp.o",
- "output": "koivuhaka"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "cd /home/wisdurm/repos/koivuhaka/build && /usr/bin/cpack --config ./CPackConfig.cmake",
- "file": "all",
- "output": "CMakeFiles/package.util"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "CMakeFiles/package.util",
- "output": "package"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "CMakeFiles/package_source.util",
- "output": "package_source"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "CMakeFiles/edit_cache.util",
- "output": "edit_cache"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "CMakeFiles/rebuild_cache.util",
- "output": "rebuild_cache"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "cd /home/wisdurm/repos/koivuhaka/build && /usr/bin/cmake -P cmake_install.cmake",
- "file": "all",
- "output": "CMakeFiles/install.util"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "CMakeFiles/install.util",
- "output": "install"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "cd /home/wisdurm/repos/koivuhaka/build && /usr/bin/cmake -DCMAKE_INSTALL_LOCAL_ONLY=1 -P cmake_install.cmake",
- "file": "all",
- "output": "CMakeFiles/install/local.util"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "CMakeFiles/install/local.util",
- "output": "install/local"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "cd /home/wisdurm/repos/koivuhaka/build && /usr/bin/cmake -DCMAKE_INSTALL_DO_STRIP=1 -P cmake_install.cmake",
- "file": "all",
- "output": "CMakeFiles/install/strip.util"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "CMakeFiles/install/strip.util",
- "output": "install/strip"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "_deps/crow-build/CMakeFiles/uninstall",
- "output": "_deps/crow-build/uninstall"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "cd /home/wisdurm/repos/koivuhaka/build && /usr/bin/cpack --config ./CPackConfig.cmake",
- "file": "_deps/crow-build/all",
- "output": "_deps/crow-build/CMakeFiles/package.util"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "_deps/crow-build/CMakeFiles/package.util",
- "output": "_deps/crow-build/package"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "_deps/crow-build/CMakeFiles/package_source.util",
- "output": "_deps/crow-build/package_source"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "_deps/crow-build/CMakeFiles/edit_cache.util",
- "output": "_deps/crow-build/edit_cache"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "_deps/crow-build/CMakeFiles/rebuild_cache.util",
- "output": "_deps/crow-build/rebuild_cache"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "cd /home/wisdurm/repos/koivuhaka/build/_deps/crow-build && /usr/bin/cmake -P cmake_install.cmake",
- "file": "_deps/crow-build/all",
- "output": "_deps/crow-build/CMakeFiles/install.util"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "_deps/crow-build/CMakeFiles/install.util",
- "output": "_deps/crow-build/install"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "cd /home/wisdurm/repos/koivuhaka/build/_deps/crow-build && /usr/bin/cmake -DCMAKE_INSTALL_LOCAL_ONLY=1 -P cmake_install.cmake",
- "file": "_deps/crow-build/all",
- "output": "_deps/crow-build/CMakeFiles/install/local.util"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "_deps/crow-build/CMakeFiles/install/local.util",
- "output": "_deps/crow-build/install/local"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "cd /home/wisdurm/repos/koivuhaka/build/_deps/crow-build && /usr/bin/cmake -DCMAKE_INSTALL_DO_STRIP=1 -P cmake_install.cmake",
- "file": "_deps/crow-build/all",
- "output": "_deps/crow-build/CMakeFiles/install/strip.util"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "_deps/crow-build/CMakeFiles/install/strip.util",
- "output": "_deps/crow-build/install/strip"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "cd /home/wisdurm/repos/koivuhaka/build && /usr/bin/cpack --config ./CPackConfig.cmake",
- "file": "build-pqxx/all",
- "output": "build-pqxx/CMakeFiles/package.util"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "build-pqxx/CMakeFiles/package.util",
- "output": "build-pqxx/package"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "build-pqxx/CMakeFiles/package_source.util",
- "output": "build-pqxx/package_source"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "build-pqxx/CMakeFiles/edit_cache.util",
- "output": "build-pqxx/edit_cache"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "build-pqxx/CMakeFiles/rebuild_cache.util",
- "output": "build-pqxx/rebuild_cache"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "cd /home/wisdurm/repos/koivuhaka/build/build-pqxx && /usr/bin/cmake -P cmake_install.cmake",
- "file": "build-pqxx/all",
- "output": "build-pqxx/CMakeFiles/install.util"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "build-pqxx/CMakeFiles/install.util",
- "output": "build-pqxx/install"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "cd /home/wisdurm/repos/koivuhaka/build/build-pqxx && /usr/bin/cmake -DCMAKE_INSTALL_LOCAL_ONLY=1 -P cmake_install.cmake",
- "file": "build-pqxx/all",
- "output": "build-pqxx/CMakeFiles/install/local.util"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "build-pqxx/CMakeFiles/install/local.util",
- "output": "build-pqxx/install/local"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "cd /home/wisdurm/repos/koivuhaka/build/build-pqxx && /usr/bin/cmake -DCMAKE_INSTALL_DO_STRIP=1 -P cmake_install.cmake",
- "file": "build-pqxx/all",
- "output": "build-pqxx/CMakeFiles/install/strip.util"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "build-pqxx/CMakeFiles/install/strip.util",
- "output": "build-pqxx/install/strip"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": ".",
- "output": "cmake_object_order_depends_target_pqxx"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "/usr/bin/c++ -I/home/wisdurm/repos/koivuhaka/build/build-pqxx/include -I/home/wisdurm/repos/koivuhaka/deps/libpqxx/include -isystem /usr/include/postgresql -std=c++23 -MD -MT build-pqxx/src/CMakeFiles/pqxx.dir/array.cxx.o -MF build-pqxx/src/CMakeFiles/pqxx.dir/array.cxx.o.d -o build-pqxx/src/CMakeFiles/pqxx.dir/array.cxx.o -c /home/wisdurm/repos/koivuhaka/deps/libpqxx/src/array.cxx",
- "file": "/home/wisdurm/repos/koivuhaka/deps/libpqxx/src/array.cxx",
- "output": "build-pqxx/src/CMakeFiles/pqxx.dir/array.cxx.o"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "/usr/bin/c++ -I/home/wisdurm/repos/koivuhaka/build/build-pqxx/include -I/home/wisdurm/repos/koivuhaka/deps/libpqxx/include -isystem /usr/include/postgresql -std=c++23 -MD -MT build-pqxx/src/CMakeFiles/pqxx.dir/binarystring.cxx.o -MF build-pqxx/src/CMakeFiles/pqxx.dir/binarystring.cxx.o.d -o build-pqxx/src/CMakeFiles/pqxx.dir/binarystring.cxx.o -c /home/wisdurm/repos/koivuhaka/deps/libpqxx/src/binarystring.cxx",
- "file": "/home/wisdurm/repos/koivuhaka/deps/libpqxx/src/binarystring.cxx",
- "output": "build-pqxx/src/CMakeFiles/pqxx.dir/binarystring.cxx.o"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "/usr/bin/c++ -I/home/wisdurm/repos/koivuhaka/build/build-pqxx/include -I/home/wisdurm/repos/koivuhaka/deps/libpqxx/include -isystem /usr/include/postgresql -std=c++23 -MD -MT build-pqxx/src/CMakeFiles/pqxx.dir/blob.cxx.o -MF build-pqxx/src/CMakeFiles/pqxx.dir/blob.cxx.o.d -o build-pqxx/src/CMakeFiles/pqxx.dir/blob.cxx.o -c /home/wisdurm/repos/koivuhaka/deps/libpqxx/src/blob.cxx",
- "file": "/home/wisdurm/repos/koivuhaka/deps/libpqxx/src/blob.cxx",
- "output": "build-pqxx/src/CMakeFiles/pqxx.dir/blob.cxx.o"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "/usr/bin/c++ -I/home/wisdurm/repos/koivuhaka/build/build-pqxx/include -I/home/wisdurm/repos/koivuhaka/deps/libpqxx/include -isystem /usr/include/postgresql -std=c++23 -MD -MT build-pqxx/src/CMakeFiles/pqxx.dir/connection.cxx.o -MF build-pqxx/src/CMakeFiles/pqxx.dir/connection.cxx.o.d -o build-pqxx/src/CMakeFiles/pqxx.dir/connection.cxx.o -c /home/wisdurm/repos/koivuhaka/deps/libpqxx/src/connection.cxx",
- "file": "/home/wisdurm/repos/koivuhaka/deps/libpqxx/src/connection.cxx",
- "output": "build-pqxx/src/CMakeFiles/pqxx.dir/connection.cxx.o"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "/usr/bin/c++ -I/home/wisdurm/repos/koivuhaka/build/build-pqxx/include -I/home/wisdurm/repos/koivuhaka/deps/libpqxx/include -isystem /usr/include/postgresql -std=c++23 -MD -MT build-pqxx/src/CMakeFiles/pqxx.dir/cursor.cxx.o -MF build-pqxx/src/CMakeFiles/pqxx.dir/cursor.cxx.o.d -o build-pqxx/src/CMakeFiles/pqxx.dir/cursor.cxx.o -c /home/wisdurm/repos/koivuhaka/deps/libpqxx/src/cursor.cxx",
- "file": "/home/wisdurm/repos/koivuhaka/deps/libpqxx/src/cursor.cxx",
- "output": "build-pqxx/src/CMakeFiles/pqxx.dir/cursor.cxx.o"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "/usr/bin/c++ -I/home/wisdurm/repos/koivuhaka/build/build-pqxx/include -I/home/wisdurm/repos/koivuhaka/deps/libpqxx/include -isystem /usr/include/postgresql -std=c++23 -MD -MT build-pqxx/src/CMakeFiles/pqxx.dir/encodings.cxx.o -MF build-pqxx/src/CMakeFiles/pqxx.dir/encodings.cxx.o.d -o build-pqxx/src/CMakeFiles/pqxx.dir/encodings.cxx.o -c /home/wisdurm/repos/koivuhaka/deps/libpqxx/src/encodings.cxx",
- "file": "/home/wisdurm/repos/koivuhaka/deps/libpqxx/src/encodings.cxx",
- "output": "build-pqxx/src/CMakeFiles/pqxx.dir/encodings.cxx.o"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "/usr/bin/c++ -I/home/wisdurm/repos/koivuhaka/build/build-pqxx/include -I/home/wisdurm/repos/koivuhaka/deps/libpqxx/include -isystem /usr/include/postgresql -std=c++23 -MD -MT build-pqxx/src/CMakeFiles/pqxx.dir/errorhandler.cxx.o -MF build-pqxx/src/CMakeFiles/pqxx.dir/errorhandler.cxx.o.d -o build-pqxx/src/CMakeFiles/pqxx.dir/errorhandler.cxx.o -c /home/wisdurm/repos/koivuhaka/deps/libpqxx/src/errorhandler.cxx",
- "file": "/home/wisdurm/repos/koivuhaka/deps/libpqxx/src/errorhandler.cxx",
- "output": "build-pqxx/src/CMakeFiles/pqxx.dir/errorhandler.cxx.o"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "/usr/bin/c++ -I/home/wisdurm/repos/koivuhaka/build/build-pqxx/include -I/home/wisdurm/repos/koivuhaka/deps/libpqxx/include -isystem /usr/include/postgresql -std=c++23 -MD -MT build-pqxx/src/CMakeFiles/pqxx.dir/except.cxx.o -MF build-pqxx/src/CMakeFiles/pqxx.dir/except.cxx.o.d -o build-pqxx/src/CMakeFiles/pqxx.dir/except.cxx.o -c /home/wisdurm/repos/koivuhaka/deps/libpqxx/src/except.cxx",
- "file": "/home/wisdurm/repos/koivuhaka/deps/libpqxx/src/except.cxx",
- "output": "build-pqxx/src/CMakeFiles/pqxx.dir/except.cxx.o"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "/usr/bin/c++ -I/home/wisdurm/repos/koivuhaka/build/build-pqxx/include -I/home/wisdurm/repos/koivuhaka/deps/libpqxx/include -isystem /usr/include/postgresql -std=c++23 -MD -MT build-pqxx/src/CMakeFiles/pqxx.dir/field.cxx.o -MF build-pqxx/src/CMakeFiles/pqxx.dir/field.cxx.o.d -o build-pqxx/src/CMakeFiles/pqxx.dir/field.cxx.o -c /home/wisdurm/repos/koivuhaka/deps/libpqxx/src/field.cxx",
- "file": "/home/wisdurm/repos/koivuhaka/deps/libpqxx/src/field.cxx",
- "output": "build-pqxx/src/CMakeFiles/pqxx.dir/field.cxx.o"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "/usr/bin/c++ -I/home/wisdurm/repos/koivuhaka/build/build-pqxx/include -I/home/wisdurm/repos/koivuhaka/deps/libpqxx/include -isystem /usr/include/postgresql -std=c++23 -MD -MT build-pqxx/src/CMakeFiles/pqxx.dir/largeobject.cxx.o -MF build-pqxx/src/CMakeFiles/pqxx.dir/largeobject.cxx.o.d -o build-pqxx/src/CMakeFiles/pqxx.dir/largeobject.cxx.o -c /home/wisdurm/repos/koivuhaka/deps/libpqxx/src/largeobject.cxx",
- "file": "/home/wisdurm/repos/koivuhaka/deps/libpqxx/src/largeobject.cxx",
- "output": "build-pqxx/src/CMakeFiles/pqxx.dir/largeobject.cxx.o"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "/usr/bin/c++ -I/home/wisdurm/repos/koivuhaka/build/build-pqxx/include -I/home/wisdurm/repos/koivuhaka/deps/libpqxx/include -isystem /usr/include/postgresql -std=c++23 -MD -MT build-pqxx/src/CMakeFiles/pqxx.dir/notification.cxx.o -MF build-pqxx/src/CMakeFiles/pqxx.dir/notification.cxx.o.d -o build-pqxx/src/CMakeFiles/pqxx.dir/notification.cxx.o -c /home/wisdurm/repos/koivuhaka/deps/libpqxx/src/notification.cxx",
- "file": "/home/wisdurm/repos/koivuhaka/deps/libpqxx/src/notification.cxx",
- "output": "build-pqxx/src/CMakeFiles/pqxx.dir/notification.cxx.o"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "/usr/bin/c++ -I/home/wisdurm/repos/koivuhaka/build/build-pqxx/include -I/home/wisdurm/repos/koivuhaka/deps/libpqxx/include -isystem /usr/include/postgresql -std=c++23 -MD -MT build-pqxx/src/CMakeFiles/pqxx.dir/params.cxx.o -MF build-pqxx/src/CMakeFiles/pqxx.dir/params.cxx.o.d -o build-pqxx/src/CMakeFiles/pqxx.dir/params.cxx.o -c /home/wisdurm/repos/koivuhaka/deps/libpqxx/src/params.cxx",
- "file": "/home/wisdurm/repos/koivuhaka/deps/libpqxx/src/params.cxx",
- "output": "build-pqxx/src/CMakeFiles/pqxx.dir/params.cxx.o"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "/usr/bin/c++ -I/home/wisdurm/repos/koivuhaka/build/build-pqxx/include -I/home/wisdurm/repos/koivuhaka/deps/libpqxx/include -isystem /usr/include/postgresql -std=c++23 -MD -MT build-pqxx/src/CMakeFiles/pqxx.dir/pipeline.cxx.o -MF build-pqxx/src/CMakeFiles/pqxx.dir/pipeline.cxx.o.d -o build-pqxx/src/CMakeFiles/pqxx.dir/pipeline.cxx.o -c /home/wisdurm/repos/koivuhaka/deps/libpqxx/src/pipeline.cxx",
- "file": "/home/wisdurm/repos/koivuhaka/deps/libpqxx/src/pipeline.cxx",
- "output": "build-pqxx/src/CMakeFiles/pqxx.dir/pipeline.cxx.o"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "/usr/bin/c++ -I/home/wisdurm/repos/koivuhaka/build/build-pqxx/include -I/home/wisdurm/repos/koivuhaka/deps/libpqxx/include -isystem /usr/include/postgresql -std=c++23 -MD -MT build-pqxx/src/CMakeFiles/pqxx.dir/result.cxx.o -MF build-pqxx/src/CMakeFiles/pqxx.dir/result.cxx.o.d -o build-pqxx/src/CMakeFiles/pqxx.dir/result.cxx.o -c /home/wisdurm/repos/koivuhaka/deps/libpqxx/src/result.cxx",
- "file": "/home/wisdurm/repos/koivuhaka/deps/libpqxx/src/result.cxx",
- "output": "build-pqxx/src/CMakeFiles/pqxx.dir/result.cxx.o"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "/usr/bin/c++ -I/home/wisdurm/repos/koivuhaka/build/build-pqxx/include -I/home/wisdurm/repos/koivuhaka/deps/libpqxx/include -isystem /usr/include/postgresql -std=c++23 -MD -MT build-pqxx/src/CMakeFiles/pqxx.dir/robusttransaction.cxx.o -MF build-pqxx/src/CMakeFiles/pqxx.dir/robusttransaction.cxx.o.d -o build-pqxx/src/CMakeFiles/pqxx.dir/robusttransaction.cxx.o -c /home/wisdurm/repos/koivuhaka/deps/libpqxx/src/robusttransaction.cxx",
- "file": "/home/wisdurm/repos/koivuhaka/deps/libpqxx/src/robusttransaction.cxx",
- "output": "build-pqxx/src/CMakeFiles/pqxx.dir/robusttransaction.cxx.o"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "/usr/bin/c++ -I/home/wisdurm/repos/koivuhaka/build/build-pqxx/include -I/home/wisdurm/repos/koivuhaka/deps/libpqxx/include -isystem /usr/include/postgresql -std=c++23 -MD -MT build-pqxx/src/CMakeFiles/pqxx.dir/row.cxx.o -MF build-pqxx/src/CMakeFiles/pqxx.dir/row.cxx.o.d -o build-pqxx/src/CMakeFiles/pqxx.dir/row.cxx.o -c /home/wisdurm/repos/koivuhaka/deps/libpqxx/src/row.cxx",
- "file": "/home/wisdurm/repos/koivuhaka/deps/libpqxx/src/row.cxx",
- "output": "build-pqxx/src/CMakeFiles/pqxx.dir/row.cxx.o"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "/usr/bin/c++ -I/home/wisdurm/repos/koivuhaka/build/build-pqxx/include -I/home/wisdurm/repos/koivuhaka/deps/libpqxx/include -isystem /usr/include/postgresql -std=c++23 -MD -MT build-pqxx/src/CMakeFiles/pqxx.dir/sql_cursor.cxx.o -MF build-pqxx/src/CMakeFiles/pqxx.dir/sql_cursor.cxx.o.d -o build-pqxx/src/CMakeFiles/pqxx.dir/sql_cursor.cxx.o -c /home/wisdurm/repos/koivuhaka/deps/libpqxx/src/sql_cursor.cxx",
- "file": "/home/wisdurm/repos/koivuhaka/deps/libpqxx/src/sql_cursor.cxx",
- "output": "build-pqxx/src/CMakeFiles/pqxx.dir/sql_cursor.cxx.o"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "/usr/bin/c++ -I/home/wisdurm/repos/koivuhaka/build/build-pqxx/include -I/home/wisdurm/repos/koivuhaka/deps/libpqxx/include -isystem /usr/include/postgresql -std=c++23 -MD -MT build-pqxx/src/CMakeFiles/pqxx.dir/strconv.cxx.o -MF build-pqxx/src/CMakeFiles/pqxx.dir/strconv.cxx.o.d -o build-pqxx/src/CMakeFiles/pqxx.dir/strconv.cxx.o -c /home/wisdurm/repos/koivuhaka/deps/libpqxx/src/strconv.cxx",
- "file": "/home/wisdurm/repos/koivuhaka/deps/libpqxx/src/strconv.cxx",
- "output": "build-pqxx/src/CMakeFiles/pqxx.dir/strconv.cxx.o"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "/usr/bin/c++ -I/home/wisdurm/repos/koivuhaka/build/build-pqxx/include -I/home/wisdurm/repos/koivuhaka/deps/libpqxx/include -isystem /usr/include/postgresql -std=c++23 -MD -MT build-pqxx/src/CMakeFiles/pqxx.dir/stream_from.cxx.o -MF build-pqxx/src/CMakeFiles/pqxx.dir/stream_from.cxx.o.d -o build-pqxx/src/CMakeFiles/pqxx.dir/stream_from.cxx.o -c /home/wisdurm/repos/koivuhaka/deps/libpqxx/src/stream_from.cxx",
- "file": "/home/wisdurm/repos/koivuhaka/deps/libpqxx/src/stream_from.cxx",
- "output": "build-pqxx/src/CMakeFiles/pqxx.dir/stream_from.cxx.o"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "/usr/bin/c++ -I/home/wisdurm/repos/koivuhaka/build/build-pqxx/include -I/home/wisdurm/repos/koivuhaka/deps/libpqxx/include -isystem /usr/include/postgresql -std=c++23 -MD -MT build-pqxx/src/CMakeFiles/pqxx.dir/stream_to.cxx.o -MF build-pqxx/src/CMakeFiles/pqxx.dir/stream_to.cxx.o.d -o build-pqxx/src/CMakeFiles/pqxx.dir/stream_to.cxx.o -c /home/wisdurm/repos/koivuhaka/deps/libpqxx/src/stream_to.cxx",
- "file": "/home/wisdurm/repos/koivuhaka/deps/libpqxx/src/stream_to.cxx",
- "output": "build-pqxx/src/CMakeFiles/pqxx.dir/stream_to.cxx.o"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "/usr/bin/c++ -I/home/wisdurm/repos/koivuhaka/build/build-pqxx/include -I/home/wisdurm/repos/koivuhaka/deps/libpqxx/include -isystem /usr/include/postgresql -std=c++23 -MD -MT build-pqxx/src/CMakeFiles/pqxx.dir/subtransaction.cxx.o -MF build-pqxx/src/CMakeFiles/pqxx.dir/subtransaction.cxx.o.d -o build-pqxx/src/CMakeFiles/pqxx.dir/subtransaction.cxx.o -c /home/wisdurm/repos/koivuhaka/deps/libpqxx/src/subtransaction.cxx",
- "file": "/home/wisdurm/repos/koivuhaka/deps/libpqxx/src/subtransaction.cxx",
- "output": "build-pqxx/src/CMakeFiles/pqxx.dir/subtransaction.cxx.o"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "/usr/bin/c++ -I/home/wisdurm/repos/koivuhaka/build/build-pqxx/include -I/home/wisdurm/repos/koivuhaka/deps/libpqxx/include -isystem /usr/include/postgresql -std=c++23 -MD -MT build-pqxx/src/CMakeFiles/pqxx.dir/time.cxx.o -MF build-pqxx/src/CMakeFiles/pqxx.dir/time.cxx.o.d -o build-pqxx/src/CMakeFiles/pqxx.dir/time.cxx.o -c /home/wisdurm/repos/koivuhaka/deps/libpqxx/src/time.cxx",
- "file": "/home/wisdurm/repos/koivuhaka/deps/libpqxx/src/time.cxx",
- "output": "build-pqxx/src/CMakeFiles/pqxx.dir/time.cxx.o"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "/usr/bin/c++ -I/home/wisdurm/repos/koivuhaka/build/build-pqxx/include -I/home/wisdurm/repos/koivuhaka/deps/libpqxx/include -isystem /usr/include/postgresql -std=c++23 -MD -MT build-pqxx/src/CMakeFiles/pqxx.dir/transaction.cxx.o -MF build-pqxx/src/CMakeFiles/pqxx.dir/transaction.cxx.o.d -o build-pqxx/src/CMakeFiles/pqxx.dir/transaction.cxx.o -c /home/wisdurm/repos/koivuhaka/deps/libpqxx/src/transaction.cxx",
- "file": "/home/wisdurm/repos/koivuhaka/deps/libpqxx/src/transaction.cxx",
- "output": "build-pqxx/src/CMakeFiles/pqxx.dir/transaction.cxx.o"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "/usr/bin/c++ -I/home/wisdurm/repos/koivuhaka/build/build-pqxx/include -I/home/wisdurm/repos/koivuhaka/deps/libpqxx/include -isystem /usr/include/postgresql -std=c++23 -MD -MT build-pqxx/src/CMakeFiles/pqxx.dir/transaction_base.cxx.o -MF build-pqxx/src/CMakeFiles/pqxx.dir/transaction_base.cxx.o.d -o build-pqxx/src/CMakeFiles/pqxx.dir/transaction_base.cxx.o -c /home/wisdurm/repos/koivuhaka/deps/libpqxx/src/transaction_base.cxx",
- "file": "/home/wisdurm/repos/koivuhaka/deps/libpqxx/src/transaction_base.cxx",
- "output": "build-pqxx/src/CMakeFiles/pqxx.dir/transaction_base.cxx.o"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "/usr/bin/c++ -I/home/wisdurm/repos/koivuhaka/build/build-pqxx/include -I/home/wisdurm/repos/koivuhaka/deps/libpqxx/include -isystem /usr/include/postgresql -std=c++23 -MD -MT build-pqxx/src/CMakeFiles/pqxx.dir/util.cxx.o -MF build-pqxx/src/CMakeFiles/pqxx.dir/util.cxx.o.d -o build-pqxx/src/CMakeFiles/pqxx.dir/util.cxx.o -c /home/wisdurm/repos/koivuhaka/deps/libpqxx/src/util.cxx",
- "file": "/home/wisdurm/repos/koivuhaka/deps/libpqxx/src/util.cxx",
- "output": "build-pqxx/src/CMakeFiles/pqxx.dir/util.cxx.o"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "/usr/bin/c++ -I/home/wisdurm/repos/koivuhaka/build/build-pqxx/include -I/home/wisdurm/repos/koivuhaka/deps/libpqxx/include -isystem /usr/include/postgresql -std=c++23 -MD -MT build-pqxx/src/CMakeFiles/pqxx.dir/version.cxx.o -MF build-pqxx/src/CMakeFiles/pqxx.dir/version.cxx.o.d -o build-pqxx/src/CMakeFiles/pqxx.dir/version.cxx.o -c /home/wisdurm/repos/koivuhaka/deps/libpqxx/src/version.cxx",
- "file": "/home/wisdurm/repos/koivuhaka/deps/libpqxx/src/version.cxx",
- "output": "build-pqxx/src/CMakeFiles/pqxx.dir/version.cxx.o"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "/usr/bin/c++ -I/home/wisdurm/repos/koivuhaka/build/build-pqxx/include -I/home/wisdurm/repos/koivuhaka/deps/libpqxx/include -isystem /usr/include/postgresql -std=c++23 -MD -MT build-pqxx/src/CMakeFiles/pqxx.dir/wait.cxx.o -MF build-pqxx/src/CMakeFiles/pqxx.dir/wait.cxx.o.d -o build-pqxx/src/CMakeFiles/pqxx.dir/wait.cxx.o -c /home/wisdurm/repos/koivuhaka/deps/libpqxx/src/wait.cxx",
- "file": "/home/wisdurm/repos/koivuhaka/deps/libpqxx/src/wait.cxx",
- "output": "build-pqxx/src/CMakeFiles/pqxx.dir/wait.cxx.o"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": ": && /usr/bin/cmake -E rm -f build-pqxx/src/libpqxx-7.10.a && /usr/bin/ar qc build-pqxx/src/libpqxx-7.10.a build-pqxx/src/CMakeFiles/pqxx.dir/array.cxx.o build-pqxx/src/CMakeFiles/pqxx.dir/binarystring.cxx.o build-pqxx/src/CMakeFiles/pqxx.dir/blob.cxx.o build-pqxx/src/CMakeFiles/pqxx.dir/connection.cxx.o build-pqxx/src/CMakeFiles/pqxx.dir/cursor.cxx.o build-pqxx/src/CMakeFiles/pqxx.dir/encodings.cxx.o build-pqxx/src/CMakeFiles/pqxx.dir/errorhandler.cxx.o build-pqxx/src/CMakeFiles/pqxx.dir/except.cxx.o build-pqxx/src/CMakeFiles/pqxx.dir/field.cxx.o build-pqxx/src/CMakeFiles/pqxx.dir/largeobject.cxx.o build-pqxx/src/CMakeFiles/pqxx.dir/notification.cxx.o build-pqxx/src/CMakeFiles/pqxx.dir/params.cxx.o build-pqxx/src/CMakeFiles/pqxx.dir/pipeline.cxx.o build-pqxx/src/CMakeFiles/pqxx.dir/result.cxx.o build-pqxx/src/CMakeFiles/pqxx.dir/robusttransaction.cxx.o build-pqxx/src/CMakeFiles/pqxx.dir/row.cxx.o build-pqxx/src/CMakeFiles/pqxx.dir/sql_cursor.cxx.o build-pqxx/src/CMakeFiles/pqxx.dir/strconv.cxx.o build-pqxx/src/CMakeFiles/pqxx.dir/stream_from.cxx.o build-pqxx/src/CMakeFiles/pqxx.dir/stream_to.cxx.o build-pqxx/src/CMakeFiles/pqxx.dir/subtransaction.cxx.o build-pqxx/src/CMakeFiles/pqxx.dir/time.cxx.o build-pqxx/src/CMakeFiles/pqxx.dir/transaction.cxx.o build-pqxx/src/CMakeFiles/pqxx.dir/transaction_base.cxx.o build-pqxx/src/CMakeFiles/pqxx.dir/util.cxx.o build-pqxx/src/CMakeFiles/pqxx.dir/version.cxx.o build-pqxx/src/CMakeFiles/pqxx.dir/wait.cxx.o && /usr/bin/ranlib build-pqxx/src/libpqxx-7.10.a && cd /home/wisdurm/repos/koivuhaka/build/build-pqxx/src && /usr/bin/cmake -E create_symlink libpqxx-7.10.a libpqxx.a",
- "file": "build-pqxx/src/CMakeFiles/pqxx.dir/array.cxx.o",
- "output": "build-pqxx/src/libpqxx-7.10.a"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "cd /home/wisdurm/repos/koivuhaka/build && /usr/bin/cpack --config ./CPackConfig.cmake",
- "file": "build-pqxx/src/all",
- "output": "build-pqxx/src/CMakeFiles/package.util"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "build-pqxx/src/CMakeFiles/package.util",
- "output": "build-pqxx/src/package"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "build-pqxx/src/CMakeFiles/package_source.util",
- "output": "build-pqxx/src/package_source"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "build-pqxx/src/CMakeFiles/edit_cache.util",
- "output": "build-pqxx/src/edit_cache"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "build-pqxx/src/CMakeFiles/rebuild_cache.util",
- "output": "build-pqxx/src/rebuild_cache"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "cd /home/wisdurm/repos/koivuhaka/build/build-pqxx/src && /usr/bin/cmake -P cmake_install.cmake",
- "file": "build-pqxx/src/all",
- "output": "build-pqxx/src/CMakeFiles/install.util"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "build-pqxx/src/CMakeFiles/install.util",
- "output": "build-pqxx/src/install"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "cd /home/wisdurm/repos/koivuhaka/build/build-pqxx/src && /usr/bin/cmake -DCMAKE_INSTALL_LOCAL_ONLY=1 -P cmake_install.cmake",
- "file": "build-pqxx/src/all",
- "output": "build-pqxx/src/CMakeFiles/install/local.util"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "build-pqxx/src/CMakeFiles/install/local.util",
- "output": "build-pqxx/src/install/local"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "cd /home/wisdurm/repos/koivuhaka/build/build-pqxx/src && /usr/bin/cmake -DCMAKE_INSTALL_DO_STRIP=1 -P cmake_install.cmake",
- "file": "build-pqxx/src/all",
- "output": "build-pqxx/src/CMakeFiles/install/strip.util"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "build-pqxx/src/CMakeFiles/install/strip.util",
- "output": "build-pqxx/src/install/strip"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "cd /home/wisdurm/repos/koivuhaka/build && /usr/bin/cpack --config ./CPackConfig.cmake",
- "file": "build-pqxx/include/all",
- "output": "build-pqxx/include/CMakeFiles/package.util"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "build-pqxx/include/CMakeFiles/package.util",
- "output": "build-pqxx/include/package"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "build-pqxx/include/CMakeFiles/package_source.util",
- "output": "build-pqxx/include/package_source"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "build-pqxx/include/CMakeFiles/edit_cache.util",
- "output": "build-pqxx/include/edit_cache"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "build-pqxx/include/CMakeFiles/rebuild_cache.util",
- "output": "build-pqxx/include/rebuild_cache"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "cd /home/wisdurm/repos/koivuhaka/build/build-pqxx/include && /usr/bin/cmake -P cmake_install.cmake",
- "file": "build-pqxx/include/all",
- "output": "build-pqxx/include/CMakeFiles/install.util"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "build-pqxx/include/CMakeFiles/install.util",
- "output": "build-pqxx/include/install"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "cd /home/wisdurm/repos/koivuhaka/build/build-pqxx/include && /usr/bin/cmake -DCMAKE_INSTALL_LOCAL_ONLY=1 -P cmake_install.cmake",
- "file": "build-pqxx/include/all",
- "output": "build-pqxx/include/CMakeFiles/install/local.util"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "build-pqxx/include/CMakeFiles/install/local.util",
- "output": "build-pqxx/include/install/local"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "cd /home/wisdurm/repos/koivuhaka/build/build-pqxx/include && /usr/bin/cmake -DCMAKE_INSTALL_DO_STRIP=1 -P cmake_install.cmake",
- "file": "build-pqxx/include/all",
- "output": "build-pqxx/include/CMakeFiles/install/strip.util"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "build-pqxx/include/CMakeFiles/install/strip.util",
- "output": "build-pqxx/include/install/strip"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "build-pqxx/src/libpqxx-7.10.a",
- "output": "libpqxx-7.10.a"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "build-pqxx/src/libpqxx-7.10.a",
- "output": "pqxx"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "_deps/crow-build/uninstall",
- "output": "uninstall"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "koivuhaka",
- "output": "all"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "build-pqxx/src/all",
- "output": "build-pqxx/all"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "",
- "file": "build-pqxx/src/libpqxx-7.10.a",
- "output": "build-pqxx/src/all"
- },
- {
- "directory": "/home/wisdurm/repos/koivuhaka/build",
- "command": "/usr/bin/cmake --regenerate-during-build -S/home/wisdurm/repos/koivuhaka -B/home/wisdurm/repos/koivuhaka/build",
- "file": "/home/wisdurm/repos/koivuhaka/CMakeLists.txt",
- "output": "build.ninja"
- }
-]
diff --git a/src/main.cpp b/src/main.cpp
index 26037a8..876f325 100644
--- a/src/main.cpp
+++ b/src/main.cpp
srand(time(NULL));
std::string r;
for (int i = 0; i < 20; ++i) {
- r += allowed[rand() % (sizeof(allowed) / sizeof(*allowed) )];
+ r += allowed[rand() % ((sizeof(allowed) / sizeof(*allowed) - 1) )];
}
r += fileExtension;
return r;
// Asunnot lista
std::vector<Asunto> asunnot;
- CROW_ROUTE(app, "/")([&asunnot](){
+ CROW_ROUTE(app, "/")
+ .methods("GET"_method, "POST"_method)([&asunnot](){
auto page = crow::mustache::load("index.html");
crow::json::wvalue asunnotJson;
for (int i = 0; i < asunnot.size(); ++i) {
});
CROW_ROUTE(app, "/asunto")
- .methods("POST"_method)([&app, &asunnot](const crow::request& req){
+ .methods("GET"_method, "POST"_method)([&app, &asunnot](const crow::request& req, crow::response& res){
auto& session = app.get_context<Session>(req);
+
if (session.get("name","_NO_") == "_NO_") {
// Jos ei kirjauduttu sisään, potki pois
- return crow::response(401);
+ res.code = 401;
+ res.redirect("/");
+ res.end();
+ return;
}
// Jatka jos kirjautunut sisään
std::string asuntoOsoite;
auto headers_it = part_value.headers.find("Content-Disposition");
if (headers_it == part_value.headers.end()) {
CROW_LOG_ERROR << "No Content-Disposition found";
- return crow::response(400);
+ res.code = 400;
+ res.redirect("/");
+ res.end();
+ return;
}
auto params_it = headers_it->second.params.find("filename");
if (params_it == headers_it->second.params.end()) {
CROW_LOG_ERROR << "Part with name \"image\" should have a file";
- return crow::response(400);
+ res.code = 400;
+ res.redirect("/");
+ res.end();
+ return;
}
const std::filesystem::path reqFile = params_it->second;
const std::string outfileName = utils::fileName(reqFile.extension());
std::ofstream file(outfilePath);
if (file.fail()) {
CROW_LOG_ERROR << "Cannot write file";
- return crow::response(500);
+ res.code = 500;
+ res.redirect("/");
+ res.end();
+ return;
}
file << part_value.body;
file.close();
// Tietokantaa varten
asuntoKuva = outfileName;
}
+ // Tarkistus
+ if (asuntoOsoite.empty() or asuntoKuva.empty()) {
+ res.code = 400;
+ res.redirect("/");
+ res.end();
+ return;
+ }
// Lisää SQL tietokantaan
try
{
if (not cx.is_open())
{
CROW_LOG_CRITICAL << "Can't open database";
- return crow::response(500);
+ res.code = 500;
+ res.redirect("/");
+ res.end();
+ return;
}
// Connection established
CROW_LOG_INFO << "Opened database successfully: " << cx.dbname();
catch (const std::exception &e)
{
CROW_LOG_ERROR << e.what();
- return crow::response(500);
+ res.code = 500;
+ res.redirect("/");
+ res.end();
+ return;
}
// Valmis
- return crow::response(200);
+ res.code = 200;
+ res.redirect("/");
+ res.end();
+ return;
});
diff --git a/static/images/zinyprzbmla8pkx5f0lx.jpg b/static/images/zinyprzbmla8pkx5f0lx.jpg
new file mode 100644
index 0000000..854b2a2
Binary files /dev/null and b/static/images/zinyprzbmla8pkx5f0lx.jpg differ